Question: You have 9 students ( 3 Eng, 3 Comps, and 3 Hum ) that you want to divide into 3 teams with one student of
You have students Eng, Comps, and Hum that you want to divide into teams with one student of each degree per team. You would like the teams to be as "balanced" as possible in terms of average GPA in other words, you do not one team with the highest possible average GPA, and one with the lowest possible
The GPAs of the students are as follows: STUDENT GPA
Eng
Eng
Eng
CompS
CompS
CompS
Hum
Hum
Hum What assignment of students to the three teams will provide the most "uniform" composition in terms of team average GPA? Solve this optimization question using excel solver and show all steps on the cells
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
