Looking for "Out of the Box" Thinkers

Sp3cial_k_1975

New Member
Joined
Dec 27, 2013
Messages
26
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:

4spot.gif
3spot.gif
2spot.gif
1spot.gif

<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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You might want to read Keno - Wizard of Odds, particularly this:

If you must play keno, the only skill is choosing where to play to play and then how many numbers to choose. It makes no difference which numbers you actually choose. Contrary to popular myth, legitimate keno games, like those in Las Vegas, are fair and every ball has a 1 in 80 chance of being drawn each game.
 
Upvote 0
shg - you are right, I was going to say "there are no trends in a sequence of truly random numbers"

I once wrote a macro to enter 1 million goes in the UK lottery (chance of winning jackpot 1 in 17 million)

I hit the jackpot in week 23

And just think how you would do that in real life - time to scan a card with 7 combinations on it =4 seconds so 190 hours plus paying time
 
Upvote 0
If every ball has the same chance each game, I would lean towards picking the numbers which have the lowest frequency.
 
Upvote 0
If every ball has the same chance each game, I would lean towards picking the numbers which have the lowest frequency.
So if you flip 10 heads in a row on a fair coin, tails is more likely on the next toss? That would indeed be spooky action at a distance.
 
Upvote 0
Code:
  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.

This can not be done using Excel (or any other method).

jim
 
Upvote 0
"If every ball has the same chance each game, I would lean towards picking the numbers which have the lowest frequency."

Every time I read a comment like that it sends a small shiver down my mathematical spine... </SPAN>
 
Upvote 0
Why?

Surely over the course of time, all things being equal, the number of times each ball is drawn will level out?
 
Upvote 0
Why?

Surely over the course of time, all things being equal, the number of times each ball is drawn will level out?

This is true by the "large of large numbers". But it is only true over time with many draws in a fair game. It says nothing about the next draw. Somewhat like oldbrewers previous post, it is not practical in a game of chance to be able to play the large number of games required to see predicted values materialize in real life - and in any case, if you did, you'd find the "state" or the "casino" would have the edge in total dollars paid in vs. paid out.
 
Upvote 0
"Surely over the course of time, all things being equal, the number of times each ball is drawn will level out?"

Yes, but in the same vein as shg's example, that in no way means that, at any given time, the chance of one ball being drawn is greater than that for any other ball.

Probability has no concept of history.

Regards
 
Upvote 0

Forum statistics

Threads
1,214,584
Messages
6,120,387
Members
448,957
Latest member
Hat4Life

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top