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 March 21, 2019, 9:26 pm 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.