# HYPGEOMDIST

HYPGEOMDIST(sample_s, number_sample, population_s, number_population)

Returns the cumulative probability function for a hypergeometric distribution (only cumulative).

 sample_s The number of successes in the sample. number_sample The size of the sample. population_s The number of successes in the population. number_population The size of the population.

 REMARKS
 * HYPGEOM.DIST was added in Excel 2010 to replace this function and include an option for probability distribution.* The hypogeometric distribution is a [[discrete distribution]]* This function always returns the cumulative probability function. There is no option for the probability distribution function.* This function returns the probability of a given number of sample successes, given the sample size, population successes, and population size.* You should use this function for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.* All arguments are truncated to integers.* If any argument is nonnumeric, then #VALUE! is returned.* If "sample_s" < 0 or "sample_s" is greater than the lesser of "number_sample" or "population_s", then #NUM! is returned.* If "sample_s" < ("number_sample" - "number_population" + "population_s"), then #NUM! is returned.* If "number_sample" < 0, then #NUM! is returned.* If "number_sample" > "number_population", then #NUM! is returned.* If "population_s" < 0, then #NUM! is returned.* If "population_s" > "number_population", then #NUM! is returned.* If "number_population" < 0, then #NUM! is returned.* This is similar to the BETADIST and LOGNORMDIST functions.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =HYPGEOMDIST(1, 4, 8, 20) = 0.363 2 =HYPGEOMDIST(1, 2, 3, 4) = 0.5 3 =HYPGEOMDIST(5, 10, 10, 20) = 0.3 4 =HYPGEOMDIST(5, 10, 5, 20) = 0 5 =HYPGEOMDIST(-1, 4, 8, 20) = #NUM! 6 =HYPGEOMDIST(6, 4, 8, 20) = 0.000