Case 9-1 Dell revenue forecast_completed

Case 9-1 Dell revenue forecast_completed - Hewlett China...

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

View Full Document Right Arrow Icon
year 1985 0.03 4.22 7.1 210.8 1986 0.07 4.46 8.1 116.5 0.275 1987 0.16 4.74 9.8 61.8 0.294 1988 0.26 5.10 11.9 46.2 0.361 1989 0.39 5.48 13.2 34.1 0.398 1990 0.55 5.80 14.5 26.5 0.339 1991 0.89 6.00 16.4 18.4 0.351 1992 2.01 6.34 20.3 10.1 0.412 1993 2.87 6.66 25.0 8.7 0.517 1994 3.48 7.07 31.5 9.1 0.467 1995 5.30 7.40 38.4 7.3 0.601 1996 7.76 7.82 35.4 4.6 0.699 1997 12.33 8.30 39.3 3.2 0.771 1998 18.24 8.75 42.4 2.3 0.817 1999 25.27 9.27 48.9 1.9 0.861 5 2000 31.89 9.82 45.2 1.4 0.946 2001 31.17 10.13 56.6 1.8 1.038 2002 35.26 10.47 73.1 2.1 1.132 2003 41.33 10.96 79.9 1.9 1.270 2004 49.12 11.69 86.7 1.8 1.486 2005 55.79 12.43 91.7 1.6 1.716 2006 57.42 13.19 2.013 2007 2.460 2008 2.798 Dell revenues (B$) U.S. GDP (T$) Hewlett Packard revenues ($B) Hewlett Packard revenues to Dell revenues China gdp per capita (K$)
Background image of page 1

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

View Full DocumentRight Arrow Icon
year 1985 0.03 4.22 7.1 210.8 Lag 4 0.973173 0.96933165 -0.5653295 1986 0.07 4.46 8.1 116.5 0.275 Lag 3 0.973458 0.96341144 -0.6174381 1987 0.16 4.74 9.8 61.8 0.294 Lag 2 0.972863 0.95866264 -0.6789734 1988 0.26 5.10 11.9 46.2 0.361 1989 0.39 5.48 13.2 34.1 0.398 1990 0.55 5.80 14.5 26.5 0.339 1991 0.89 6.00 16.4 18.4 0.351 1992 2.01 6.34 20.3 10.1 0.412 1993 2.87 6.66 25.0 8.7 0.517 1994 3.48 7.07 31.5 9.1 0.467 1995 5.30 7.40 38.4 7.3 0.601 1996 7.76 7.82 35.4 4.6 0.699 1997 12.33 8.30 39.3 3.2 0.771 1998 18.24 8.75 42.4 2.3 0.817 1999 25.27 9.27 48.9 1.9 0.861 2000 31.89 9.82 45.2 1.4 0.946 2001 31.17 10.13 56.6 1.8 1.038 2002 35.26 10.47 73.1 2.1 1.132 2003 41.33 10.96 79.9 1.9 1.270 2004 49.12 11.69 86.7 1.8 1.486 2005 55.79 12.43 91.7 1.6 1.716 2006 57.42 13.19 2.013 2007 2.460 2008 2.798 Dell revenues (B$) U.S. GDP (T$) Hewlett Packard revenues ($B) Hewlett Packard revenues to Dell revenues China gdp per capita (K$) US GDP (T$) HP revenues ($B) HP revenues to Dell revenues
Background image of page 2
year 1989 0.39 4.46 1990 0.55 4.74 1991 0.89 5.10 1992 2.01 5.48 1993 2.87 5.80 1994 3.48 6.00 1995 5.30 6.34 1996 7.76 6.66 1997 12.33 7.07 1998 18.24 7.40 1999 25.27 7.82 2000 31.89 8.30 2001 31.17 8.75 2002 35.26 9.27 2003 41.33 9.82 2004 49.12 10.13 2005 55.79 10.47 2006 57.42 10.96 2007 11.69 2008 12.43 13.19 Dell revenues (B$) US GDP (T$) lag 3
Background image of page 3

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.9734578059 R Square 0.9476200998 Adjusted R Square 0.9438786784 Standard Error 3.9193335176 Observations 16 ANOVA df SS MS F Significance F Regression 1 3890.64921493 3890.64921493 253.2781 2.3199232E-010 Residual 14 215.05645311 15.3611752221 Total 15 4105.70566804 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -46.3460408877 4.0833229889 -11.3500795832 1.9E-008 -55.1038976496 -37.588184 US GDP (T$) lag 3 8.9215115627 0.5605826164 15.9147131973 2.3E-010 7.7191814334 10.1238417 RESIDUAL OUTPUT Observation Predicted Dell revenues (B$) Residuals Durbin Watson dL
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 / 13

Case 9-1 Dell revenue forecast_completed - Hewlett China...

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