The BINOM.DIST function returns the binomial distribution probability for a given number of successes from a specified number of trials.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- BINOM.DIST replaces the BINOMDIST function included in earlier versions of Excel.
|number_s||The number of successes in trials|
|trials||The number of independent trials|
|probability_s||The probability of success on each trial|
|cumulative||A logical argument that specifies the type of binomial distribution to be calculated. This can have the value TRUE or FALSE meaning:
|2||6||Number of successes in trial|
|3||10||Number of independent trials|
|4||0.5||Probability of success on each trial|
|7||=BINOM.DIST(A2,A3,A4,FALSE)||0.2050781||Probability of exactly 6 of 10 trials being successful|
Usage note: Use BINOM.DIST in problems with a fixed number of tests or trials, when the outcomes of any trial are only success or failure, when trials are independent, and when the probability of success is constant throughout the experiment. For example, BINOM.DIST can calculate the probability that two of the next three babies born are male.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the number_s, trials, or probability_s arguments are nonnumeric|
|#NUM!||Occurs if either:
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:
- The Probability Mass Function – calculates the probability of there being exactly x successes from n independent trials
- The Cumulative Distribution Function – calculates the probability of there being at most x successes from n independent trials
The binomial probability mass function is:
The cumulative binomial distribution is:
See Wikipedia for more information on binomial distribution.