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.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV