Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel ? Formula for moving average | Excel Worksheet Functions | |||
moving text from a word document to excel | New Users to Excel | |||
moving average of figures from separate tables | Excel Discussion (Misc queries) | |||
24hr moving average | Excel Discussion (Misc queries) |