WorksheetFunction.CritBinom method (Excel)

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

Syntax

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

Remarks

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.