Calculate exact binomial probabilities: the chance of exactly x successes, at most x, fewer than x, at least x, more than x, or between a and b, in n independent trials with success probability p. You also get the mean, variance and standard deviation, a complete probability table and a bar chart with your outcomes highlighted.
When does the binomial distribution apply?
- There is a fixed number of trials, n.
- Each trial has two outcomes: success or failure.
- The probability of success p is the same for every trial.
- Trials are independent.
Examples: the number of heads in 20 coin tosses, defective items in a batch of 50, or patients out of 12 who respond to a treatment with a 30% response rate.
Formulas
P(X = x) = C(n, x) · pˣ · (1 − p)ⁿ⁻ˣ · mean = np · variance = np(1 − p)
Worked example
A multiple-choice quiz has 20 questions with a 30% chance of guessing each one correctly. The probability of guessing exactly 5 right is P(X = 5) = 0.1789. The probability of at least 5 right is P(X ≥ 5) = 0.7625. On average a guesser gets 6 right, with an SD of 2.05.
“At least” and “at most” without mistakes
| Words | Symbol | Includes x? |
|---|---|---|
| at most x, no more than x | P(X ≤ x) | Yes |
| fewer than x, less than x | P(X < x) = P(X ≤ x − 1) | No |
| at least x, no fewer than x | P(X ≥ x) = 1 − P(X ≤ x − 1) | Yes |
| more than x | P(X > x) = 1 − P(X ≤ x) | No |
Frequently asked questions
Can I use the normal approximation instead?
When np and n(1 − p) are both at least about 10, the normal distribution approximates the binomial well. This calculator computes exact values for any n, even in the thousands, so you don’t need the approximation.
What are the Excel equivalents?
BINOM.DIST(x, n, p, FALSE) for P(X = x) and BINOM.DIST(x, n, p, TRUE) for P(X ≤ x).