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.
|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
|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 following equation is used to calculate binomial distribution:
See Wikipedia for more information on binomial distribution.