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 

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