Featured image for the Double Exponential Smoothing blog showing the international passenger airline monthly data.

Holt’s Double Exponential Smoothing

Simple exponential smoothing does not do well in the presence of a trend, so several methods devised under the “Double Exponential” umbrella are proposed to handle this type of data.

NumXL supports Holt’s double exponential smoothing, which take the following formulation:

$$S_1=X_1$$ $$B_1=\frac{X_T-X_1}{T-1}$$ $$S_{t>1}=\alpha X_t + (1-\alpha)(S_{t-1}+B_{t-1})$$ $$B_{t>1}=\beta (S_t – S_{t-1})+(1-\beta)B_{t-1}$$ $$Y_t=\left\{\begin{matrix} S_t+B_t & t<T\\ S_T+m\times B_T & t=T+m \end{matrix}\right.$$

Where:

  • $\alpha$ is the smoothing factor ($0 \prec \alpha \prec 1$)
  • $\beta$ is the trend smoothing factor ($0 \prec \beta \prec 1$)

Example 1:

Let’s examine the international passengers’ airline data.

We chose an Alpha value of 0.9 and a Beta of 0.1. Please note that although double smoothing traces the original data well, the out-of-sample forecast is inferior to the simple moving average.

How do we find the best smoothing factors?

We take a similar approach to our simple exponential smoothing example but modified for two variables. We compute the sum of the squared errors; construct a two-variable data table, and pick the alpha and beta values that minimize the overall SSE.

Tutorial Video

Files Examples

Please click the button below to download Holt’s Double Exponential Smoothing example.

Icon

Holt Double Smoothing 0.00 KB

Example shows Double (Holts) Exponential Smoothing method ...

Leave a Reply

Your email address will not be published.

We are glad you have chosen to leave a comment. Please keep in mind that comments are moderated according to our comment policy.