Math Functions > Smoothing Functions


Forward Moving Average

The Forward Moving Average function computes a moving average of the last “NAVG” values for regular or irregular interval time series data.  The number of values for averaging, “NAVG,” must be greater than 2.  The first NAVG-1 values in the resultant time series are set to missing.

 

If the averaging interval contains a missing value, the smoothed value is computed from the remaining valid values in the interval.  However, if there are less than 2 valid values in the interval, the value in the resultant data is set to missing.

 

Forward Moving Average

 

To compute the forward moving average for time series data:

  1. Choose the Smoothing tab of the Math Functions screen and select the Forward Moving Average operator, as shown above.
  2. Select a data set to apply the function from the Selected Data Set pull-down list at the top of the screen or multiple data sets from the list in the lower portion of the screen.  If you include the data set selected in the top Selected Data Set, the operation on that set will only be done once.
  3. In the Number to Average Over box, enter the number of values in the averaging interval.  This number must be greater than two (2).
  4. Click Compute.