Missing digits in Lotto

[Bertil]

The Powerball Lotto has five double digit black numbers.
Count each digit and you'll notice that often four are missing.
It's easy to generate five pairs from all ten digits, such as
09-18-27-36-45.
How many combinations with all ten digits would a complete set
of 5006386 have in the 59/5 lotto?
There could be as many as seven missing digits, such as in 01-10-11-12-20
Can the frequencies of sets with 0,1,2,3,4,5,6 and 7 missing digits be
determined after all possible combinations have been drawn?

Bertil

 

[PAB]

Hi Bertil,

The Powerball Lotto has five double digit black numbers.
Count each digit and you'll notice that often four are missing.
It's easy to generate five pairs from all ten digits, such as 09-18-27-36-45.
How many combinations with all ten digits would a complete set of 5,006,386 have in the 59/5 Lotto?

As you know, I live in the UK so I don't actually do the Powerball Lotto.
If you wanted to know how many combinations there are with ALL 10 Digits being different from the numbers from 1-59, the answer is...

10 Seperate Digits = 2,760 Combinations Which = 0.05513 Percent.

If this is not exactly what you are after then please let me know with a bit more of an explanation and I will try and work it out for you!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Bertil]

Missing digits

That was quick. How did you calculate it?
Would it be equally ease to calculate 9, 8, 7, 6, 5, 4, separate digits, and
determine how many there would be with only 3 separate digits, as I listed?

Bertil

 

[PAB]

Hi Bertil,

Would it be equally easy to calculate 9, 8, 7, 6, 5, 4, separate digits, and determine how many there would be with only 3 seperate digits?

Here is the full list for the C(59,5) which = 5,006,386 combinations.

3 Seperate Digits = 580 Combinations Which = 0.01159 Percent.
4 Seperate Digits = 45,080 Combinations Which = 0.90045 Percent.
5 Seperate Digits = 517,620 Combinations Which = 10.33919 Percent.
6 Seperate Digits = 1,683,902 Combinations Which = 33.63508 Percent.
7 Seperate Digits = 1,895,804 Combinations Which = 37.86772 Percent.
8 Seperate Digits = 762,480 Combinations Which = 15.23015 Percent.
9 Seperate Digits = 98,160 Combinations Which = 1.96070 Percent.
10 Seperate Digits = 2,760 Combinations Which = 0.05513 Percent.
Total = 5,006,386 Combinations Which = 100.00000 Percent.

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Bertil]

Missing Lotto Digits

Thanks PAB. Your calculations are fantastic.
I asked Colin Fairbrother to do it, but he was unable,
and responded with insults and other abuse.
His one man lottery post is waste if time to go to.

Bertil

 

[jack]

Hello, bertil, playing the powerball, I have the perfect matrix of initial digit 0-5
* Groups with 252 hits in 100% in any lottery that will come the bonus ball out of this study is Ametade project are you only have to worry about the endings or last digit 0-9
* Example 47 are concerned with the digit 7 for the front already solved 100%, calm
* What you have to study are the last digit, you want to see the array to take any questions?

 

[PAB]

Hi Bertil,

Your calculations are fantastic.
I asked Colin Fairbrother to do it, but he was unable, and responded with insults and other abuse.

You're welcome!
I hope you can derive something useful from the data.

In your initial post you said...

Count each digit and you'll notice that often four are missing.
There could be as many as seven missing digits.

On this basis you would be covering 2,247,182 combinations from the total combinations of 5,006,386 which equates to 44.88631
percent.

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Bertil]

Missing Lotto digits

If you calculate the 10-log for each frequency and plot them on a graph
paper, you'll get a nice upside-down curve and can calculate the mean
missing digits as 4.5.

I wonder if one might be able to search the total list of draws at the PB
headquarters and show how the frequencies now compare with theory?

Bertil

 

[Bertil]

Missing digits in lotto

Correction. The graph is an inverted cup and the mean will be 6.45

Bertil

 

[PAB]

Hi Bertil,

I wonder if one might be able to search the total list of draws at the PB headquarters and show how the frequencies now compare with theory?

If you could provide a link where the complete history can be downloaded from, or alternatively upload your SpreadSheet with ALL the draws, I could calculate that data for you!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Bertil]

Missing digits in PowerBall

If you Google "PowerBall Numbers" you get the most recent draws but
you can also find "Historical Numbers" at that site.
But there is a complication. It looks like the Multi State Lottery Com. lists
only single digit numbers ,D, not OD numbers.
The current version of the game started on 1/18/12 and covers only 150 draws. But that's what I would like you to test to see how the data differ
from the theoretical ones, you have calculated.
My computer skills are rudimentary at best, so I can't do any programming.
I'm a bit surprised that OD numbers are not drawn. It might be to avoid
mistaking 01 for 10. With less paint on nine balls one might think this
could influence the weight and thus slightly increase the frequency of draws.
I must trust that MSLC has tested for this problem.
There are many other web sites listing the results and I often go to "Lottery Post", where the digit numbers are listed as OD.

Bertil

 

[PAB]

Hi Bertil,

If you Google "PowerBall Numbers" you get the most recent draws but you can also find "Historical Numbers" at that site.
The current version of the game started on 1/18/12 and covers only 150 draws. But that's what I would like you to test to see how the data differ from the theoretical ones, you have calculated.

Unfortunateley that isn't very helpful for me !

There appears to be many different sites relating to different PowerBall Lotto's.
Please can you give me the site that you use by posting the Website link or at least the last three draws numbers so I can search and find the correct Lotto before I do any work on it please.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Bertil]

Missing digits in powerBall

I just discovered that there is a line below the three most recent draws
reading "Click here for the winning numbers in plain-text format".
It lists the numbers in the order drawn and shows digits as OD.
Might this help?

Bertil

 

[PAB]

Hi Bertil,

I just discovered that there is a line below the three most recent draws reading "Click here for the winning numbers in plain-text format".
It lists the numbers in the order drawn and shows digits as OD.

If this is the site...

http://www.powerball.com/powerball/pb_nbr_history.asp

...then when I click the "Click here for the winning numbers in plain-text format." it gives me draws going back to 11/01/1997 which is NOT the 150 draws you are talking about.
Please post the link to the Website!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Bertil]

Missing Digits in PowerBall

Let me be more specific. At the PowerBall site you need to look at the listing on the left side and click on "FAQ/ History/ News" to get to the 'Historical
Winning Numbers'. Click on The 2nd fine line below the three most recent
draws will get you to all numbers drawn. Go back to Jan 18,2012.

Bertil

 

[Bertil]

issing Digits in PowerBall

From what little I know about using data from another site, I think you can
blue-mark the time period from 6/22/13 down to 1/18/12 and transfere them to a spread sheet, where I would hope you would be able to sort each
line in order, if you care. Maybe then you could count the number of
missing digits per line. I seem to remember my son doing something like that yeas ago, but he is now in India and of no help.
If this does not work, I don't know what site to use instead.

Bertil

 

[PAB]

Hi Bertil,

At the PowerBall site you need to look at the listing on the left side and click on "FAQ/ History/ News" to get to the 'Historical Winning Numbers'. Click on The 2nd fine line below the three most recent draws will get you to all numbers drawn. Go back to Jan 18,2012.

Success !!!

Here is a file that has ALL 150 draws since the format changed.
It includes the Unique Digits for EACH DRAW and a summary table giving the Expected Results, Actual Results & Difference Between The Two.

http://www.mediafire.com/download/9d876ppcgd7y7pr/MediaFire_-_PowerBall_Unique_Digits.xlsm

I hope this helps!
Please let me know what you think.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[PAB]

Hi Bertil,

From what little I know about using data from another site, I think you can blue-mark the time period from 6/22/13 down to 1/18/12 and transfer them to a SpreadSheet, where I would hope you would be able to sort each line in order, if you care. Maybe then you could count the number of missing digits per line. I seem to remember my son doing something like that yeas ago, but he is now in India and of no help.
If this does not work, I don't know what site to use instead.

For your information, and anyone else who is interested in how they can use data from a Website in their SpreadSheet, here is a quick reference on how to achieve this:-

(1) Highlight ALL the data that you want to copy into your SpreadSheet and press Ctrl-C, this copies all the data to the clipboard.
(2) Goto your SpreadSheet and select cell A1 for example.
(3) Right-Click your mouse and click Paste Special... and then click Text.
(4) Highlight the whole of the column that the data is now in.
(5) Click the Data Tab at the top of your screen.
(6) Click Text to Columns.
(7) Click Delimited in this case and click Next.
(8) Click the Space box which will put a TICK in it and click Next.
(9) Click Finish.

Now you have the data in your SpreadSheet and can do as you so wish with it!

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[Icewynd]

PAB,

Hope you don't mind, but I thought your previous post was information that could be very useful to a wide audience, so I copied it into its own post on the Excel & Macros forum. That way, it will be available to a wider audience.

 

[Icewynd]

Changed my mind, I think YOU should cut and paste into its own thread on Excel & Macros -- that way there will be no mistaking the authorship of this valuable information.

FYI -- I had planned to entitle the post "Lottery 101 - Importing Data Into Your Spreadsheet".

Sorry, Bertil. Didn't mean to hijack your thread!