The Mavs.xlsx file contains statistics for the great 2002-2003 Dallas Mavericks basketball team. Player names are...

 

Transcribed Image Text:

The Mavs.xlsx file contains statistics for the great 2002-2003 Dallas Mavericks basketball team. Player names are listed in column A, statistical categories are listed in row 3, and statistical results are listed in rows 4-20. Change the worksheet so that all player names are listed in the same row and all statistical categories are listed in the same column. PLAYER AVERAGES REBOUNDS Player G GS MPG FG% 3P% FT% OFF DEF TOT APG SPG ВPG TO PF РPG Dirk Nowitzki 35 35 38.4 0.458 0.378 0.835 1.1 10.1 2.5 1.4 1.09 1.57 2.3 22.4 Michael Finley 37 37 38.8 0.418 0.366 0.845 1.6 4.5 6.1 2.9 1.24 0.24 1.76 1.4 19.8 Steve Nash 37 37 32.6 0.463 0.365 0.919 0.7 2.1 2.8 6.8 1.24 0.03 2.59 1.6 18.4 Nick Van Exel 28 1 26.6 0.395 0.364 0.861 0.6 2.4 2.9 4.6 0.61 0.11 1.5 1.5 11.7 Raef LaFrentz 24 13 24 0.535 0.394 0.765 1.5 3.3 4.8 0.9 0.42 1.38 0.67 3.9 9.3 Eduardo Najera 15 3 25.4 0.602 0.775 1.9 3.3 5.3 1 1.2 0.47 0.4 2.8 8.7 Shawn Bradley 36 24 26.2 0.512 0.798 2.4 5.2 7.6 0.7 0.72 2.92 0.83 3.7 Walt Williams 31 1 20.5 0.397 0.354 0.571 0.9 3.1 4 1.1 0.52 0.35 0.55 2.5 6.5 Adrian Griffin 35 31 18.9 0.444 0.231 0.947 1.4 2.3 3.7 1.6 1.2 0.11 0.69 2.3 4.5 Avery Johnson 27 10.5 0.484 0.783 0.2 0.6 0.8 1.6 0.33 0.63 0.7 4.1 Raja Bell Evan Eschmeyer 35 12.7 0.476 0.348 0.65 0.5 1.1 1.5 0.6 0.66 0.09 0.6 1.8 2.9 2 1 9.5 0.667 0.5 1.5 1.5 1 0.5 2.5 Popeye Jones 18 8.5 0.41 0.571 1.1 1 2.1 0.4 0.17 0.61 1.1 Mark Strickland 4 3.3 0.4 1.3 0.5 1.8 0.25 0.3 1 Adam Harrington 13 2.8 0.235 0.333 1 0.2 0.2 0.2 0.08 0.08 0.15 0.2 0.8 Team Averages 37 240 0.451 0.364 0.831 11.2 32.3 43.6 21.7 8.3 5.8 11.6 20.6 102.5 Opponents 37 240 0.421 0.331 0.714 13.2 33 46.2 21.1 6.3 4.1 16.5 21.5 92 co m O o O - O O N N O n 1 4 m m N1 m 615 00 O o The Mavs.xlsx file contains statistics for the great 2002-2003 Dallas Mavericks basketball team. Player names are listed in column A, statistical categories are listed in row 3, and statistical results are listed in rows 4-20. Change the worksheet so that all player names are listed in the same row and all statistical categories are listed in the same column. PLAYER AVERAGES REBOUNDS Player G GS MPG FG% 3P% FT% OFF DEF TOT APG SPG ВPG TO PF РPG Dirk Nowitzki 35 35 38.4 0.458 0.378 0.835 1.1 10.1 2.5 1.4 1.09 1.57 2.3 22.4 Michael Finley 37 37 38.8 0.418 0.366 0.845 1.6 4.5 6.1 2.9 1.24 0.24 1.76 1.4 19.8 Steve Nash 37 37 32.6 0.463 0.365 0.919 0.7 2.1 2.8 6.8 1.24 0.03 2.59 1.6 18.4 Nick Van Exel 28 1 26.6 0.395 0.364 0.861 0.6 2.4 2.9 4.6 0.61 0.11 1.5 1.5 11.7 Raef LaFrentz 24 13 24 0.535 0.394 0.765 1.5 3.3 4.8 0.9 0.42 1.38 0.67 3.9 9.3 Eduardo Najera 15 3 25.4 0.602 0.775 1.9 3.3 5.3 1 1.2 0.47 0.4 2.8 8.7 Shawn Bradley 36 24 26.2 0.512 0.798 2.4 5.2 7.6 0.7 0.72 2.92 0.83 3.7 Walt Williams 31 1 20.5 0.397 0.354 0.571 0.9 3.1 4 1.1 0.52 0.35 0.55 2.5 6.5 Adrian Griffin 35 31 18.9 0.444 0.231 0.947 1.4 2.3 3.7 1.6 1.2 0.11 0.69 2.3 4.5 Avery Johnson 27 10.5 0.484 0.783 0.2 0.6 0.8 1.6 0.33 0.63 0.7 4.1 Raja Bell Evan Eschmeyer 35 12.7 0.476 0.348 0.65 0.5 1.1 1.5 0.6 0.66 0.09 0.6 1.8 2.9 2 1 9.5 0.667 0.5 1.5 1.5 1 0.5 2.5 Popeye Jones 18 8.5 0.41 0.571 1.1 1 2.1 0.4 0.17 0.61 1.1 Mark Strickland 4 3.3 0.4 1.3 0.5 1.8 0.25 0.3 1 Adam Harrington 13 2.8 0.235 0.333 1 0.2 0.2 0.2 0.08 0.08 0.15 0.2 0.8 Team Averages 37 240 0.451 0.364 0.831 11.2 32.3 43.6 21.7 8.3 5.8 11.6 20.6 102.5 Opponents 37 240 0.421 0.331 0.714 13.2 33 46.2 21.1 6.3 4.1 16.5 21.5 92 co m O o O - O O N N O n 1 4 m m N1 m 615 00 O o

Answer rating: 100% (QA)

The Given Excel Data is Player GS MPG FG 3P FT OFF DEF TOT PG SPG BPG TO PF PPG Dirk Nowitzki 35 35 ... View the full answer