[Solution] Please go to ProQuest and read the article below. - #80105
Module 01 - Case Assignment
Baseball Salaries
Please go to ProQuest and read the article below.
Weir, T. & Sylwester, M. (Oct. 17, 2002). Baseball salaries top-heavy; Elite's share keeps getting bigger. USA TODAY, pg. C.01
Here is the Baseball Salaries Spreadsheet Link
Use this article and refer to the Baseball Salaries spreadsheet to answer the case questions. You should also save the Baseball Salaries spreadsheet to your computer and use it to submit your answers to the questions below. Put your data answers (Questions 1-3) in the first sheet and then work the problems directly in the workbook for the remaining questions on measures.
Use the appropriate Excel statistical functions to help you with your calculations. You may want to use the “Calculations” worksheet to do those calculations involving more than one team’s data. Also note that each Excel function has its own help operation; so if you have difficulty with any function, use its help capability to explain how the function works.
1. Identify one each of the following data types used in the article above: ordinal, nominal, and ratio.
- Use MS Excel and information from the Baseball Salaries spreadsheet above to create a single meaningful frequency distribution table with at least 5 separate categories.
3. For each baseball team listed in the workbook, compute the mean, mode, and median salaries. (Warning: Excel’s mode function is not a good one. It will pick out only one mode even though there might be several in a given team’s data. Use your eyeball to spot all the modes.)
4. What is the probability that each team will pay a player $1,000,000 or more? (Hint: For each team, you may identify the numerator (number of successes) and the denominator (number of total possible outcomes) in the probability equation.)
5. If you had to pick one player at random from each of two different teams, what is the probability that they would both be paid $1,000,000 or more? (Hint: This is asking for the probability that one player picked from one given team will be paid $1,000,000 or more, AND that one player picked from another given team will also earn that amount.)
Deliverable: Word Document
and pdf
