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

8 thoughts on “Euro Millions lottery outcomes: most drawn numbers

  1. Some comments:
    – a frequency table does not tell you a lot. It doesn’t matter if the number 17 is drawn the first, second, .. or last number. Only the total number of times it is drawn. For 17 this is 53 times.
    – Stars 1 & 9 are not the most drawn. Star 3 (120), star 5 (115) and 8 (115) are the most drawn stars.
    – The most drawn numbers are: 4, 12, 14, 19, 38, 50 (6 numbers because some are having the same frequency)

    Other statistics possible
    – Numbers drawn the least
    – Last time a number was drawn

    Both of these statistics increase the chance these numbers are drawn in the next draw.

  2. Another smaller problem with these statistics is the fact that somewhere underway the euromillions system changed. Before there were only 9 stars, now there are 11 stars. To give a correct view for the stars, you should only account for the draws with the new system (the chance number 1-9 are drawn reduced when the new system came into place).

  3. Or you need a female colleague like I have whom is of the spiritual kind and can sense the winning numbers or sees them in dreams, which so far hasn’t won us any money playing together yet but well it’s as good a method as any :p

    • Well it’s pretty much impossible to calculate yourself into winning things like this, you can only start excluding what’s statistically improbable to happen. And even then, lotteries are just gambling games…

  4. Another fact is that neither Lottery has yet to repeat. So do not choose a number sequence that has already been drawn.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s