CRITBINOM(trials, probability_s, alpha) 
Returns the probability of getting greater than a particular value in a binomial distribution. 
trials  The number of independent trials. 
probability_s  The probability of a success on each trial. 
alpha  The probability for the criteria. 
Remarks 
* BINOM.INV was added in Excel 2010 to replace this function. * The binomial distribution is a discrete distribution. * This function assumes a cumulative probability function. * If "trials" < 0, then #NUM! is returned. * If "trials" is not an integer, it is truncated. * If "trials" is not numeric m then #VALUE! is returned. * If "probability_s" < 0, then #NUM! is returned. * If "probability_s" > 1, then #NUM! is returned. * If "probability" is not numeric, then #VALUE! is returned. * If "alpha" <= 0, then #NUM! is returned. * If "alpha" >= 1, then #NUM! is returned. * If "alpha" is not numeric, then #VALUE! is returned. * In Excel 2010 the accuracy of this function was improved. * For the Microsoft documentation refer to support.office.com 

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