BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel

Attention:

- If any values ​​of arguments are not whole numbers -> they are truncated to integers.

- If any argument is out of bounds -> the function returns the #NUM! Error value .

- 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 

- The function uses the equation:

[sumlimits_ {k = S} ^ {S2} {left ({begin {array} {* {20} {c}} N k end {array}} right) {p ^ k} {{left ({1 - p } right)} ^ {N - k}}}]]

Inside:

N is the test, p is the probability of success, s is number_s, s2 is number_s2.

For example:

Calculate the probability of success of the tests with the data in the following table:

BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel Picture 2

- Calculate the binomial distribution based on the successful 52 times of 92 tests . In the cell to calculate enter the formula : = BINOM.DIST.RANGE (C6, C7, C8)

BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel Picture 3

- Press Enter -> probability of success is:

BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel Picture 4

- Calculate the binomial distribution based on the successful 52 to 65 times of 92 tests . In the cell to calculate enter the formula : = BINOM.DIST.RANGE (C6, C7, C8,65)

BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel Picture 5

- Press Enter -> probability of success is:

BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel Picture 6

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

Good luck!