Help With Mathematical model

JAE1XINMD

New member
Joined
Dec 24, 2013
Messages
1
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
 
You are assuming a lot that is NOT given! Yes, if there are 100,000 people in the city and 53.57% of them are female then there are 53,570 females in the city. It does NOT, however, follow that the percentage of females in a particular age group is also 53.57% of the people in that age group. Nor is it necessarily true that the number of people in a particular age is the same percentage of an overall group as the fraction of years in that overall period.
 
Top