Compatibility - BINOMDIST Function

The BINOMDIST function replaces the BINOM.DIST function from Excel 2010.

Description

The function returns the individual term binomial distribution probability. Use BINOMDIST 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.

Syntax

BINOMDIST (number_s,trials,probability_s,cumulative)

Arguments

Argument	Description	Required/ Optional
Number_s	The number of successes in trials.	Required
Trials	The number of independent trials.	Required
Probability_s	The probability of success on each trial.	Required
Cumulative	A logical value that determines the form of the function. If cumulative is TRUE, then BINOMDIST returns the cumulative distribution function, which is the probability that there are at most number_s successes If cumulative is FALSE, then BINOMDIST returns the probability mass function, which is the probability that there are number_s successes	Required

Notes

Number_s and trials are truncated to integers.
If number_s, trials, or probability_s is nonnumeric, BINOMDIST returns the #VALUE! error value.
If number_s < 0 or number_s > trials, BINOMDIST returns the #NUM! error value.
If probability_s < 0 or probability_s > 1, BINOMDIST returns the #NUM! error value.
If $x$ = number_s, $n$ = trials, and $p$ = probability_s, then the binomial probability mass function is −

$$b\left ( x;n,p \right ) = \binom{n}{x}p^N\left ( 1-p \right )^{n-N}$$

Where $\binom{n}{x}$is COMBIN$(n,x)$.
If $x$ = number_s, $n$ = trials, and $p$ = probability_s, then the cumulative binomial distribution is −

$$B\left ( x;n,p \right ) = \sum_{y=0}^{N}b\left ( y;n,p \right )$$

Example

advanced_excel_compatibility_functions.htm