running average

[jlmotta]

Hi,
I figured out how to get an average of a column of numbers using the
AVERAGE function, yet I cannot figure out how to get a running average
when a new number is added. Please help.
Thank you,
Jill

 

[Guest]

What do you mean by "running" average?.

With data in A1:A10, average these:

A11 is added ... average A1:A11 OR A2:A11

If the former, create a dynamic range and use this in your formula.

See here for info on creating named ranges:

http://www.contextures.com/xlNames01.html

HTH

 

[James Silverton]

(e-mail address removed) wrote on Mon, 09 Jul 2007
12:10:21 -0700:

j> Hi,
j> I figured out how to get an average of a column of numbers
j> using the AVERAGE function, yet I cannot figure out how to
j> get a running average when a new number is added. Please
j> help. Thank you,
j> Jill

Numbers in, say, A1:A35,
Overall average in B35, say, =AVERAGE(A$1:A35) Just pull the
cell down to new line to expand the range.
5-point, say, moving average in C35, =AVERAGE(A31:A35) Extend
similarly; the absence of $ allows both cell numbers to
increment.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[jlmotta]

(e-mail address removed) wrote on Mon, 09 Jul 2007
12:10:21 -0700:

j> Hi,
j> I figured out how to get an average of a column of numbers
j> using the AVERAGE function, yet I cannot figure out how to
j> get a running average when a new number is added. Please
j> help. Thank you,
j> Jill

Numbers in, say, A1:A35,
Overall average in B35, say, =AVERAGE(A$1:A35) Just pull the
cell down to new line to expand the range.
5-point, say, moving average in C35, =AVERAGE(A31:A35) Extend
similarly; the absence of $ allows both cell numbers to
increment.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

Hi James, thank you. When I copied the formula down to B36 it changed
from A1:A35 to A2:A36. How would i get it to include A1 as well and
not start at A2?
Thank you. Jill

 

[jlmotta]

What do you mean by "running" average?.

With data in A1:A10, average these:

A11 is added ... average A1:A11 OR A2:A11

If the former, create a dynamic range and use this in your formula.

See here for info on creating named ranges:

http://www.contextures.com/xlNames01.html

HTH





- Show quoted text -

Hi Again HTH- sorry I did it worng the first time- it works now-
thanks again.
Jill

 

[jlmotta]

Hi James, thank you. When I copied the formula down to B36 it changed
from A1:A35 to A2:A36. How would i get it to include A1 as well and
not start at A2?
Thank you. Jill- Hide quoted text -

- Show quoted text -

Hi James, I did it wrong the first time. it now works- thanks again-
jill