Question
Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 season. Refer to the variable team salary.
Prepare a report on the team salaries. Be sure to answer the following questions in your report.
Around what values do the data tend to cluster? Specifically what is the mean team salary? What is the median team salary? Is one measure more representative of the typical team salary than the others?
What is the range of the team salaries? What is the standard deviation? About 95% of the salaries are between what two values?
Refer to the information on the average salary for each year. In 1989 the average player salary was $512,930. By 2012 the average player salary had increased to $3,440,000. What was the rate of increase over the period?
Team League Opened Seating Capacity Salary 2012 Wins Attendance BA ERA HR Errors SB X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12 Arizona Diamondbacks 0 1998 48633 74.3 81 2.18 0.259 3.93 165 90 93 Atlanta Braves 0 1996 49586 83.3 94 2.42 0.247 3.42 149 86 101 Baltimore Orioles 1 1992 45971 81.4 93 2.1 0.247 3.9 214 106 58 Boston Red Sox 1 1912 37495 173.2 69 3.04 0.26 4.7 165 101 97 Chicago Cubs 0 1914 41009 88.2 61 2.88 0.24 4.51 137 105 94 Chicago White Sox 1 1991 40615 96.9 85 1.97 0.255 4.02 211 70 109 Cincinnati Reds 0 2003 42319 82.2 97 2.35 0.251 3.34 172 89 87 Cleveland Indians 1 1994 43429 78.4 68 1.6 0.251 4.78 136 96 110 Colorado Rockies 0 1995 50398 78.1 64 2.63 0.274 5.22 166 122 100 Detroit Tigers 1 2000 41255 132.3 88 3.03 0.268 3.75 163 99 59 Houston Astros 0 2000 40981 60.7 55 1.61 0.236 4.56 146 118 105 Kansas City Royals 1 1973 37903 60.9 72 1.74 0.265 4.3 131 113 132 Los Angeles Angels 1 1966 45957 154.5 89 3.06 0.274 4.02 187 98 134 Los Angeles Dodgers 0 1962 56000 95.1 86 3.32 0.252 3.34 116 98 104 Miami Marlins 0 2012 36742 118.1 69 2.22 0.244 4.09 137 103 149 Milwaukee Brewers 0 2001 41900 97.7 83 2.83 0.259 4.22 202 99 158 Minnesota Twins 1 2010 39504 94.1 66 2.78 0.26 4.77 131 107 135 New York Mets 0 2009 41922 93.4 95 2.24 0.249 4.09 139 101 79 New York Yankees 1 2009 50287 198 74 3.54 0.265 3.85 245 74 93 Oakland Athletics 1 1966 35067 55.4 94 1.68 0.238 3.48 195 111 122 Philadelphia Phillies 0 2004 43651 174.5 81 3.57 0.255 3.83 158 101 116 Pittsburgh Pirates 0 2001 38362 63.4 79 2.09 0.243 3.86 170 112 73 San Diego Padres 0 2004 42691 55.2 76 2.12 0.247 4.01 121 121 155 San Francisco Giants 0 2000 41915 117.6 94 3.38 0.269 3.68 103 115 118 Seattle Mariners 1 1999 47860 82 75 1.72 0.234 3.76 149 72 104 St. Louis Cardinals 0 2006 43975 110.3 88 3.26 0.271 3.71 159 107 91 Tampa Bay Rays 1 1990 34078 64.2 90 1.56 0.24 3.19 175 114 134 Texas Rangers 1 1994 48194 120.5 93 3.46 0.273 3.99 200 85 91 Toronto Blue Jays 1 1989 49260 75.5 73 2.1 0.245 4.64 198 101 123 Washington Nationals 0 2008 41487 81.3 98 2.37 0.261 3.33 194 94 105
Explanation / Answer
Mean 98.0233333333 Standard Error 6.7246359271 Mode #VALUE! Median 85.75 First Quartile 76.15 Third Quartile 115.775 Variance 1356.6218505747 Standard Deviation 36.832347883 Kurtosis 1.10334953 Skewness 1.271337119 Range 142.8 Minimum 55.2 Maximum 198 Sum 2940.7 Count 30