Documentation/Calc Functions/CRITBINOM

Function name:
CRITBINOM

Category:
Statistical Analysis

Summary:
Returns the smallest number for which the cumulative binomial distribution value is greater than or equal to the given criterion value.

Syntax:
CRITBINOM(Trials; SP; Alpha)

Returns:
Returns a real number.

Arguments:
Trials is a non-negative integer value or a reference to the cell containing that value which is the total number of trials.

SP is a real number between 0 and 1 or a reference to the cell containing that value which is the probability of success for one trial only.

Alphais a real number between 0 and 1 or a reference to the cell containing that value which is the threshold probability to be reached 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 on inverse binomial distribution, visit Wikipedia.
 * CRITBINOM and BINOM.INV performs the same function

Related LibreOffice functions:
BINOM.INV

ODF standard:
Section 6.18.19, part 2

Equivalent Excel functions:
CRITBINOM