The accompanying data resulted from an experiment to investigate whether yield from a certain chemical process depended either on the formulation of a particular input or on mixer speed.Speed60 70 80189.7 185.1 189.0188.6 179.4 193.0190.1 177.3 191.1Formulation1165.1 161.7 163.32 165.9 159.8 166.6.167.6 161.6 170.3A statistical computer package gave SS(Form) = 2253.44, SS(Speed) = 230.81, SS(Form*Speed) = 18.58, and SSE = 71.87.(a) Does there appear to be interaction between the factors?Yes, there appears to be interaction between the two factors.O No, there appears to be no interaction between the two factors.(b) Does yield appear to depend on either formulation or speed?Only formulation appears to have a highly statistically significant effect on yield.Only speed appears to have a highly statistically significant effect on yield.O Both formulation and speed appear to have a highly statistically significant effect on yield.ONeither have a statistically significant effect on yield.B₁ =B₂ =B3 =(c) Calculate estimates of the main effects. (Let Factor A= formulation and Factor B = speed.) (c) Calculate estimates of the main effects. (Let Factor A= formulation and Factor B = speed.)Q₁ =â₂ =B₂ =B3 =(d) The fitted values are yk = û +â, +, +, and the residuals are Xijk - Complete the table. (Round your answers to two decimal places.)ObservedFittedResidual189.7188.6190.1165.1165.9167.6185.1179.4177.3161.7159.8161.6189.0193.0191.1163.3166.6170.3

Given the data asSpeed607080Formulation1189.7185.1189188.6179.4193190.1177.3191.12165.1161.7163.3165.9159.8166.6167.6161.6170.3The Two-way ANOVA output from EXCEL isDecision rule: (a) No, there appears to be no interaction between the two factors since p-value for interaction is .(b) Both formulation and speed appear to have a highly statistically significant effect on yield since both p-values are less than 0.05.The steps for Anova: Two-Factor With Replication output in EXCEL :Step 1 : Upload the data into EXCELStep 2 : Select Data in Home barStep 3 : Select Data analysis tab in Data barStep 4 : Select ANOVA: Two-Factor With Replication in Data analysis tool barStep 5 : Select the data in Input Range and put Rows per sample 3Step 6 : Click OK(c) (d) The fitted values areObservedFittedResidual189.7202.64-12.94188.6202.64-14.04190.1202.64-12.54165.1157.008.10165.9157.008.90167.6157.0010.60185.1186.76-1.66179.4186.76-7.36177.3186.76-9.46161.7144.8216.88159.8144.8214.98161.6144.8216.78189205.26-16.26193205.26-12.26191.1205.26-14.16163.3158.584.72166.6158.588.02170.3158.5811.72(a) No, there appears to be no interaction between the two factors.(b) Both formulation and speed appear to have a highly statistically significant effect on yield.(c) The estimates of the main effects are(d) The completed table isObservedFittedResidual189.7202.64-12.94188.6202.64-14.04190.1202.64-12.54165.1157.008.10165.9157.008.90167.6157.0010.60185.1186.76-1.66179.4186.76-7.36177.3186.76-9.46161.7144.8216.88159.8144.8214.98161.6144.8216.78189205.26-16.26193205.26-12.26191.1205.26-14.16163.3158.584.72166.6158.588.02170.3158.5811.72