BINOM.DIST.RANGE

Formulas / BINOM.DIST.RANGE
The BINOM.DIST.RANGE formula calculates the probability of achieving a specified range of successes in a fixed number of trials, each with the same probability of success, using the binomial distribution.
`BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])`
• trials - The number of independent trials.
• probability_s - The probability of success on each trial.
• number_s - The lower bound for the number of successes in the range.
• number_s2 - [OPTIONAL] The upper bound for the number of successes in the range. If omitted, the function calculates the probability of exactly "number_s" successes.

Examples

• `=BINOM.DIST.RANGE(10, 0.5, 3)`

This formula calculates the probability of getting exactly 3 successes in 10 independent trials, each with a 50% probability of success (e.g., getting 3 heads in 10 coin flips). The result is the probability of this specific outcome.

• `=BINOM.DIST.RANGE(10, 0.5, 3, 5)`

This formula calculates the probability of getting between 3 and 5 successes (inclusive) in 10 independent trials, each with a 50% probability of success (e.g., getting 3, 4, or 5 heads in 10 coin flips). The result is the cumulative probability of getting 3, 4, or 5 successes.

Summary

The BINOM.DIST.RANGE function calculates the probability of a range of successes in a fixed number of trials, each with the same probability of success, using the binomial distribution.

• The BINOM.DIST.RANGE function is a statistical function that calculates the probability of achieving a specified range of successes in a given number of independent trials, each with the same probability of success, using the binomial distribution.
• The function takes three required arguments: the number of trials ("trials"), the probability of success on each trial ("probability_s"), and the lower bound for the number of successes ("number_s"). An optional fourth argument ("number_s2") can be provided to specify the upper bound for the number of successes; if omitted, the function calculates the probability of achieving exactly "number_s" successes.
• BINOM.DIST.RANGE requires "trials" to be a whole number (integer) and "probability_s" to be within the range [0, 1]; otherwise, the function returns a #NUM! error. Fractional values for "trials" are not valid.

`=BINOM.DIST.RANGE(10, 0.5, 3)`
`=BINOM.DIST.RANGE(10, 0.5, 3, 5)`