|
<< Click to Display Table of Contents >> CRITBINOM (binomial distribution) |
Note: CRITBINOM is supplemented by the new identical function BINOM.INV, which is available in newer versions of Microsoft Excel (2010 or later).
Syntax:
CRITBINOM(n, p, Alpha)
Description:
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to the criterion value Alpha.
It is thus calculated how many times a certain event with probability p may occur at most when performing a sample with n repetitions before its cumulative probabilities assume a value greater than or equal to the error probability Alpha.
This function is applicable for binomial distributions only (see also BINOM.DIST/BINOMDIST function); therefore, the drawings must be independent with only two possible outcomes: success (event occurs) or failure (event does not occur).
n is the number of independent trial runs.
p is the probability of a success for each trial run. Must be in the range 0 to 1.
Alpha is the criterion value that must be not exceeded. Must be in the range 0 to 1.
Example:
You know from previous deliveries that normally 7% of a certain electronic component is defective. To check this statement, you carry out a sample of 100 components for a new delivery. What is the maximum number of defects that may be present if the error probability is not to exceed 1%?
CRITBINOM(100, 7%, 1%) returns 2
See also: