FREQUENCY 2 Function (Functions in Excel)

This example shows how the =FREQUENCY() function has been used to calculate

how often certain numbers appear in the Lottery results.

Table 1 is a record of all the results from the past seven weeks.

	Table 1
	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7
1st Number	3	36	5	3	2	41	45
2nd Number	6	3	19	37	23	15	4
3rd Number	15	44	35	20	47	29	44
4th Number	32	15	32	46	6	45	23
5th Number	37	31	13	22	49	13	43
6th Number	5	22	30	8	49	11	46
Bonus Ball	17	13	15	25	18	17	1

Table 2 is the list of possible number from 1 to 49, and how many appearances

each number has made during the past seven weeks.

Table 2
Lottery Number	How Many Appearances
1	1	{=FREQUENCY(C10:I16,B24:B72)}
2	1	{=FREQUENCY(C10:I16,B24:B72)}
3	3	{=FREQUENCY(C10:I16,B24:B72)}
4	1	{=FREQUENCY(C10:I16,B24:B72)}
5	2
6	2
7	0
8	1
9	0		Special tip!
10	0		To count how many unique numbers in a range
11	1		use the following formula. It has to be entered,
12	0		as an array, so press Ctrl+Shift+Enter rather than,
13	3		just Enter alone.
14	0
15	4			Unique values.	31
16	0
17	2			=SUM(1/COUNTIF(C10:I16,C10:I16))
18	1
19	1
20	1
21	0
22	2
23	2
24	0
25	1
26	0
27	0
28	0
29	1
30	1
31	1
32	2
33	0
34	0
35	1
36	1
37	2
38	0
39	0
40	0
41	1
42	0
43	1
44	2
45	2
46	2
47	1
48	0
49	2

Related Posts by Categories