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

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