To apply the methodThe function executes seasonal decomposition and adjustment of monthly or quarterly data using the X11 method. It decomposes the source series into a seasonal, trend-cycle and irregular component, and finds the seasonal adjustment. It is included in the Smoothing group.
NOTE. The X11 method is supported only in Windows.
After the function is applied, a series with the name of the X11(<Series_Name>) type and containing calculation results is added to the data table for each of the selected series. For example:
If the smoothed series does not have quarterly or monthly frequency, the calculation is aborted. The calculated series is filled with empty values.
To set up specific calculation options, use the tabs on the side panel:
Parameters. It enables the user to change basic calculation parameters: applied seasonality model, applied adjustments, and so on.
Moving Average. It enables the user to set moving average calculation method for each element of the source series calendar frequency.
Weight Coefficients. It enables the user to set weight coefficients for week days.
See also:
Calculation Methods | Smoothing | The X11 Method
Smoothing button on the Calculations ribbon tab.