Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weighted Average Using Row Number | Excel Worksheet Functions | |||
Weighted Avg | Excel Discussion (Misc queries) | |||
Normal Distribution line | Excel Discussion (Misc queries) | |||
Normal Distribution line | Excel Discussion (Misc queries) | |||
How can I use Excel to schedule students for classes? | Excel Discussion (Misc queries) |