I need assistance with question #2
Team League Baltimore American 1992 115.59 2172344 89 4.22 Boston American 1912 182.16 2955434 93 4.00 Chicago Sox American 1991 98.71 1746293 78 4.10 Cleveland American 1994 86.34 1591667 94 3.84 Detroit American 2000 172.28 2493859 86 4.24 Houston American 2000 69.06 2306623 84 4.06 Kansas City American 1973 112.91 2557712 81 4.21 LA Angels American 1966 146.45 3016142 74 4.28 Minnesota American 2010 108.26 1963912 59 5.08 NY Yankees American 2009 213.47 3063405 84 4.16 Oakland American 1966 80.28 1521506 69 4.51 Seattle American 1999 122.71 2267928 86 4.00 Tampa Bay American 1990 73.65 1286163 68 4.20 Texas American 1994 144.31 2710402 95 4.37 Toronto American 1989 112.90 3392299 89 3.78 Arizona National 1998 70.76 2036216 69 5.09 Atlanta National 1996 87.62 2020914 68 4.51 Chicago Cubs National 1914 116.65 3232420 103 3.15 Cincinnati National 2003 116.73 1894085 68 4.91 Colorado National 1995 98.26 2602524 75 4.91 LA Dodgers National 1962 223.35 3703312 91 3.70 Miami National 2012 84.64 1712417 79 4.05 Milwaukee National 2001 98.68 2314614 73 4.08 NY Mets National 2009 99.63 2789602 87 3.58 Philadelphia National 2004 133.05 1915144 71 4.63 Pittsburgh National 2001 85.89 2249021 78 4.21 San Diego National 2004 126.37 2351426 68 4.43 San Francisco National 2000 166.50 3365256 87 3.65 St. Louis National 2006 120.30 3444490 86 4.08 Washington National 2008 166.01 2481938 95 3.51 Team League Tampa Bay American Year Opened Year Opened 1990 Team Salary Team Salary 73.65 Attendance Attendance 1286163 Wins Wins 68 ERA Oakland American 1966 80.28 1521506 69 Cleveland American 1994 86.34 1591667 94 Miami National 2012 84.64 1712417 79 Chicago Sox American 1991 98.71 1746293 78 Cincinnati National 2003 116.73 1894085 68 Philadelphia National 2004 133.05 1915144 71 Minnesota American 2010 108.26 1963912 59 Atlanta National 1996 87.62 2020914 68 Arizona National 1998 70.76 2036216 69 Baltimore American 1992 115.59 2172344 89 Pittsburgh National 2001 85.89 2249021 78 Seattle American 1999 122.71 2267928 86 Houston American 2000 69.06 2306623 84 Milwaukee National 2001 98.68 2314614 73 San Diego National 2004 126.37 2351426 68 Washington National 2008 166.01 2481938 95 Detroit American 2000 172.28 2493859 86 Kansas City American 1973 112.91 2557712 81 Colorado National 1995 98.26 2602524 75 Texas American 1994 144.31 2710402 95 NY Mets National 2009 99.63 2789602 87 Boston American 1912 182.16 2955434 93 LA Angels American 1966 146.45 3016142 74 NY Yankees American 2009 213.47 3063405 84 Chicago Cubs National 1914 116.65 3232420 103 San Francisco National 2000 166.50 3365256 87 Toronto American 1989 112.90 3392299 89 St. Louis National 2006 120.30 3444490 86 LA Dodgers National 1962 223.35 3703312 91 BA HR 0.256 253 Year 2000 0.282 208 2001 0.257 168 2002 0.262 185 2003 0.267 211 2004 0.247 198 2005 0.261 147 2006 0.26 156 2007 0.251 200 2008 0.252 183 2009 0.246 169 2010 0.259 223 2011 0.243 216 2012 0.262 215 2013 0.248 221 2014 0.261 190 2015 0.255 122 2016 Average Salary (millions) 1.99 2.26 2.38 2.56 2.49 2.63 2.87 2.94 3.15 3.24 3.30 3.31 3.44 3.65 3.95 4.25 4.40 0.256 199 0.256 164 0.275 204 0.249 189 0.263 128 0.244 194 0.246 218 0.24 161 0.257 153 0.235 177 0.258 130 0.255 225 0.256 203 Less than2.0 68 3 2.0-3.0 68 74 Anova: Single Factor 69 69 84 94 89 103 79 78 87 78 86 89 68 84 86 71 73 91 59 68 SUMMARY Groups Less than2.0 2.0-3.0 3 95 86 81 75 95 ANOVA Source of Variation Between Grou Within Groups 87 93 Total a: Single Factor TASKS: Count Sum 8 0 15 7 SS 805.37142857143 2495.32857142857 3300.7 586 0 1227 614 df 2 27 29 1) At the .10 significance level, is there a difference in the variation in team salary among the American and National League teams? There is no signficant difference in the variation between the American and the National League teams. We can accept the hypothesis, which means that there is no signficance difference between the two teams. 10 points F is lower than F critical and p is higher than the 2) Create a variable that classifies a team's total signficance level. attendance into three groups: less than 2.0 (million), 2.0 up to 3.0, and 3.0 and more. At the .05 significance level, is there a difference in the mean number of games won 10 points among the three groups? Yes, there is a difference in the mean number of games won by the three groups. The F variable is higher than the F critical, so we reject the null hypothesis. Average 73.25 #DIV/0! 81.8 87.7142857142857 MS 402.685714 92.4195767 Variance 109.6428571 #DIV/0! 91.17142857 75.23809524 F 4.3571436 Ho: There is no significant difference in the variation in team salary among the American and Ha: There is a significant difference in the variation in team salary among the American and American (Variance 1763.92208380952 National (Variance) 1601.44193523809 F stat critical value decision 1.10145865734887 2.00953 Since the Fstat is not less than the critic accept the null hypothsis. We conclude that there is no signficance difference in the variation. F-Test Two-Sample for Variances Mean Variance Observations df F P(F
