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


    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!

Register Yourself Login