Welcome Guest
( Log In | Register )
The time is now 4:38 pm
You last visited January 17, 2017, 4:16 pm
All times shown are
Eastern Time (GMT-5:00)

Constant Cells

Published:

For those of you who like tracking patterns (as I like to do), here is one that rather gave me a surprise.

This would apply whether you play a P3, P4, or P5 game.  Of course you should use Excel or some similiar spreadsheet and be able to program VBA.  Life would be so much easier.

Somewhere within your history of past draws, select a number of cells at random.  I play the P5 game exclusively so I selected seven (7) cells.  The one criteria I insisted upon was that the seven cells had to be at least fifty draws back.   Then I set about writing code to determine how often a drawn number appears within one of the Constant Cells. 

I fully expected this pattern to result positive in about 10% of the cases.  Much to my surprise the answer was closer to 63%. 

I rearranged my Constant Cells several times over the last few days expecting to find one "set" that would result in a 10% positive hit.  That was not to be.  No matter where I put these seven cells, the answer I always achieved was 63% give or take a point or two.

Entry #20

Comments

1.
Comment by phileight - June 18, 2011, 6:22 pm
Interesting. I can't follow what you are doing. How do you define a constant cell? did you select 7 of the possible 35 # and check how many games 1 or more showed up?
2.
Comment by GASMETERGUY - June 18, 2011, 7:51 pm
Not quite.
I keep a running track of every draw in the Georgia P5 game. What I did was go back to the last fifty draws and, starting at that point and not going below that point, selected randomly seven cells. Each cell contains only one of the drawn numbers. I then programmed Excel to compare the drawn numbers with the numbers in the Constant Cells. What I wanted to know was how many times were one of the drawn numbers found in one of the Constant Cells.   The answer turned out to be 63% of the time, one of the drawn numbers could be found in one of the Constant Cells.
3.
CARBOBComment by CARBOB - September 6, 2011, 6:17 am
Are you willing to share the VB code? If not, will you post an image of the ws. Are the random cells on different rows of the 50 draws?

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.