Optimization Model USING SPREADSHEET

Data for the Dream Team

Average Average Average Player Rebounds Assists Height Points Defensive Ability

Number Per Game Per Game (feet and inches) Per Game (scale from 0 to 10) 1 1 7 5' 11" 10 10 2 2 14 6' 0" 14 9 3 3 12 6' 4" 19 8 4 4 4 6' 0" 18 6 5 5 9 6' 3" 20 8 6 7 6 6' 5" 21 10 7 7 8 6' 8" 23 10 8 4 2 6' 5" 13 5 9 8 2 6' 10" 17 8

10 5 5 6' 4" 25 8 11 10 6 6' 10" 20 9 12 8 8 6' 9" 30 10 13 10 2 7' 3" 24 9 14 9 5 6' 10" 15 7 15 6 3 6' 10" 17 6 16 16 2 6' 9" 3 6 17 11 1 7' 4" 27 9 18 12 5 7' 2" 26 10 19 11 1 7' 3" 21 9 20 9 1 7' 0" 14 8