Explore BrainMass

Explore BrainMass

    Exponential Smoothing Forecast

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 4, 2020, 1:03 am ad1c9bdddf

    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.