Combinations countPrev TopicNext Topic

• frenchie

  

  Los Angeles
  United States
  Member #75,407
  June 2, 2009
  601 Posts
  Offline
  Jul 4, 2010, 7:55 pm

  ▲▼

  Hi everyone,

  and happy 4th of july to all.     

   

  Question : Does anyone know how to calculate how many combinations a number by positions will generate ?

  for exemple :

  Number 1 as 1st position generate 341 055 combinations.

  Number 15 as 1st position generate 101 270 combinations.

  Number 26 as 3rd position generate 130 500 combinations.

  Etc...

  See below part of the chart

  

  Thank you ....                                                        Serge.
• JADELottery

  

  Eagle Sun

  IA, MN, WI
  United States
  Member #21
  December 7, 2001
  5,177 Posts
  Offline
  Jul 4, 2010, 8:35 pm

  ▲▼

  https://www.lotterypost.com/thread/144425

  The One Over None
  I Know...
• frenchie

  

  Los Angeles
  United States
  Member #75,407
  June 2, 2009
  601 Posts
  Offline
  Jul 4, 2010, 8:43 pm

  ▲▼

  Thanks again, JADELottery.

  I realy appreciate it.
• RJOh

  

  100

  mid-Ohio
  United States
  Member #9
  March 24, 2001
  20,272 Posts
  Offline
  Jul 4, 2010, 8:55 pm

  ▲▼
  In response to frenchie

  Quote: Originally posted by frenchie on Jul 4, 2010

  Hi everyone,

  and happy 4th of july to all.     

   

  Question : Does anyone know how to calculate how many combinations a number by positions will generate ?

  for exemple :

  Number 1 as 1st position generate 341 055 combinations.

  Number 15 as 1st position generate 101 270 combinations.

  Number 26 as 3rd position generate 130 500 combinations.

  Etc...

  See below part of the chart

  

  Thank you ....                                                        Serge.

  First you have to know the size of the combinations and the size of the number pool because the larger the combination and number pool, the more combinations that will be generated. 

  The potion of the chart you're showing looks like it's for combinations of 5 for a pool of 56 numbers.

  If 1 is in the first position then there are 4/55 combinations left = 341055
  If 2 is in the first position then there are 4/54 combinations left = 316251 and etc.

  Since 2 is the lowest number that can be in the second position of any combination, you start with 2.
  If 2 is in the second position then there are 3/54 combinations left = 24504 and etc.

  You do the same thing for all the remaining positions and you will have made a chart.

  If you were doing this for a combination of 6 for a number pool of 49 then:
  If 1 is in the first position then there are 5/48 combinations left = 1712304 and etc.

  If you don't have a program to calculate the number of combinations of a certain size for a number pool of a certain size, you can use the formula at the link in JADELottery post or just download one from the Internet.

   * you don't need to buy every combination, just the winning ones * 

         
  
• frenchie

  

  Los Angeles
  United States
  Member #75,407
  June 2, 2009
  601 Posts
  Offline
  Jul 4, 2010, 9:04 pm

  ▲▼

  Thank you RJoh for the explanations...          Serge.
• frenchie

  

  Los Angeles
  United States
  Member #75,407
  June 2, 2009
  601 Posts
  Offline
  Jul 5, 2010, 2:05 am

  ▲▼

  Hi JADELottery,

            I tried to put together your " combinatorial distribition " with your info but with no success, can you, if possible send me the excel file with the formulas in the cells ?

                                                                                                                                                     Thank you.    Serge.
• JADELottery

  

  Eagle Sun

  IA, MN, WI
  United States
  Member #21
  December 7, 2001
  5,177 Posts
  Offline
  Jul 5, 2010, 11:20 am

  ▲▼
  In response to frenchie

  Quote: Originally posted by frenchie on Jul 5, 2010

  Hi JADELottery,

            I tried to put together your " combinatorial distribition " with your info but with no success, can you, if possible send me the excel file with the formulas in the cells ?

                                                                                                                                                     Thank you.    Serge.

  You can download an Excel file at the following ftp and http sites.

  ftp://www.jadexcode.com/Excel/CombinatorialDistribution.xls

  http://www.jadexcode.com/Excel/CombinatorialDistribution.xls

  The One Over None
  I Know...
• frenchie

  

  Los Angeles
  United States
  Member #75,407
  June 2, 2009
  601 Posts
  Offline
  Jul 5, 2010, 4:42 pm

  ▲▼

  Hi JADELottery,

  Thank you for the link, I would never came up with thoses formulas,I tried with the fisrt post you gave me and was able to do the first and second column but after that, the third wasn't working properly ?? so I stoped, I don't have your level in formula knowledge or VBA etc..., I get thoses ideas and then ask for the formula or VBA code to someone when it become to complicated for me, so you will see more of me asking for help.

              In a previous post call " Combinations by number position " I like to ask you if you know an excel file that would basicly have all the 5/56 combinations but separate by their numbers of position ? which woud be like the chart you just sent me with 260 columns (x2) with their respective combinations of position number AND their lexicographic number ?

              That's what I'm looking for and by changing the VBA code ( if possible ) I will be able to create all files for all the other games.

              I just want to ask you : Do you know a site or someone that already have it ? I'm sure someone thought of it already ?

                               Thank you so much for your great help...                Serge.