The Excel BINOMDIST Function

Related Functions:
CRITBINOM
NEGBINOMDIST

BINOMDIST and BINOM.DIST

In Excel 2010, the Binomdist function has been replaced by the Binom.Dist function, which has improved accuracy.

Although it has been replaced, the Binomdist function is still available in Excel 2010 (stored in the list of compatibility functions), to allow compatibility with earlier versions of Excel.




Basic Description

The Excel BINOMDIST function returns the Binomial Distribution probability of a specified number of successes out of a specified number of trials.

The format of the function is :

BINOMDIST( number_s, trials, probability_s, cumulative )

where the arguments are shown in the table below :


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 in one trial
cumulative -

A logical argument that specifies whether you want to calculate the cumulative distribution function or the probability mass function. This argument can have the value TRUE or FALSE, meaning:

TRUE - use the cumulative distribution function
FALSE - use the probability mass function

Note that if decimal values are input for the number_s and trials arguments, these are truncated to integers by Excel.

  +   Display Binomial Distribution Summary:


Binomdist Function Examples

Binomial Distribution Probability Mass Function Chart
Probability Mass Function for the Toss of a Coin in 100 Trials

Example 1 - Binomial Distribution Probability Mass Function

The chart on the right shows the Binomial Distribution Probability Mass Function for 100 tosses of a coin. The chart shows the probability that exactly x heads will be thrown from 100 tosses of a coin.

The spreadsheets below show the Excel Binomdist function used to evaluate this function for three different values of x.

Clearly, the probability of tossing a head on any one trial is 50%, so this is input as the probability argument to the functions.


 Formulas:
Examples of use of the Excel Binomdist Function
 Results:
Excel Binomdist Function Results

Binomial Cumulative Distribution Function Chart
Cumulative Distribution Function for the Toss of a Coin in 100 Trials

Example 2 - Binomial Cumulative Distribution Function

The chart on the right shows the Binomial Cumulative Distribution Function for 100 tosses of a coin. The chart shows the probability that at most x heads will be thrown from 100 tosses of a coin.

The spreadsheets below show the Excel Binomdist function used to evaluate the Cumulative Distribution for three different values of x.


 Formulas:
Examples of use of the Excel Binomdist Function
 Results:
Excel Binomdist Function Results

Further examples of the Excel Binomdist function can be found on the Microsoft Office website.


Trouble Shooting

If you get an error from the Excel Binomdist Function, this is likely to be one of the following:

Common Errors
#NUM! - Occurs if either:
- the supplied number_s is < 0 or > trials
or
- the supplied probability_s is < 0 or > 1
#VALUE! - Occurs if any of the number_s, trials, or probability_s arguments are nonnumeric
Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net