Analysis of the MegaMIllions lottery

I compiled some data in Excel using the winning numbers data from 5-17-2002 – 3-23-2012.A few of the charts created using the winning numbers for the Mega Millions lottery are found below.

This first chart describes the number of times each number is drawn for each pick. From the data we see that the number 2 is more likely to be the first number drawn because it shows up as the first pick more often. The number of times 2 has appeared first is 75.4% of the total number of times a 2 has been in the winning numbers.

How many times each numbers is drawn
	first pick	second pick	third pick	fourth pick	fifth pick	mega ball
1s	82	0	0	0	0	19
2's	92	9	0	0	0	21
3s	78	7	1	0	0	27
4's	70	23	1	0	0	24
5's	68	22	3	1	0	18
6's	61	21	3	0	0	22
7's	63	24	6	1	0	28
8's	53	27	4	0	0	22
9's	52	36	6	0	0	27
10's	50	46	13	0	0	27
11's	39	32	10	3	0	17
12's	35	44	16	2	0	21
13's	27	49	15	2	0	27
14's	46	40	19	2	1	16
15's	24	39	19	4	0	23
16's	32	42	16	10	0	15
17's	17	50	30	3	0	17
18's	23	40	27	10	1	21
19's	12	38	30	11	0	22
20's	13	40	38	7	1	24
21's	10	33	35	13	2	30
22's	14	34	32	13	4	25
23's	9	27	30	12	2	18
24's	14	32	36	10	3	23
25's	10	33	29	19	4	20
26's	5	25	39	19	2	22
27's	9	25	42	16	7	20
28's	5	20	35	34	5	9
29's	4	26	33	30	7	25
30's	2	23	27	29	8	21
31's	2	25	40	29	12	21
32's	1	19	34	35	10	15
33's	1	11	25	29	13	23
34's	0	8	31	29	11	26
35's	1	12	30	29	16	28
36's	1	10	25	41	21	32
37's	1	5	33	37	7	17
38's	1	6	25	40	22	25
39's	1	7	30	46	23	18
40's	0	5	19	45	23	20
41's	0	3	20	28	26	19
42's	0	3	18	43	29	23
43's	0	4	22	27	31	20
44's	0	1	18	32	42	21
45's	0	1	19	38	37	19
46's	0	1	11	44	47	17
47's	0	0	7	35	40	7
48's	0	0	12	41	55	4
49's	0	0	3	33	54	7
50's	0	0	2	25	74	4
51's	0	0	4	26	81	1
52's	0	0	2	17	89	10
53's	0	0	2	16	56	0
54's	0	0	1	8	50	0
55's	0	0	0	4	49	0
56's	0	0	0	0	63	0

In this next chart I have laid out the average, mode, median, harmonic mean and other analysis of the number distributions across all of the different picks. 

	first pick	second pick	third pick	fourth pick	fifth pick	mega ball
median all	7.5	18	28	38	49	24
Average all	9.278210117	18.6624514	28.3015564	37.42607	46.4542802	23.990272
mode all	2	17	27	39	52	36
standard deviation	7.137233978	9.10326996	10.2470703	9.59011029	7.6711884	13.842004
Geometric mean	6.565968069	16.139646	26.1471469	35.9559721	45.6978254	18.277583
Harmonic mean	4.207752217	13.1495089	23.5028125	34.0860285	44.7726832	10.698143
Mean - stddev	2.140976139	9.5591814	18.0544862	27.8359598	38.7830918	10.148268
Mean + stddev	14.63723398	27.10327	38.2470703	47.5901103	56.6711884	37.842004
avg mean+-stddev	8.389105058	18.3312257	28.1507782	37.713035	47.7271401	23.995136

This final chart is all of the data above rounded to the nearest whole number.

first pick	second pick	third pick	fourth pick	fifth pick	mega ball
8	18	28	38	49	24
9	19	28	37	46	24
2	17	27	39	52	36
7	9	10	10	8	14
7	16	26	36	46	18
4	13	24	34	45	11
2	10	18	28	39	10
15	27	38	48	57	38
8	18	28	38	48	24

It is important to note, that all these numbers represent the various distribution statistics of the numbers that were drawn at each of the televised drawings, and do not represent any regressive or other types of predictive models. These numbers are just simply a statistical analysis of the given data for educational purposes only. All data represents the real numbers published at http://www.megamillions.com/numbers/pastdrawings.asp The website offers a tool at the top of the page to select your data range and get all of the drawings