CRITBINOM

Try it

When to use it

When should I use CRITBINOM?

Use CRITBINOM to find the smallest integer k such that the binomial CDF is at least alpha — a legacy equivalent of BINOM.INV used for determining acceptance numbers in quality control sampling plans.

Used in

operations · science

Syntax

CRITBINOM(n,p,alpha)

Examples

=CRITBINOM(100,0.005,0.8) // => 1