Revision as of 08:31, 29 April 2015

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.

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 EXPONENTIALSMOOTHING() function.

=EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE) returns the following table:

@@ Line 137: / Line 137: @@
 | 545.331907584
 |}
+==Related Videos==
+{{#ev:youtube|0r5pK8mlcXM|280|center|EXPONENTIAL SMOOTHING}}
 == See Also ==