Manuals/calci/EXPONENTIALSMOOTHING - Revision history

Devika at 22:05, 10 August 2018

2018-08-10T22:05:45Z

Devika at 22:50, 13 July 2018

2018-07-13T22:50:18Z

Jayaram at 07:27, 13 March 2017

2017-03-13T07:27:41Z

Devika: /* ZOS */

2015-06-08T16:04:17Z

ZOS

Devika at 19:29, 5 June 2015

2015-06-05T19:29:08Z

Swapna at 02:59, 30 April 2015

2015-04-30T02:59:58Z

Swapna at 14:31, 29 April 2015

2015-04-29T14:31:25Z

Swapna: /* Examples */

2014-04-30T14:51:04Z

Examples

Swapna at 22:15, 10 January 2014

2014-01-10T22:15:45Z

Swapna at 22:11, 10 January 2014

2014-01-10T22:11:59Z

@@ Line 6: / Line 6: @@
 *<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.
+**EXPONENTIALSMOOTHING(), Smooths data, weighting more recent data heavier.
 == Description ==

← Older revision		Revision as of 22:50, 13 July 2018
Line 1:		Line 1:
−	=EXPONENTIALSMOOTHING(Array, DampingFactor, ShowChart, ShowStandardErrorOptions, 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,

← Older revision		Revision as of 07:27, 13 March 2017
Line 157:		Line 157:

	*[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 ]]

@@ Line 26: / Line 26: @@
 ==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 ==

@@ Line 23: / Line 23: @@
 *<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.
 == Examples ==

@@ 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>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 ==
-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.
@@ Line 17: / Line 19: @@
 *Smaller the damping factor, more smoother are the projections.
 *If <math>DampingFactor</math> is omitted, Calci assumes it to be '0.3'.
 *<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.
 == Examples ==
@@ Line 94: / Line 97: @@
 |}
-  =EXPONENTIALSMOOTHING(B3:B13,0.2,TRUE) returns the following table:
+  =EXPONENTIALSMOOTHING(B3:B13, 0.2, TRUE, FALSE, TRUE) returns the below table followed by the chart output:
 <div id="5SpaceContent" class="zcontent" align="left">

@@ Line 137: / Line 137: @@
 | 545.331907584
 |}
 == See Also ==

@@ Line 22: / Line 22: @@
 == Examples ==
-Consider the following table with Columns A as data point and Column B as array input for MOVINGAVERAGE() function.
+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">

@@ Line 94: / Line 94: @@
 |}
-  =EXPONENTIALSMOOTHING(B1:B10,0.2,TRUE) returns the following table:
+  =EXPONENTIALSMOOTHING(B3:B12,0.2,TRUE) returns the following table:
 <div id="5SpaceContent" class="zcontent" align="left">
@@ Line 118: / Line 118: @@
 | 160
 | 171.056
-|- class="odd"
+|- class="even"
 | 300
 | 162.21120000000002
-|- class="even"
+|- class="odd"
 | 340
 | 272.44224
-|- class="odd"
+|- class="even"
 | 310
 | 326.488448
-|- class="even"
+|- class="odd"
 | 500
 | 313.2976896
-|- class="odd"
+|- class="even"
 | 566
 | 462.65953792
-| class="odd"
+|- class="odd"
 | 610
 | 545.331907584