Difference between revisions of "Manuals/calci/EXPONENTIALSMOOTHING"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | =EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)= | + | =EXPONENTIALSMOOTHING(Array, DampingFactor, ShowChart, ShowStandardErrorOptions, NewTableFlag)= |
| − | *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. | ||
| Line 9: | Line 11: | ||
== 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 19: | ||
*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. | ||
| − | |||
== Examples == | == Examples == | ||
| Line 94: | Line 97: | ||
|} | |} | ||
| − | =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"> | ||
Revision as of 20:59, 29 April 2015
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.
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() predicts a value based on the forecast for the earlier data points, by adjusting the instability in earlier data points.
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.
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 |