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).
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 |