Centered Moving Average
The Centered Moving Average function computes a centered moving average of “NAVG”
values for regular or irregular interval time series data. The number of values to
average over (“NAVG”) must be an odd integer greater than 2.
The Only Valid Values option pertains to when the averaging interval contains
missing values. If checked, the option sets the value in the resultant data set to
missing. If unselected, the option computes a smoothed value from the valid values
in the interval.
The Use Reduced Number of Values option pertains to the first and last NAVG/2
values in the resultant data. If selected, the option computes smoothed values at
the beginning and ending of the data set from a reduced number of values of the original
data set. If unselected, the option sets the first and last NAVG/2 values in the
resultant data to missing.
Centered Moving Average
To compute the centered moving average for time series data:
-
Choose the Smoothing tab of the Math Functions screen and select the Centered
Moving Average operator, as shown in the figure above.
-
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.
-
In the Number to Average Over box, enter a value to set the number of values for
the moving average. This number must be an odd number greater than two (2).
-
Select the Only Valid Values box to compute a smoothed value only if all the
values in the averaging interval are valid (no missing values). If there are one
or more missing values, the value in the resultant time series data is then set to
missing. If the box is not checked, the value in the resultant time series data
is computed using the remaining valid values in the averaging interval.
-
Select the Use Reduced Number of Values box to compute a moving average from a
reduced number of time series values near the beginning and ending of a time
series. At these locations, the moving average interval becomes truncated and
there are not “Number to Average Over” values for averaging. If unchecked, values
in the resultant time series data at these locations will be set to missing.
-
Click Compute to perform a centered moving average smoothing of the selected
data.