Statistical - BINOM.DIST Function

Description

The BINOM.DIST function returns the individual term binomial distribution probability.

Use BINOM.DIST in problems with a fixed number of tests or trials.

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

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 BINOM.DIST returns the cumulative distribution function, which is the probability that there are at most number_s successes If cumulative is FALSE, then BINOM.DIST returns the probability mass function, which is the probability that there are number_s successes	Required

Number_s and trials are truncated to integers.
If number_s, trials, or probability_s is nonnumeric, BINOM.DIST returns the #VALUE! error value.
If number_s < 0 or number_s > trials, BINOM.DIST returns the #NUM! error value.
If probability_s < 0 or probability_s > 1, BINOM.DIST returns the #NUM! error value.
The binomial probability mass function is −

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

Where $\left ( \frac{n}{x} \right )$ is a COMBIN (n,x).
The cumulative binomial distribution is −

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

Excel 2010, Excel 2013, Excel 2016

advanced_excel_statistical_functions.htm