So we've reached triple exponential smoothing.
A bit of history first.
Exponential smoothing was first proposed in 1957 by C. C. Holt and intended for non-recurrent (no seasonality) time series, that doesn't show any trends.
In 1958, he also proposed a modification of this method, which takes into account the trend - double exponential smoothing.
In 1965, Winters generalized this method to a seasonally adjusted. Therefore, the triple exponential smoothing method is also called the Holt-Winters (Holt-Winters method).
Since I've already said all sorts of introductions in previous articles let's get straight to the formulas.
Triple exponential smoothing:
, , takes the value from the range [0;1]
y - observation
S - smoothed observation value
b - trend rate
I - seasonality index
F - forecast for m periods ahead
t - current observation index
As well as for the other exponential smoothing, , , are chosen by trial and error so as to minimize the mean square error.
The special thing here - the existence of L, determining the number of periods. By the number of periods, it's needed to construct the corresponding starting seasonality indices. Thus, the method, in terms of the seasonality indices calculation, requires minimum L of observations. It is clear, that the more full seasons available, the better - the initial seasonality indices will be more precise.
Seasonality indices are calculated as follows - suppose there is observational evidence for n seasons by L periods.
1) mean value is calculated for each season
, j varies from 1 to n
2) seasonality index is calculated for each period
, i varies from 1 to L
- observation, corresponding to i period of season j.
Next - to correctly calculate the initial trend, we must be able to take the seasonal fluctuations impact into account. If we only have data for a single season (e.g., year - L = 12), the trend will be difficult to distinguish from the seasonal fluctuations. Thus, the method, in terms of the initial coefficient trend calculation, requires minimum 2L of observations. With the data for two seasons ( L = 24), it is clear, that it is already possible to identify a trend, comparing the respective season periods (for example, in January last year to January this year).
Commonly used formula for trend estimation
As we can see, the data of two seasons is used.
Hence the moral - it is best to use a triple exponential smoothing for the data showing a strong trend and the presence of seasonal fluctuations while it is necessary to have the results of 2L and more observations.
The calculator below is the quintessence of all three articles - it builds a simple exponential smoothing, double exponential smoothing and a triple exponential smoothing. In addition, it builds forecasted values at the specified distance.
Set the parameters , , , data frequency L (4 by default - 4 quarters of a year) and forecast range m (also 4).
Note: The calculator will work only if there is at least
P.S. By the way, if the default date will be replaced with the data really have a strong trend and frequency, the mean square error of triple smoothing will be much less than the mean square error of single and double smoothing. That even surprised me. The default data, perhaps, not very indicative for demonstration.
Save the calculation to reuse next time or share with friends.