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.

Frequently Asked Questions

Example 1:
 =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.
Example 2:
 =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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV