View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pkaraffa@gmail.com is offline
external usenet poster
 
Posts: 35
Default Even Distribution of Students now with a Weighted Twist

Good afternoon, I have a problem that I have been trying to figure out
for a while. Let me first start by saying that I am not the smartest
person in the world I learn everyday. We have a poplulation of 1563
students. Are program will only allow 1110 students. We have 3 tests we
work from. Test X has 146 students, test Y has 723 and test Z has 694.
Since we have only 1110 openings what I did was to divide the
1110/1563. This would give me a percentage of about 71.0172744721689%.
Then I took the figure and I divided each test group
146/71.0172744721689%, 723 /71.0172744721689% and the
694/71.0172744721689%. When rounded this gives me 104 children for test
X, 513 for test Y and 493 for text Z. My question is, is there a way to
weight the different tests like test X =35%, test Y = 25% and test Z =
40% and have that come out to the 1110 students?

Thank you in advance
PJ