CH8HW (1).xlsx - eek Value 1 2 3 4 5 6 Forecast 18 13 16 11 15.66667 21.77778 17 13.33333 13.44444 14 14.66667 0.444444 14 mse eek Value 1 2 3 4 5 6 SFE

CH8HW (1).xlsx - eek Value 1 2 3 4 5 6 Forecast 18 13 16 11...

This preview shows page 1 - 10 out of 10 pages.

eek Value Forecast SFE 1 18 2 13 3 16 4 11 15.66667 21.77778 5 17 13.33333 13.44444 6 14 14.66667 0.444444 14 mse 11.88889 eek Value SFE 1 18 #N/A 2 13 18 25 3 16 17 1 4 11 16.8 33.64 5 17 15.64 1.8496 6 14 15.912 3.655744 13.02907
Image of page 1
eek Sales (1,004-week For5-week ForSFE SFE 1 17 2 21 3 19 4 23 5 18 20 4 6 16 20.25 19.6 18.0625 12.96 7 20 19 19.4 1 0.36 8 18 19.25 19.2 1.5625 1.44 9 22 18 19 16 9 10 20 19 18.8 1 1.44 11 15 20 19.2 25 17.64 12 22 18.75 19 10.5625 9 19.75 19.4 MSE 9.648438 7.405714
Image of page 2
t yt Forecast SFE SUMMARY OUTPUT 1 6 6.8 0.64 2 11 8.9 4.41 Regression Statistics 3 9 11 4 Multiple R 0.903696 4 14 13.1 0.81 R Square 0.816667 5 15 15.2 0.04 Adjusted R 0.755556 6 17.3 Standard E 1.81659 Observatio 5 1.98 ANOVA df SS MS F ignificance Regression 1 44.1 44.1 13.36364 0.035353 Residual 3 9.9 3.3 Total 4 54 Coefficients tandard Erro t Stat P-value Lower 95% 1 Intercept 4.7 1.905256 2.46686 0.090316 -1.363375 b1 t 2.1 0.574456 3.655631 0.035353 0.271824 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 0 2 4 6 8 10 12 14 16 yt
Image of page 3
F Upper 95%Lower 95.0% Upper 95.0% 10.76337 -1.363375 10.76337 3.928176 0.271824 3.928176
Image of page 4
ear Cost/Unit (Forecast SFE 1 20 21.76667 3.121111 2 24.5 23.54048 0.920686 3 28.2 25.31429 8.327347 4 27.5 27.0881 0.169666 5 26.6 28.8619 5.116213 6 30 30.63571 0.404133 7 31 32.40952 1.986757 8 36 34.18333 3.300278 9 35.95714 MSE 2.918274 SUMMARY OUTPUT Regression Statistics Multiple R 0.921878 R Square 0.849859 Adjusted R 0.824835 Standard E 1.97257 Observatio 8 ANOVA df SS MS F ignificance F Regression 1 132.1488 132.1488 33.96241 0.001123 Residual 6 23.34619 3.891032 Total 7 155.495 Coefficients tandard Erro t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% Intercept 19.99286 1.537014 13.0076 1.27E-005 16.23192 23.75379 16.23192 23.75379 ear 1.77381 0.304374 5.827728 0.001123 1.029033 2.518586 1.029033 2.518586 1 2 3 4 0 5 10 15 20 25 30 35 40 Cost
Image of page 5
5 6 7 8 t/Unit ($)
Image of page 6
uarter x
Image of page 7
Image of page 8
Image of page 9
Image of page 10

You've reached the end of your free preview.

Want to read all 10 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture