Hypergeometric distribution[1][2].
Syntax:
HYPGEOM.DIST( sample_successes:Number, number_sample:Number, population_successes:Number, number_population:Number {, cumulative:Boolean} )
Returns the value of the cumulative distribution function (CDF) or the probability mass function (PMF) for the hypergeometric distribution for a sample with sample_successes, number_sample and a population with population_successes, number_population.
cumulative selects CDF (TRUE
) or PMF (FALSE
, default).
Revisions:
This function was added in Fireworkz 2.00.