BINOM.DIST.RANGE
Returns the probability of a trial result using a binomial distribution.
StatisticalStatistics & Analysis
What it does
Returns the probability of a range of successes in a binomial experiment.
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
Arguments
trials(number) — Number of independent trials.probability_s(number) — Probability of success on each trial.number_s(number) — Minimum number of successes.number_s2(number) — Maximum number of successes (optional).
Examples
Range Probability
Chance of getting between 4 and 6 heads in 10 flips.
FORMULA
=BINOM.DIST.RANGE(10, 0.5, 4, 6)
RESULT
0.656
SAMPLE DATA
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Trials | Prob | Min | Max |
| 2 | 10 | 0.5 | 4 | 6 |