Exam 4 - ANOVA and Regression Excel output (dragged).pdf (1 page) Exam 4 - ANOVA and Regression Excel output.pdf (page 1 of 2) Q Q Search 1 Q Q Search here to answer questions 14 through 30. To shorten the time it takes him to make his favorite pizza, a student designed an experiment to test the effect of sugar and milk on the activation times for baking yeast. Specifically, he tested four different recip Assessment us Size and measured how many seconds it took for the same amount of dough to rise to the top of a bowl. He randomized the order of the recipes and replicated each treatment 4 times. With a = 0.05, is there a 80000 significant difference in the average times among the four recipes? Use the Excel ANOVA output shown 75000 here to answer questions 9 through 13. SUMMARY OUTPUT 70000 65000 Assessment (dollars) Regression Statistics 60000 55000 Multiple R 0.569851776 SUMMARY 50000 R Square 0.324731046 Groups Count Sum Average Variance 45000 Adjusted R Square 0.282526737 40000 Recipe A 4 1945 486.25 6339.583333 Standard Error 4682.104467 1500 1700 1900 2100 2300 2500 2700 Recipe B 785 196.25 4489.583333 Observations 18 Recipe C 2624 Size (square feet) 656 5490.666667 Recipe D 735 183.75 2722.916667 ANOVA df SS MS F Significance F Regression 1 168674414.2 168674414.2 7.694262727 0.013552357 Residual 16 350753635.8 21922102.24 ANOVA Total 17 519428050 Source of Variation SS df MS F P-value F crit Between Groups 638967.6875 3 212989.2292 44.73917458 8.63974E-07 3.490294819 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Within Groups 57128.25 12 4760.6875 Intercept 37108.84945 8664.324755 4.282947661 0.000570588 18741.30148 55476.39741 Size 11.89874684 4.289609109 2.773853408 0.013552357 2.805181763 20.99231193 Total 696095.9375 15