# Lottery table question?

#### Orage

##### Board Regular
Hey guys! I'd like to get a formula that will give me to most commun number hit by the lottery and the PB numbers too, based on this table:
Book1
ABCD
1Draw DateNumbersPB
211/5/200602 19 35 24 2826
311/6/200640 17 21 07 4937
411/7/200641 14 13 29 161
511/8/200632 07 45 21 268
611/9/200619 10 48 03 2122
711/10/200622 31 03 07 142
811/11/200615 46 34 23 4035
911/12/200611 27 13 02 3123
1011/13/200618 09 14 47 4232
1111/14/200615 26 28 08 4336
1211/15/200618 21 28 41 043
1311/16/200644 41 46 35 0527
1411/17/200603 05 45 18 1320
1511/18/200623 11 12 17 107
1611/19/200628 16 35 34 0314
1711/20/200614 48 15 36 0917
1811/21/200627 14 06 04 056
1911/22/200604 09 27 07 326
2011/23/200618 04 30 37 0323
2111/24/200617 09 07 44 2025
2211/25/200616 09 06 28 3813
2311/26/200628 09 49 38 296
2411/27/200631 32 23 01 2633
2511/28/200607 23 15 28 3610
2611/29/200623 48 36 15 3112
2711/30/200613 36 48 07 1118
2812/1/200630 25 12 08 2120
Sheet1

My friends want to bet the most commun number to see if we hit the big one...

Thanks!

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### The Todal

##### Board Regular
You will need to use the Text to Columns feature to distribute the numbers in Column B into separate columns. Then, create a list of all the possible numbers (1-49). In the column adjacent to this list put the formula COUNTIF(A1), copy down. It will now be easy to see which number(s) has played most frequently.

I have to say that this is something of a fool's errand, however. The theory behind your scheme implies that which numbers come up is a non-random event. Lottery management takes great pains to insure randomness. To put it another way, selecting the lottery numbers is what is known in Probability Theory as Mutually Exclusive Events meaning a previous result has absolutely no influence over the next event.

#### The Todal

##### Board Regular
Further thoughts on this...

You could use Conditional Formatting to automatically highlight the most frequently played number. For each of the cells in your 1-49 list, use the MAX() function with Conditional Formatting so the most frequently played number stands out.

From a statistical point of view, one could make the argument that the number(s) most likely to play are actually the ones that have played the FEWEST times. If you assume total randomness of selection, if the population is large enough, each of the 49 numbers will play an equal number of times. Therefore, if some numbers have played far below an average number of times, they should be more likely to play soon.

I'm sure there are some statistical gurus on this site who could do a better job describing the statistics of lotteries than I.

#### Orage

##### Board Regular
I got it! Well, I'll pass these #s to them. Thank you very much

#### dcardno

##### Well-known Member
Therefore, if some numbers have played far below an average number of times, they should be more likely to play soon.
No. If the draws are random (and they are) then past draws will not affect the current (and future) probability of any given ball being drawn. One "edge" (if available) is to determine which numbers are least often selected by players, and play those numbers. They will be no more likely to win than any other combination, but if fewer other people hit on the same jackpot your average winnings will be higher than other players'.

This still won't mean that you will have a positive expectation going into the game - just that the distribution of expectations is uneven: players who play common numbers have a lower expection than average (although in aggregate, their expectation is the same) while players who play 'unpopular' numbers have a higher (but still negative) expectation - again, in aggregate, their expectation is the same. The difference in individual expectation is that the aggregate is shared among more player in the 'popular numbers' group than in the 'unpopular numbers' group, by definition.

Replies
4
Views
164
Replies
14
Views
460
Replies
2
Views
196
Replies
0
Views
71
Replies
15
Views
418

1,191,499
Messages
5,986,919
Members
440,065
Latest member
JCH136

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back