# 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 = probability distribution function (equal to)True = cumulative probability function (equal to or less than)

 REMARKS
 * This function was added in Excel 2010 to replace the HYPGEOMDIST function.* The hypogeometric distribution is a discrete distribution* If "cumulative" = False / 0, then the height of the bell shaped curve at "x" is returned. This uses the probability mass function* If "cumulative" = True / 1, then the area under the curve to the left of "x" is returned. This uses the cumulative probability function* 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