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
Procedure
- Open the Model page of the Forecast editor.
- Click Add. The Forecast model selection page of the Add Model wizard opens.
- Click Weighted moving average and
then click Next. The Weighted moving average page of the Add Model wizard opens.
- Specify the number of previous time periods to use to calculate the moving average in the Number of periods drop-down list.
- 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.
- Click Finish. The Add Model wizard closes and the forecast model is displayed in the table.