3 1 65 4 58 5 1 52 6 1 68 7 1 74 8 60 9 1 56 10 1 75 11 1 78 12 63 13 1 59 14 1

3 1 65 4 58 5 1 52 6 1 68 7 1 74 8 60 9 1 56 10 1 75

This preview shows page 25 - 32 out of 32 pages.

3 0 0 1 6.5 4 0 0 0 5.8 5 1 0 0 5.2 6 0 1 0 6.8 7 0 0 1 7.4 8 0 0 0 6.0 9 1 0 0 5.6 10 0 1 0 7.5 11 0 0 1 7.8 12 0 0 0 6.3 13 1 0 0 5.9 14 0 1 0 8.0 15 0 0 1 8.4 16 0 0 0 17 1 0 0 18 0 1 0 19 0 0 1 20 0 0 0 21 1 0 0 22 0 1 0 23 0 0 1 24 0 0 0 25 1 0 0 26 0 1 0 27 0 0 1 28 0 0 0 29 1 0 0 30 0 1 0
Image of page 25
Image of page 26
SI8 SI9 SI10 SI11 MAD 0.141875 8 9 10 11 Forecast Abs(error) 4.85125 0.05125 4.32625 0.22625 6.20125 0.20125 6.65125 0.15125 5.43375 0.36625 4.90875 0.29125 6.78375 0.01625 7.23375 0.16625 6.01625 0.01625 5.49125 0.10875 7.36625 0.13375 7.81625 0.01625 6.59875 0.29875 6.07375 0.17375 7.94875 0.05125 8.39875 0.00125 7.18125 future forecast from 17 6.65625 8.53125 8.98125 7.76375 7.23875 if question asked, whats the forec 9.11375 answer is 7.23875 9.56375 8.34625 7.228 7.82125 which is =in 9.69625 we use s12 10.14625 dummy var 8.92875 8.40375
Image of page 27
Image of page 28
7 down ast of the sixth year second quarter? getting answer without stealing from table ntercept + slope (22) + s12 2 because its asking for second period riables for first and third period is 0
Image of page 29
Image of page 30
SUMMARY OUTPUT Regression Statistics Multiple R 0.98806594 R Square 0.976274301 Adjusted R Square 0.967646775 Standard Error 0.216663753 Observations 16 ANOVA df SS MS F Significance F Regression 4 21.248 5.312 113.15807311 7.4E-009 Residual 11 0.516375 0.0469431818 Total 15 21.764375 Coefficients Standard Error t Stat P-value Lower 95%Upper 95% Intercept 6.06875 0.1624978147 37.346656091 6.12289E-013 5.711095 6.426405 Period 0.145625 0.012111872 12.023327202 0.000000114 0.118967 0.172283 1 -1.363125 0.1574543359 -8.657271914 3.05975E-006 -1.70968 -1.01657 2 -2.03375 0.1551076422 -13.111862 4.65532E-008 -2.37514 -1.69236 3 -0.304375 0.1536824269 -1.980545245 0.0732010429 -0.642628 0.033878 1.14*10^-07 < .05 because the period p value is very sm
Image of page 31
Lower 95.0% Upper 95.0% 5.711095 6.426405 0.118967 0.172283 -1.70968 -1.01657 -2.37514 -1.69236 -0.642628 0.033878 mall, there is a trend
Image of page 32

You've reached the end of your free preview.

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