ReferenceFunctionsStatistics Functions
HYPGEOM.DIST
HYPGEOM.DIST: Returns hypergeometric probabilities for successes drawn without replacement.
Summary
Use HYPGEOM.DIST for finite-population sampling where each draw changes remaining odds.
Remarks
- Count inputs are truncated to integers.
- Requires valid population/sample bounds and feasible success counts.
- Set
cumulativeto non-zero for CDF mode, or0for PMF mode. - Returns
#NUM!for invalid population setup; out-of-support PMF values return0.
Examples
Hypergeometric PMF
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.5
Hypergeometric CDF
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.6666666666666666
Related functions
Runtime metadata
Category
Statistics
Signature
HYPGEOM.DIST(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5: Number)Arity
min 5, max 5
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
arg4Number · Scalar · coercion NumberLenientText
arg5Number · Scalar · coercion NumberLenientText
Caps
PURE
Source