keno most drawn numbers in 100 draws  using excel

lenny147
lenny147 used Ask the Experts™
on
keno most drawn numbers in 100 draws  using excel
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
Easy. 15, 23, 77, 59, 67 and 82

Or maybe you have a data sample of what the Keno numbers are (for those who do not have "Keno" (whatever that may be) where they live) and also supply the drawn numbers for the last 100 draws. Then we can give you a method to work it out.

cheers, teylyn
>Then we can give you a method to work it out.

No you can't as the numbers are random!

Patrick
Most Valuable Expert 2011
Awarded 2010

Commented:
"most drawn numbers" in the last 100 would be doable, just look at the data and do the statistics. Predicting the next 100 is the challenge :-))

Unfortunately, I don't know how many numbers are involved in Keno, nor what the range is.

But if I see the results of 100 Keno draws, I can work out what the most drawn numbers in these 100 draws are.

cheers, teylyn
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

>"most drawn numbers" in the last 100 would be doable, just look at the data and do the statistics. Predicting the next 100 is the challenge :-))

Oh come on Teylyn, if statistics could be used to improve the chances of winning the lottery they would be used by every intelligent person. As it is statistics are useless for predicting such things. Buy a crystal ball, find a witch or medicine man and you would be just as unsuccessful.

Keno usually involves 80 numbers. You can indeed work out the frequency of the drawn numbers but that willl have no influence whatsoever on what will be drawn the next time the machine is run.

Patrick
Most Valuable Expert 2011
Awarded 2010

Commented:
Patrick, thanks for helping me to understand Keno. Now I know it involves 80 numbers.

I know you cannot predict numbers for random number draws.

I do not read the asker's post as anything else than to analyse a batch of ALREADY DRAWN 100 Keno results and come up with the most frequently drawn numbers.

I do not see a question for any *prediction* of future numbers. It says "keno most drawn numbers in 100 draws".

As far as I am concerned, that means I see a batch of 100 Keno draw results that have already occurred. I can use Excel to work out  in retrospect what the most frequently drawn numbers in those PAST 100 draws were. That is how I understood the question.

Maybe I missed something? Please help me. As I said, I don't know Keno.

cheers, teylyn
Wikipedia says there are many different keno games with individual rules and win lines for each casino and some state run games that appear different again. It looks like drawing 20 from 80 is the most common, so are you looking for a way to analyse 100 rows of 20 randomly drawn numbers?
 
Teylyn,

We don't have Keno in the UK but we do have the National Lottery which uses 49 balls in a machine that is for all intents and purposes identical to the Keno machine. Keno is played in many places around the world so I'd guess that you need to identify a Californian Keno game as that appears to be the area in which the asker operates.

Patrick
>>> Easy. 15, 23, 77, 59, 67 and 82


Lol.



I'm sorry but without 13 you don't stand a chance :-)
No, you've got that wrong, it's 31 that you need. Apart from that, if you know what numbers haven't been used too often then you can assume that they stand a better chance of being picked in the future. Everyone knows that. It's only common sense. I just don't know why everyone doesn't use that strategy and win much more often.
OK... then I will REMOVE number 31...
It hasn't come up anymore...
That makes it MORE likely to come up in the future?
LOL!
Now that's unfair as I wanted to use the 31.
I have a serious problem knowing what to do with all my lottery winnings.
Most Valuable Expert 2013

Commented:
According to Patrick's link there are 20 numbers drawn out of 70 (it looks like) so if you have 100 draws worth of data in A1:T100 try this:
list the number 1 to 70 in V2:V71 then in W2 copied down use this formula
=COUNTIF(A$1:T$100,V2)
Now select V2:W100 and sort descending on column W, the number will now be listed in order of appearance
regards, barry
And that should improve your chances of winning no end. No wonder I have a problem knowing what to do with my lottery winnings.
>don't know why everyone doesn't use that strategy and win much more often.
I have been using that strategy since they started the UK lottery, it's the winning much more often part I haven't managed. I think some of those balls are just too big to fit through the selection tube.
20/70? Wiki said 20/80. It won't make any difference to the analysis in the question though, as long as there are still 20 picked in each draw they just need to ba ranked according to the number of appearances.
>I have been using that strategy since they started the UK lottery, it's the winning much more often part I haven't managed.

That's just not logical - it must work. Otherwise it would be unfair for some of the balls and we all know that would be one load of unhappy balls.
BTW - do you pick the 'lucky' balls because they have been picked more frequently or do you pick the 'unlucky' balls because it's their turn for a spot in the limelight?
I do two lines, one of each type. The one that comes in, well with a 3 match, is the 'most common' row. As they all have equal chances and some are lagging behind I have to keep playing the other one as well.

Author

Commented:
Hi Experts,
Attached is sample from lottery site. Okay what Excel file will tell me most pairs, triples etc occured?

Lets go team!
keno-sample.xlsx
Have a look on this sample of attached workboolk. Worksheet Analysis.
Keno.xls
lenny147,

Attached is the frequency summary of the numbers you have quoted in your workbook. Good luck.

Patrick
keno-frquencies-01.xls

Author

Commented:
Tested all the submitted solutions over several days and found calacuccia's method to be the best.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial