HYPGEOMDIST
Description
Returns the hypgeomdist distribution probability (cumulative or density) for the
specified value.
Syntax
HYPGEOMDIST(
sample_s
,
number_sample
,
population_s
,
number_pop
, [
cumulative
])
- 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_pop: The size of the population.
- cumulative: The type of distribution to use. FALSE = probability density function; TRUE = cumulative distribution function.
Example
For the table:
A | |
|---|---|
1
| 1 |
2
| 4 |
3
| 8 |
4
| 20 |
The formulas and results are:
Formula | Result |
|---|---|
HYPGEOMDIST(A1,A2,A3,A4,TRUE) | 0.465428277 |
HYPGEOMDIST(A1,A2,A3,A4,FALSE) | 0.363261094 |
Notes
- This function does the same action as HYPGEOM.DIST().
- If an impossible scenario occurs (for example, there are more successes than trials), Worksheets returns aninvalid numbererror.