Forecasting Linear trend analysis
Input Data Forecast Error Analysis
Period
Actual value
(or) Y
Period number
(or) X
Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 30 1 27.018 2.982 2.982 8.891 9.94%
Year 2 27 2 30.303 -3.303 3.303 10.910 12.23%
Problem 11-27
60
Trend Analysis