Question

Please show calculations using MINITAB

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.

Answer 1

e Fom the half rormal plot of efects shoan belo, factoss A,B,C, D, AB, AC ard ABC apead b be Loage Design expeat output: anfidenly Team Inteacept Sumnga efect Nodel Madel Madel Model A 12.FHc8 3.01888 72.9089 22.099 3.97589 126-46 8.0804 -3. 59625 lo3.464 Macdel Madel Mocel 5.35823 1.95775 30.6623 AB 1.93412 29.9367 5.22909 AC 128.496 4-00775 22.4548 AD O.0765 O.046818 Shig1800.0 Bc O.096 O.01288y OO73328 ESEN Ed Model BD O.O425 O-0173605 O.001 2112 CD O.0012618S 0.076875 ABC .3618 3.1375 ARD ο. ο 13W2 (V 0.098 O.c76332 Edoco ACD BCD O0191e5 .002926 13 σ. οιοι 531 Q.00159613 O-0005113Y 9.035625 EddoD ABCD 936Etlo0o O.014125 O,0002F8923 Half Nosmal plot Scanned with CS Ito CamScanner 1

Maan sauae Fvalue pab2f DF Sum of squae Souace O.016 day o.016 20.000 45.11 38 06 15 Model S70.95 852.59 72.9 F2.9 JM.83 2O 000 126. 46 103.46 12001.7) 2ac0o 103. 46 R0 66 29.93 358.86 20 66 Ca000) AR 349.96 eq.93 AC 128-50 128.50 1502.63 Co.000 AD O.O47 a.o47 O.SS & C 0.07Y o.86 .3678 O.018 O018 O.21 D.6542 Eho o a55 920.92 CD o.4696 tho.o 78 F5 A&C 78.75 AB D O.90 o.3582 2.9266-0 ACD O034 2.920E-003 o.8837 fc D d 12 lo.010 O.7352 ARCD S96E-03 1.596E-003 O.019 0.893 Residud 1.29 O.086 IS Co To tal 572.25 31 A, &, C, D,AB, Ac and Aßc ae sgnificat ePecty Coack length 11,99 1.5) *A -.80 xC xSb.0t 0.97KA x S 2.00AC + 1.57 *A SC Camsc

Nosmal plot xesidual RSsduals vs Psedsc ted a.454BT 95 O.232682 & Se 20 -0.2117 11.93 15-8 G 3-06 0.01os .232688 0.454815 433835-0.2)1687 Precicted Ragtdual Thexe nothing unugnal abaut the vesfeluols. CS 5T

As per HomeworkLib policy we need to solve four sub parts per question. Please post the remaining questions in another post.