BINOM.DIST.RANGE function

The BINOM.DIST.RANGE function in Excel returns the probability of a specific number of successes in trials for a binomial distribution within a defined range. It’s particularly useful when you need to calculate the probability of having between two numbers of successes (inclusive) in a given number of trials.

Syntax:

BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])

Arguments:

• trials: The number of independent trials (integer value).
• probability_s: The probability of success on a single trial (decimal between 0 and 1).
• number_s: The number of successes (integer value).
• [number_s2] (optional): The upper bound on the number of successes (integer value). If omitted, the function will return the probability of exactly number_s successes.

Example:

You perform 10 trials, and the probability of success in each trial is 0.5. You want to calculate the probability of getting between 3 and 7 successes.

=BINOM.DIST.RANGE(10, 0.5, 3, 7)

This will return the probability of getting between 3 and 7 successes (inclusive) out of 10 trials.

If you want the probability of exactly 5 successes:

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