View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Math Problem in Excel

On Jun 14, 12:22*pm, smandula wrote:
For instance random numbers, any order, in picking
6 numbers out of 49 numbers [...] is 1 in 13,983,816 odds
=COMBIN(49,6)

[....]
However, in sequence, of 4 numbers in a row, such as
1 2 3 4 x x out of 49 numbers.


The number of such sequences is 46*COMBIN(45,2)

Explanation.... There are 49-4+1 combinations of 4 contiguous
numbers, i.e. 49 48 47 46, 48 47 46 45, ..., 4 3 2 1. That leaves 45
numbers from which any 2 are chosen at random.


smandual wrote:
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


No. I hope that is apparent from my explanation.