Forecasting 2 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Week 1 22
Week 2 27
Week 3 30 24.500 5.500 5.500 30.250 18.33%
Week 4 21 28.500 -7.500 7.500 56.250 35.71%
Problem 11-17
Forecasting 3 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Week 1 22
Week 2 27
Week 3 30
Week 4 21 26.333 -5.333 5.333 28.444 25.40%
Problem 11-17
Forecasting 4 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Week 1 22
Week 2 27
Week 3 30
Week 4 21
Problem 11-17