SmartPhoneSales.xlsx - Year 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 Quarter period(time Sales(1000s 1 1 4.8 2 2 4.1 3 3 6.0 4 4 6.5 1 5 5.8 2 6 5.2 3 7 6.8 4 8

SmartPhoneSales.xlsx - Year 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4...

This preview shows page 1 - 4 out of 12 pages.

Year Quarter period(time) Sales (1000s) 1 2 3 time 1 1 1 4.8 1 0 0 1 1 2 2 4.1 0 1 0 2 1 3 3 6.0 0 0 1 3 1 4 4 6.5 0 0 0 4 2 1 5 5.8 1 0 0 5 2 2 6 5.2 0 1 0 6 2 3 7 6.8 0 0 1 7 2 4 8 7.4 0 0 0 8 3 1 9 6.0 1 0 0 9 3 2 10 5.6 0 1 0 10 3 3 11 7.5 0 0 1 11 3 4 12 7.8 0 0 0 12 4 1 13 6.3 1 0 0 13 4 2 14 5.9 0 1 0 14 4 3 15 8.0 0 0 1 15 4 4 16 8.4 0 0 0 16 observatio seasonality trend mayb confirm trend exist time is sign p value is l SUMMARY OUTPUT use multipl level = 4 Regression Statistics k-1= 3 dum Multiple R 0.71086 R Square 0.505322 Adjusted R 0.469987 Standard E 0.876941 Observatio 16 ANOVA df SS MS F ignificance F Regression 1 10.99800735 10.998007353 14.30121 0.002023 Residual 14 10.76636765 0.7690262605 Total 15 21.764375 CoefficientsStandard Error t Stat P-value Lower 95%Upper 95% Lower 95.0% Intercept 4.8525 0.459871962 10.551850077 4.8E-008 3.866173 5.838827 3.866173 period(time0.179853 0.047558826 3.7816942894 0.002023 0.077849 0.281856 0.077849 0 2 4 6 8 10 12 14 16 18 0.0 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 Sales (1000s)
Image of page 1
RESIDUAL OUTPUT Observation cted Sales (1 Residuals 1 5.032353 -0.23235294 2 5.212206 -1.11220588 3 5.392059 0.607941176 4 5.571912 0.928088235 5 5.751765 0.048235294 6 5.931618 -0.73161765 7 6.111471 0.688529412 8 6.291324 1.108676471 9 6.471176 -0.47117647 10 6.651029 -1.05102941 11 6.830882 0.669117647 12 7.010735 0.789264706 13 7.190588 -0.89058824 14 7.370441 -1.47044118 15 7.550294 0.449705882 16 7.730147 0.669852941
Image of page 2
SUMMARY OUTPUT Regression Statistics Multiple R 0.988066 R Square 0.976274 Adjusted R 0.967647 Standard E 0.216664 Observatio 16 yhat = 6.06+0.145t-1.363q1-2.033q2-0.304 ANOVA df SS MS F ignificance F Regression 4 21.248 5.312 113.1581 7.4E-009
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 12 pages?

  • Fall '16
  • NAJARA
  • Regression Analysis, 4 k, yhat, 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 Quarter, 007 0.118967 0.172283 0.118967 k

  • 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