CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Returns the smallest value for which the cumulative binomial distribution is >= criterion (Legacy).
Syntax
CRITBINOM(trials, probability_s, alpha)
Arguments
trials(number) — Number of Bernoulli trials.probability_s(number) — Success probability.alpha(number) — Criterion value.
Examples
Legacy Critical Binom
Calculate threshold.
FORMULA
=CRITBINOM(100, 0.5, 0.75)
RESULT
53
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | N | P | Alpha |
| 2 | 100 | 0.5 | 0.75 |