Ch04Ex8 - this is causal regression then enter the y,x...

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

View Full Document Right Arrow Icon
CHAPTER 4: Example 8 Forecasting Regression/Trend analysis Date Forecasts and Error Analysis Period Demand (y) Period (x) Forecast Error Absolute Squared 2001 74 1 67.25 6.75 6.75 45.56 2002 79 2 77.79 1.21 1.21 1.47 2003 80 3 88.32 -8.32 8.32 69.25 2004 90 4 98.86 -8.86 8.86 78.45 2005 105 5 109.39 -4.39 4.39 19.3 2006 142 6 119.93 22.07 22.07 487.15 2007 122 7 130.46 -8.46 8.46 71.64 Total 0 60.07 772.82 Intercept 56.71 Average 0 8.58 110.4 Slope 10.54 Bias MAD MSE SE 12.43 Next period 141 8 Correlation 0.89 0 0 20 40 60 80 100 120 140 160 If this is trend analysis then simply enter the past demands in the demand column. If
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: this is causal regression then enter the y,x pairs with y first and enter a new value of x at the bottom in order to forecast y. Abs Pct Err 09.12% 01.54% 10.40% 09.84% 04.18% 15.54% 06.94% 57.57% 08.22% MAPE 1 2 3 4 5 6 7 8 Regression Column B Linear Re-gression for Column B...
View Full Document

This note was uploaded on 11/24/2010 for the course QUANT DSCI taught by Professor B during the Fall '10 term at Fairleigh Dickinson.

Page1 / 2

Ch04Ex8 - this is causal regression then enter the y,x...

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