how do I set up a moving average in Excel
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. |
how do I set up a moving average in Excel
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. "p-nut" wrote: 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. |
All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com