# BINOM.DIST.RANGE Function in Excel

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:

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

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:

##### • 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

##### Result: 