HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: BinomDist Function

In Excel, the BinomDist function returns the individual term binomial distribution probability.

The syntax for the BinomDist function is:

BinomDist( number_success, number_trial, prob_success, cumulative )

number_success is the number of successes in the trials.

number_trial is the number of independent trials.

prob_success is the probability of success for each trial.

cumulative is either TRUE or FALSE. With a value of TRUE, the BinomDist function returns the cumulative distribution function. With a value of FALSE, the BinomDist function returns the probability mass function.


Applies To:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

=BinomDist(3, 8, 0.35, TRUE) would return 0.706399436
=BinomDist(3, 8, 0.35, FALSE) would return 0.278585779
=BinomDist(50, 125, 0.4, TRUE) would return 0.538748205