stats 2 week 14

stats 2 week 14 - Sarah Anderson Statistics 2 Week 14 1 The...

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 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. ..... -11986016.9 578576.5911 -20.71638758 2.43524E-11 X Variable 6016.164286 289.2876206 20.79648024 2.31927E-11 …
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

stats 2 week 14 - Sarah Anderson Statistics 2 Week 14 1 The...

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