The Mavs.xlsx file contains statistics for the great 2002-2003 Dallas Mavericks basketball team. Player names are...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Accounting concepts and applications
ISBN: 978-0538745482
11th Edition
Authors: Albrecht Stice, Stice Swain
Posted Date:
Students also viewed these accounting questions
-
The Dallas Mavericks basketball team has hired you as its new accountant. On your first day on the job, Mavericks owner, Mark Cuban, comes to you and asks, How many tickets must we sell to pay for...
-
A basketball player shoots when she is 5 m from the backboard. Knowing that the ball has an initial velocity v0 at an angle of 30? with the horizontal, determine the value of v0 when d is equal to(a)...
-
In March 2004, Internet broadcasting pioneer and Dallas Mavericks owner Mark Cuban acquired 600,000 shares, a 6.3 percent stake, of Mamma.com. Later that spring, Mamma.com decided to sell more of its...
-
All of the following are advantages of licensing EXCEPT: the foreign country gains employment by having the product manufactured locally. the licensee gains information that allows it to start with a...
-
A finance executive would like to determine if a relationship exists between the current earnings per share (EPS) of a bank and the following independent variables: Total assets ($ billions) ...
-
Use the information in the table below in solving this problem. Situation A. A fixed- income manager holding a $ 20 million market value position of U. S. Treasury 1134 percent bonds maturing...
-
You have collected the following data: If you place these five numbers in a bag and randomly select one, what is the probability the number (X) will be ... a. equal to 6 ? b. less than 11 ? c....
-
Burgundy, Inc., and Violet Gomez are equal partners in the calendar year BV LLC. Burgundy uses a fiscal year ending April 30, and Violet uses a calendar year. Burgundy receives an annual guaranteed...
-
Before recording adjusting entries on December 31, the Store Supplies account had a $1,900 debit balance, while a physical count of the supplies showed $300 of unused supplies on hand. Prepare the...
-
a. Given the available capacity in the network, how much gas can be shipped from Katy to Leidy? From Katy to Joliet? b. How much gas should Bruce offer to sell to Joliet and Leidy if he wants to...
-
Do you employ the appropriate superstructure for this audience and purpose? Does cover letter expand on important. Does each paragraph of your letter have a clear purpose and important content for...
-
In the iceberg syndrome, what are the six different viewers perspectives that appear above the waterline?
-
What are the main differences between requirement-led and system-led development?
-
Have you ever seen or worked for an ineffective manager? Describe the behaviors that contributed to the managers ineffectiveness.
-
Why would you use multiple scenarios when refining and optimizing the benefit mix?
-
The selection of the BPM TOM components will impact how BPM is implemented within the organization. Why?
-
A client wants to know more about Wilson Security's services that can help them with their current security concerns. You relay the information to your Regional Manager so they can help you with the...
-
Is it a breach of fiduciary duty for a director of a real estate investment trust (REIT) negotiating a joint venture on behalf of the REIT with another director for the development of a portfolio of...
-
Snowy Peaks Corporation was organized in January 2009 and issued shares of preferred and common stock as shown. As of December 31, 2012, there have been no changes in outstanding stock. Preferred...
-
On December 31, Daniel McGrath completed the first year of operations for his new business. The following data are available from the companys accounting records: 1. How much net income (loss) should...
-
What is the purpose of closing entries?
-
a. Suppose that General Hospital has a current ratio of 0.5. Which of the following actions would improve (increase) this ratio? Use cash to pay off current liabilities. Collect some of the current...
-
What is the role of internal control in an organization?
-
What are the elements and principles of the COSO framework?
Study smarter with the SolutionInn App