HYPGEOM.DIST function
Returns the hypergeometric distribution
Syntax
HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| sample_s | Yes | The number of successes in the sample.1 |
| number_sample | Yes | The size of the sample.4 |
| population_s | Yes | The number of successes in the population.8 |
| number_pop | Yes | The population size.20 |
| cumulative | Yes | A logical value that determines the form of the function. If cumulative is TRUE, HYPGEOM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.true |
Try HYPGEOM.DIST
Guard a population without marked records
=IF(C2=0,1,HYPGEOM.DIST(A2,B2,C2,D2,TRUE))With valid feasible counts, no marked population means the zero-count event is certain. The explicit IF handles that mathematical case before calling HYPGEOM, whose documented domain rejects a zero marked-population argument.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
HYPGEOM.DIST · inside IF
=IF(C2=0,1,HYPGEOM.DIST(A2,B2,C2,D2,TRUE))Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.