Manuals/calci/EXPONENTIALSMOOTHING

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

EXPONENTIALSMOOTHING(Array, DampingFactor, 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'.
• $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

Examples

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

Period	Array Input
0	0
1	45.5
2	60
3	200
4	160
5	300
6	340
7	310
8	500
9	566
10	610

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

EXPONENTIALSMOOTHING

Input	Output
0	null
45.5	0
60	36.4
200	55.28
160	171.056
300	162.21120000000002
340	272.44224
310	326.488448
500	313.2976896
566	462.65953792
610	545.331907584

See Also

• HISTOGRAM
• MOVINGAVERAGE

References

• Exponential Smoothing