HW07_sol_X - Problem 3 Average 680 E 648.6 F 25.6 700 600...

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

View Full Document Right Arrow Icon
Problem 3 Period Year Spending 1 1977 214 2 1978 259 3 1979 303 4 1980 323 5 1981 369 6 1982 367 7 1983 357 8 1984 416 9 1985 443 10 1986 437 11 1987 443 12 1988 545 13 1989 571 14 1990 578 15 1991 556 16 1992 566 17 1993 623 18 1994 680 E 18 1994 648.6 F Average 25.6 1977 1979 1981 1983 1985 1987 1989 200 300 400 500 600 700 Capital Spending Year Billions of Dollars
Background image of page 1

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

View Full DocumentRight Arrow Icon
SUMMARY OUTPUT Regression Statistics Multiple R 0.978 R Square 0.957 Adjusted R Square 0.954 Standard Error 26.518 Observations 17 ANOVA df SS Regression 1 232,948.5 Residual 15 10,547.7 Total 16 243,496.2 Coefficients Standard Error Intercept 218.5 13.5 Period 23.9 1.3 1991 1993 Spending
Background image of page 2
MS F Significance F 232,948.5 331.3 0.00000 703.2 t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 16.2 0.00000 189.8 247.2 189.8 247.2 18.2 0.00000 21.1 26.7 21.1 26.7
Background image of page 3

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

View Full DocumentRight Arrow Icon
Seasonal Index Calculation 2000 2001 2002 2003 2004 2005 Median Adjusted Jan 1.21 1.20 1.27 1.41 1.43 1.27 1.28 Feb 0.70 0.56 0.94 1.09 0.90 0.90 0.91 Mar 0.52 0.56 0.79 0.80 0.61 0.61 0.62 Apr 0.44 0.43 0.48 0.55 0.70 0.48 0.48 May 0.42 0.36 0.49 0.50 0.40 0.42 0.43 Jun 0.49 0.46 0.46 0.47 0.53 0.47 0.47 Jul 0.64 0.90 0.60 0.68 0.60 0.66 0.65 0.65 Aug 1.11 0.91 0.89 0.80 0.83 0.83 0.86 0.86 Sep 1.37 1.56 1.35 1.27 1.13 1.39 1.36 1.36 Oct 1.79 1.86 1.80 1.57 1.64 1.77 1.78 1.79 Nov 1.88 2.01 1.87 1.70 1.70 1.85 1.86 1.87 Dec 1.52 1.09 1.22 1.28 1.45 1.28 1.29 Multiplicative Decomposition Calculations Period Year Month Sales 1Y MT 2Y MT 1Y MA Index S Y/S 1 2000 Jan 154 1.28 120 2 2000 Feb 96 0.91 106 3 2000 Mar 73 0.62 119 4 2000 Apr 49 0.48 102 5 2000 May 36 0.43 85 6 2000 Jun 59 1762 0.47 126 7 2000 Jul 95 1808 3570 149 0.64 0.65 145 8 2000 Aug 169 1830 3638 152 1.11 0.86 196 9 2000 Sep 210 1847 3677 153 1.37 1.36 154 10 2000 Oct 278 1877 3724 155 1.79 1.79 155 11 2000 Nov 298 1919 3796 158 1.88 1.87 160 12 2000 Dec 245 1951 3870 161 1.52 1.29 190 13 2001 Jan 200 2023 3974 166 1.21 1.28 156 14 2001 Feb 118 2023 4046 169 0.70 0.91 130 15 2001 Mar 90 2102 4125 172 0.52 0.62 146 16 2001 Apr 79 2171 4273 178 0.44 0.48 164 17 2001 May 78 2248 4419 184 0.42 0.43 183 18 2001 Jun 91 2206 4454 186 0.49 0.47 195 19 2001 Jul 167 2229 4435 185 0.90 0.65 256 20 2001 Aug 169 2215 4444 185 0.91 0.86 196 21 2001 Sep 289 2232 4447 185 1.56 1.36 212 22 2001 Oct 347 2238 4470 186 1.86 1.79 194 23 2001 Nov 375 2235 4473 186 2.01 1.87 201 24 2001 Dec 203 2243 4478 187 1.09 1.29 158 25 2002 Jan 223 2211 4454 186 1.20 1.28 174 26 2002 Feb 104 2253 4464 186 0.56 0.91 115 27 2002 Mar 107 2299 4552 190 0.56 0.62 174 28 2002 Apr 85 2412 4711 196 0.43 0.48 176 29 2002 May 75 2525 4937 206 0.36 0.43 176 30 2002 Jun 99 2648 5173 216 0.46 0.47 212 31 2002 Jul 135 2771 5419 226 0.60 0.65 207 32 2002 Aug 211 2928 5699 237 0.89 0.86
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

HW07_sol_X - Problem 3 Average 680 E 648.6 F 25.6 700 600...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online