Answered step by step
Verified Expert Solution
Link Copied!

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 basketballteam. Player names are listed in c 

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538750196, 538745487, 538750197, 978-0538745482

More Books

Students also viewed these Accounting questions

Question

What are the 5 Cs of marketing channel structure?

Answered: 1 week ago

Question

What is the purpose of closing entries?

Answered: 1 week ago