BINOM.INV(trials, probability_s, alpha)

Returns the probability of getting greater than a particular value in a binomial distribution.

trialsThe number of trials.
probability_sThe probability of a success on each trial.
alphaThe criterion value.

Remarks

* Added in Excel 2010.
* This function replaces the CRITBINOM function.
* The binomial distribution is a discrete distribution.
* You can use the BINOM.DIST function to return the probability of getting less than or equal to a particular value in a binomial distribution.
* For the Microsoft documentation refer to support.office.com

 A
1=BINOM.INV(6,0.5,9.38%) = 1.00
2=BINOM.INV(6,0.5,23.44%) = 2.00
3=BINOM.INV(6,0.5,BINOM.DIST(3,6,0.5,FALSE)) = 2.00
4=BINOM.INV(6,0.5,BINOM.DIST(3,6,0.5,TRUE)) = 3.00
5=BINOM.INV(6,0.5,0.75) = 4.00
6=BINOM.INV(4,0.5,0.75) = 3.00
7=BINOM.INV(4,0.5,0.9999) = 4.00
8=BINOM.INV(4,0.5,0.0001) = 0.00
9=BINOM.INV(4,0.5,-0.75) = #NUM!
10=BINOM.INV(4,-0.5,0.75) = #NUM!


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top