Please show calculations using MINITAB PROBLEM 1 A nickel-titanium alloy is. used to make components for...
PROBLEM 1 A nickel-titanium alloy is. used to make components for jet turbine aircraft engines. Cracking is a potentially serious problem in the final part because it can lead to non-recoverable failure. A test is run at the parts produced to determine the effect of four factors on cracks. The four factors are A pouring temperature Btitanium content C = heat treatment method D amount of grain refiner used Two replicates of a 2 design are run, and the length of crack (in hundredths of one mm) induced in sample coupon subjected to a standard test is measured. The data are shown below: a Replicate Treatment Combination C D II (1) 7.037 6.376 14.707 15.219 11.635 12.089 7373ן ab 2.815ן 10.151 10.403 4.368 4.098 ac be 9.360 9.253 abc 13.440 12.923 8.95 8.561 d ad 17.052 16.867 13.876 13.658 bd abd 19.824 19.639 12.337 cd 11.846 6.125 5.904 ac bed 10.935 11.190 15.653 15.053 abcd Using entirely an Excel worksheet, do the following: Estimate the effects of main factors and interactions. Which factors effects appear to be large, significant? Complete the ANOVA table for the experiment, including the p-values. Do any of the factors a. b. significantly affect cracking? Use a-0.05 Write down a regression model that can be used to predict crack length as a function of the c. significant main effects and interactions you have identified in part (b). Analyze variability in cracking (calculate standard deviation). Is there an indication that any of the factors affect the variability in cracking? What recommendations would you make regarding process operations, that is, regarding the settings of the process factors? Use Excel Solver as the optimization approach to assist you in drawing conclusions. d. e.
PROBLEM 1 A nickel-titanium alloy is. used to make components for jet turbine aircraft engines. Cracking is a potentially serious problem in the final part because it can lead to non-recoverable failure. A test is run at the parts produced to determine the effect of four factors on cracks. The four factors are A pouring temperature Btitanium content C = heat treatment method D amount of grain refiner used Two replicates of a 2 design are run, and the length of crack (in hundredths of one mm) induced in sample coupon subjected to a standard test is measured. The data are shown below: a Replicate Treatment Combination C D II (1) 7.037 6.376 14.707 15.219 11.635 12.089 7373ן ab 2.815ן 10.151 10.403 4.368 4.098 ac be 9.360 9.253 abc 13.440 12.923 8.95 8.561 d ad 17.052 16.867 13.876 13.658 bd abd 19.824 19.639 12.337 cd 11.846 6.125 5.904 ac bed 10.935 11.190 15.653 15.053 abcd Using entirely an Excel worksheet, do the following: Estimate the effects of main factors and interactions. Which factors effects appear to be large, significant? Complete the ANOVA table for the experiment, including the p-values. Do any of the factors a. b. significantly affect cracking? Use a-0.05 Write down a regression model that can be used to predict crack length as a function of the c. significant main effects and interactions you have identified in part (b). Analyze variability in cracking (calculate standard deviation). Is there an indication that any of the factors affect the variability in cracking? What recommendations would you make regarding process operations, that is, regarding the settings of the process factors? Use Excel Solver as the optimization approach to assist you in drawing conclusions. d. e.