writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + + + Line 9:
Line 11: − + − + + + − <font color="blue">Need to check the functionality of NewTableFlag after next release</font> Line 94:
Line 97: − +
Manuals/calci/MOVINGAVERAGE (view source)
Revision as of 02:51, 30 April 2015
, 02:51, 30 April 2015→MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag)
=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>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.
== Description ==
== 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.
*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''.
*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> is omitted, Calci assumes it to be 3.
*If <math>PeriodInterval</math> < 4, Calci returns an #N/A error message.
*If <math>PeriodInterval</math> < 4, Calci returns an #N/A error message.
*If <math>PeriodInterval</math> > 'Length of Array', Calci returns an #N/A error message.
*If <math>PeriodInterval</math> > 'Length of Array', Calci returns an #N/A error message.
*<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 ==
|}
|}
=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">
<div id="5SpaceContent" class="zcontent" align="left">