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.
should be array of numbers.
is the exponential smoothing constant referred as α. Value of α should be greater than '0'.
If < 0, Calci displays #NULL error message.
Smaller the damping factor, more smoother are the projections.
If is omitted, Calci assumes it to be '0.3'.
can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If is TRUE, the result is displayed on new zspace sheet.

The syntax is to use this function in ZOS is
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: