BINOMDIST Function

Basic Description

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

Syntax: 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.

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

 

Trouble Shooting

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

#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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment