Forecasting 4 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Quarter 1 263
Quarter 2 300
Quarter 3 245
Quarter 4 381
Quarter 5 312 297.250 14.750 14.750 217.563 4.73%
Problem 11-45
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
Quarter 1 263 1 293.088 -30.088 30.088 905.302 11.44%
Quarter 2 300 2 297.401 2.599 2.599 6.752 0.87%
Quarter 3 245 3 301.715 -56.715 56.715 3216.558 23.15%
Quarter 4 381 4 306.028 74.972 74.972 5620.810 19.68%
Quarter 5 312 5 310.341 1.659 1.659 2.752 0.53%
Problem 11-45