Welcome Guest
Log In | Register )
You last visited December 10, 2016, 11:02 pm
All times shown are
Eastern Time (GMT-5:00)

Excel formula

Topic closed. 5 replies. Last post 13 years ago by luckycat.

Page 1 of 1
PrintE-mailLink
SHTh's avatar - baby

United States
Member #1959
August 1, 2003
42 Posts
Offline
Posted: August 1, 2003, 5:07 am - IP Logged
Hi,

I've been lurking for a while and have been entertained & educated by the postings.


Please can someone help me with the following: I am looking for an Excel formula that will generate a list of all possible triple combinations of a 49 number draw.

 

Secondly if someone can provide a formula that would enable me to determine the frequency of repetitive triple combinations in my lottery data.


I have a lottery table with all lottery results in (Columns B:G), 300 rows.

 

I would appreciate any help you can give me.

 

SHT.
    Avatar
    New Member
    GA
    United States
    Member #1491
    May 11, 2003
    7 Posts
    Offline
    Posted: August 1, 2003, 10:04 pm - IP Logged

    Try the regression formula

      Cleveland,Oh
      United States
      Member #1856
      July 16, 2003
      531 Posts
      Offline
      Posted: August 2, 2003, 5:08 am - IP Logged

      A 45 sounds better!

        Pacific Northwest
        United States
        Member #1229
        March 6, 2003
        707 Posts
        Offline
        Posted: August 2, 2003, 12:34 pm - IP Logged

        MrSteel,

        So violent? Did you not win lately? Cheese and Crackers....

        SHT,

        The question is interesting, maybe you should repost it alos in the Jackpot Forum, in PICK 3 only PICK 3 lotteries are discussed.

        I assume you are looking for all different triple combinations (18424) from 1,2,3 to 47,48,49?

        I so I could send you a spreadsheet that calcutes those to inocrporate in your own spreadsheets. Of course once it is calculated it would be much faster to just copy the values in rather than the formulas. Now this is programmed in Excel, using Excel only and not any VB subroutines or such. Many Excel users do not have that installed anyhow and/or did not enable Macros for security reasons.

        If you like to have the entire list email me at cs@snohome.com with your email address and I can send it to you. No problem. No charge :)

        Starting from





        123
        124
        125
        126
        127
        128
        129
        1210
        1211
        1212
        1213
        1214
        1215
        1216
        1217
        1218
        1219
        1220
        1221



        .................

        Ending with





        434749
        434849
        444546
        444547
        444548
        444549
        444647
        444648
        444649
        444748
        444749
        444849
        454647
        454648
        454649
        454748
        454749
        454849
        464748
        464749
        464849
        474849



        Frequency of repetitive triple combinations...so you want to see how often the same triple combinations appear. Now you can certainly track that, by I am almost certain that you will not find very much new out of it.

        Using the hypergeometrical distribution the chances for repeating 3 numbers in a 6/49 game are about 1 in 56 cases, the same as the chances to hit three correct numbers. Or in percent in 0.01765 of the cases.

        I will add the forumala to the spreadsheet for you to look at.

        I hope this will help you.

        Good Luck,

        ME

          SHTh's avatar - baby

          United States
          Member #1959
          August 1, 2003
          42 Posts
          Offline
          Posted: August 3, 2003, 7:08 am - IP Logged

          Thank you for your responses so far.

          SHT

            luckycat's avatar - animaniacs24

            United States
            Member #1687
            June 16, 2003
            1047 Posts
            Offline
            Posted: August 3, 2003, 9:45 pm - IP Logged

             have u tried  loto/win dload???

            I think it there also.

             

                luckycat        >>>>>>>    purr-purr--purrfect