The Philadelphia Phillies defeated the Tampa Bay Rays 4 to 3

The Philadelphia Phillies defeated the Tampa Bay Rays 4 to 3 to win the 2008 major league baseball World Series. Earlier in the major league baseball playoffs, the Philadelphia Phillies defeated the Los Angeles Dodgers to win the National League Championship, while the Tampa Bay Rays defeated the Boston Red Sox to win the American League Championship. The file MLBSalaries contains the salaries for the 28 players on each of these four teams (USA Today Salary Database, October 2008). The data, shown in thousands of dollars, have been ordered from the highest salary to the lowest salary for each team. Click on the webfile logo to reference the data.

a. Analyze the salaries for the World Champion Philadelphia Phillies. What is the total payroll for the team? Thousands What is the median salary? What is the five-number summary (to 2 decimals, if necessary)? Smallest value 390 Thousands First quartile Thousands Median 6087.5 Thousands Third quartile 436.25 Thousands Largest value 14920 Thousands

b. Calculate the upper and lower limits for the Philadelphia Phillies (to 2 decimals, if necessary)? Lower limit Upper limit Were there outliers for the Philadelphia Phillies?

c. What is the total payroll for each of the other three teams? Los Angeles Dodgers $ 136373 Thousands Tampa Bay Rays $ 96870 Thousands Boston Red Sox $ 120460 Thousands Develop the five-number summary for each team (to 2 decimals, if necessary). Los Angeles Dodgers Tampa Bay Rays Boston Red Sox Smallest value First quartile Median Third quartile Largest value

Solution

a.

b.

Interquartile range : IQR = 3rd Quartile - 1st quartile = 6087.5 - 436.25 = 5651.25

Lower limit = Q1 - 1.5*IQR = 436.25- 1.5*5651.25 = -8040.63

Upper Limit = Q3 +1.5*IQR = 6087.5 + 1.5*5651.25 = 14564.38

c.

https://www.dropbox.com/s/br916dbdvm5qwoh/Phillies.xlsx?dl=0