Vijay Bashwani is organizing a charity golf tournament where teams of 4 players will play in a captain's choice format. The handicaps of the 40 players who have registered for the tournament are summarized in the following table. Vijay needs to create 10 teams of 4 players each in such a way that the total handicap of each team is as equal as possible. He would like to do this by minimizing the variance of the total handicaps of all the teams.

a. Create a spreadsheet model for this problem and solve it.
b. What are the optimal team assignments?

Transcribed Image Text:

Player Handicaps 10 10 12 13 13