EXPONENTIALSMOOTHING(Array, DampingFactor, 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
$NewTableFlag$ is a logical value that decides whether to display the output in the same worksheet or a new space cube.

EXPONENTIALSMOOTHING() predicts a value based on the forecast for the earlier data points, by adjusting the instability in earlier data points.

Description

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'.
$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.

Need to check the functionality of NewTableFlag after next release

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

=EXPONENTIALSMOOTHING(B1:B10,0.2,TRUE) returns the following table: