Question

The number and frequency of Atlantic hurricanes annually from 1940 through 2015 are shown below. Use VLOOKUP to generate 25 random variates from this distribut

Number	Frequency
0	5
1	16
2	20
3	14
4	4
5	5
6	5
7	3
8	2
10	1
12	1

Answer 1

The frequency of Atlantic hurricane is given as a discrete distribution ranging from 0 to 12 incidences. Using the frequency distribution one used the random number generator to obtain a random number between 0 and 76.

The cumulative distribution table us as follows:

Number	Frequency	CF
0	5	5
1	16	21
2	20	41
3	14	55
4	4	59
5	5	64
6	5	69
7	3	72
8	2	74
10	1	75
12	1	76

Any number arriving between Cfi and CF(i-1) belongs to the ith number.

So the random numbers generated and their corresponding numbers are:

r.n.	number
45	3
55	3
70	7
33	2
1	0
13	1
50	3
71	7
38	2
52	3
2	0
22	2
54	3
71	7
21	1
74	8
61	5
62	5
55	4
76	12
17	1
38	2
30	2
30	2
45	3