What is the estimated standard deviation for the residuals 0.2834.2908664.3254682.1040.570

Exam 4 - ANOVA and Regression Excel output (dragged).pdf (1 page) " Q Search Exam 4 - ANOVA and Regression Excel output.pdf (page 1 of 2) Q Search here to answer questions 14 through 30. shorten the time it takes him to make his favorite pizza, a student designed an experiment to test the fect of sugar and milk on the activation times for baking yeast. Specifically, he tested four different recip Assessment us Size d measured how many seconds it took for the same amount of dough to rise to the top of a bowl. He 80000 indomized the order of the recipes and replicated each treatment 4 times. With a = 0.05, is there a 75000 gnificant difference in the average times among the four recipes? Use the Excel ANOVA output shown SUMMARY OUTPUT 70000 ere to answer questions 9 through 13. 65000 Assessment (dollars) 60000 Regression Statistics 55000 Multiple R 0.569851776 50000 SUMMARY R Square 0.324731046 45000 Groups Count Sum Average Variance Adjusted R Square 0.282526737 40000 Recipe A P 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 Size (square feet) Recipe C 2624 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