# Manuals/calci/EXPONENTIALSMOOTHING

EXPONENTIALSMOOTHING(Array, DampingFactor, ShowChart, ShowStandardErrorOptions, 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 a chart,
• is a logical value that decides whether to calculate standard errors,
• 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.
• 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.
• can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
• 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.

## ZOS

• The syntax is to use this function in ZOS is • 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