Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Age of Population on a Specific Date
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Age of Population on a Specific Date
dagostm wrote...
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Age of Population on a Specific Date
"Harlan Grove" wrote: dagostm wrote... 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. It is retrospective. I have everyone's date of birth. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Age of Population on a Specific Date
dagostm wrote...
"Harlan Grove" wrote: dagostm wrote... 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. 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Age of Population on a Specific Date
Thank you
"Harlan Grove" wrote: dagostm wrote... "Harlan Grove" wrote: dagostm wrote... 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. 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. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average only with specific critera | Excel Discussion (Misc queries) | |||
Date Population | Excel Worksheet Functions | |||
Every Sat Date Population | Excel Discussion (Misc queries) | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
how do I find an average number of specific words in a column | New Users to Excel |