Extrapolative forecasting, using models such as exponential smoothing, is arguably not very complicated from a mathematical point of view, but it requires a shift in logic in terms of what is a good forecast. For this discussion I will use a simple form of exponential smoothing to demontrate my point. 1. The forecasting model: single… Read More »
From time to time people have asked me how to implement Holt Winters (trend-seasonal exponential smoothing) in Excel. I have my reservations for using Excel to do your day-to-day forecasting. Nonetheless, you can find an example here.