The tool supports interface of Foresight Analytics Platform 9 or earlier.

Trend

The method enables the user to remove the seasonal component from a time series and create a theoretical time series based on a change pattern expressed in mathematical terms. The following trend models are available in the time series database:

NOTE. On changing the data of the source series, the Autotrend calculated series automatically takes the optimal trend and it is recalculated.

Trend methods are included in the Forecasting group.

To apply the method

After the method is applied, in the workbook, based on each selected series a calculated series with a name of the <Method_Name>(<Series_Name>) type is created, containing the calculation results. For example:

Setting Up Calculation Parameters. The Parameters Tab

To set up calculation parameters, use the Parameters side panel tab.

To display the tab

Specify method parameters on the tab:

If there is no seasonality, equation coefficients are estimated based on the source series using the least-squares method.

If the series contains a seasonal component, first the calculations, connected to excluding this periodically repeating component from the original series, are performed. After the seasonal component has been calculated and excluded from the source series, equation coefficients are estimated. Linear method of least squares is used for estimation.

See also:

Working with Calculated Series | Trend with Functional Dependency Estimation | Modeling Container Trend with Functional Dependency Estimation | IModelling.Extrapolate