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


    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]

Participate now!

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