Number Generator Example.xlsm

	A	B	C	D	E	F	G	H	I	J	L	M	O	P	Q	R	S	U	W	X	AA
1	Examples of Frequency & Random
2
3		Column1	Column2	1	2	3	4	5	6	Random	Selections	Frequency	Highest Frequencies			Number of Random Numbers Required :
4				2	13	27	28	35	47	0.1392170776	1	#NAME?	#1	#NAME?		43
5				4	7	8	14	33	47	0.6633421161	2		#2	#NAME?
6				11	13	19	20	27	30	0.3555517092	3		#3	#NAME?
7				9	32	33	34	38	43	0.8964694158	4		#4	#NAME?
8				9	18	24	37	40	45	0.9190181095	5		#5	#NAME?
9				12	18	27	32	44	45	0.2839246816	6
10				3	11	23	25	34	44	0.4552217421	7
11				12	16	17	22	28	39	0.668573041	8
12				1	3	5	25	28	37	0.5603428499	9
13				6	11	13	31	34	37	0.9864720502	10		Number Selections Based On Highest Frequencies					Combine Selections			Select Cell Below to pate
14				14	16	17	21	25	48	0.8988359604	11		1	2	3	4	5		47	47	47
15				22	30	32	37	42	44	0.4442627725	12								37	37	37
16				6	26	32	36	40	45	0.8608046561	13								2	2	2
17				4	13	30	37	43	47	0.390652969	14								1	1	1
18				1	3	6	16	19	27	0.5125270783	15								10	10	10
19				3	8	19	24	25	47	0.7268243032	16										43
20				21	24	26	38	40	48	0.4092050724	17								43	43	3
21				9	10	16	17	34	36	0.3602226804	18								3	3	6
22				2	9	10	15	19	41	0.7940528129	19								6	6	11
23				1	7	12	33	41	46	0.6759534394	20								11	11	7
24				1	2	16	18	36	45	0.7105597505	21										13
25				15	21	24	37	38	45	0.4460604966	22										12
26				5	9	13	34	47	48	0.1665949497	23								7	7	9
27				2	8	27	30	31	47	0.3997749771	24								13	13	17
28				7	17	24	31	32	44	0.2518014252	25								12	12	20
29				10	23	24	30	35	49	0.5308422036	26										24
30				6	13	14	15	18	47	0.5366798053	27										18
31				4	18	20	21	29	36	0.8251094443	28								9	9	36
32				3	15	18	33	38	40	0.935935428	29								17	17	30
33				7	23	26	27	44	48	0.4694454402	30								20	20	19
34				2	19	27	43	47	49	0.2894530547	31										45
35				2	33	35	36	40	47	0.2566457445	32										38
36				17	19	37	38	39	49	0.7143612243	33								24	24	21
37				7	12	31	35	39	43	0.1632652833	34								18	18	48
38				19	29	30	40	41	43	0.7768766283	35								36	36	40
39				20	23	28	35	43	44	0.3594429973	36										23
40				1	12	22	23	41	48	0.3919205637	37										25
41				3	5	7	20	24	48	0.9510015617	38								30	30	27
42				9	10	13	20	43	46	0.2039484209	39								19	19	31
43				12	26	33	38	47	49	0.8717991518	40								45	45	32
44				1	7	17	25	35	43	0.8592193079	41										33
45				10	21	31	35	37	46	0.6839911845	42										34
46				3	6	9	11	23	43	0.8261831279	43								38	38	35
47				9	11	21	31	32	34	0.829156416	44								21	21	44
48				7	15	18	20	22	40	0.2382155666	45								48	48
49				2	17	40	41	42	45	0.6559148858	46
50				1	5	6	10	39	44	0.05616308102	47
51				6	11	21	32	33	46	0.459596676	48								40	40
52				8	23	24	31	47		0.8147616905	49								23	23
53				4	26	36	37	38		0.7647173137
54				3	8	14	30	46		0.4177881843
55				5	14	25	30	38		0.197612358
56				2	22	25	34	42		0.1757331593
57																			25	25
58
59
60
61
62																			27	27
63
64
65
66
67																			31	31
68
69
70
71
72																			32	32
73
74
75
76
77																			33	33
78
79
80
81
82																			34	34
83
84
85
86
87																			35	35
88
89
90
91
92																			44	44
93
94
95
96
97
98
99
100