Manuals/calci/MOVINGAVERAGE
Jump to navigation
Jump to search
MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag)
where,
Array - Input range should be one block.
PeriodInterval - represents the number of intervals. The default interval is 3.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
Moving Average calculatesthe expected value over a past period of fixed length at any time.
Lets see an example in (Column3Row1)
=MOVINGAVERAGE(R1C1:R6C1,3, TRUE)
MOVINGAVERAGE returns the result in new sheet(5Space).
MOVINGAVERAGE(R1C1:R6C1, 7, TRUE)
MOVINGAVERAGE returns the #ERROR(LengthofArray < PeriodInterval).
MOVING AVERAGE
Syntax
Remarks
Examples
Description
If Length of Array < 4 ,MOVINGAVERAGE return the #ERROR.
MOVINGAVERGAGE returns the #ERROR, if Length of Array < PeriodInterval.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 11 | 3 | 5Space | 5 |
| Row2 | 70 | 8 | 9 | 128 |
| Row3 | 12 | #ERROR | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 110 | 26 | 10023 | 168 |
| Row6 | 6 | 8 | 1.619775 | 0.525322 |
| Input | Moving Average |
|---|---|
| 11 | null |
| 70 | null |
| 12 | 31 |
| 17 | 33 |
| 110 | 46.333333333333336 |
| 6 | 44.333333333333336 |