Theorical values for repeating numbers
thornc
You will find below the formula used to determine the number of combinations that have from 0 to 6 repeating numbers.
0 number: COMBIN(43,6)*COMBIN(6,0)
1 number: COMBIN(43,5)*COMBIN(6,1)
2 numbers: COMBIN(43,4)*COMBIN(6,2)
3 numbers: COMBIN(43,3)*COMBIN(6,3)
4 numbers: COMBIN(43,2)*COMBIN(6,4)
5 numbers: COMBIN(43,1)*COMBIN(6,5)
6 numbers: COMBIN(43,0)*COMBIN(6,6)
To find each individual percentage, just divide each value by COMBIN(49,6).
To understand the formula, let's take the formula for 2 numbers repeating:
- COMBIN(43,4) gives the possible combinations of 4 numbers taken from the 43 numbers that do not repeat (or 123,410);
- COMBIN(6,2) gives the possible combinations of 2 numbers taken from the 6 numbers that could repeat (or 15);
- when multiplying the two values, it gives the overall numbers of combinations for 2 numbers repeating (or 1,851,150);
- and by dividing that number by COMBIN(49,6) or 13,983,816, you get the theorical percentage of 13.24%.