Hi,
I have a task to work out values based on a number of different variables. The total number is 5000 but here is the stipulations:
40% Male, 60% Female
then 20% under 25, 60% 25-50 and 40% over 50
then 30% have an income of 10k-20k, 40% have an income of 20k-30k and 30% an income of 40k+
As you can see, I need to work out values where they "cross over" each of these variables so that the total of each is true to the overall total. Is there any formula or way I can easily work this out rather than having to go through each variable manually working it out?
Thanks.
I have a task to work out values based on a number of different variables. The total number is 5000 but here is the stipulations:
40% Male, 60% Female
then 20% under 25, 60% 25-50 and 40% over 50
then 30% have an income of 10k-20k, 40% have an income of 20k-30k and 30% an income of 40k+
As you can see, I need to work out values where they "cross over" each of these variables so that the total of each is true to the overall total. Is there any formula or way I can easily work this out rather than having to go through each variable manually working it out?
Thanks.