Setting weighted moving average parameters

A weighted moving average smooths a time series by forecasting the value for each period using the weighted average of several previous periods.

About this task

To specify weighted moving average parameters:

Procedure

  1. Open the Model page of the Forecast editor.
  2. Click Add.
    The Forecast model selection page of the Add Model wizard opens.
  3. Click Weighted moving average and then click Next.
    The Weighted moving average page of the Add Model wizard opens.
  4. Specify the number of previous time periods to use to calculate the moving average in the Number of periods drop-down list.
  5. Specify a weight for each of the previous periods in the Weight column of the table.
    The periods are listed from the earliest to the most recent. For example, giving a high weight to the last period in the list will increase the importance of the most recent data relative to earlier data.
  6. Click Finish.
    The Add Model wizard closes and the forecast model is displayed in the table.