| Team | League | Year Opened | Team Salary | Attendance | Wins | ERA | BA | HR | | Year | Average Salary (millions) | | | PART I TASKS: | 1) Create a frequency distribution for the Team Salary variable and answer the questions: | 4 points |
| Arizona | National | 1998 | 70.76 | 2036216 | 69 | 5.09 | 0.261 | 190 | | 2000 | 1.99 | | | | 2) What is the range of Salary? | 2 points |
| Atlanta | National | 1996 | 87.62 | 2020914 | 68 | 4.51 | 0.255 | 122 | | 2001 | 2.26 | | | | 3) What is the shape of the distribution? Does it appear that any of the teams have a salary that is out of line with the others? | 4 points |
| Baltimore | American | 1992 | 115.59 | 2172344 | 89 | 4.22 | 0.256 | 253 | | 2002 | 2.38 |
| Boston | American | 1912 | 182.16 | 2955434 | 93 | 4.00 | 0.282 | 208 | | 2003 | 2.56 | | | | 4) Draw a cumulative relative frequency distribution of team salary. Using this distribution, forty percent of the teams have a salary of less than what amount? | 4 points |
| Chicago Cubs | National | 1914 | 116.65 | 3232420 | 103 | 3.15 | 0.256 | 199 | | 2004 | 2.49 |
| Chicago Sox | American | 1991 | 98.71 | 1746293 | 78 | 4.10 | 0.257 | 168 | | 2005 | 2.63 | | | | 5) About how many teams have a total salary of more than $220 million? | 4 points |
| Cincinnati | National | 2003 | 116.73 | 1894085 | 68 | 4.91 | 0.256 | 164 | | 2006 | 2.87 |
| Cleveland | American | 1994 | 86.34 | 1591667 | 94 | 3.84 | 0.262 | 185 | | 2007 | 2.94 |
| Colorado | National | 1995 | 98.26 | 2602524 | 75 | 4.91 | 0.275 | 204 | | 2008 | 3.15 |
| Detroit | American | 2000 | 172.28 | 2493859 | 86 | 4.24 | 0.267 | 211 | | 2009 | 3.24 |
| Houston | American | 2000 | 69.06 | 2306623 | 84 | 4.06 | 0.247 | 198 | | 2010 | 3.30 | | | PART II TASKS: | 1) The Year Opened is the first year of operation for that stadium. For each team, use this variable to create a new variable, stadium age, by subtracting the value of the variable Year Opened from the current year. | 2 points |
| Kansas City | American | 1973 | 112.91 | 2557712 | 81 | 4.21 | 0.261 | 147 | | 2011 | 3.31 |
| LA Angels | American | 1966 | 146.45 | 3016142 | 74 | 4.28 | 0.26 | 156 | | 2012 | 3.44 |
| LA Dodgers | National | 1962 | 223.35 | 3703312 | 91 | 3.70 | 0.249 | 189 | | 2013 | 3.65 | | | | 2) Develop a box plot with the new variable Stadium Age. | 4 points |
| Miami | National | 2012 | 84.64 | 1712417 | 79 | 4.05 | 0.263 | 128 | | 2014 | 3.95 | | | | 3) Are there any outliers? If so, which of the stadiums are outliers? | 4 points |
| Milwaukee | National | 2001 | 98.68 | 2314614 | 73 | 4.08 | 0.244 | 194 | | 2015 | 4.25 | | | | 4) Using the variable salary create a box plot. Are there any outliers? | 4 points |
| Minnesota | American | 2010 | 108.26 | 1963912 | 59 | 5.08 | 0.251 | 200 | | 2016 | 4.40 | | | | 5) Compute the Salary quartiles using formula 4-1. Write a brief summary of your analysis. | 4 points |
| NY Mets | National | 2009 | 99.63 | 2789602 | 87 | 3.58 | 0.246 | 218 | | | | | | | 6) Draw a scatter diagram with the variable Wins on the vertical axis and salary on the horizontal axis. What are your conclusions? |
| NY Yankees | American | 2009 | 213.47 | 3063405 | 84 | 4.16 | 0.252 | 183 | | | | | | | | 4 points |
| Oakland | American | 1966 | 80.28 | 1521506 | 69 | 4.51 | 0.246 | 169 |
| Philadelphia | National | 2004 | 133.05 | 1915144 | 71 | 4.63 | 0.24 | 161 |
| Pittsburgh | National | 2001 | 85.89 | 2249021 | 78 | 4.21 | 0.257 | 153 |
| San Diego | National | 2004 | 126.37 | 2351426 | 68 | 4.43 | 0.235 | 177 |
| San Francisco | National | 2000 | 166.50 | 3365256 | 87 | 3.65 | 0.258 | 130 |
| Seattle | American | 1999 | 122.71 | 2267928 | 86 | 4.00 | 0.259 | 223 |
| St. Louis | National | 2006 | 120.30 | 3444490 | 86 | 4.08 | 0.255 | 225 |
| Tampa Bay | American | 1990 | 73.65 | 1286163 | 68 | 4.20 | 0.243 | 216 |
| Texas | American | 1994 | 144.31 | 2710402 | 95 | 4.37 | 0.262 | 215 |
| Toronto | American | 1989 | 112.90 | 3392299 | 89 | 3.78 | 0.248 | 221 |
| Washington | National | 2008 | 166.01 | 2481938 | 95 | 3.51 | 0.256 | 203 |
bahlman2
BUSU610ExcelAssignment2.xlsx
