BINOM.DIST Function in Excel

       BINOM.DIST function in Excel returns the Binomial Distribution probability of a specified number of successes out of given number of trials. BINOM.DIST function in Excel can be used to calculate Binomial Distribution Probability Mass Function and Binomial Cumulative Distribution Function, we will see both with an example.

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 Function in Excel:

BINOM.DIST( number_s, trials, probability_s, cumulative )

 

number_s  –  The number of successes that you want to calculate the probability for.

trials–     The number of independent trials that are to be done.

probability_s– The probability of success(for a single trial).

cumulative – A logical argument which takes TRUE or FALSE

  • TRUE-calculates the cumulative distribution function.
  • FALSE-calculates the probability mass function.

 

Example of BINOM.DIST Function in Excel which calculates probability mass function:

Formula

BINOM.DIST function in Excel 1

  • In the above example success is defined as number of heads on toss of a coin.
  • In the above example Binomial Distribution Function – BINOM.DIST takes up the number of success which ranges from 10 to 90, number of trials which is 100, probability of success in each trial which is 0.5, and cumulative as FALSE, so that probability mass function is returned.

So the result will be a probability mass function

BINOM.DIST function in Excel 2

When we plot the result with number of success on x axis we will get the graph for probability mass function which is shown below.

BINOM.DIST function in Excel 3

 

Example of BINOM.DIST Function in Excel which calculates Cumulative Distribution Function:

Formula

BINOM.DIST function in Excel 4

  • In the above example success is defined as number of heads on toss of a coin.
  • In the above example Binomial Distribution Function – BINOM.DIST takes up the number of success which ranges from 10 to 90, number of trials which is 100, probability of success in each trial which is 0.5, and cumulative as TRUE, so that cumulative distribution function is returned.

So the result will be a cumulative distribution function

BINOM.DIST function in Excel 5

When we plot the result with number of success on x axis we will get the graph for cumulative distribution function which is shown below

BINOM.DIST function in Excel 6

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