<< Click to Display Table of Contents >> BINOM.INV (binomial distribution) |
Syntax:
BINOM.INV(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%?
BINOM.INV(100, 7%, 1%) returns 2
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.
See also: