Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.
Sample Usage
BINOM.INV(100,0.005,0.8)
BINOM.INV(C2,C3,C4)
Syntax
BINOM.INV(trials, probability_s, alpha)
- trials - The number of independent trials.
- probability_s - The probability of success in any given trial.
- alpha - The desired threshold probability.
Examples
BINOM.INV(100,0.005,0.8) returns the value 1.
BINOM.INV(C2,C3,C4) returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.