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.