Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Day 1 622 622.000
Day 2 418 622.000 -204.000 204.000 41616.000 48.80%
Problem 11-16(a)
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
Day 1 622 1 557.800 64.200 64.200 4121.640 10.32%
Day 2 418 2 576.933 -158.933 158.933 25259.804 38.02%
Problem 11-16(b)