Euro Millions lottery outcomes: most drawn numbers

I found out you can download the results from all Euro Millions drawings in a CSV file, which opens a range of statistical analysis tools. Since it’s all about numbers, I’m going to use Excel which is made for this purpose. Let’s start simple: most drawn numbers.

You can get the CSV file here: http://www.euromillions.be/NL/Spelen_en_Winnen/Trekkingsspelen/Euromillions/Results/DownloadResults.aspx

Thanks to Bart Devriendt for fixing this up (see comments).

The rules

Euro Millions is a simple lottery, let’s quickly go over how it works:

  • There are two bowls which numbers are drawn from.
  • 5 numbers are drawn from bowl A with a range from 1 to 50.
  • 2 numbers are drawn from bowl B with a range from 1 to 11 which are called “Stars”.
  • Once a number has been drawn from a bowl it cannot be redrawn.
  • You can participate multiple times on the same drawing.

The two Euro Millions bowls.

When do you get a prize?

You need at least two matching numbers to “win”. The more numbers you match, the higher the prize. If you’ve played one set of numbers, and you have two matching numbers, you’ll usually profit. (From the drawing of 31/08/2012, if you had 2 matching numbers, you earned € 4,20 while it costs € 2,- to participate).

The jackpot currently starts at € 15 000 000 and whatever is left carries over to the next drawing.

The form you fill in to participate. They elusively present two rows to fill in but you only have to fill in one to join the game.

Stat. analysis 101: which numbers are most drawn?

(This analysis has been done based on the results from 13/02/2004 to 31/08/2012)

The Excel sheet: Euro Millions – Most drawn numbers

Since we know which numbers have been drawn, we can make a frequency table. The tables below are sorted on their frequency.

Regulars

32 39
33 43
39 44
46 45
2 45
13 45
27 45
43 45
18 46
10 46
28 47
34 47
48 47
41 47
31 47
5 48
40 48
7 48
47 48
35 49
42 49
8 49
30 50
20 50
22 50
6 50
24 50
26 52
3 52
15 52
17 53
44 53
45 53
29 53
49 53
23 54
9 55
16 56
25 57
1 57
21 58
36 58
37 58
11 58
14 60
38 60
19 63
12 63
4 63
50 72

Stars

10 27
11 29
4 90
6 104
2 106
9 107
1 108
7 111
8 115
5 115
3 120

Graphs

What are the most drawn numbers?

4, 12, 14, 19, 38 (tied with 14), 50; stars: 3, 5 (tied with 8)

What’s next?

Do you know any more interesting statistics we could get out of this?

Advertisements