# Documentation/Calc Functions/BINOM.INV

Jump to navigation Jump to search

BINOM.INV

## Category:

Statistical Analysis

## Summary:

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a border probability.

## Syntax:

BINOM.INV(Trials; SP; Alpha)

## Returns:

Returns a real number.

## Arguments:

Trials is a positive integer value or a reference to a cell containing that value which is the total number of trials.

SP is a real number between 0 and 1(both inclusive) or a reference to a cell containing that number is the probability of success on each trial.

Alpha is a real number between 0 and 1(both inclusive) or a reference to a cell containing that number which is the border probability that is attained or exceeded.

• If Trials is a non-integer value, then the function truncates it to an integer.
• If Trials is less than zero, then the function returns an error value.
• If SP or Alpha are greater than 1 or less than 0, then the function returns an error value.

## Additional details:

• For more details th on inverse binomial distribution, visit Wikipedia.
• CRITBINOM and BINOM.INV performs the same function

## Examples:

Formula Description Returns
=BINOM.INV(8;0.6;0.9) the smallest value for which the cumulative binomial distribution is greater than or equal to 0.9. 7

None

BINOM.INV