CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. Replaced by BINOM.INV.
Syntax
CRITBINOM(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
=CRITBINOM(6, 0.5, 0.75)