Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
★★★★★
3.40 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
The Given Excel Data is Player GS MPG FG 3P FT OFF DEF TOT PG SPG BPG TO PF PPG Dirk Nowitzki 35 35 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started