BINOM.DIST
Returns the individual term binomial distribution probability.
StatisticalStatistics & Analysis
What it does
Calculates the probability of a specific number of successes in a fixed number of trials.
Syntax
BINOM.DIST(number_s, trials, probability_s, cumulative)
Arguments
number_s(number) — Number of successes.trials(number) — Number of independent trials.probability_s(number) — Probability of success on each trial.cumulative(logical) — TRUE for cumulative distribution, FALSE for probability mass function.
Examples
Probability of Success
Chance of exactly 6 heads in 10 flips (0.5 prob).
FORMULA
=BINOM.DIST(6, 10, 0.5, FALSE)
RESULT
0.205
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Successes | Trials | Prob |
| 2 | 6 | 10 | 0.5 |