Ch 8 HW 7.xlsx - Quarter Actual DemanPeriod 1 5 2 1 3 3 4 7 1 8 2 3 3 6 4 10 1 10 2 7 3 8 4 12 1 2 3 4 5 6 7 8 9 10 11 12 1 1 0 0 0 1 0 0 0 1 0 0 0 2 0

Ch 8 HW 7.xlsx - Quarter Actual DemanPeriod 1 5 2 1 3 3 4 7...

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

Quarter Actual DemanPeriod 1 2 3 T 1 5 1 1 0 0 1 2 1 2 0 1 0 2 3 3 3 0 0 1 3 4 7 4 0 0 0 4 1 8 5 1 0 0 5 2 3 6 0 1 0 6 3 6 7 0 0 1 7 4 10 8 0 0 0 8 1 10 9 1 0 0 9 2 7 10 0 1 0 10 3 8 11 0 0 1 11 4 12 12 0 0 0 12 0 2 0 2 4 6 8 10 12 14
Image of page 1
4 6 8 10 12 14 Actual Demand
Image of page 2
SUMMARY OUTPUT Regression Statistics Multiple R 0.71713717 R Square 0.51428571 Adjusted R Sq 0.33214286 Standard Erro 2.66145324 Observations 12 ANOVA df SS MS F Significance F Regression 3 60 20 2.82352941 0.10688825 Residual 8 56.6666667 7.08333333 Total 11 116.666667 CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Intercept 9.667 1.53659074 6.29098328 0.00023506 6.12328206 13.2100513 1 -2.000 2.17306747 -0.92035799 0.38429846 -7.01110257 3.01110257 2 -6.000 2.17306747 -2.76107396 0.02463388 -11.0111026 -0.98889743 3 -4.000 2.17306747 -1.84071597 0.1029323 -9.01110257 1.01110257 RESIDUAL OUTPUT Observation ted Actual Dem Residuals 1 7.66666667 -2.66666667 7.11111111 2 3.66666667 -2.66666667 7.11111111 3 5.66666667 -2.66666667 7.11111111 4 9.66666667 -2.66666667 7.11111111 5 7.66666667 0.33333333 0.11111111 6 3.66666667 -0.66666667 0.44444444 7 5.66666667 0.33333333 0.11111111 8 9.66666667 0.33333333 0.11111111 9 7.66666667 2.33333333 5.44444444 10 3.66666667 3.33333333 11.1111111 11 5.66666667 2.33333333 5.44444444 12 9.66666667 2.33333333 5.44444444 12.333 15.333 4.722 18.333 21.333
Image of page 3
Lower 95.0% Upper 95.0% 6.12328206 13.2100513 -7.01110257 3.01110257 -11.0111026 -0.98889743 -9.01110257 1.01110257
Image of page 4
SUMMARY OUTPUT Regression Statistics Multiple R 0.99337088 R Square 0.98678571 Adjusted R Sq 0.97923469
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 6 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes