Math Problem in Excel
This is dealing with lottery odds.
For instance random numbers, any order, in picking 6 numbers out of 49
numbers
6/6 is 1 in 13,983,816 odds
=COMBIN(49,6)
Numbers in order or in sequence:
However, in sequence, of 4 numbers in a row, such as 1 2 3 4 x x out
of 49 numbers.
what are the odds for this calculation, and how would you calculate
this in Excel.
Further, if this sequence is at the beginning of 49 numbers would the
odds be any
different than 4 number in sequence at the end, such as x x 46 47 48
49
With Thanks
|