BINOM.DIST.RANGE function
The BINOM.DIST.RANGE function is one of the statistical functions. It is used to return the probability of a trial result using a binomial distribution.
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
The BINOM.DIST.RANGE function has the following arguments:
| Argument | Description |
|---|---|
| trials | The number of trials, a numeric value greater than or equal to number_s. |
| probability | The success probability of each trial, a numeric value greater than or equal to 0 but less than or equal to 1. |
| number_s | The minimum number of successes in the trials you want to calculate probability for, a numeric value greater than or equal to 0. |
| number_s2 | An optional argument. The maximum number of successes in the trials you want to calculate probability for, a numeric value greater than number_s and less than or equal to trials. |
Notes
How to apply the BINOM.DIST.RANGE function.
Examples
The figure below displays the result returned by the BINOM.DIST.RANGE function.
