Refer to the baseball dataset provided on the author's website. Over the last 10 years, the mean attendance per team followed a normal distribution with a mean of 2.25 million per team and a standard deviation of.70 million. Use a statistical software to

mzlkha
baseball_2009_chicago.xls
Home>Mathematics homework help>Numerical analysis homework help>Refer to the baseball dataset provided on the author's website. Over the last 10 years, the mean attendance per team followed a normal distribution with a mean of 2.25 million per team and a standard deviation of.70 million. Use a statistical software to

Output

Frequency Distribution - Quantitative
Salary cumulative
lower upper midpoint width frequency percent frequency percent
30 < 70 50 40 9 30.0 9 30.0
70 < 110 90 40 14 46.7 23 76.7
110 < 150 130 40 6 20.0 29 96.7
150 < 190 170 40 0 0.0 29 96.7
190 < 230 210 40 1 3.3 30 100.0
229.99
30 100.0

Sheet1

Team League Built Size Salary Wins Attendance BA ERA HR Errors SB Year Average
X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12 X13 X14
Baltimore Orioles 1 1992 48876 67.1 64 1.91 0.268 5.15 160 90 76 1989 $512,930
Boston Red Sox 1 1912 39928 121.8 95 3.06 0.270 4.35 212 82 126 1990 $578,930
Chicago White Sox 1 1991 40615 96.1 79 2.28 0.258 4.14 184 113 113 1991 $891,188
Cleveland Indians 1 1994 43345 81.6 65 1.77 0.264 5.06 161 97 84 1992 $1,084,408
Detroit Tigers 1 2000 41782 115.1 86 2.57 0.260 4.29 183 88 72 1993 $1,120,254
Kansas City Royals 1 1973 40793 70.5 65 1.80 0.259 4.83 144 116 88 1994 $1,188,679
Los Angeles Angels 1 1966 45050 113.7 97 3.24 0.285 4.45 173 85 148 1995 $1,071,029
Minnesota Twins 1 2010 40000 65.3 87 2.42 0.274 4.50 172 76 85 1996 $1,176,967
New York Yankees 1 2009 52325 201.5 103 3.72 0.283 4.26 244 86 111 1997 $1,383,578
Oakland Athletics 1 1966 34077 62.3 75 1.41 0.262 4.26 135 105 133 1998 $1,441,406
Seattle Mariners 1 1999 47116 98.9 85 2.20 0.258 3.87 160 105 89 1999 $1,720,050
Tampa Bay Rays 1 1990 36048 63.3 84 1.87 0.263 4.33 199 98 194 2000 $1,988,034
Texas Rangers 1 1994 49115 68.2 87 2.16 0.260 4.38 224 106 149 2001 $2,264,403
Toronto Blue Jays 1 1989 50516 80.5 75 1.88 0.266 4.47 209 76 73 2002 $2,383,235
Arizona Diamondbacks 0 1998 49033 73.5 70 2.13 0.253 4.42 173 124 102 2003 $2,555,476
Atlanta Braves 0 1996 50091 96.7 86 2.37 0.263 3.57 149 96 58 2004 $2,486,609
Chicago Cubs 0 1914 41118 134.8 83 3.17 0.255 3.84 161 105 56 2005 $2,632,655
Cincinnati Reds 0 2003 42059 73.6 78 1.75 0.247 4.18 158 89 96 2006 $2,866,544
Colorado Rockies 0 1995 50445 75.2 92 2.67 0.261 4.22 190 87 106 2007 $2,944,556
Florida Marlins 0 1987 36331 36.8 87 1.46 0.268 4.29 159 106 75 2008 $3,154,845
Houston Astros 0 2000 40950 103.0 74 2.52 0.260 4.54 142 78 113 2009 $3,240,000
Los Angeles Dodgers 0 1962 56000 100.4 95 3.76 0.270 3.41 145 83 116
Milwaukee Brewers 0 2001 42200 80.2 80 3.04 0.263 4.83 182 98 68
New York Mets 0 2009 45000 149.4 70 3.15 0.270 4.45 95 97 122
Philadelphia Phillies 0 2004 43647 113.0 93 3.60 0.258 4.16 224 76 119
Pittsburgh Pirates 0 2001 38496 48.7 62 1.58 0.252 4.59 125 73 90
San Diego Padres 0 2004 42445 43.7 75 1.92 0.242 4.37 141 94 82
San Francisco Giants 0 2000 41503 82.6 88 2.86 0.257 3.55 122 88 78
St. Louis Cardinals 0 2006 49660 77.6 91 3.34 0.263 3.66 160 96 75
Washington Nationals 0 2008 41888 60.3 59 1.82 0.258 5.00 156 143 73

Ch9

Team League Built Size Salary Wins Attendance BA ERA HR Errors SB Year Average
X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12 X13 X14
Boston Red Sox 1 1912 39928 121.8 95 3.06 0.270 4.35 212 82 126 1989 $512,930
Chicago Cubs 0 1914 41118 134.8 83 3.17 0.255 3.84 161 105 56 1990 $578,930
Los Angeles Dodgers 0 1962 56000 100.4 95 3.76 0.270 3.41 145 83 116 1991 $891,188
Los Angeles Angels 1 1966 45050 113.7 97 3.24 0.285 4.45 173 85 148 1992 $1,084,408
Oakland Athletics 1 1966 34077 62.3 75 1.41 0.262 4.26 135 105 133 1993 $1,120,254
Kansas City Royals 1 1973 40793 70.5 65 1.80 0.259 4.83 144 116 88 1994 $1,188,679
Florida Marlins 0 1987 36331 36.8 87 1.46 0.268 4.29 159 106 75 1995 $1,071,029
Toronto Blue Jays 1 1989 50516 80.5 75 1.88 0.266 4.47 209 76 73 1996 $1,176,967
Tampa Bay Rays 1 1990 36048 63.3 84 1.87 0.263 4.33 199 98 194 1997 $1,383,578
Chicago White Sox 1 1991 40615 96.1 79 2.28 0.258 4.14 184 113 113 1998 $1,441,406
Baltimore Orioles 1 1992 48876 67.1 64 1.91 0.268 5.15 160 90 76 1999 $1,720,050
Cleveland Indians 1 1994 43345 81.6 65 1.77 0.264 5.06 161 97 84 2000 $1,988,034
Texas Rangers 1 1994 49115 68.2 87 2.16 0.260 4.38 224 106 149 2001 $2,264,403
Colorado Rockies 0 1995 50445 75.2 92 2.67 0.261 4.22 190 87 106 2002 $2,383,235
Atlanta Braves 0 1996 50091 96.7 86 2.37 0.263 3.57 149 96 58 2003 $2,555,476
Arizona Diamondbacks 0 1998 49033 73.5 70 2.13 0.253 4.42 173 124 102 2004 $2,486,609
Seattle Mariners 1 1999 47116 98.9 85 2.20 0.258 3.87 160 105 89 2005 $2,632,655
Detroit Tigers 1 2000 41782 115.1 86 2.57 0.260 4.29 183 88 72 2006 $2,866,544
Houston Astros 0 2000 40950 103.0 74 2.52 0.260 4.54 142 78 113 2007 $2,944,556
San Francisco Giants 0 2000 41503 82.6 88 2.86 0.257 3.55 122 88 78 2008 $3,154,845
Milwaukee Brewers 0 2001 42200 80.2 80 3.04 0.263 4.83 182 98 68 2009 $3,240,000
Pittsburgh Pirates 0 2001 38496 48.7 62 1.58 0.252 4.59 125 73 90
Cincinnati Reds 0 2003 42059 73.6 78 1.75 0.247 4.18 158 89 96
Philadelphia Phillies 0 2004 43647 113.0 93 3.60 0.258 4.16 224 76 119
San Diego Padres 0 2004 42445 43.7 75 1.92 0.242 4.37 141 94 82
St. Louis Cardinals 0 2006 49660 77.6 91 3.34 0.263 3.66 160 96 75
Washington Nationals 0 2008 41888 60.3 59 1.82 0.258 5.00 156 143 73
New York Yankees 1 2009 52325 201.5 103 3.72 0.283 4.26 244 86 111
New York Mets 0 2009 45000 149.4 70 3.15 0.270 4.45 95 97 122
Minnesota Twins 1 2010 40000 65.3 87 2.42 0.274 4.50 172 76 85
1.5649215929
0.0588006475

Sheet3