...
Use  Function  Explanation 
Hypergeometric probability  =HYPGEOMDIST(x,n,D,M)  The hypergeometric probability of observing exactly s in a sample of size n that come from subpopulation D in a total population M. 
Combinations  =COMBIN(n,x)  The binomial coefficient _{n}C_{x} = n!/(s!(ns)!) 
Factorial  =FACT(x)  x! 
The Hypergeometric Process
Gliffy Diagram  


Description
The hypergeometric process occurs when one is sampling randomly without replacement from some population (as opposed to sampling with replacement in the Binomial Process), and where one is counting the number in that sample that have some particular characteristic. This is a very common type of scenario. For example, population surveys, herd testing, and lotto are all hypergeometric processes. In many situations, the population is very large in comparison to the sample and we can assume that if a sample was put back into the population, the probability is very small that it would be picked again. In that case, each sample would have the same probability of picking an individual with a particular characteristic: in other words this becomes a binomial process. When the population is not very large compared to the sample (a good rule is that the population is less than ten times the size of the sample) we cannot make a binomial approximation to the hypergeometric. This section discusses the distributions associated with the hypergeometric process.
The figure above demonstrates the four parameters of the Hypergeometric process: The population one is sampling from (M); the subpopulation of interest (D), the number being randomly sampled from the population (n) and the number (s) in that sample that come from D. We recommend that you draw out a diagram like this when you are faced with a hypergeometric problem to keep that all clear!
Once you have reviewed the material in this section, you might like to test how much you have learned by taking the selftest quiz:
A quiz on The hypergeometric process:
Take Quiz Button  


Summary of results for the hypergeometric process
Quantity  Formula  Notes  
Number of subpopulation in the sample  In Crystal Ball version 5.5: s = Hypergeometric(D/M,n,M) In Crystal Ball version 7.0+: s = Hypergeometric(D,n,M)  
Number of samples to observe s from the subpopulation  n = InvHypergeo(s,D,M)  
Number of samples there were to have observed s from the subpopulation  n = InvHypergeo(s,D,M)  Where the last sample is known to have been from the subpopulation  
Number of samples n there were before having observed s from the subpopulation 
 Where the last sample is not known to have been from the subpopulation. This uncertainty distribution needs to be normalized.  
Size of subpopulation D 
 This uncertainty distribution needs to be normalized.  
Size of population M 
 This uncertainty distribution needs to be normalized. 
Useful Excel Functions:
Use  Function  Explanation 
Hypergeometric probability  =HYPGEOMDIST(x,n,D,M)  The hypergeometric probability of observing exactly s in a sample of size n that come from subpopulation D in a total population M. 
Combinations  =COMBIN(n,x)  The binomial coefficient _{n}C_{x} = n!/(s!(ns)!) 
Factorial  =FACT(x)  x! 