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,
• $NewTableFlag$ 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.
• $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'.
• $ShowChart$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
• $ShowStandardErrorOptions$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
• $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.

ZOS

• The syntax is to use this function in ZOS is $EXPONENTIALSMOOTHING(Array,DampingFactor,ShowChart,ShowStandardErrorOptions,NewTableFlag)$
• For e.g.,EXPONENTIALSMOOTHING([10,12.3,18,9.4,22,39,45,51,29],0.5,true,false,true)

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, FALSE, TRUE) returns the below table followed by the chart output:

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

Related Videos

EXPONENTIAL SMOOTHING

See Also

• HISTOGRAM
• MOVINGAVERAGE

References

• Exponential Smoothing

• List of Main Z Functions

• Z3 home