To apply the methodThe function smoothes a series using the Moving Average method. It is included in the Smoothing group.
Moving average method presents a series as a sum of sufficiently smooth trend and a random component. The method is based on the local trend approximation using a polynomial of not an extremely high degree.
After the method is applied, a series with the name of the Moving Average(<Series_Name>) type and containing calculation results is added to the data table for each of the selected series. For example:
To set up calculation options, use the Parameters tab on the side panel.
Set method parameters:
Window Size. Time interval, in which the average element value is calculated. The greater is the window width, the smoother is the series. The window size is 5 by default.
The size of the smoothing window cannot be greater than the number of observations. If the window size is greater than the number of observations, the calculation is aborted. The calculated series is filled with empty values.
Center Moving Average. If the checkbox is selected, the centering method is applied to calculate smoothed values. The method is relevant if the window size is even.
See also:
Calculation Methods | Smoothing | Moving Average Method
Smoothing button on the Calculations ribbon tab.