O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required