Average Age of Population on a Specific Date

D

dagostm

Hello: I am trying to figure out the average age of a varying population of
employees on 40 specific days over a three year period.

Is there a formula that can be used to determine this without first
calculation everyone's individual age and then using the
"=AVERAGE(RANGE:RANGE)" formula?
 
H

Harlan Grove

dagostm said:
Hello: I am trying to figure out the average age of a varying
population of employees on 40 specific days over a three year
period.

Is this retrospective, so you know who the employees are? If it's
prospective and since you provide no demographic information other
than the implicit 'working age', you're on your own.
Is there a formula that can be used to determine this without first
calculation everyone's individual age and then using the
"=AVERAGE(RANGE:RANGE)" formula?

You mean give you the average age without knowing the ages of all the
individuals in question at some point in time? No, at least not the
actual average age. If you could possibly provide demographic
information, there may be ways to estimate the average age, but such
estimates wouldn't be actual average ages. Most of the time such
estimates should be reasonably close to the actual average age, but
such estimates could be way off on rare occasions.
 
D

dagostm

Harlan Grove said:
Is this retrospective, so you know who the employees are? If it's
prospective and since you provide no demographic information other
than the implicit 'working age', you're on your own.

It is retrospective. I have everyone's date of birth.
 
H

Harlan Grove

dagostm said:
It is retrospective. I have everyone's date of birth.

Then you only need to calculate their ages as of a given date (the
base date), then select the particular group of people as of some
particular date (D), calculate the average age of those people as of
the base date and add the period from the base date to D to get the
average age on the particular date.
 
D

dagostm

Thank you

Harlan Grove said:
Then you only need to calculate their ages as of a given date (the
base date), then select the particular group of people as of some
particular date (D), calculate the average age of those people as of
the base date and add the period from the base date to D to get the
average age on the particular date.

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top