Manuals/calci/EXPONENTIALSMOOTHING

From ZCubes Wiki
Jump to navigation Jump to search
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

See Also

References