BINOM.INV (binomial distribution)

<< 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:

CRITBINOM, BINOM.DIST/BINOM.DIST.RANGE/BINOMDIST