Explore BrainMass

Explore BrainMass

    Exponential Smoothing Forecast


    Given the following data, use exponential smoothing with a=0.2 and a=0.5 to generate forecasts for periods 2 through 6. Use MAD and MSE to decide which of the two models produced a better forecast.

    Period Actual Forecast
    1 15 17
    2 18
    3 14
    4 16
    5 13
    6 16


    Solution Summary

    This solution is comprised of detailed step-by-step calculation of the given problem in EXCEL and provides students with a clear perspective of the underlying concepts.