Question

Companies are sometimes interested in their costs and output and relating the two. The data set here has one part of cost for a professional sports league, the players' salaries, and one measure of their output, their points scored. The data are for the NBA for the 2009-2010 season. Use the Data Analysis feature in Excel to help you find the correct answers. What is the range of salaries? Do not include a dollar sign.

NAME TEAM SALARY 2009-2010 points scored 2009-2010 1 season season 2472 2258 2027 1970 1943 1896 1681 1678 1667 1640 1631 1611206 1190 1156 1156 1148 1146 1145 1143 1135 1110 1095 1094 1092 1080 1072 1066 1050 1045 1013 1008 996 994 993 990 979 977 9832 831 825 824 820 818 805 804 792 791 788 784 774 771 768 763 753 746 741 735 733 730 724 723 722 719 716 710 109 Ryan Gome635 630 623 622 620 619 615 596 595 595 591 587 586 586 585 567 556 543 542 539 534 532 528 521 518 513 511 511 163 Andres No440 439 435 434 430 427 418 411 410 399 399 397 386 385 384 382 375 374 371 367 365 364 358 358 357 355 350 217 Earl Boykins,245 244 243 242 233 232 228 223 215 215 215 210 209 208 208 207 207 202 202 197 189 185 271 Tracy McGrady, SG 272 Jordan Hill105 104 101 99 95 93 92 88 83 82 81 79 78 77 75 74 71 71 69 69 62 62 59 58 56 53 53 52 325 Malik Allen, PF 326 Aaron Gray, C21 20 19 18 16 14 14 14 12 11 10 10 7 6 5 4 2 0 0 0 0 0 0 0 0 373 Brian Cook, PF 374 Cedric Jackson, G 375 Patrick OBryant,


3 0
Add a comment Improve this question Transcribed image text
Answer #1

Descriptive Statistics

We put the data in Excel and go to Data > Data Analysis > Descriptive Statistics and tick the Summary Statistics option to get the range of the data.

We get the range of the salaries as: 23031683.

Note that, range of any data set is given as the difference between the maximum and minimum values of the set. Here maximum value is 23034375 and minimum value is 2692.

Thus the range is: (23034375-2692) = 23031683.

Add a comment
Know the answer?
Add Answer to:
Companies are sometimes interested in their costs and output and relating the two.
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A quality control inspector is interested in comparing two concreting companies with respect to overall quality...

    A quality control inspector is interested in comparing two concreting companies with respect to overall quality of their work. One measure of quality is whether or not the concrete that has been poured is at least 15 centimeters (cm) thick. The inspector has recorded details for jobs from both companies and is now interested in whether the companies differ with respect to this measure of quality. Let p1 denote the true proportion of times that Company 1 will fail to...

  • objective question What is the mode and the mean for the following set of numbers? {4,9,8,2,16,4,4,8,9,6}...

    objective question What is the mode and the mean for the following set of numbers? {4,9,8,2,16,4,4,8,9,6} O A. Mean = 7, mode =8 O B. Mean = 7, mode =4 O C. Mean = 6, mode =8 O D. Mean = 8, mode =9 You are conducting a survey of the people of the United Kingdom to find out how popular the racket sports are. You randomly choose people to call, and make 1,000 phone calls to people scattered across...

  • PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS...

    PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 Chocolates by Jacki has provided information relating to its current year. The Controller has asked you to complete a First-Stage Allocation to Activity Cost Pools....

  • Respond to the following prompt with your original thoughts, at least 200 words, utilize academic sources...

    Respond to the following prompt with your original thoughts, at least 200 words, utilize academic sources to support your point. Is the WACC an estimation of the real cost of capital(explicit cost of money) or an opportunity cost tied to a particular decision based on market required returns? You use the following points to discuss this question or utilize your own points. 1. Projects of different levels of risk should have different associated discount rates. 2. The WACC reflects the...

  • 1. Many companies use a incoming shipments of parts, raw materials, and so on. In the...

    1. Many companies use a incoming shipments of parts, raw materials, and so on. In the electronics industry, component parts are commonly shipped from suppliers in large lots. Inspection of a sample of n components can be viewed as the n trials of a binomial experimem. The outcome for each component tested (trialD will be that the component is classified as good or defective defective components in the lot do not exceed 1 %. Suppose a random sample of fiver...

  • EXERCISE 4D Rhetorical Features of Argument ntifying denduy 3 SBV, we identify the elements of written...

    EXERCISE 4D Rhetorical Features of Argument ntifying denduy 3 SBV, we identify the elements of written argument presented in this Io the first essay, identifv auter Il h In the n the second, we ask you to do the same. We must point out that sometimes ntegories overlap: A statement (or statements) may serve as both a refutation these and a premise thesis counterarguments premises refutations concessions Could It Be That Video Games Are Good for Kids? STEVEN JOHNSON Dear...

  • Activity-Based Costing, Distorted Product Costs Sharp Paper Inc. has three paper mills, one of which is...

    Activity-Based Costing, Distorted Product Costs Sharp Paper Inc. has three paper mills, one of which is located in Memphis, Tennessee. The Memphis mill produces 300 different types of coated and uncoated specialty printing papers. Management was convinced that the value of the large variety of products more than offset the extra costs of the increased complexity. During 20X1, the Memphis mill produced 120,000 tons of coated paper and 80,000 tons of uncoated paper. Of the 200,000 tons produced, 180,000 were...

  • Here is the text book information, trend needs to be return on investment Calculate one financial...

    Here is the text book information, trend needs to be return on investment Calculate one financial statement ratio trend within your industry that warrants improvement efforts. Make up your own. Return on Investment LO 2 Explain the importance and show the calculation of return on investment. Imagine that you are presented with two investment alternatives. Each investment will be made for one year, and each investment is equally risky. At the end of the year you will get your original...

  • Using the book, write another paragraph or two: write 170 words: Q: Compare the assumptions of...

    Using the book, write another paragraph or two: write 170 words: Q: Compare the assumptions of physician-centered and collaborative communication. How is the caregiver’s role different in each model? How is the patient’s role different? Answer: Physical-centered communication involves the specialists taking control of the conversation. They decide on the topics of discussion and when to end the process. The patient responds to the issues raised by the caregiver and acts accordingly. On the other hand, Collaborative communication involves a...

  • Please use own words. Thank you. CASE QUESTIONS AND DISCUSSION > Analyze and discuss the questions...

    Please use own words. Thank you. CASE QUESTIONS AND DISCUSSION > Analyze and discuss the questions listed below in specific detail. A minimum of 4 pages is required; ensure that you answer all questions completely Case Questions Who are the main players (name and position)? What business (es) and industry or industries is the company in? What are the issues and problems facing the company? (Sort them by importance and urgency.) What are the characteristics of the environment in which...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT