|
|
The Excel BINOM.DIST 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:
Basic DescriptionThe 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. The format of the Binom.Dist function is :
BINOM.DIST( number_s, trials, probability_s, cumulative )
where the arguments are as follows :
Note that, if the values input for the number_s and trials arguments are decimal numbers, these values are truncated to integers.  Probability Mass Function for the Toss of a Coin in 100 Trials
Binom.Dist Function Example 1The 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.
 Cumulative Distribution Function for the Toss of a Coin in 100 Trials
Binom.Dist Function Example 2The 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.
Further examples of the Excel Binom.Dist function can be found on the Microsoft Office website. Trouble ShootingIf you get an error from the Excel Binom.Dist Function, this is likely to be one of the following: Common Errors
|
||||||||||||||||||||||||||||||||||||
|
|
Copyright © 2008-2011 ExcelFunctions.net |
