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

 REMARKS
 * This function was added in Excel 2010 to replace the HYPGEOMDIST function and include an option for probability distribution.* 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.* 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