We help IT Professionals succeed at work.

keno most drawn numbers in 100 draws  using excel

on
8,548 Views
keno most drawn numbers in 100 draws  using excel
Comment
Watch Question

View Solution Only

CERTIFIED EXPERT
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

Commented:
>Then we can give you a method to work it out.

No you can't as the numbers are random!

Patrick
CERTIFIED EXPERT
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

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 :-))

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
CERTIFIED EXPERT
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
CERTIFIED EXPERT

Commented:
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?

Commented:
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

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

Lol.

I'm sorry but without 13 you don't stand a chance :-)

Commented:
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.
CERTIFIED EXPERT

Commented:
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!

Commented:
Now that's unfair as I wanted to use the 31.

Commented:
I have a serious problem knowing what to do with all my lottery winnings.
CERTIFIED EXPERT
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

Commented:
And that should improve your chances of winning no end. No wonder I have a problem knowing what to do with my lottery winnings.
CERTIFIED EXPERT

Commented:
>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.

Commented:
>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.

Commented:
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?
CERTIFIED EXPERT

Commented:
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.

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
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)

Commented:
lenny147,

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

Patrick
keno-frquencies-01.xls

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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Connect with Certified Experts to gain insight and support on specific technology challenges including:

• Troubleshooting
• Research
• Professional Opinions
Unlock the solution to this question.