Manuals/calci/EXPONENTIALSMOOTHING
EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)
- where, is the input array or reference to the cells containing array
- is a corrective factor that minimizes the instability of data
- 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.
- 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.
- If 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 MOVINGAVERAGE() 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(B1:B10,0.2,TRUE) returns the following table:
| 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 | class="odd" | 610 | 545.331907584 |