BINOM.DIST.RANGE function in Excel returns the Binomial Distribution probability for the number of successes within a specified range from a specified number of trials.
Binomial Distribution Formula:
Binomial Distribution Formula is shown below.
Where
n: is the number of trials
x: The number of successes that result from the binomial experiment.
p: The probability of success on an individual trial.
q: The probability of failure on an individual trial (q= 1-p)
Syntax of BINOM.DIST.RANGE Function in Excel:
trials – The number of independent trials that are to be done.
probability_s– The probability of success(for a single trial).
number_s – The minimum number of successes that you want to calculate the probability for.
number_s2 – Maximum number of successes that you want to calculate the probability for.
Example of BINOM.DIST.RANGE Function in Excel:
Formula
- In the above example success is defined as number of heads on toss of a coin.
- In the first 3 examples BINOM.DIST.RANGE Function in Excel takes number of trials, probability of success, and the range of minimum and maximum number of success.
- In the last 2 examples BINOM.DIST.RANGE Function in Excel takes number of trials, probability of success and the exact number of success.
So the result will be