|HYPGEOM.DIST(sample_s, number_sample, population_s, number_population, cumulative)|
Returns the probability of getting less than or equal to a value in a hyper geometric distribution (finite population).
|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:|
True / 1 = cumulative probability function
False / 0 = probability mass function
|* This function was added in Excel 2010 to replace the HYPGEOMDIST function.|
* The hypo geometric distribution is a discrete distribution.
* For the Microsoft documentation refer to support.microsoft.com
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top