Difference between revisions of "Manuals/calci/MOVINGAVERAGE"
| (7 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag) | + | <div style="font-size:25px">'''MOVINGAVERAGE (Array,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)'''</div><br/> |
| − | *where, <math>Array</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>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. | ||
| − | + | **MOVINGAVERAGE(), calculates the expected value, over a past period of fixed length at any time. | |
| − | MOVINGAVERAGE() calculates the expected value, over a past period of fixed length at any time. | ||
== Description == | == Description == | ||
| − | MOVINGAVERAGE(Array, PeriodInterval, 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. | *Moving average is a calculation to analyze data points by creating a series of averages of different subsets of the full data set. | ||
| Line 17: | Line 18: | ||
*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 == | ||
| Line 94: | Line 96: | ||
|} | |} | ||
| − | =MOVINGAVERAGE( | + | =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"> | ||
| Line 137: | Line 139: | ||
| 437.6666666666667 | | 437.6666666666667 | ||
|} | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|OuCS-wG0eh4|280|center|MOVING AVERAGE}} | ||
== See Also == | == See Also == | ||
| Line 146: | Line 152: | ||
*[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 ]] | ||
Latest revision as of 16:18, 10 August 2018
MOVINGAVERAGE (Array,PeriodInterval,ShowChart,ShowStandardErrorOptions,NewTableFlag)
- where, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is an array of reference to cells containing an array,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PeriodInterval} represents the number of intervals,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ShowChart} is a logical value that decides whether to display a chart,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ShowStandardErrorOptions} is a logical value that decides whether to calculate standard errors,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag}
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
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.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} can be any positive integers including zero '0'.
- e.g. If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PeriodInterval} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PeriodInterval} is omitted, Calci assumes it to be 3.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PeriodInterval} < 4, Calci returns an #N/A error message.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PeriodInterval} > 'Length of Array', Calci returns an #N/A error message.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ShowChart} can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ShowStandardErrorOptions} can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} 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 MOVINGAVERAGE() 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 |
=MOVINGAVERAGE(B3:B13, 6, TRUE, FALSE, TRUE) returns the below table followed by the chart output:
| Input | Moving Average |
|---|---|
| 0 | null |
| 45.5 | null |
| 60 | null |
| 200 | null |
| 160 | null |
| 300 | 127.58333333333333 |
| 340 | 184.25 |
| 310 | 228.33333333333334 |
| 500 | 301.6666666666667 |
| 566 | 362.6666666666667 |
| 610 | 437.6666666666667 |
Related Videos
See Also
References