stats 2 week 14

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

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

View Full Document Right Arrow Icon
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. .....
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
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 Right Arrow Icon
Ask a homework question - tutors are online