Search

# Double Exponential Smoothing Help

The Double Exponential Smoothing time series analysis is used to analyze data that has a trend and no seasonal component. The Double Exponential Smoothing model used for the fit is:

L1 = Y1

T1 = 0

Lt = αYt + (1 – α)(Lt-1 + Tt-1)

Tt = g( Lt – Lt-1) + (1 – g) Tt-1

Ŷt = Lt-1 + Tt-1

where

This help page describes how to perform the Double Exponential Smoothing time series analysis using the SPC for Excel software with the data that can be downloaded at this link. This page contains the following:

### Data Entry

Enter your data in a spreadsheet as shown below. The data must be in a single column with or without a heading. The data can be anywhere in the spreadsheet. There can be no empty cells or non-numeric entries in the data (except if there is a heading). It is important that the data represent evenly spaced data in time.

### Running the Analysis

Select the data on the worksheet to be included in the analysis. You just have to put the cursor in the first row (the data or the heading as shown above). The software will select the data automatically then.

To start the analysis, select “Time Series” under the “Analysis” panel on the SPC for Excel ribbon. The form below is shown.

Weight Options:

### Output

The output from the Double Exponential Smoothing time series analysis consists of two parts: the chart and the printed results (if that option was selected).

The Double Exponential Smoothing chart is shown below. It includes the actual values, the fitted values, the forecasts (if a number greater than 0 was entered; 6 was used in this example), the values of MAPE, MAD, and MSD, as well as the best fit equation.

The forecast values for the next k time periods is given by :

Ŷt+1 = Lt + kTt

The 95% prediction limits are given by:1

Var(et(k))=[1 +(1/6) (k – 1)α2(1 + kg + k(2k-1)g2)]σe2

Upper Prediction Limit = Forecast + 1.96 × [Var(et(k))]1/2
Lower Prediction Limit = Forecast – 1.96 × [Var(et(k))]1/2

where k = number of steps ahead and σe2 = Var(et(l)) = the variance of the one step ahead forecast errors, which is estimated from the data used for fitting.

The printed results are shown below. It includes the same information as in the chart but in tabular format.

### Interpretation of Output

The first thing to do is to examine the chart of the fitted values with the actual values. Decide if the fitted values fit the data. If they do, then it is probably a good fit. If you ran other models, you compare the three accuracy measures (MAPE, MAD, and MSD) described in the first time series help page. The smaller the values, the better the fit.

If there are forecasts values, you can check to see how good they might be. You want the fitted values to closely follow the actual results. If it begins to vary at the end of the actual data, something may be changing (like the trend).

1Prediction Intervals fro the Holt-Winters Forecasting Procedure; Chatfield and Yar, International Journal of Forecasting 6 (1990)

Scroll to Top