stats 2 week 14

# stats 2 week 14 - -11986016.9 578576.5911 -20.71638758...

This preview shows pages 1–2. Sign up to view the full content.

Sarah Anderson Statistics 2 Week 14 Exercise 1 (page 605) Exercises 4, 5 (page 609) Exercise 8 (page 612) 1. The weighted moving averages are: 31,584.8, 33,088.9, 34,205.4, 34,899.8, 35,155.0, 34,887.1 4. Below is the regression analysis from Excel. The coeffcients for the regression line y = ax + b are a = 6016.164286 b = -11986016.9 So the LS line is y = 6016.164286x – 11986016.9 plug in x=2008 and x = 2009 to get your estimates 2008: 94440.98 2009: 100457.1 Regression Statistics Multiple R 0.985301418 R Square 0.970818884 Adjusted R Square 0.968574183 Standard Error 4840.707766 Observations 15 ANOVA ....................... df . ..SS. ......................... MS . ........................... F . ................ Significance F Regression 1 . ..10134385160 . ..... 10134385160 . ....... 432.4935905 2.31927E-11 Residual . ..13 . ..304621871.8 . ..... 23432451.68 Total . ........ 14 . ..10439007031 ................... Coefficients Standard Error t Stat P-value Intercept. .....

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -11986016.9 578576.5911 -20.71638758 2.43524E-11 X Variable 6016.164286 289.2876206 20.79648024 2.31927E-11 … RESIDUAL OUTPUT Obs# . ....Predicted Y . ........ Residuals 1 . ......... 4198.516667 . ...... 5040.483333 2 . ......... 10214.68095 . ...... 2262.319048 3 . ......... 16230.84524 . ......-760.8452381 4 . ......... 22247.00952 . ......-2712.009524 5 . ......... 28263.17381 . ......-4107.17381 6 . ......... 34279.3381 . ........-4060.338095 7 . ......... 40295.50238 . ......-1861.502381 8 . ......... 46311.66667 . ......-573.6666667 9 . ......... 52327.83095 . ...... 1225.169048 10 . ........ 58343.99524 . ......-96.99523809 11 . ........ 64360.15952 . ...... 455.8404762 12 . ........ 70376.32381 . ...... 2717.67619 13 . ........ 76392.4881 . ...... 5118.511905 14 . ........ 82408.65238 . ...... 8428.347619 15 . ........ 88424.81667 . ......-11075.81667 5. Y= 1.30 + .90t Y= 1.30 + .90 (7) = 7.6 8....
View Full Document

## This note was uploaded on 04/12/2011 for the course STAT 2610 taught by Professor Sanjeev during the Spring '11 term at Bemidji State.

### Page1 / 2

stats 2 week 14 - -11986016.9 578576.5911 -20.71638758...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online