Hi All,
I am trying to create a model to answer a few population questions. Any help would be greatly appreciated.
Given:
City 1
TOTAL POPULATION CITY 1 100,000
Avg Age of Population 27.8
Median Age (Male) 20.5
Median Age (Female) 27.8
% Male Population 46.43%
% Female Population 53.57%
% 16 & over 92.43%
% 18 & over 91.83%
% 21 & over 41.92%
% 65 & over 4.90%
% of US Female Population (ages 15 - 44) that need Product X: 11%
Answer:
1. How many females between the age of 25 - 40 live in City 1.
2. What % of females between the age of 25 - 40 need Product X.
3. How many females between the age of 25-40 in City 1 need Product X.
My methodology and answers:
My Methodology
Get % of inidvuduals in the 25 - 40 year range
Year between 25 -40 including 25 & 40 = 16
Years between 21 - 64 including 21 & 64 = 45
I am now looking for 16 of the 45 years = 36% of the age range
% in the desired range = 37% x 36% = 13.15 %
% 21 - 64 : 41.92 % - 4.90 % = 37%
my answers
Questions (Methedology used)
1. How many females between the age of 25 - 40 live in City 1? 100,000 * 53.57= 53,570 (Females); 53,570 x 13.15% = 7,044
2. What % of females between the age of 25 - 40 need Product X? There are 31 years betwween 15 - 44 incl. 15 & 44, looking for 16 years so it would be 11% x 52% = 6%
3. How many females between the age of 25-40 in City 1 need Product X? 7,044 x 6% = 423
I am trying to create a model to answer a few population questions. Any help would be greatly appreciated.
Given:
City 1
TOTAL POPULATION CITY 1 100,000
Avg Age of Population 27.8
Median Age (Male) 20.5
Median Age (Female) 27.8
% Male Population 46.43%
% Female Population 53.57%
% 16 & over 92.43%
% 18 & over 91.83%
% 21 & over 41.92%
% 65 & over 4.90%
% of US Female Population (ages 15 - 44) that need Product X: 11%
Answer:
1. How many females between the age of 25 - 40 live in City 1.
2. What % of females between the age of 25 - 40 need Product X.
3. How many females between the age of 25-40 in City 1 need Product X.
My methodology and answers:
My Methodology
Get % of inidvuduals in the 25 - 40 year range
Year between 25 -40 including 25 & 40 = 16
Years between 21 - 64 including 21 & 64 = 45
I am now looking for 16 of the 45 years = 36% of the age range
% in the desired range = 37% x 36% = 13.15 %
% 21 - 64 : 41.92 % - 4.90 % = 37%
my answers
Questions (Methedology used)
1. How many females between the age of 25 - 40 live in City 1? 100,000 * 53.57= 53,570 (Females); 53,570 x 13.15% = 7,044
2. What % of females between the age of 25 - 40 need Product X? There are 31 years betwween 15 - 44 incl. 15 & 44, looking for 16 years so it would be 11% x 52% = 6%
3. How many females between the age of 25-40 in City 1 need Product X? 7,044 x 6% = 423