Manuals/calci/MOVINGAVERAGE - Revision history

Devika at 22:18, 10 August 2018

2018-08-10T22:18:38Z

Devika at 22:18, 10 August 2018

2018-08-10T22:18:20Z

Devika at 19:15, 13 June 2018

2018-06-13T19:15:36Z

Jayaram at 07:31, 13 March 2017

2017-03-13T07:31:37Z

Swapna: /* MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag) */

2015-04-30T02:51:41Z

MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag)

Swapna at 14:38, 29 April 2015

2015-04-29T14:38:41Z

Swapna at 22:17, 10 January 2014

2014-01-10T22:17:34Z

Swapna at 23:13, 9 January 2014

2014-01-09T23:13:01Z

Swapna at 23:10, 9 January 2014

2014-01-09T23:10:05Z

Swapna at 23:07, 9 January 2014

2014-01-09T23:07:49Z

Show changes

← Older revision		Revision as of 22:18, 10 August 2018
Line 1:		Line 1:
−	~~=MOVINGAVERAGE (Array,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)=~~
	<div style="font-size:25px">'''MOVINGAVERAGE (Array,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)'''</div><br/>		<div style="font-size:25px">'''MOVINGAVERAGE (Array,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)'''</div><br/>

@@ Line 1: / Line 1: @@
 =MOVINGAVERAGE (Array,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)=
 *where, <math>Array</math> is an array of reference to cells containing an array,
@@ Line 6: / Line 7: @@
 *<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.
+**MOVINGAVERAGE(), calculates the expected value, over a past period of fixed length at any time.
 == Description ==

@@ Line 1: / Line 1: @@
-=MOVINGAVERAGE(SomeArray, PeriodInterval, ShowChart, ShowStandardErrorOptions, NewTableFlag)=
+=MOVINGAVERAGE (Array,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)=
-*where, <math>SomeArray</math> is an array of reference to cells containing an array,
+*where, <math>Array</math> is an array of reference to cells containing an array,
 *<math>PeriodInterval</math> represents the number of intervals,
 *<math>ShowChart</math> is a logical value that decides whether to display a chart,
@@ Line 11: / Line 11: @@
 == Description ==
-MOVINGAVERAGE(SomeArray, PeriodInterval, ShowChart, ShowStandardErrorOptions, NewTableFlag)
+MOVINGAVERAGE(Array, PeriodInterval, ShowChart, ShowStandardErrorOptions, NewTableFlag)
 *Moving average is a calculation to analyze data points by creating a series of averages of different subsets of the full data set.
-*<math>SomeArray</math> can be any positive integers including zero '0'.
+*<math>Array</math> can be any positive integers including zero '0'.
 *e.g. If <math>PeriodInterval</math> is set to '6', the average of previous 5 points and the current data point is calculated. Moving Average for first '5' data points cannot be calculated due to less number of data points. Hence Moving average for first '5' data points will be ''null''.
 *If <math>PeriodInterval</math> is omitted, Calci assumes it to be 3.

← Older revision		Revision as of 07:31, 13 March 2017
Line 153:		Line 153:

	*[http://en.wikipedia.org/wiki/Moving_average Moving Average]		*[http://en.wikipedia.org/wiki/Moving_average Moving Average]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 1: / Line 1: @@
-=MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag)=
+=MOVINGAVERAGE(SomeArray, PeriodInterval, ShowChart, ShowStandardErrorOptions, NewTableFlag)=
-*where, <math>Array</math> is an array of reference to cells containing an array
+*where, <math>SomeArray</math> is an array of reference to cells containing an array,
-*<math>PeriodInterval</math> represents the number of intervals
+*<math>PeriodInterval</math> represents the number of intervals,
 *<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 ==
-MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag)
+MOVINGAVERAGE(SomeArray, PeriodInterval, ShowChart, ShowStandardErrorOptions, NewTableFlag)
 *Moving average is a calculation to analyze data points by creating a series of averages of different subsets of the full data set.
-*<math>Array</math> can be any positive integers including zero '0'.
+*<math>SomeArray</math> can be any positive integers including zero '0'.
 *e.g. If <math>PeriodInterval</math> is set to '6', the average of previous 5 points and the current data point is calculated. Moving Average for first '5' data points cannot be calculated due to less number of data points. Hence Moving average for first '5' data points will be ''null''.
 *If <math>PeriodInterval</math> is omitted, Calci assumes it to be 3.
 *If <math>PeriodInterval</math> &lt; 4, Calci returns an #N/A error message.
 *If <math>PeriodInterval</math> &gt; 'Length of Array', Calci returns an #N/A error message.
 *<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: @@
 |}
-  =MOVINGAVERAGE(B3:B13, 6, TRUE) returns the following table:
+  =MOVINGAVERAGE(B3:B13, 6, TRUE, FALSE, TRUE) returns the below table followed by the chart output:
 <div id="5SpaceContent" class="zcontent" align="left">

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

@@ Line 94: / Line 94: @@
 |}
-  =MOVINGAVERAGE(A1:A11, 6, TRUE) returns the following table:
+  =MOVINGAVERAGE(B1:B11, 6, TRUE) returns the following table:
 <div id="5SpaceContent" class="zcontent" align="left">