Question

In: Statistics and Probability

3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel,...

3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel, include the appropriate output (copy + paste) along with an explanation. Data description: An article in The Wall Street Journal (July 11, 2008) outlined a number of reasons as to why the 16 teams in Major League Baseball’s National League (NL) are inferior to the 14 teams in the American League (AL). One reason for the imbalance pointed to the disparity in opening-day payrolls: the average AL payroll is greater than the NL average. A portion of the data showing opening-day payroll (in $) for each team is shown in the accompanying table.

Questions:

a. Discuss the mean and the median of AL and NL opening-day salaries and comment on skewness.

b. Compare the range and the standard deviation of AL and NL opening-day salaries.

c. Use these summary measures to comment on the findings in The Wall Street Journal.

American League Payroll National League Payroll
New York Yankees 206333389 Chicago Cubs 146609000
Boston Red Sox 162447333 Philadelphia Phillies 141928379
Detroit Tigers 122864928 New York Mets 134422942
Chicago White Sox 105530000 San Francisco Giants 98641333
Los Angeles Angels 104963866 Los Angeles Dodgers 95358016
Minnesota Twins 97559166 St. Louis Cardinals 93540751
Seattle Mariners 86510000 Houston Astros 92355500
Baltimore Orioles 81612500 Atlanta Braves 84423666
Tampa Bay Rays 71923471 Colorado Rockies 84227000
Kansas City Royals 71405210 Milwaukee Brewers 81108278
Toronto Blue Jays 62234000 Cincinnati Reds 71761542
Cleveland Indians 61203966 Washington Nationals 61400000
Texas Rangers 55250544 Arizona Diamondbacks 60718166
Oakland Athletics 51654900 Florida Marlins 57034719
San Diego Padres 37799300
Pittsburgh Pirates 34943000

Solutions

Expert Solution

American League Payroll National League Payroll
New York Yankees 206333389 Chicago Cubs 146609000
Boston Red Sox 162447333 Philadelphia Phillies 141928379
Detroit Tigers 122864928 New York Mets 134422942
Chicago White Sox 105530000 San Francisco Giants 98641333
Los Angeles Angels 104963866 Los Angeles Dodgers 95358016
Minnesota Twins 97559166 St. Louis Cardinals 93540751
Seattle Mariners 86510000 Houston Astros 92355500
Baltimore Orioles 81612500 Atlanta Braves 84423666
Tampa Bay Rays 71923471 Colorado Rockies 84227000
Kansas City Royals 71405210 Milwaukee Brewers 81108278
Toronto Blue Jays 62234000 Cincinnati Reds 71761542
Cleveland Indians 61203966 Washington Nationals 61400000
Texas Rangers 55250544 Arizona Diamondbacks 60718166
Oakland Athletics 51654900 Florida Marlins 57034719
San Diego Padres 37799300
Pittsburgh Pirates 34943000
Total 1341493273 1376271592

a.

Mean of American League Payroll = 1341493273 / 14 = 95820948.07

Mean of National League Payroll = 1376271592 / 16 = 86016974.5

Now, we arrange the data in ascending order as :

S.No. American League Payroll S.No. National League Payroll
1 51654900 Oakland Athletics 1 Pittsburgh Pirates 34943000
2 55250544 Texas Rangers 2 San Diego Padres 37799300
3 61203966 Cleveland Indians 3 Florida Marlins 57034719
4 62234000 Toronto Blue Jays 4 Arizona Diamondbacks 60718166
5 71405210 Kansas City Royals 5 Washington Nationals 61400000
6 71923471 Tampa Bay Rays 6 Cincinnati Reds 71761542
7 81612500 Baltimore Orioles 7 Milwaukee Brewers 81108278
8 86510000 Seattle Mariners 8 Colorado Rockies 84227000
9 97559166 Minnesota Twins 9 Atlanta Braves 84423666
10 104963866 Los Angeles Angels 10 Houston Astros 92355500
11 105530000 Chicago White Sox 11 St. Louis Cardinals 93540751
12 122864928 Detroit Tigers 12 Los Angeles Dodgers 95358016
13 162447333 Boston Red Sox 13 San Francisco Giants 98641333
14 206333389 New York Yankees 14 New York Mets 134422942
15 Philadelphia Phillies 141928379
16 Chicago Cubs 146609000

Median = [ (n+1)/2 ]th value

Median for American League Payroll = [ (14+1)/2 ]th value = 7.5th value = 7th value + ( 8th value - 7th value)*0.5

= 81612500 + ( 86510000 - 81612500)*0.5 = 84061250

Median for National League Payroll = [ (16+1)/2 ]th value = 8.5th value = 8th value + ( 9th value - 8th value)*0.5

= 84227000+ ( 84423666- 84227000)*0.5 = 84325333

b.

Range for American League Payroll = 206333389 - 51654900 = 154678489

Range for National League Payroll = 146609000 - 34943000 = 111666000

Sample Standard deviation is obtained using the formula :

We get :

Sample Standard deviation for American League Payroll = 43803002.27

Sample Standard deviation for National League Payroll = 33403170.09

c.

We can see that Mean of American League Payroll is greater than Mean of National League Payroll.

Median of American League Payroll is approximately equal to Median of National League Payroll.

Sample Standard deviation for American League Payroll is greater than Sample Standard deviation for National League Payroll.

Hence, one of the findings in The Wall Street Journal is that the average AL payroll is greater than the NL average which is observed from the given data.


Related Solutions

3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel,...
3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel, include the appropriate output (copy + paste) along with an explanation. Data description: An article in The Wall Street Journal (July 11, 2008) outlined a number of reasons as to why the 16 teams in Major League Baseball’s National League (NL) are inferior to the 14 teams in the American League (AL). One reason for the imbalance pointed to the disparity in opening-day payrolls:...
Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with...
Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with sample size, n = 40, mean = 20 and standard deviation = 11. Write the generated data in the following table. Answer: 1 11 21 31 2 12 22 32 3 13 23 33 4 14 24 34 5 15 25 35 6 16 26 36 7 17 27 37 8 18 28 38 9 19 29 39 10 20 30 40 Conduct the...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment) 1. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?...
Use the following data to answer the questions below:
Use the following data to answer the questions below:             Q                 VC             MC           AVC              1                 $10              ___            ___                                   2                16              ___            ___                       3                20              ___            ___                                   4                25              ___            ___              5                31              ___            ___              6                  38              ___            ___                  7                  46              ___            ___8                  55              ___            ___9                  65              ___            ___         a. Calculate the marginal cost and average variable cost for each level of production.b. How much would the firm produce if it could sell its product for...
Use the following to answer questions 1-3: The balance sheet data of Kohler Company at the...
Use the following to answer questions 1-3: The balance sheet data of Kohler Company at the end of 2015 and 2014 follow: 2015                2014 Cash $ 100,000        $ 140,000 Accounts receivable (net) 240,000           180,000 Inventory 280,000           180,000 Prepaid expenses 40,000           100,000 Buildings and equipment 360,000           300,000 Accumulated depreciation—buildings and equipment (72,000)          (32,000) Land 360,000          160,000 Totals $1,308,000     $1,028,000 Accounts payable $ 272,000       $220,000 Accrued expenses 48,000 72,000 Notes payable—bank, long-term 160,000 Mortgage...
Use the Excel Solver to answer the following questions. The owners of the appliance store want...
Use the Excel Solver to answer the following questions. The owners of the appliance store want to spend up to $250,000 on buying new stock. They need to buy at least 100 of each appliance. The prices of buying appliances and the profits derived from selling them are shown in the following table, along with the floor area the devices require when stacked in the warehouse. Appliance Price Profit Area (m2) Clothes dryer $200 $21 1.2 Coffee machine $300 $28...
The following table provides data for a project. Use the data to answer the following questions...
The following table provides data for a project. Use the data to answer the following questions Activity Immediate Predecessor Time Estimates (weeks) Optimistic Most Likely Pessimistic Expected Variance A - 6 7 14 B - 8 10 12 C A 2 3 4 D A 6 7 8 E B,C 5 5.5 9 F B,C 5 7 9 G D,E 4 6 8 H F 2.5 3 3.5 Draw a network to represent the above project. What is the critical...
Use the following data to answer questions 1-3: There are three industrial firms in Happy Valley:...
Use the following data to answer questions 1-3: There are three industrial firms in Happy Valley: Firm A       Pollution Level = 70 units     Cost to Reduce Pollution = $20 / Unit Firm B       Pollution Level = 80 units     Cost to Reduce Pollution = $25 / Unit Firm C       Pollution Level = 50 units     Cost to Reduce Pollution = $10 / Unit The government is considering options to reduce the pollution level to 90 total units. Suppose they decide to impose...
Use the data given in the table to answer the following questions. The data represents the...
Use the data given in the table to answer the following questions. The data represents the average number of miles that a salesperson travels in a day verses the number of sales made each month. Miles, x 24 32 75 41 76 107 32 46 112 Sales, y 76 58 190 112 141 235 24 147 188 (a) What is the value of the correlation coefficient for this set of data? Round to 3 decimal places. (b) What is the...
To answer the following questions, students should use a sum of relevant economic theories (if require)...
To answer the following questions, students should use a sum of relevant economic theories (if require) for the justification of their answers. Students can also use figures (i.e., supply and demand curves) for presenting their answers. Consider the financial crisis 2007-2009 in USA. Now, assume that the crisis has been continuing for 10 years. We call this period as a long run period. 1. Explain the effect of this crisis on USA's GDP in long-run? 2. Explain the effect of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT