File Home Insert Page Layout Formulas Data Review View Add-ins Tell me what you

Question

File Home Insert Page Layout Formulas Data Review View Add-ins Tell me what you want to do Data Analysis Clear Reapply Text to Advanced Columns Queries & Connections A ! . A Get Sort Filter What-If Forecast Outline MegaStat AllEdit Links Analysis Sheet Forecast Get & Transform Data Queries & Connections Sort & Filter Data Tools Analysis Statistics G8 X 13220 0 0 2004 2003 2002 20012000 1999 Qtr 13.007 2.716 2.574 2517 2.590 2.486 Qtr2 3,264 2,988 2,737 2,585 2,586 2,617 Qt3 3,318 3.113 2,7 2,594 2,570 2,719 Qtr4 3,632 3,359 2947 2,647 2,579 2,689 10,325 10,511 2,485 Qtr2 2,617 Qtr3 2,719 Qtr4 2,689 2000 Q 2,590 2,586 Qtr3 2,570 Qtr4 2,579 2001 Qt2,517 Qtr2 2,585 Qtr3 2,594 2,647 2,574 Qtr2 2,737 Qtr3 2,759 Qtr4 2,947 2,716 2,988 3,113 Qtr4 3,359 2004 at3,007 3,264 atr3 3,318 3,630 Year 13,22012,176 11,016 10 0 stibutor of Learning Stats home appliances, under severál brand names Copyg 2007 Qtr4 atr1 Source: Standard & Poor's Stock Report, April 2 2005. Data are for statistical education only, and should not be used as a guide to investments Quarternty data may not sum to annual totals due to rounding or other tactors. 2002 The spreaddheet is intnded sotely for educational rpoa by tanasd be copied ee resolifor profi 2003 Qtr1 Qtr2 Qtr4

Explanation / Answer

Regression on deseasonalized data

2)

3)

SUMMARY OUTPUT Regression Statistics Multiple R 0.846053789 R Square 0.715807015 Adjusted R Square 0.702889152 Standard Error 155.6781248 Observations 24 ANOVA df SS MS F Significance F Regression 1 1342952 1342952 55.41219 1.91E-07 Residual 22 533184.9 24235.68 Total 23 1876137 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 2388.842708 65.59505 36.41803 3.7E-21 2252.807 2524.879 2252.807 2524.878523 t 34.17285863 4.590697 7.443936 1.91E-07 24.65233 43.69338 24.65233 43.69338243

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.