Returns the probability of a trial result using a binomial distribution.
Sample Usage
BINOM.DIST.RANGE(20:30)
BINOM.DIST.RANGE(60,0.75,45,50)
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_2, number_s2)
- trials - The number of independent trials.
- probability_s - The probability of success in any given trial.
- number_s - Minimum number of successes that you want to calculate the probability for. Must be greater than or equal to 0 and less than or equal to trials.
- number_s2 - Maximum number of successes that you want to calculate the probability for. Must be greater than or equal to number_s and less than or equal to trials.
Examples
BINOM.DIST.RANGE(60,0.75,48) returns a value of 0.083975.
BINOM.DIST.RANGE(60,0.75,45,50) returns a value of 0.524, representing the binomial distribution based on the probability of between 45 and 50 successes.