Choosing the most appropriate forecasting method for your time series is not a trivial task and even though there has been scientific forecasting for so many decades, how to best do it is still an open research question. Nonetheless, there are some reasonable ways to deal with the problem, which although they may not be… Read More »
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.