The Excel output of a simple linear regression analysis of the data set for this case (see Table 13.5) is given in Figure 13.13. Recall that a labeled Excel regression output is on page 482.

Transcribed Image Text:

Regression StatisticS Multiple R R Square Adjusted R Square Standard Error Observations 0.9996 0.9993 0.9992 8.6415 12 MS F Significance F 5.04E-17 ANOVA Regressiorn Residual Total df 1 1024592.9043 1024592.9043 13720.4677 10 746.7624 1 1025339.6667 Coefficients Standard Error 4.6766 0.0866 74.6762 P-value 3.9532 0.0027 117.1344 5.04E-17 t Stat Intercept BatchSize ) 18.4875 10.1463 Lower 95% 8.0674 9.9533 Upper 95% 28.9076 10.3393