Ex9.xlsx - quarter 1 Quarter 2 Quarter 3 Values 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 forecast error squared 4

Ex9.xlsx - quarter 1 Quarter 2 Quarter 3 Values 1 0 0 0 1 0...

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

quarter 1 Quarter 2 Quarter 3 Values forecast error squared 1 0 0 4 5.667 -1.667 2.779 0 1 0 2 3.667 -1.667 2.779 0 0 1 3 4.667 -1.667 2.779 0 0 0 5 6.667 -1.667 2.779 1 0 0 6 5.667 0.333 0.111 0 1 0 3 3.667 -0.667 0.445 0 0 1 5 4.667 0.333 0.111 0 0 0 7 6.667 0.333 0.111 1 0 0 7 5.667 1.333 1.777 0 1 0 6 3.667 2.333 5.443 0 0 1 6 4.667 1.333 1.777 0 0 0 8 6.667 1.333 1.777 MSE 1.889 SUMMARY OUTPUT Regression Statistics Multiple R 0.6310547429 R Square 0.3982300885 Adjusted R Square 0.1725663717 Standard Error 1.6832508231 Observations 12 ANOVA df SS Regression 3 15 Residual 8 22.6666666667 Total 11 37.6666666667 Coefficients Standard Error Intercept 6.6666666667 0.9718253158 quarter 1 -1 1.3743685419 Quarter 2 -3 1.3743685419 Quarter 3 -2 1.3743685419
Image of page 1
MS F ignificance F 5 1.7647058824 0.231425 2.8333333333 t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% 6.8599434057 0.0001296755 4.425633 8.9077 4.425633 8.9077 -0.7276068751 0.4875996168 -4.1693 2.1693 -4.1693 2.1693 -2.1828206253 0.060595435 -6.1693 0.1693 -6.1693 0.1693 -1.4552137502 0.183698114 -5.1693 1.1693 -5.1693 1.1693
Image of page 2
quarter 1 Quarter 2 Quarter 3 t Values forecast error squared 1 0 0 1 4 4.042 -0.042 0.002 0 1 0 2 2 2.041 -0.041 0.002 0 0 1 3 3 3.041 -0.041 0.002 0 0 0 4 5 5.041 -0.041 0.002 1 0 0 5 6 5.666 0.334 0.112 0 1 0 6 3 3.665 -0.665 0.442 0 0 1 7 5 4.665 0.335 0.112 0 0 0 8 7 6.665 0.335 0.112 1 0 0 9 7 7.29 -0.29 0.084 0 1 0 10 6 5.289 0.711 0.506 0 0 1 11 6 6.289 -0.289 0.084 0 0 0 12 8 8.289 -0.289 0.084 MSE 0.128
Image of page 3
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 5 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