This worksheet contains values required for MegaStat charts. Boxplot 12/5/2012 16:43.50 2 1559681 2 2093854 3 2093854 3 2359023 1 2359023 3 2359023 3 3039261 2 3039261 2 3565718 2 3039261 1 3039261 1 2093854 2 2093854 1 -742364.5 3 -742364.5 1 675744.9 3 675744.9 1 4457370 3 4457370 1 5875479 3 5875479 Dotplot 12/5/2012 16:44.17 1559681 1 1603596 1 1607733 1 1679013 1 1721920 1 1739859 1 1965955 1 2091918 1 2099663 1 2102240 1 2123721 1 2177617 1 2219444 1 2242803 1 2347251 1 2370794 1 2420171 1 2630458 1 2776354 1 2831385 1 2882756 1 3028033 1 3043003 1 3061770 1 3262109 1 3324246 1 3377371 1 3460280 1 3542406 1 3565718 1 Team X1 League Opened Seating Capacity X2 X3 X4 Arizona Diamondbacks 0 1998 48633 Atlanta Braves 0 1996 49586 Baltimore Orioles 1 1992 45971 Boston Red Sox 1 1912 37495 Chicago Cubs 0 1914 41009 Chicago White Sox 1 1991 40615 Cincinnati Reds 0 2003 42319 Cleveland Indians 1 1994 43429 Colorado Rockies 0 1995 50398 Detroit Tigers 1 2000 41255 Houston Astros 0 2000 40981 Kansas City Royals 1 1973 37903 Los Angeles Angels 1 1966 45957 Los Angeles Dodgers 0 1962 56000 Miami Marlins 0 2012 36742 Milwaukee Brewers 0 2001 41900 Minnesota Twins 1 2010 39504 New York Mets 0 2009 41922 New York Yankees 1 2009 50287 Oakland Athletics 1 1966 35067 Philadelphia Phillies 0 2004 43651 Pittsburgh Pirates 0 2001 38362 San Diego Padres 0 2004 42691 San Francisco Giants 0 2000 41915 Seattle Mariners 1 1999 47860 St. Louis Cardinals 0 2006 43975 Tampa Bay Rays 1 1990 34078 Texas Rangers 1 1994 48194 Toronto Blue Jays 1 1989 49260 Washington Nationals 0 2008 41487 71. Refer to the Baseball 2012 data. Compute the mean number of home runs per game. To d this, first find the mean number of home runs per team for 2012. Next, divide this value by 162 (a season comprises 162 games). Then multiply by 2 because there are two teams in each game. Use the Poisson distribution to estimate the number of home runs that will be hit in a game. Find the probability that: a. There are no home runs in a game. b. There are two home runs in a game. c. There are at least four home runs in a game. Salary 2012 Wins Attendance BA ERA HR X5 X6 X7 X8 X9 X10 74.3 81 2.18 0.259 3.93 165 83.3 94 2.42 0.247 3.42 149 81.4 93 2.1 0.247 3.9 214 173.2 69 3.04 0.26 4.7 165 88.2 61 2.88 0.24 4.51 137 96.9 85 1.97 0.255 4.02 211 82.2 97 2.35 0.251 3.34 172 78.4 68 1.6 0.251 4.78 136 78.1 64 2.63 0.274 5.22 166 132.3 88 3.03 0.268 3.75 163 60.7 55 1.61 0.236 4.56 146 60.9 72 1.74 0.265 4.3 131 154.5 89 3.06 0.274 4.02 187 95.1 86 3.32 0.252 3.34 116 118.1 69 2.22 0.244 4.09 137 97.7 83 2.83 0.259 4.22 202 94.1 66 2.78 0.26 4.77 131 93.4 95 2.24 0.249 4.09 139 198 74 3.54 0.265 3.85 245 55.4 94 1.68 0.238 3.48 195 174.5 81 3.57 0.255 3.83 158 63.4 79 2.09 0.243 3.86 170 55.2 76 2.12 0.247 4.01 121 117.6 94 3.38 0.269 3.68 103 82 75 1.72 0.234 3.76 149 110.3 88 3.26 0.271 3.71 159 64.2 90 1.56 0.24 3.19 175 120.5 93 3.46 0.273 3.99 200 75.5 73 2.1 0.245 4.64 198 81.3 98 2.37 0.261 3.33 194 mber of home runs per game. To do 2012. Next, divide this value by ecause there are two teams in mber of home runs that will be Errors SB X11 X12 90 93 86 101 106 58 101 97 105 94 70 109 89 87 96 110 122 100 99 59 118 105 113 132 98 134 98 104 103 149 99 158 107 135 101 79 74 93 111 122 101 116 112 73 121 155 115 118 72 104 107 91 114 134 85 91 101 123 94 105 Average Salary 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Average Salary $512,930 $578,930 $891,188 $1,084,408 $1,120,254 $1,188,679 $1,071,029 $1,176,967 $1,383,578 $1,441,406 $1,720,050 $1,988,034 $2,264,403 $2,383,235 $2,555,476 $2,486,609 $2,632,655 $2,866,544 $2,944,556 $3,154,845 $3,240,206 $3,297,828 $3,305,393 $3,440,000 Balance ATM Services Debit Interest City 1756 13 4 0 1 2 748 9 2 1 0 1 1501 10 1 0 0 1 1831 10 4 0 1 3 1622 14 6 0 1 4 1886 17 3 0 1 1 740 6 3 0 0 3 1593 10 8 1 0 1 1169 6 4 0 0 4 2125 18 6 0 0 2 1554 12 6 1 0 3 1474 12 7 1 0 1 1913 6 5 0 0 1 1218 10 3 1 0 1 1006 12 4 0 0 1 2215 20 3 1 0 4 137 7 2 0 0 3 167 5 4 0 0 4 343 7 2 0 0 1 2557 20 7 1 0 4 2276 15 4 1 0 3 1494 11 2 0 1 1 2144 17 3 0 0 3 1995 10 7 0 0 2 1053 8 4 1 0 3 1526 8 4 0 1 2 1120 8 6 1 0 3 1838 7 5 1 1 3 1746 11 2 0 0 2 1616 10 4 1 1 2 1958 6 2 1 0 2 634 2 7 1 0 4 580 4 1 0 0 1 1320 4 5 1 0 1 1675 6 7 1 0 2 789 8 4 0 0 4 1735 12 7 0 1 3 1784 11 5 0 0 1 1326 16 8 0 0 3 2051 14 4 1 0 4 1044 7 5 1 0 1 1885 10 6 1 1 2 1790 11 4 0 1 3 765 4 3 0 0 4 1645 6 9 0 1 4 32 2 0 0 0 3 1266 11 7 0 0 4 890 7 1 0 1 1 2204 14 5 0 0 2 2409 16 8 0 0 2 1338 14 4 1 0 2 2076 12 5 1 0 2 1708 13 3 1 0 1 2138 18 5 0 1 4 2375 12 4 0 0 2 1455 9 5 1 1 3 1487 8 4 1 0 4 1125 6 4 1 0 2 1989 12 3 0 1 2 2156 14 5 1 0 2 Refer to the Century National Bank data. Is it reasonable that a normal probability distribution? Determine the mean and th mean and the standard deviation for the sample of 60 custom distribution. Cite some specific examples and comment on you Divide the account balances into three groups, of about 20 ea first group, the middle third in the second group, and those w table that shows the number in each of the categories of the a account balances by branch. Does it appear that account bala and comment on your findings. ata. Is it reasonable that the distribution of checking account balances approximates termine the mean and the standard deviation for the sample of 60 customers. the sample of 60 customers. Compare the actual distribution with the theoretical ples and comment on your findings. ee groups, of about 20 each, with the smallest third of the balances in the econd group, and those with the largest balances in the third group. Next, develop a of the categories of the account balances by branch. Does it appear that account appear that account balances are related to the branch? Cite some examples