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 9 students (3 Eng, 3 Comps, and 3 Hum) that you want to divide into 3 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 9 students are as follows: STUDENT GPA
Eng13.98
Eng23.95
Eng33.92
CompS13.94
CompS23.85
CompS33.83
Hum13.89
Hum23.86
Hum33.82. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!