Documentation/Calc Functions/BINOM.INV
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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
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 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
BINOM.INV