In: Economics
Please assist with the following:
The Philadelphia Phillies defeated the Tampa Bay Rays 4 to 3 to win the 2008 major league baseball World Series (The Philadelphia Inquirer, October 29, 2008). 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.
Analyze the salaries for the World Champion Philadelphia Phillies. What is the total payroll for the team? What is the median salary? What is the five-number summary?
Were there salary outliers for the Philadelphia Phillies? If so, how many and what were the salary amounts?
What is the total payroll for each of the other three teams? Develop the five-number summary for each team and identify any outliers.
Show the box plots of the salaries for all four teams. What are your interpretations? Of these four teams, does it appear that the team with the higher salaries won the league championships and the World Series?
MLB Salaries:
Player | Phillies | Dodgers | Rays | Red Sox |
1 | 14250 | 19000 | 6000 | 14000 |
2 | 10000 | 15730 | 5375 | 13000 |
3 | 8583 | 15217 | 3898 | 12500 |
4 | 8000 | 14727 | 3785 | 10442 |
5 | 7958 | 10000 | 2875 | 10167 |
6 | 7786 | 9517 | 2750 | 9250 |
7 | 6350 | 9250 | 2400 | 8333 |
8 | 6000 | 9000 | 2300 | 8000 |
9 | 5500 | 8000 | 2250 | 6000 |
10 | 5000 | 7500 | 1600 | 5083 |
11 | 3250 | 7433 | 1275 | 4000 |
12 | 3000 | 2000 | 1000 | 3850 |
13 | 2400 | 1925 | 800 | 3000 |
14 | 1700 | 1115 | 417 | 3000 |
15 | 900 | 600 | 413 | 2000 |
16 | 900 | 500 | 412 | 1275 |
17 | 600 | 454 | 412 | 840 |
18 | 500 | 425 | 405 | 835 |
19 | 480 | 415 | 401 | 800 |
20 | 445 | 411 | 401 | 775 |
21 | 440 | 406 | 400 | 457 |
22 | 425 | 400 | 398 | 422 |
23 | 420 | 393 | 397 | 421 |
24 | 415 | 393 | 396 | 406 |
25 | 395 | 392 | 396 | 405 |
26 | 393 | 390 | 396 | 403 |
27 | 390 | 390 | 392 | 400 |
28 | 390 | 390 | 390 | 396 |
Philadelphia phillies team - according to the given data we can see there is a huge difference between the hight and lowest paid salaries with no outliers . This means players are paid based on their sportsmanship skill. .
Total payroll for ÷
Phillies = 89084
Dodgers = 135980
Rays = 41938
Red sox = 117460
There are no salary outliers for phillies team as
Higher outlier = Q3 + 1.5 × IQR
= 14788.75
And no value is greater than 14788.75
Lower outlier = Q1- 1.5× IQR
=-8181.25
So no value is lower than this value .
Similarly for ,
Dodgers =no outlier as
IQR = 8722 ,
Q3 + 1.5×IQR = 22208
Rays = two outliers as
IQR = 1951
Q3 + 1.5× IQR = 5276.5
Values greater than 5276.5 are 6000 and 5375
Red sox = no outliers as
IQR = 7727
Q3 + 1.5× IQR = 19757
By closely observing the boxplots for all the salary amount set for four teams we can see that majority of the salary amounts are greater than the median salary amount . Also the start of the box shows 25% of the data lower than the Q1 and 75% of the data lower than Q3 . In all four teams majority data is 25% above the Q3 and a very small amounts are lower than Q1 .
There is no evidencw that the team with higher salaries paid won the championship leagues as we can see that phillie were given lesser salaries than dodgers and yet they defeated dodgers .