Please answer the question and also complete the excel part! Thanks!

A1 A x fix x fx Number of Hurricanes B B C D E F G H 1 L M M N O P a R S Question 1 1 pts The number and frequency of Atlantic hurricanes annually from 1940 through 2015 are shown. Use VLOOKUP and RAND to generate 10 random variates from this distribution in Excel worksheet Hurricanes. Use only the highlighted cells. 4 H B D E F G 1 Sampling from the Distribution of Dice Outcomes 2 3 Probability distribution Intervals for random sampling 4 X Number of Number of Number of 1 Hurricanes Frequency Prob. Cumu. Interval Hurricanes No. Hurricanes 2 O 5 1 3 1 1 16 2 4. 2 20 3 5 3 14 6 4 4 5 7 5 5 6 8 6 5 7 9 7 3 8 10 8 2 9 11 10 1 10 12 12 1 13 TOTAL 14 15 Hint: 16 0. Study the example we did in class. 17 1. Calculate the total frequency (B13), then the probability of each value of number of 18 hurricanes (Column C). 19 2. Calculate the cumulative probability. 20 3. Construct the VLOOKUP table in columns E, F, and using the cumulative probability in column D and number of hurricanes in column A. 21 4. Use RAND() and VLOOKUP to generate ten random number of hurricanes in column). 22 23 24 25 26 27 28 29 30 31 32 33 7. f CI.COM 0.056 0.083 0.111 01.11 0.167 0.139 0.111 0 01.050 0.028 Z 3 4 5 6 7 3 9 10 11 12 F(x) 0.025 0.083 0.167 0.278 0.417 0.583 0.722 0.833 0.917 0.972 1.000 Interval ta to to to tor ta to to to ta to U 0.028 0.083 0.167 07 0.417 0.583 0.722 0.833 091/ 0.972 1.11 0.083 0.167 0.278 1417 0.583 0.722 0.833 0.917 Outcome 2 3 4 5 6 7 8 10 11 12 13 74 15 16 17 11 19 20 10 11 12 1.000 Cenerate random number Find the interval in which it falls Use the associated outcome: 0.12751 -RANDO 0.083 to 0.166667 4 VLOOKUPIGIS, ESHLS 4 TRUE 4