# BINOM.INV

BINOM.INV(trials, probability_s, alpha)

Returns the number of trials needed for a specific amount of success using a binomial distribution.

 trials The total number of trials. probability_s The probability of a success on each trial. alpha The cumulative probability you want to find.

 REMARKS
 * This function was added in Excel 2010 to replace the CRITBINOM function.* For an illustrated example refer to the page under Distributions* The binomial distribution is a discrete distribution* This function will return the smallest number of trials needed for which the cumulative distribution is greater than or equal to "alpha".* If any of the arguments are not numeric, then #VALUE! is returned.* If "trials" is not an integer, it will be truncated.* If "trials" < 0, then #NUM! is returned.* If "probability_s" < 0, then #NUM! is returned.* If "probability_s" > 1, then #NUM! is returned.* If "alpha" < 0, then #NUM! is returned.* If "alpha" > 1, then #MUM! is returned.* You can use the BINOM.DIST function to return the probability of getting a specific number of successes using a binomial distribution.* You can use the BINOM.DIST.RANGE function to * You can use the NEGBINOM.DIST function to* For the Microsoft documentation refer to support.microsoft.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!