HYPGEOMDIST(sample_s, number_sample, population_s, number_population)

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

sample_sThe number of successes in the sample.
number_sampleThe size of the sample.
population_sThe number of successes in the population.
number_populationThe size of the population.

* 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

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

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top