BINOM.INV (binomial distribution)

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

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