Documentation/Calc Functions/BINOM.INV

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

Related LibreOffice functions:
BINOM.DIST

BINOMDIST

B

CRITBINOM

ODF standard:
None

Equivalent Excel functions:
BINOM.INV