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

moving
Phil R


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.

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Fark
  • Furl
  • MisterWong
  • NewsVine
  • Propeller
  • Reddit
  • Simpy
  • Slashdot
  • StumbleUpon
  • TwitThis
Tags: , , , , , , ,


Related Posts:
How much does an average moving company charge?


This entry was posted on Tuesday, October 14th, 2008 at 3:00 pm and is filed under Moving. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How do i take a moving average of a moving average in excel within the same cell?”

  1. The Drunken Fool on October 17th, 2008 at 8:02 pm

    the only way you can do that is to nest your formulas. but i dont think you will get a satisfacotry resolution that way.

  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.

Leave a Reply