Sunday, December 4, 2011

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

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),Averag鈥?br>




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.|||the only way you can do that is to nest your formulas. but i dont think you will get a satisfacotry resolution that way.

No comments:

Post a Comment