Forecasting Functions

Forecasting functions manipulate data for the purpose of smoothing, interpolating, or calculating future values. Forecasting functions are often used in planning, analysis, and modeling applications. Some forecasting functions recognize the optional Range List Parameters rangeList or XrangeList).

Table 2-13 Forecasting Functions

Function	Data Manipulation
@MOVAVG	Applies a moving average to a data set, replacing each term in the list with a trailing average. This function modifies the data set for smoothing purposes.
@MOVMAX	Applies a moving maximum to a data set, replacing each term in the list with a trailing maximum. This function modifies the data set for smoothing purposes.
@MOVMED	Applies a moving median to a data set, replacing each term in the list with a trailing median. This function modifies the data set for smoothing purposes.
@MOVMIN	Applies a moving minimum to a data set, replacing each term in the list with a trailing minimum. This function modifies the data set for smoothing purposes.
@MOVSUM	Applies a moving sum to a data set. This function modifies the data set for smoothing purposes.
@MOVSUMX	Applies a moving sum to a data set, enabling specification of values for trailing members. This function modifies the data set for smoothing purposes.
@SPLINE	Applies a smoothing spline to a set of data points. A spline is a mathematical curve that is used to smooth or interpolate data.
@TREND	Calculates future values, basing the calculation on curve-fitting to historical values