Refer to the Baseball 2010 data, which reports information on the 30 Major Leagu
ID: 3774657 • Letter: R
Question
Refer to the Baseball 2010 data, which reports information on the 30 Major League Baseball teams for the 2010 season.
a. At the .10 significance level, is there a difference in the variation in team payroll among the American and National league teams?
b. Create a variable that classifies a team's total attendence into three group: less than 2.0 (million), 2.0 up to 3.0, and 3.0 or more. At the .01 significance level is there a difference in the mean number of games won among the three groups ?
c. Using the same attendence variable developed in part (b), is there a difference in the mean number of home run hits per team ? Use the .01 significance level.
d. Using the same attendence variable developed in part (b), is there a difference in the mean payroll of the three groups? Use the .01 significance level.
i copied my spreadsheet and sent it from word hope this works
Explanation / Answer
At the .10 significance level, is there a difference in the variation in team payroll among the American and National league teams?
b. Create a variable that classifies a team's total attendence into three group: less than 2.0 (million), 2.0 up to 3.0, and 3.0 or more. At the .01 significance level is there a difference in the mean number of games won among the three groups ?
c. Using the same attendence variable developed in part (b), is there a difference in the mean number of home run hits per team ? Use the .01 significance level.
d. Using the same attendence variable developed in part (b), is there a difference in the mean payroll of the three groups? Use the .01 significance level.
Refer to the Baseball 2010 data, which reports information on the 30 major league teams for the 2010 baseball season.At the .10 significance level, is there a difference in the variation in team payroll among the American and National league teams?
b. Create a variable that classifies a team's total attendence into three group: less than 2.0 (million), 2.0 up to 3.0, and 3.0 or more. At the .01 significance level is there a difference in the mean number of games won among the three groups ?
c. Using the same attendence variable developed in part (b), is there a difference in the mean number of home run hits per team ? Use the .01 significance level.
d. Using the same attendence variable developed in part (b), is there a difference in the mean payroll of the three groups? Use the .01 significance level.
x1 = Team x2 = League (American = 1, National = 0) x3 = Built (year stadium was built) x4 = Size (stadium capacity) x5 = Surface (natural = 0, artificial = 1) x6 = Salary (total 2005 team salary $ Mil) x7 = Wins x8 = Attendance (total annual for team) x9 = Batting x10 = ERA (earned run average) x11 = HR (home runs) x12 = Errors x13 = SB (stolen bases) x14 = Year x15 = Average player salary ($) 30 Teams Team x1 League, x2 Built, x3 Age (x) Size, x4 Surface, x5 Salary, x6 Wins, x7 Attendance, x8 Batting, x9 ERA, x10 HR, x11 Errors, x12 SB, x13 Year, x14 Average, x15 Boston 1 1912 97 33,871 0 123.5 95 2,847,798 0.281 4.74 199 109 45 1989 512,930 New York Yankees 1 1923 86 57,746 0 208.3 95 4,090,440 0.276 4.52 229 95 84 1990 578,930 Oakland 1 1966 43 43,662 0 55.4 88 2,108,818 0.262 3.69 155 88 31 1991 891,188 Baltimore 1 1992 17 48,262 0 73.9 74 2,623,904 0.269 4.56 189 107 83 1992 1,084,408 Los Angeles Angels 1 1966 43 45,050 0 97.7 95 3,404,636 0.27 3.68 147 87 161 1993 1,120,254 Cleveland 1 1994 15 43,368 0 41.5 93 2,014,220 0.271 3.61 207 106 62 1994 1,188,679 Chicago White Sox 1 1991 18 44,321 0 75.2 99 2,342,804 0.262 3.61 200 94 137 1995 1,071,029 Toronto 1 1989 20 50,516 1 45.7 80 2,014,995 0.265 4.06 136 95 72 1996 1,176,967 Minnesota 1 1982 27 48,678 1 56.2 83 2,034,243 0.259 3.71 134 102 102 1997 1,383,578 Tampa Bay 1 1990 19 44,027 1 29.7 67 1,141,915 0.274 5.39 157 124 151 1998 1,441,406 Texas 1 1994 15 52,000 0 55.8 79 2,525,259 0.267 4.96 260 108 67 1999 1,720,050 Detroit 1 2000 9 40,000 0 69.1 71 2,024,505 0.272 4.51 168 110 66 2000 1,988,034 Seattle 1 1999 10 45,611 0 87.8 69 2,724,859 0.256 4.49 130 86 102 2001 2,264,403 Kansas City 1 1973 36 40,529 0 36.9 56 1,371,181 0.263 5.49 126 125 53 2002 2,383,235 Atlanta 0 1993 16 50,062 0 86.5 90 2,520,904 0.265 3.98 184 86 92 2003 2,555,476 Arizona 0 1998 11 49,075 0 62.3 77 2,059,327 0.256 4.84 191 94 67 2004 2,486,609 Houston 0 2000 9 42,000 0 76.8 89 2,805,060 0.256 3.51 161 89 115 2005 2,632,655 Cincinnati 0 2003 6 42,059 0 61.9 73 1,923,254 0.261 5.15 222 104 72 New York Mets 0 1964 45 55,775 0 101.3 83 2,827,549 0.258 3.76 175 106 153 Pittsburgh 0 2001 8 38,127 0 38.1 67 1,817,245 0.259 4.42 139 117 73 Los Angeles Dodgers 0 1962 47 56,000 0 83 71 3,603,680 0.253 4.38 149 106 58 San Diego 0 2004 5 42,445 0 63.3 82 2,869,787 0.257 4.13 130 109 99 Washington 0 1961 48 56,000 0 48.6 81 2,730,352 0.252 3.87 117 92 45 San Francisco 0 2000 9 40,800 0 90.2 75 3,181,020 0.261 4.33 128 90 71 St. Louis 0 1966 43 49,625 0 92.1 100 3,542,271 0.27 3.49 170 100 83 Florida 0 1987 22 42,531 0 60.4 83 1,852,608 0.272 4.16 128 103 96 Philadelphia 0 2004 5 43,500 0 95.5 88 2,665,304 0.27 4.21 167 90 116 Milwaukee 0 2001 8 42,400 0 39.9 81 2,211,323 0.259 3.97 175 119 79 Chicago Cubs 0 1914 95 38,957 0 87 79 3,100,092 0.27 4.19 194 101 65 Colorado 0 1995 14 50,381 0 48.2 67 1,914,385 0.267 5.13 150 118 65