WorksheetFunction.CritBinom (Excel)

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

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.

CritBinom (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblCritBinom As Double
dblCritBinom = WorksheetFunction.CritBinom(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3)


Arg1, Arg2, Arg3

Arg1 (Double) - The number of Bernoulli trials.

Arg2 (Double) - The probability of a success on each trial.

Arg3 (Double) - The criterion value.