BINOM.DIST Function

Basic Description

The Excel BINOM.DIST function returns the Binomial Distribution probability for a given number of successes from a specified number of trials. The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, the Binom.Dist function is simply a new version of the Binomdist function that is available in earlier versions of Excel.

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

where the arguments are listed 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 the type of Binomial distribution to be calculated. This can be either:

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

 

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

Binomial Distribution Probability Mass Function Chart

Probability Mass Function for the Toss of a Coin in 100 Trials
Binom.Dist Function Example 1

The chart on the right uses the Binomial Distribution Probability Mass Function to show the probability that exactly x heads will be thrown from 100 tosses of a coin. The spreadsheets below show the Excel Binom.Dist function used to evaluate this function for three different values of x. The spreadsheet on the left displays the functions and the spreadsheet on the right shows the results. 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 Binom.Dist Function

 Results:

Excel Binom.Dist Function Results

 

Binomial Cumulative Distribution Function Chart

Cumulative Distribution Function for the Toss of a Coin in 100 Trials
Binom.Dist Function Example 2

The chart on the right shows the Binomial Cumulative Distribution Function, used to show the probability that at most x heads will be thrown from 100 tosses of a coin. The spreadsheets below show the Excel Binom.Dist function used to evaluate this function for three different values of x. Again, the spreadsheet on the left displays the functions and the spreadsheet on the right shows the results.

 Formulas:

Examples of use of the Excel Binom.Dist Function

 Results:

Excel Binom.Dist Function Results

 

Trouble Shooting

If you get an error from the Excel Binom.Dist 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