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

Grouping Companion Pairs, Triads, Quads and Quints

Topic closed. 30 replies. Last post 1 year ago by dr san.

Page 1 of 3
PrintE-mailLink
Avatar
bgonçalves
Brasil
Member #92564
June 9, 2010
2124 Posts
Offline
Posted: September 6, 2015, 8:05 am - IP Logged

I need to find a way to group test results together. The best way to explain what I need is to use the lottery as an example.
Each drawing date six numbers are chosen. I want to know how many times unique pairs (2 numbers), triads (3 numbers), quads (4 numbers), quints (5 numbers) have occurred.

9/12/2001 16-24-30-31-36-49
9/15/2001 7-16-17-28-43-45
9/19/2001 8-12-13-31-42-46
9/22/2001 19-28-31-41-44-47
9/26/2001 1-2-11-14-42-44
9/29/2001 2-24-27-38-40-41
10/3/2001 6-14-28-37-39-48
10/6/2001 5-17-20-34-41-47
10/10/2001 6-10-11-29-34-49
10/13/2001 7-11-12-28-45-46
10/17/2001 5-9-13-14-15-22
10/20/2001 16-18-19-38-41-49
10/24/2001 3-4-12-16-20-23
10/27/2001 3-8-11-17-27-28
10/31/2001 2-5-15-19-41-43
11/3/2001 7-10-35-37-42-45
11/7/2001 7-14-19-20-24-45
11/10/2001 1-7-35-40-43-46
11/14/2001 7-10-15-22-23-36
11/17/2001 13-20-28-34-35-46
11/21/2001 6-26-28-31-34-46
11/24/2001 3-13-14-29-37-45
11/28/2001 22-23-27-31-42-44
12/1/2001 5-6-9-19-32-47
12/5/2001 11-20-26-30-34-36
12/8/2001 5-18-27-30-34-45
12/12/2001 2-14-23-32-40-45
12/15/2001 4-7-13-27-37-49
12/19/2001 2-5-27-40-46-49
12/22/2001 1-19-31-35-36-41

Results Needed:


HITS COMPANION PAIRS
4......07-45, 19-41
3......02-40, 14-45, 20-34, 28-46
2......01-35, 02-05, 02-14, 02-27, 02-41, 05-09, 05-15, 05-19, 05-27,
05-34, 05-41, 05-47, 06-28, 06-34, 07-10, 07-28, 07-35, 07-37,
07-43, 07-46, 11-28, 11-34, 12-46, 13-14, 13-37, 13-46, 14-37,
15-22, 16-49, 17-28, 19-31, 19-47, 22-23, 26-34, 27-40, 27-49,
28-31, 28-34, 28-45, 30-34, 30-36, 31-36, 31-41, 31-42, 31-44,
31-46, 34-46, 35-46, 37-45,

HITS COMPANION TRIADS
2......02-27-40, 07-28-45, 19-31-41, 28-34-46

I need to find a way to group test results together. The best way to explain what I need is to use the lottery as an example.
Each drawing date six numbers are chosen. I want to know how many times unique pairs (2 numbers), triads (3 numbers), quads (4 numbers), quints (5 numbers) have occurred.

9/12/2001 16-24-30-31-36-49
9/15/2001 7-16-17-28-43-45
9/19/2001 8-12-13-31-42-46
9/22/2001 19-28-31-41-44-47
9/26/2001 1-2-11-14-42-44
9/29/2001 2-24-27-38-40-41
10/3/2001 6-14-28-37-39-48
10/6/2001 5-17-20-34-41-47
10/10/2001 6-10-11-29-34-49
10/13/2001 7-11-12-28-45-46
10/17/2001 5-9-13-14-15-22
10/20/2001 16-18-19-38-41-49
10/24/2001 3-4-12-16-20-23
10/27/2001 3-8-11-17-27-28
10/31/2001 2-5-15-19-41-43
11/3/2001 7-10-35-37-42-45
11/7/2001 7-14-19-20-24-45
11/10/2001 1-7-35-40-43-46
11/14/2001 7-10-15-22-23-36
11/17/2001 13-20-28-34-35-46
11/21/2001 6-26-28-31-34-46
11/24/2001 3-13-14-29-37-45
11/28/2001 22-23-27-31-42-44
12/1/2001 5-6-9-19-32-47
12/5/2001 11-20-26-30-34-36
12/8/2001 5-18-27-30-34-45
12/12/2001 2-14-23-32-40-45
12/15/2001 4-7-13-27-37-49
12/19/2001 2-5-27-40-46-49
12/22/2001 1-19-31-35-36-41

Results Needed:


HITS COMPANION PAIRS
4......07-45, 19-41
3......02-40, 14-45, 20-34, 28-46
2......01-35, 02-05, 02-14, 02-27, 02-41, 05-09, 05-15, 05-19, 05-27,
05-34, 05-41, 05-47, 06-28, 06-34, 07-10, 07-28, 07-35, 07-37,
07-43, 07-46, 11-28, 11-34, 12-46, 13-14, 13-37, 13-46, 14-37,
15-22, 16-49, 17-28, 19-31, 19-47, 22-23, 26-34, 27-40, 27-49,
28-31, 28-34, 28-45, 30-34, 30-36, 31-36, 31-41, 31-42, 31-44,
31-46, 34-46, 35-46, 37-45,

HITS COMPANION TRIADS
2......02-27-40, 07-28-45, 19-31-41, 28-34-46

    Avatar
    bgonçalves
    Brasil
    Member #92564
    June 9, 2010
    2124 Posts
    Offline
    Posted: September 6, 2015, 8:08 am - IP Logged
    also 60/6
    you can do, please !!! the lottery 60/6 all the same so have change
    * For 60/6 (mega sena) macro in a planilia then I'm updating the sweepstakes
    17 19 33 35 39 52
    03 23 26 35 39 49
    01 07 11 32 51 59
    25 27 29 37 50 51
    31 34 36 48 12 56
    16 20 27 36 07 52
    29 32 38 45 17 50
    19 30 35 42 07 47
    07 21 28 56 58 59
    26 38 39 45 22 50
    12 19 29 50 02 59
    10 16 23 27 03 29
    02 08 24 36 51 52
    20 35 40 53 16 60
    25 36 41 42 02 53
    02 09 16 37 44 58
    30 31 32 47 04 53
    22 31 34 44 01 54
    18 23 31 39 49 57
    12 19 33 36 04 38
    09 23 39 41 49 58
    27 30 46 52 14 60
    27 33 37 39 58 60
    18 26 30 31 16 34
    10 42 49 54 03 57
      RL-RANDOMLOGIC's avatar - usafce

      United States
      Member #59354
      March 13, 2008
      3972 Posts
      Offline
      Posted: September 12, 2015, 8:48 am - IP Logged

      dr san

      One can get a quick estimate using the data below but if your wanting to calculate the totals

      within a games history then it could take some time to generate a list.  For instance to find out

      the number of quads we need to generate all 487645 quads then check each one against every

      line in your database.  To code it would be easy but the run time would be very long. 

       

      Lets say that you have a 500 game history.  The estimated hits for each pair would be

      ((500*15)/1770)=4.23.  Counting trays and quads would not produce any useful data

      as most would not hit more than a couple times if at all.   

       

      There are     1770 pairs 60 numbers

      There are   34220 trays in 60 numbers

      There are 487635 quads in 60 numbers

       

      In each 6 number set there are 15 pairs 

      in each 6 number set there are  20 trays

      is each 6 number set there are  15 quads

      RL

      Working on my Ph.D.  "University of hard Knocks"

      I will consider the opinion that my winnings are a product of chance if you are willing to consider

      they are not.  Many great discoveries come while searching for something else

      USAF https://en.wikipedia.org/wiki/Prime_Base_Engineer_Emergency_Force

        US Flag Trump / 2016 & 2020  

        Avatar
        bgonçalves
        Brasil
        Member #92564
        June 9, 2010
        2124 Posts
        Offline
        Posted: September 12, 2015, 3:41 pm - IP Logged

        Hello. Very good job, rl, conglatulation in trios have
        34.220, how many trios have no repeating digit
          Example = = 06,25,48 have here six distinct digits
        0,6,2,5,4,8, 4-pair and 2 odd, the default leaving without repeating digits in threes
        In 60/6 is 83% always leaves a trio without repetition, this trio will be fixed,
          And the other 3 numbers missing at least one digit base trio gravitate or repeats
          The trio.
          test = 1740 = 10 15 25 38 47 57                     10 25 38 = trio, the other three numbers 15,47,57
          The three digits = 3,1,5 trio repeat the base or reference 10,25,38
        Rl order to have a trio or crack base to secure it can use the pattern of non repetition of digit each other. You understand? Can you do? thank you

          Avatar
          bgonçalves
          Brasil
          Member #92564
          June 9, 2010
          2124 Posts
          Offline
          Posted: September 12, 2015, 3:50 pm - IP Logged

          Hello separate from 34,220 trios without digits pretiçao is easy.
            What more difficult, it is to put together trios of starting the otros three numbers where has at least one trio digit without repeating type in the base set or fixed. By urge is good locate this trio
            The 20 positions = 1,2,3 1,2,4 4,5,6 ....... until = 20 positions
            Example the trio without repetiaço of digit, have positions in 1st 4th 6th trio 02,34 = 58,
          Position 1,4,6 = 02,34,58 the other three number STERA in positions 2nd 3rd 5th
            Example knowing that the 2nd place going 02-35 and and will be tera'um digit base trio

            garyo1954's avatar - garyo
            Dallas, Texas
            United States
            Member #4549
            May 2, 2004
            1718 Posts
            Online
            Posted: September 12, 2015, 8:44 pm - IP Logged

            I need to find a way to group test results together. The best way to explain what I need is to use the lottery as an example.
            Each drawing date six numbers are chosen. I want to know how many times unique pairs (2 numbers), triads (3 numbers), quads (4 numbers), quints (5 numbers) have occurred.

            9/12/2001 16-24-30-31-36-49
            9/15/2001 7-16-17-28-43-45
            9/19/2001 8-12-13-31-42-46
            9/22/2001 19-28-31-41-44-47
            9/26/2001 1-2-11-14-42-44
            9/29/2001 2-24-27-38-40-41
            10/3/2001 6-14-28-37-39-48
            10/6/2001 5-17-20-34-41-47
            10/10/2001 6-10-11-29-34-49
            10/13/2001 7-11-12-28-45-46
            10/17/2001 5-9-13-14-15-22
            10/20/2001 16-18-19-38-41-49
            10/24/2001 3-4-12-16-20-23
            10/27/2001 3-8-11-17-27-28
            10/31/2001 2-5-15-19-41-43
            11/3/2001 7-10-35-37-42-45
            11/7/2001 7-14-19-20-24-45
            11/10/2001 1-7-35-40-43-46
            11/14/2001 7-10-15-22-23-36
            11/17/2001 13-20-28-34-35-46
            11/21/2001 6-26-28-31-34-46
            11/24/2001 3-13-14-29-37-45
            11/28/2001 22-23-27-31-42-44
            12/1/2001 5-6-9-19-32-47
            12/5/2001 11-20-26-30-34-36
            12/8/2001 5-18-27-30-34-45
            12/12/2001 2-14-23-32-40-45
            12/15/2001 4-7-13-27-37-49
            12/19/2001 2-5-27-40-46-49
            12/22/2001 1-19-31-35-36-41

            Results Needed:


            HITS COMPANION PAIRS
            4......07-45, 19-41
            3......02-40, 14-45, 20-34, 28-46
            2......01-35, 02-05, 02-14, 02-27, 02-41, 05-09, 05-15, 05-19, 05-27,
            05-34, 05-41, 05-47, 06-28, 06-34, 07-10, 07-28, 07-35, 07-37,
            07-43, 07-46, 11-28, 11-34, 12-46, 13-14, 13-37, 13-46, 14-37,
            15-22, 16-49, 17-28, 19-31, 19-47, 22-23, 26-34, 27-40, 27-49,
            28-31, 28-34, 28-45, 30-34, 30-36, 31-36, 31-41, 31-42, 31-44,
            31-46, 34-46, 35-46, 37-45,

            HITS COMPANION TRIADS
            2......02-27-40, 07-28-45, 19-31-41, 28-34-46

            I need to find a way to group test results together. The best way to explain what I need is to use the lottery as an example.
            Each drawing date six numbers are chosen. I want to know how many times unique pairs (2 numbers), triads (3 numbers), quads (4 numbers), quints (5 numbers) have occurred.

            9/12/2001 16-24-30-31-36-49
            9/15/2001 7-16-17-28-43-45
            9/19/2001 8-12-13-31-42-46
            9/22/2001 19-28-31-41-44-47
            9/26/2001 1-2-11-14-42-44
            9/29/2001 2-24-27-38-40-41
            10/3/2001 6-14-28-37-39-48
            10/6/2001 5-17-20-34-41-47
            10/10/2001 6-10-11-29-34-49
            10/13/2001 7-11-12-28-45-46
            10/17/2001 5-9-13-14-15-22
            10/20/2001 16-18-19-38-41-49
            10/24/2001 3-4-12-16-20-23
            10/27/2001 3-8-11-17-27-28
            10/31/2001 2-5-15-19-41-43
            11/3/2001 7-10-35-37-42-45
            11/7/2001 7-14-19-20-24-45
            11/10/2001 1-7-35-40-43-46
            11/14/2001 7-10-15-22-23-36
            11/17/2001 13-20-28-34-35-46
            11/21/2001 6-26-28-31-34-46
            11/24/2001 3-13-14-29-37-45
            11/28/2001 22-23-27-31-42-44
            12/1/2001 5-6-9-19-32-47
            12/5/2001 11-20-26-30-34-36
            12/8/2001 5-18-27-30-34-45
            12/12/2001 2-14-23-32-40-45
            12/15/2001 4-7-13-27-37-49
            12/19/2001 2-5-27-40-46-49
            12/22/2001 1-19-31-35-36-41

            Results Needed:


            HITS COMPANION PAIRS
            4......07-45, 19-41
            3......02-40, 14-45, 20-34, 28-46
            2......01-35, 02-05, 02-14, 02-27, 02-41, 05-09, 05-15, 05-19, 05-27,
            05-34, 05-41, 05-47, 06-28, 06-34, 07-10, 07-28, 07-35, 07-37,
            07-43, 07-46, 11-28, 11-34, 12-46, 13-14, 13-37, 13-46, 14-37,
            15-22, 16-49, 17-28, 19-31, 19-47, 22-23, 26-34, 27-40, 27-49,
            28-31, 28-34, 28-45, 30-34, 30-36, 31-36, 31-41, 31-42, 31-44,
            31-46, 34-46, 35-46, 37-45,

            HITS COMPANION TRIADS
            2......02-27-40, 07-28-45, 19-31-41, 28-34-46

            It would be easier if we knew how many numbers we were dealing with, how large the group is, and how the OP wants the grouping done.

            (I'm assuming since the request was written twice in the same OP, you copied and pasted it. Why else would you write the same thing verbatim in one post?)

            My greatest accomplishment is teaching cats about Vienna Sausage. When I need a friend, all I need do is walk outside, pop open a can, and every little critter in the neighborhood drops by to say "Hi!"

              Avatar
              bgonçalves
              Brasil
              Member #92564
              June 9, 2010
              2124 Posts
              Offline
              Posted: September 12, 2015, 10:20 pm - IP Logged

              Hello, I copied the translator because the google takes to join the forum found what he had not come from the 1st try, you can delete the duplicas? Garyo, the BJECTIVE is see I type, number and diplas trio and quartets from a 60/6 lottery or similar need to establish a set example = 02,15,38 does not have to have repeating digits 6 digits distinct = 0,1,2,3 5.8

                garyo1954's avatar - garyo
                Dallas, Texas
                United States
                Member #4549
                May 2, 2004
                1718 Posts
                Online
                Posted: September 13, 2015, 12:37 am - IP Logged

                Hello, I copied the translator because the google takes to join the forum found what he had not come from the 1st try, you can delete the duplicas? Garyo, the BJECTIVE is see I type, number and diplas trio and quartets from a 60/6 lottery or similar need to establish a set example = 02,15,38 does not have to have repeating digits 6 digits distinct = 0,1,2,3 5.8

                That's not the stated objective in the first post at all. The first post wants to use it for grouping test scores.

                The OBJECTIVE stated in the OP is to put the pairs, triples, quads, and quints in groups. It's not to delete anything.

                I wrote the program for Cash5 to find every pair and every triple, get total counts and hit counts by position for the entire matrix. 80% of what it would take to do what the OP states is already done.

                Do you want to know how much time I spent on that program? 18 hours.

                Do you remember what you said? "Great. Now do this."

                I didn't finish reading. I closed the thread realizing you were wasting my time.

                And you'd waste anybody's time who started this 6/49 or 6/60 and wouldn't care one bit.

                If the original poster would like to sign up here and post exactly what they need or want, I'll see if I can do it. But I'm wasting time modifying a program to work on a 6/49 and then have you add more and more and more......and eventually want it done for a 6/60 as well.

                Ain't happening. You done wore out all my goodwill.

                My greatest accomplishment is teaching cats about Vienna Sausage. When I need a friend, all I need do is walk outside, pop open a can, and every little critter in the neighborhood drops by to say "Hi!"

                  Avatar
                  bgonçalves
                  Brasil
                  Member #92564
                  June 9, 2010
                  2124 Posts
                  Offline
                  Posted: September 13, 2015, 8:33 am - IP Logged

                  That's not the stated objective in the first post at all. The first post wants to use it for grouping test scores.

                  The OBJECTIVE stated in the OP is to put the pairs, triples, quads, and quints in groups. It's not to delete anything.

                  I wrote the program for Cash5 to find every pair and every triple, get total counts and hit counts by position for the entire matrix. 80% of what it would take to do what the OP states is already done.

                  Do you want to know how much time I spent on that program? 18 hours.

                  Do you remember what you said? "Great. Now do this."

                  I didn't finish reading. I closed the thread realizing you were wasting my time.

                  And you'd waste anybody's time who started this 6/49 or 6/60 and wouldn't care one bit.

                  If the original poster would like to sign up here and post exactly what they need or want, I'll see if I can do it. But I'm wasting time modifying a program to work on a 6/49 and then have you add more and more and more......and eventually want it done for a 6/60 as well.

                  Ain't happening. You done wore out all my goodwill.

                  Hello, garyo excel is very limited for that you have to use the delfi, it is much faster to simulate situations and easy probalidades tests, excel does not serve takes a long Doing so twos and threes, is to divide the enemy, ára the enfrequecer and attack by columns (positions) look at the example of crack without repeating digits in 83% at 60/6, can be used to set, for example in the last set or trio has the digits 1,5,8,0,4,9 , the last to the next will only use a maximum of 2.3, digits others are different, so have a base to assemble the trio or crack of reference. Standing use as fixed, is this
                  Or I can use double is trios each of the past sweepstakes is to combine

                    Avatar
                    bgonçalves
                    Brasil
                    Member #92564
                    June 9, 2010
                    2124 Posts
                    Offline
                    Posted: September 13, 2015, 10:06 am - IP Logged

                    Hello garyo, how we can use the table of the 64 standards of the genetic code to decobrirtrincas a lottery 49/6 or 60/6? It has numbers that almost numca combines
                      The crack = then the repetition of some positions in the array is the secret of odds

                      garyo1954's avatar - garyo
                      Dallas, Texas
                      United States
                      Member #4549
                      May 2, 2004
                      1718 Posts
                      Online
                      Posted: September 13, 2015, 10:23 am - IP Logged

                      Hello, garyo excel is very limited for that you have to use the delfi, it is much faster to simulate situations and easy probalidades tests, excel does not serve takes a long Doing so twos and threes, is to divide the enemy, ára the enfrequecer and attack by columns (positions) look at the example of crack without repeating digits in 83% at 60/6, can be used to set, for example in the last set or trio has the digits 1,5,8,0,4,9 , the last to the next will only use a maximum of 2.3, digits others are different, so have a base to assemble the trio or crack of reference. Standing use as fixed, is this
                      Or I can use double is trios each of the past sweepstakes is to combine

                      So now you're an Excel and Delphi wizard?

                      Why haven't you done it already?

                      My greatest accomplishment is teaching cats about Vienna Sausage. When I need a friend, all I need do is walk outside, pop open a can, and every little critter in the neighborhood drops by to say "Hi!"

                        Avatar
                        bgonçalves
                        Brasil
                        Member #92564
                        June 9, 2010
                        2124 Posts
                        Offline
                        Posted: September 13, 2015, 10:26 am - IP Logged

                        hello RL , GARYO..

                        LINK=http://probability.infarom.ro/9789731991115sample.pdf

                          Avatar
                          bgonçalves
                          Brasil
                          Member #92564
                          June 9, 2010
                          2124 Posts
                          Offline
                          Posted: September 13, 2015, 10:28 am - IP Logged

                          GARYo ONLY'M TALKING TO MANY OF PROGRAMMING LANGUAGE faster EXAMPLE DELFI !!!

                            garyo1954's avatar - garyo
                            Dallas, Texas
                            United States
                            Member #4549
                            May 2, 2004
                            1718 Posts
                            Online
                            Posted: September 13, 2015, 11:46 am - IP Logged

                            GARYo ONLY'M TALKING TO MANY OF PROGRAMMING LANGUAGE faster EXAMPLE DELFI !!!

                            Now you're an expert in programming languages too?

                            With all the expertness your claiming you should be able to do this with your eyes closed!

                            Why set here begging someone to do it for you when you are an expert in programming and know exactly what you want?

                            Makes no sense.

                            For what its worth, I've already updated the program to run triples for the 6/49 and started running it against the entire matrix.

                            If you're an expert and can't do it, I must be a MASTER EXPERT.

                            My greatest accomplishment is teaching cats about Vienna Sausage. When I need a friend, all I need do is walk outside, pop open a can, and every little critter in the neighborhood drops by to say "Hi!"

                              Avatar
                              bgonçalves
                              Brasil
                              Member #92564
                              June 9, 2010
                              2124 Posts
                              Offline
                              Posted: September 13, 2015, 5:28 pm - IP Logged

                              Now you're an expert in programming languages too?

                              With all the expertness your claiming you should be able to do this with your eyes closed!

                              Why set here begging someone to do it for you when you are an expert in programming and know exactly what you want?

                              Makes no sense.

                              For what its worth, I've already updated the program to run triples for the 6/49 and started running it against the entire matrix.

                              If you're an expert and can't do it, I must be a MASTER EXPERT.

                              Hello, no, no google translate very badly, I just asked what the best schedule
                                I know nothing of programming m'm truck driver,
                              I know nothing about and excel programçao, it is obvious that then I would not
                                Garyo, it was very good as did the dismembered ..... 1,2,3 positions, '4,5,6
                                Excellent work, so you can see the location of certain pairs in certain positions
                                perfect