BINOM.DIST

Try it

When to use it

When should I use BINOM.DIST?

Use BINOM.DIST to compute the binomial PMF (exact probability of exactly k successes) or CDF (probability of at most k successes) given n trials and success probability p — for quality control, defect analysis, or any pass/fail process.

Used in

operations · science

Syntax

BINOM.DIST(k,n,p,cumulative)

Examples

=BINOM.DIST(4,100,0.005,FALSE) // => 0.0015146682842220032
=BINOM.DIST(4,100,0.005,TRUE) // => 0.9998414007611653