BINOM.INV()/CRITBINOM()
Syntax. BINOM.INV(trials;probability_s;alpha)
Definition. This function returns the smallest value for which the cumulative binomial distribution is greater than or equal to the specified probability. Use this function for quality assurance applications. For example, use the BINOM.INV() function to determine the largest number of defective parts that are allowed to come off an assembly line run without rejecting the entire lot.
Arguments
trials (required). The number of Bernoulli trials
probability_s (required). The probability for the success of each trial
alpha(required). The cumulative binomial probability
Note
If one of the arguments isn’t a numeric value, the BINOM.INV() function returns the #VALUE!
error.
If trials isn’t ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.