| Team | League | Year Opened | Team Salary | Attendance | Wins | ERA | BA | HR | | Year | Average Salary (millions) | | PART I TASKS: | A United Nations report shows the mean family income for Mexican migrants to the United States is $27,000 per year. A Farm Labor Organizing Committee evaluation of 25 Mexican family units reveals the mean to be $30,000 with a sample standard deviation of $10,000. Does this information disagree with the United Nations report? Apply the .01 significance level. |
| Arizona | National | 1998 | 70.76 | 2036216 | 69 | 5.09 | 0.261 | 190 | | 2000 | 1.99 |
| Atlanta | National | 1996 | 87.62 | 2020914 | 68 | 4.51 | 0.255 | 122 | | 2001 | 2.26 | | | | 12 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 |
| 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 |
| Cincinnati | National | 2003 | 116.73 | 1894085 | 68 | 4.91 | 0.256 | 164 | | 2006 | 2.87 | | PART II TASKS: | Refer to the Baseball data: |
| Cleveland | American | 1994 | 86.34 | 1591667 | 94 | 3.84 | 0.262 | 185 | | 2007 | 2.94 | | | 1) At the 0.05 significance level, can we conclude that there is a difference in the mean salary of teams in the American League versus teams in the National League? | 9 points |
| 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 | | | 2) At the 0.05 significance level, can we conclude that there is a difference in the mean home attendance of teams in the American League versus teams in the National League? | 9 points |
| Houston | American | 2000 | 69.06 | 2306623 | 84 | 4.06 | 0.247 | 198 | | 2010 | 3.30 |
| Kansas City | American | 1973 | 112.91 | 2557712 | 81 | 4.21 | 0.261 | 147 | | 2011 | 3.31 | | | 3) Compute the mean and the standard deviation of the attendance for the 10 teams with the highest salaries. Do the same for the 10 teams with the lowest salaries. At the .05 significance level, is there a difference in the mean attendance for the two groups? | 10 points |
| 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 |
| Miami | National | 2012 | 84.64 | 1712417 | 79 | 4.05 | 0.263 | 128 | | 2014 | 3.95 |
| Milwaukee | National | 2001 | 98.68 | 2314614 | 73 | 4.08 | 0.244 | 194 | | 2015 | 4.25 |
| Minnesota | American | 2010 | 108.26 | 1963912 | 59 | 5.08 | 0.251 | 200 | | 2016 | 4.40 |
| NY Mets | National | 2009 | 99.63 | 2789602 | 87 | 3.58 | 0.246 | 218 |
| NY Yankees | American | 2009 | 213.47 | 3063405 | 84 | 4.16 | 0.252 | 183 |
| 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
BUSU610ExcelAssignment5.xlsx
