Difference between revisions of "Manuals/calci/EXPONENTIALSMOOTHING"
Jump to navigation
Jump to search
| (7 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag) | + | <div style="font-size:25px">'''EXPONENTIALSMOOTHING(Array, DampingFactor, ShowChart, ShowStandardErrorOptions, NewTableFlag)'''</div><br/> |
| − | *where, <math>Array</math> is the input array or reference to the cells containing array | + | *where, <math>Array</math> is the input array or reference to the cells containing array, |
| − | *<math>DampingFactor</math> is a corrective factor that minimizes the instability of data | + | *<math>DampingFactor</math> is a corrective factor that minimizes the instability of data, |
| + | *<math>ShowChart</math> is a logical value that decides whether to display a chart, | ||
| + | *<math>ShowStandardErrorOptions</math> is a logical value that decides whether to calculate standard errors, | ||
*<math>NewTableFlag</math> is a logical value that decides whether to display the output in the same worksheet or a new space cube. | *<math>NewTableFlag</math> 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. | |
| − | EXPONENTIALSMOOTHING() | ||
== Description == | == Description == | ||
| − | EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag) | + | 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. | *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. | ||
| Line 17: | Line 18: | ||
*Smaller the damping factor, more smoother are the projections. | *Smaller the damping factor, more smoother are the projections. | ||
*If <math>DampingFactor</math> is omitted, Calci assumes it to be '0.3'. | *If <math>DampingFactor</math> is omitted, Calci assumes it to be '0.3'. | ||
| + | *<math>ShowChart</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE. | ||
| + | *<math>ShowStandardErrorOptions</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE. | ||
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE. | *<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE. | ||
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet. | *If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet. | ||
| − | < | + | |
| + | ==ZOS== | ||
| + | *The syntax is to use this function in ZOS is <math>EXPONENTIALSMOOTHING (Array,DampingFactor,ShowChart, ShowStandardErrorOptions,NewTableFlag)</math> | ||
| + | *For e.g.,EXPONENTIALSMOOTHING([10,12.3,18,9.4,22,39,45,51,29],0.5,true,false,true) | ||
== Examples == | == Examples == | ||
| − | Consider the following table with Columns A as data point and Column B as array input for | + | Consider the following table with Columns A as data point and Column B as array input for EXPONENTIALSMOOTHING() function. |
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
| Line 94: | Line 100: | ||
|} | |} | ||
| − | =EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE) returns the | + | =EXPONENTIALSMOOTHING(B3:B13, 0.2, TRUE, FALSE, TRUE) returns the below table followed by the chart output: |
<div id="5SpaceContent" class="zcontent" align="left"> | <div id="5SpaceContent" class="zcontent" align="left"> | ||
| Line 137: | Line 143: | ||
| 545.331907584 | | 545.331907584 | ||
|} | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|0r5pK8mlcXM|280|center|EXPONENTIAL SMOOTHING}} | ||
== See Also == | == See Also == | ||
| Line 146: | Line 156: | ||
*[http://en.wikipedia.org/wiki/Exponential_smoothing Exponential Smoothing] | *[http://en.wikipedia.org/wiki/Exponential_smoothing Exponential Smoothing] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 17:05, 10 August 2018
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.
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.
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:
| 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
See Also
References