Moving Average

B

Bgreer5050

Is there a formula for calculating the moving average for a group of numbers
?

Thanks
 
S

sbitaxi

I'm assuming that you want a running average (at least, that's how I am
interpreting it)

Assuming your values are in column A and your average in column B

the formula in B1 should be as follows:
=Average($A$1:A1)

then just copy and paste it down the rest of the column and it will
calculate the average as numbers are added.




Steven Bitaxi
 
B

Bucky

I'm assuming that you want a running average (at least, that's how I am
interpreting it)
Click to expand...

I think the OP wants a moving average. This is very simple. In column
A, you have your data points. Let's say you want a moving average of
the last 10 data points. Then in cell B10, enter "=AVERAGE(A1:A10)".
Fill B10 all the way down. Each cell will be incremented automatically.
 
D

Dana DeLouis

Another option to get you started might be ...Tools | Data Analysis |
"Moving Average."
 
Top