Top  Previous  Next

Calculates the moving point average, or centred moving point average, for the data in column with a cycle length of cyclelen.


The MPA function automatically centres the moving point average if cyclelen is even.


The data in column B of the example has been generated using MPA(A,4)




Note:  If you type decimals using a comma (eg 3,2) you should enter this formula as MPA(A ; 4) - using the ; as a separator