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.

BINOMDIST function in Excel 1

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:

Formula
BINOM.DIST.RANGE function in Excel 1
  • 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:

BINOM.DIST.RANGE function in Excel 2

previous BINOM.DIST.RANGE Function in Excel                                                                                                                next BINOM.DIST.RANGE Function in Excel