HYPGEOM.DIST

HYPGEOM.DIST(sample_s, number_sample, population_s, number_population, cumulative)

Returns the probability distribution functon OR the cumulative probability function for a hypergeometric distribution.

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.
cumulative	A logical value indicating the type of function to use: False (or 0) = individual probability (equal to) True (<> 0) = cumulative probability (equal to or less than)

REMARKS

* For an illustrated example refer to the page under Distributions
* The hypogeometric distribution is a discrete distribution
* If "cumulative" = False, then the height of the curve at "x" is returned.
* If "cumulative" = True, then the area under the curve to the left of "x" is returned.
* This function was added in Excel 2010 to replace the HYPGEOMDIST function and include an option for probability distribution.
* For the Microsoft documentation refer to support.microsoft.com

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