Manuals/calci/EXPONENTIALSMOOTHING

EXPONENTIALSMOOTHING(Array, DampingFactor, ShowChart, ShowStandardErrorOptions, NewTableFlag)

where, $Array$ is the input array or reference to the cells containing array,
$DampingFactor$ is a corrective factor that minimizes the instability of data,
$ShowChart$ is a logical value that decides whether to display a chart,
$ShowStandardErrorOptions$ is a logical value that decides whether to calculate standard errors,
is a logical value that decides whether to display the output in the same worksheet or a new space cube.
- EXPONENTIALSMOOTHING(), Smooths data, weighting more recent data heavier.

Description

EXPONENTIALSMOOTHING(Array, DampingFactor, ShowChart, ShowStandardErrorOptions, NewTableFlag)

Exponential Smoothing is a technique that can be applied to a set of data, either to produce smoothed data for presentations, or to make forecasts.
$Array$ should be array of numbers.
$DampingFactor$ is the exponential smoothing constant referred as α. Value of α should be greater than '0'.
If $DampingFactor$ < 0, Calci displays #NULL error message.
Smaller the damping factor, more smoother are the projections.
If $DampingFactor$ is omitted, Calci assumes it to be '0.3'.
$ShowChart$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
$ShowStandardErrorOptions$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
$NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If $NewTableFlag$ is TRUE, the result is displayed on new zspace sheet.

The syntax is to use this function in ZOS is $EXPONENTIALSMOOTHING(Array,DampingFactor,ShowChart,ShowStandardErrorOptions,NewTableFlag)$
For e.g.,EXPONENTIALSMOOTHING([10,12.3,18,9.4,22,39,45,51,29],0.5,true,false,true)

Consider the following table with Columns A as data point and Column B as array input for EXPONENTIALSMOOTHING() function.

=EXPONENTIALSMOOTHING(B3:B13, 0.2, TRUE, FALSE, TRUE) returns the below table followed by the chart output: