Forecasting Causal regression analysis
Input Data Forecast Error Analysis
Period
Dep Variable
(or) (Y)
Indep Variable
(or) (X)
Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 41 4000 39.610 1.390 1.390 1.933 3.39%
Year 2 38 3500 38.327 -0.327 0.327 0.107 0.86%
Problem 11-37
25
27
33
41
43
45
1500 2000 2500 3000 3500 4000 4500
Dependent Variable, Y
Independent Variable, X
Regression Line
25
27
29
31
35
37
43
45
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8
Actual vs. Forecast
Actual