how do I set up a moving average in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a 7 day moving average and cannot figure out how to set
it up? Any help would be great.
 
Assume you have numbers to average in row 1, beginning at column 1 and going
across the sheet. At G2, enter this formula:
=AVERAGE(A1:G1)
and simply extend the formula to the right, it will automatically give the
average of the value above it and in the 6 cells to the right of that cell,
sliding as it goes.

Hope this helps.
 
Back
Top