A B C D E F G H Atlantic Hurricanes PLEASE clearly label every cell/column in your work. W Number of Hurricanes Frequency (# Empirical Theoretical in a Year of years) Probability Probability 0 5 0.068 0.0518 =B5/$B$18 =POISSON(A5,$C$20,FALSE) 16 0.219 0.1534 =B6/$B$18 =POISSON(A6,$ C$20, FALSE) N - 19 0.260 0.2270 =B7/$B$18 =POISSON(A7,$C$20, FALSE) 14 0. 192 0.2240 =B8/$B$18 =POISSON(A8,$ C$20,FALSE) 3 0.041 0. 1657 =B9/$B$18 =POISSON(A9,$C$20, FALSE) 10 0.068 0.0981 =B10/$B$ 18 =POISSON(A10,$C$20, FALSE) 4 0.055 0.0484 =B11/$B$ 18 =POISSON(A11,$C$20,FALSE) 7 0.041 0.0205 =B12/$B$18 =POISSON(A12,$C$20,FALSE) 0.027 0.0076 =B 13/$B$18 =POISSON(A13,$C$20,FALSE) 0 0.0025 =B14/$B$18 =POISSON(A 14,$C$20,FALSE) 0.014 0.0007 =B15/$B$18 =POISSON(A15,$C$20, FALSE) - 0 - 0.0002 =B 16/$B$18 =POISSON(A16,$ C$20,FALSE) 0.014 0.0000 =B17/$B$18 =POISSON(A17,$C$20, FALSE) 73 Mean (Hint: this is group data) 2.96 a. Find the probabilities of 0-12 hurricanes each 25 26 season using these data. 27 b. Assuming a Poisson distribution and using the 28 mean number of hurricanes per season from the 29 30 empirical data, compute the probabilities of ex- 31 periencing 0-12 hurricanes in a season. Compare 32 these to your answer to part (a). How good does 33 34 a Poisson distribution model this phenomenon? 35 Construct a chart to visualize these results. 36