running average
 

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

running average
 

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

" wrote:

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

running average
 

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

running average
 

On Jul 9, 3:25 pm, "James Silverton"
wrote:
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

running average
 

On Jul 9, 3:24 pm, Toppers wrote:
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



" wrote:
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- Hide quoted text -

- Show quoted text -

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

running average
 

On Jul 9, 4:29 pm, wrote:
On Jul 9, 3:25 pm, "James Silverton"
wrote:





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- Hide quoted text -

- Show quoted text -

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