Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

WorksheetFunction.CritBinom Method (Excel)

Published: July 16, 2012

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

expression .CritBinom(Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

The number of Bernoulli trials.

Arg2

Required

Double

The probability of a success on each trial.

Arg3

Required

Double

The criterion value.

Return Value

Double

Use this function for quality assurance applications. For example, use CritBinom to determine the greatest number of defective parts that are allowed to come off an assembly line run without rejecting the entire lot.

  • If any argument is nonnumeric, CritBinom generates an error.

  • If trials is not an integer, it is truncated.

  • If trials < 0, CritBinom generates an error.

  • If probability_s is < 0 or probability_s > 1, CritBinom generates an error.

  • If alpha < 0 or alpha > 1, CritBinom generates an error.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.