<< Click to Display Table of Contents >> BINOM.INV (binomial distribution) |
Syntax:
BINOM.INV(n, p, Alpha)
Description:
This returns the smallest value for which the cumulative binomial distribution is greater than or equal to the criterion value Alpha.
You thus calculate the maximum number of times a certain event with probability p may occur 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); thus, they must be independent draws where only two outcomes are possible: success (event occurs) or failure (event does not occur).
n is the number of independent trial runs.
p is the probability of the success of each trial run. The values must be within the range 0 to 1.
Alpha is the probability of error that must not be exceeded. The values must be within the range 0 to 1.
Example:
You know from previous deliveries that 7% of a certain electronic component is usually defective. To check this statement, you carry out a sample of 100 components for a new delivery. What is the maximum number of them that can be defective if the probability of error 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. The function is unknown in older versions.
See also: