Related Function:

The BINOM.DIST.RANGE function returns the binomial distribution probability for the number of successes from a specified number of trials falling into a specified range.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

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

Arguments

Argument Description
trials The number of independent trials that are to be done – must be ≥ 0
probability_s The probability of success in each trial – must be ≥ 0 and ≤ 1
number_s The number of successes in trials – must be ≥ 0 and ≤ trials
  Optional. the maximum number of successes that you want to calculate the probability for

  If provided, [number_s2] must be ≥ number_s and ≤ trials
  If the [number_s2] argument is omitted, the function calculates the probability of exactly number_s successes

Examples

  A B C
1 Formula Result Notes
2 =BINOM.DIST.RANGE(60,0.75,48) 0.084 Returns the binomial distribution based on the probability of 48 successes in 60 trials and a 75% probability of success (84%)
3 =BINOM.DIST.RANGE(60,0.75,45,50) 0.524 Returns the binomial distribution based on the probability of between 45 and 50 successes (inclusive) in 60 trials and a 75% probability of success (52.4%)

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are nonnumeric
#NUM! Occurs if either:

  the supplied probability_s is < 0 or > 1
  the supplied number_s is < 0 or > trials
  the supplied [number_s2] is < 0 or > trials or < number_s

The following equation is used to calculate binomial distribution:      

    \[   \begin{aligned}  \sum_{k=s}^{s2} \binom {n}{k} p^k (1-p)^{n-k}   \\\text{where: } \ p & = \text{probability\_s}  \\s & = \text{number\_s}  \\s2 & = \text{number\_s2} \\k & = \text{the iteration variable}\end{aligned}  \]

See Wikipedia for more information on binomial distribution.