Name
CRITBINOM
Synopsis
Use
CRITBINOM to find the smallest value where
the cumulative binomial distribution is greater than or equal to the
value specified for the Alpha
argument,
which measures the probability of making a type 1 error in hypothesis
testing. This function is typically used
in quality assurance applications.
To Calculate
=CRITBINOM(Trials
,Probability_S
,Alpha
)
All arguments are required for this function.
-
Trials
Specifies a numeric value that indicates the number of Bernoulli trials. If the value specified is not an integer, it is truncated by the function.
-
Probability_S
Specifies a decimal value between and 1 that indicates the probability of success for each trial.
-
Alpha
Specifies a decimal value between and 1 that indicates the criterion value.
Example
Figure 15-10 illustrates how CRITBINOM is used to find the minimum number of successes. For example, if these were tests on new products, the result would be the minimum number of successes allowed for each product.
Figure 15-10. Use CRITBINOM to determine the minimum number of successes allowed for the specified number of trials
Get Excel 2000 in a Nutshell 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.