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!