HYPGEOM.DIST(sample_s, number_sample, population_s, number_population, cumulative)
Returns the probability of getting less than or equal to a particular 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||The type of function to use|
True = cumulative probability function
False = probability mass function
|* Added in Excel 2010.|
* This function replaces the HYPGEOMDIST function.
* The hypo geometric distribution is a discrete distribution.
* For the Microsoft documentation refer to support.office.com
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top