BINOM.INV

Try it

When to use it

When should I use BINOM.INV?

Use BINOM.INV to find the smallest number of successes k such that the binomial CDF is at least alpha — useful for setting acceptance thresholds in quality control or determining minimum passing scores.

Used in

operations · science

Syntax

BINOM.INV(n,p,alpha)

Examples

=BINOM.INV(100,0.005,0.8) // => 1