Looking for "Out of the Box" Thinkers

[Sp3cial_k_1975]

Hello All,
This is Kody, aka Sp3cial K. I have recently joined MRExcel in hopes to find methods to creating passages through excel to better my thoughts that run through my head. Some may think I'm crazy, but I truly believe that with the thoughts of others and myself, that a simple game can be cracked, leading us all to making a lot of money.

As I look at life, I know, just as any other smart person knows, life revolves around numeric patterns. And what I have seen by joining this site is that there are a lot of smart people out there. So, What I have decided to do is to write this as an invite to those interested. The game I play is Keno, it can be found in most states that carry lotto, not just at casinos. Keno is a numbers game where you pick 1-10 numbers of 80. There are 20 numbers drawn and if your numbers match, then you win depending on what sequence of numbers you choose.

Now, I have played every sequence there is. Here in Missouri, The winnings are as follows:

<tbody>
</tbody>

What I have found is your best chances to win, are simply picking two numbers. If two out of 20 numbers hit, you win 10/1 odds. So, what I am trying to find, is a formula in excel that we can use, to configure the next drawings to show us at least 2 numbers that will come in. This sounds easy I'm sure, I've been racking my brain trying different methods, count, sum, and even predict (which has slipped my mind of the formula name, but you take certain numbers in a row and it tells you what the next number should be) Anyway, Billions of people play the lottery, everyone is looking for that edge to make more money aside from their real-life job. I am looking for others interested in trying to devise a pattern or formula in excel that we can figure out the next drawing up to three drawings ahead. If interested, reply to this post, share the post and maybe with more minds then 1, we can find a solution.

Kody

 

[pleeseemailme]

If that is the case, then the opposite must also be true: Probability has no concept of future.

 

[auto.pilot]

The original poster wants to

figure out the next drawing up to three drawings ahead.

This is impossible, even if certain numbers have not been among the winners for a very long time.

Probability has no concept of history.

Well said!

 

[xenou]

That's an interesting thought about history/future. I think probability is concerned with future and past, but not in a precise way. That's why you can say that "if I flip this coin 1000 times I think it will come up heads at least once." That's because the probability is very high that this is the case. But even then it is not a certainty (though you may be willing to gamble quite a lot on the near-certainty). Likewise, looking back, you can say, if you have flipped that coin 1000 times I think you flipped a heads at least once. So we can make predictions about the past and the future. What is more relevant to this case however, is that we are saying "You have flipped the coin 1000 times and I think the next flip will be heads". We can also speak to the future probability here, and it is (assuming a fair flip) exactly 50%, which is same probability of every individual trial. In that sense, the coin doesn't have any sense of what it was on the last flip - so there is no memory on the part of the coin, which merely obeys the laws of physics, not the "laws" of probability.

 

[Sp3cial_k_1975]

I find all these comments, interesting, and I thank you all for your bits of information.. I do understand that keno is random, but it's also computer generated also right? So, in some format, there must be a sequence? If you look at each drawing, ex: Club Keno Drawings:: The Official Web Site of the Missouri Lottery
You can watch a drawing, live, one after the other, you will notice that each number drawn is within 10 of the last drawing. (What I mean is, look up drawing 1135952 you will see that the 1st ball was 71, 2nd ball was 9, 3rd ball was 33, then you go to the next draw (1135953) you will see that the 1st number was 65 (with-in 10 of 1st number drawn last draw), 2nd number was 10, 3rd number 41. 3rd drawing (1135954) 1st ball 61, 2nd ball 9, 3rd ball 29. From time to time these patterns change, but for the most part, all 20 numbers drawn are with-in the same pattern (with-in 10 numbers of each other from previous draws) So to me, it seems that if you can find where the numbers change, you can find how often they stay with-in the 10 digit sequence) Or, if say 6 of the 20 numbers happen to fall between a 20 number range, you would then have maybe 6 chances of picking the right 2 numbers for the next draw.

 

[gorem]

Hi Special K,

You note "I do understand that keno is random, but it's also computer generated also right? So, in some format, there must be a sequence?"

This is where your problem lies. Computers can certainly generate random numbers with no predictable pattern. See =RANDBETWEEN

 

[Sp3cial_k_1975]

Check this out.. I have formatted an excel sheet to where I put in the 20 numbers of a draw, it automatically pairs each number with all 190 possible 2-number combinations. Then I have set it up using =countif format to count each 2-way combination that has come across. Now, thinking that if you win, a 2 number pick, you win 10/1 odds. so I went back to drawing 1136000 and typed in the 20 numbers drawn, then I went 10 drawings later and did it again. I did this for 10 drawings (1136000,1136010, all the way to 1136090) The results shared this. In every 10 draws that end with 0, the number 80 has hit 60% of the time, the number 30 has hit 40% and the number 38 has hit 40%. Of those 3 numbers, 38-80 hit 4 times, 30-80 hit 4 times and 30-38 also hit 4x. 30-38-80 had hit 3 times out of the last 10 draws ending in 0

 

[shg]

In every 10 draws that end with 0, the number 80 has hit 60% of the time, the number 30 has hit 40% and the number 38 has hit 40%.

And you attribute this to some computerized affinity for this pattern?

 

[Sp3cial_k_1975]

not sure yet.. just saying.. Now I went the next 10 draws (1136100-1136190) all drawings ending in 0, 30-80 only hit once... but a new set came up being 24-50 hitting 50% of the last 10 draws. there were 7 2-combo numbers that hit 40% of the time. So now my thought is, ok, the 80 and 30/38 were played in that first 100 plus how ever many more before these draws, now, it's 24-50 and 12 being the strong numbers.. So if I started at the beginning, and went every 10 draws, that would maybe show a pattern right?

 

[Rick Rothstein]

Check this out.. I have formatted an excel sheet to where I put in the 20 numbers of a draw, it automatically pairs each number with all 190 possible 2-number combinations. Then I have set it up using =countif format to count each 2-way combination that has come across. Now, thinking that if you win, a 2 number pick, you win 10/1 odds. so I went back to drawing 1136000 and typed in the 20 numbers drawn, then I went 10 drawings later and did it again. I did this for 10 drawings (1136000,1136010, all the way to 1136090) The results shared this. In every 10 draws that end with 0, the number 80 has hit 60% of the time, the number 30 has hit 40% and the number 38 has hit 40%. Of those 3 numbers, 38-80 hit 4 times, 30-80 hit 4 times and 30-38 also hit 4x. 30-38-80 had hit 3 times out of the last 10 draws ending in 0

I know I am joining this discussion late, but I just wanted to say... the people who run these kinds of games of chance (whether it be individuals, organizations or governments) love people like you (those who think they found a "system" to beat the odds)... it is from them that they make all their money. It cannot be emphasize enough... whatever has happened in the past can have absolutely NO effect on any single current game... period... and any attempt to find such a system is just a waste of time. And another reason why such a system cannot exist... if it could, then with all the smart people schooled in math and statistics who have ever lived, or who are still alive, someone would have already found it and "broken the bank" so to speak, or bragged about it so that everyone knew about it, either way, the games would have had to close down because of it... since the games are still running, it must mean none of those smart people schooled in math and statistics has ever found such a system. Now, I don't know anything about you personally, but do you really think that you, using Excel and some past lottery results, will be able to find something that people schooled in such matters hasn't been able to do?

 

[shg]

It might be indicative of a pattern if there were some hidden underlying algorithm to the selection of numbers.

You either believe the number selections are random and uniform in distribution, or you don't (because it's crooked, or the random number generator has a flaw, or ...). Those are the only alternatives.

Also, if there were some faint pattern (you choose a reason), you would have to massively improve your odds to get past the fact that the house take is 50%. Hopefully some of that education money is being spent on math.