moving average
Posted by candace on September 23, 2001 5:06 PM
How do I calculate a moving average of these figures: I went to the Data anaylsis but I am not sure how to fill in the formula.
data %
1.85
2.9
5.9
7
9.7
7.9
13.75
7
6.75
5.35
3
thank you!!!
Posted by anno on September 23, 2001 6:03 PM
candace
try the excel help topic called "moving average analysis tool and formula". apart from figuring out what interval to use (setting it at '2' will average a given cell ref and the previous cell contents, '3' will average the cell ref and the previous 2 cells contents, etc) it's pretty much plug in the input and output ranges. leave about as much space for the output range as for your input range and you shouldn't overwrite anything.
good luck
Posted by Omar on September 23, 2001 8:50 PM
I may not have understood what you're after, but try this.
If your data starts in A1, put this in B1 and fill down :-
=SUM($A$1:$A1)/COUNT($A$1:$A1)
Posted by Aladin Akyurek on September 23, 2001 9:08 PM
Omar,
That would produce a "running average". For "moving average", see Tools|Data Analysis.
Aladin
