How do i take a moving average of a moving average in excel within the same cell?

29 Aug 2009

29 Aug, 2009 Moving

I have some data i wish to smooth. I know how to take a moving average but then i wish to take a moving average of the original moving average within the same cell instead of using other cells within excel.

Any help would be greatly appreciated.

Thanks.

It depends on the precision of the average. To Average 25 cells down 1 by way of 5 parts, try:
Average(Average(A1,A2,A3,A4,A5),Average(A6,A7,A8,A9,A10),….,Average(A21,A22,A23,A24,A25))

This would create 5 averages of 5 cells each and average the resulting 5 values.

I am not sure what the double averages accomplishes, Just take an average of a wider range to get a more summary average. It would accomplish the same thing.

TrackBack URI | RSS feed for comments on this post

2 Responses

The Drunken Fool
2009 Aug 29 1

the only way you can do that is to nest your formulas. but i dont think you will get a satisfacotry resolution that way.
References :
kpizura
2009 Aug 29 2

It depends on the precision of the average. To Average 25 cells down 1 by way of 5 parts, try:
Average(Average(A1,A2,A3,A4,A5),Average(A6,A7,A8,A9,A10),….,Average(A21,A22,A23,A24,A25))

This would create 5 averages of 5 cells each and average the resulting 5 values.

I am not sure what the double averages accomplishes, Just take an average of a wider range to get a more summary average. It would accomplish the same thing.
References :

Moving House