# Statistics Of Keno Drawings

• Hello,

Here in Michigan we have "Club Keno". There are 80 numbers on the board and they choose 20 numbers each dawing. There are approx 250 drawings a day. I can cut and paste the drawing numbers from each day and paste them into an excel worksheet. Each cell will contain 20 numbers. I would like to be able to search the 250 or so drawings each day and see how many times each number "1-80" has been drawn.

Example: each cell will contain 20 #'s
01 04 05 09 18 28 29 30 37 42 46 49 57 58 61 62 68 72 76 80

03 05 08 11 19 20 25 27 32 34 40 43 55 56 58 62 63 72 76 78

01 04 07 12 18 19 20 34 37 38 41 47 50 60 63 68 71 72 73 74

03 05 14 21 25 26 27 31 33 41 44 45 47 55 58 59 69 72 73 74

01 04 05 12 15 18 24 30 34 43 44 45 46 51 53 58 61 63 70 77

06 13 14 15 16 23 33 35 38 39 49 55 58 60 62 67 69 70 75 77

07 12 26 34 36 40 44 45 53 54 55 58 64 67 71 72 74 76 78 80

I'm looking to see how often "01" was drawn "02".."03" ect.

Thank you for your help

Tony

• Re: Sort The Daily Club Keno Drawings

Perfoming Text to Columns would be a good way to start, that would put each number in its own cell.
Then SUMIF and COUNTIF could be used to get the statistics you seek.

• Re: Statistics Of Keno Drawings

I copied your strings of numbers into cells A2:A8 of a new sheet.
I formatted cells B2 and B3 as Text, then entered 01 into B2 and 02 in B3
and autofilled down to 80. Then in cell C2 I entered this:
=SUMPRODUCT(--NOT(ISERROR(FIND(B2,\$A\$2:\$A\$8))))
I autofilled down C2 to C81. QED.
The only bit you have to change before you autofill C2 downwards is the
\$A\$2:\$A\$8
bit which should become
\$A\$2:\$A\$270
or similar, the 270 being a number beyond which there'll never be string of numbers in column A; if there's no data in any rows it doesn't matter, so the formula can remain the same as you replace the data in column A from day to day.
p45cal

• Re: Statistics Of Keno Drawings

Thank Very much

Both ideas were very helpful.

• Re: Statistics Of Keno Drawings

A typical expectation in Keno in US casinos is a payout of \$0.80 on each dollar bet -- not as bad as betting on a lottery, but much worse than, for example, roulette.

I have a spreadsheet you can plug in the payouts and it calculates the expectation, if you're interested.

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• Re: Statistics Of Keno Drawings

Yes very muck so...thank you

• Re: Statistics Of Keno Drawings

See attached.

## Files

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!