BINOM.INV
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
Syntax
BINOM.INV(trials, probability_s, alpha)
Parameters
- trials: Required. The number of Bernoulli trials
- probability_s: Required. The probability of a success on each trial
- alpha: Required. The criterion value
Example
=BINOM.INV(6, 0.5, 0.75)