Moving Average

[Bgreer5050]

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

Thanks

 

[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

 

[Bucky]

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

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.

 

[Dana DeLouis]

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