BINOM. DIST Function - Function Returns the Probability of Binomial

This guide provides a practical overview of BINOM. DIST Function - Function Returns the Probability of Binomial, including its main features, benefits, limitations, and important considerations.

Description: The function returns the binomial distribution probability of the individual term. Support function from Excel 2010 version.

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

Inside:

- number_s: number of successes in the test, a required parameter.

- trials: Number of independent trials, required.

- probability_s: The probability of success of each test, is a required parameter.

- cumulative: Logical value determines the form of the function if it is True -> returns the cumulative distribution function, if the False value returns the probability mass function .

Attention:

- If number_ s and trials are not whole numbers they are truncated to whole numbers.

- If number_ s and trials are not numbers -> the function returns the #VALUE! Error value

- If number_s <0 or number_s > trials -> the function returns the #NUM! Error value

- If probability_s <0 or probability_s> 1 -> the function returns the #NUM! Error value

- Binomial probability function is:

[bleft ({x, n, p} right) = left ({begin {array} {* {20} {c}} n x end {array}} right) {p ^ N} {left ({1 - p } right) ^ {n - N}}]

Inside:

(left ({begin {array} {* {20} {c}} nx end {array}} right)): COMBIN (n, x).

- Cumulative binomial distribution function is:

[Bleft ({x, n, p} right) = sumlimits_ {y = 0} ^ N {bleft ({y, n, p} right)}]

For example:

Calculate the probabilities of the tests with the data in the table below:

- Calculate the probability of success in 8 of the 12 tests with a value of False. In the cell to calculate enter the formula : = BINOM. DIST (C6, C7, C8, C10)

- Press Enter -> probability of success is:

- Calculate the probability of success in 8 of the 12 tests with a value of True. In the cell to calculate enter the formula : = BINOM. DIST (C6, C7, C8, C9)

- Press Enter -> probability of success is:

So with different function defined values -> the function returns the same result.

Above are instructions and specific examples when using the BINOM. DIST function in Excel.

Good luck!