BINOM.INV
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
StatisticalStatistics & Analysis
What it does
Calculates the minimum number of successes required to reach a specific cumulative probability.
Syntax
BINOM.INV(trials, probability_s, alpha)
Arguments
trials(number) — Number of Bernoulli trials.probability_s(number) — Probability of success on each trial.alpha(number) — Criterion value (probability 0 to 1).
Examples
Success Threshold
Min successes for 75% cumulative prob in 100 trials.
FORMULA
=BINOM.INV(100, 0.5, 0.75)
RESULT
53
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Trials | Prob S | Alpha |
| 2 | 100 | 0.5 | 0.75 |