|
|
The Excel BINOMDIST Function
BINOMIAL DISTRIBUTION
The Binomial Distribution is a statistical measure that is frequently used to indicate the probability
of a specific number of successes occurring from a specific number of independent trials.
The following two forms are used:
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 DescriptionThe 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 as follows :
Note that if decimal values are input for the number_s and trials arguments, these are truncated to integers by Excel. Binomdist Function Examples Probability Mass Function for the Toss of a Coin in 100 Trials
Example 1 - Binomial Distribution Probability Mass FunctionThe 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.
 Cumulative Distribution Function for the Toss of a Coin in 100 Trials
Example 2 - Binomial Cumulative Distribution FunctionThe 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.
Further examples of the Excel Binomdist function can be found on the Microsoft Office website. Trouble ShootingIf you get an error from the Excel Binomdist Function, this is likely to be one of the following: Common Errors
|
||||||||||||||||||||||||||||||||||||
|
|
Copyright © 2008-2011 ExcelFunctions.net |
