Documentation/Calc Functions/BETAINV

Function name:
BETAINV

Category:
Statistical Analysis

Summary:
Returns the inverse of the cumulative beta probability density function.

Syntax:
BETAINV(Number; Alpha; Beta [; Start [; End]])

Returns:
Returns a real number such that if Number = BETADIST(P;A;B;S;E;TRUE), then BETAINV(Number;A;B;S;E) = P.

Arguments:
Number is a real number or a reference to the cell containing that number which is the probability associated with the beta distribution function so it is between 0(inclusive) and 1(inclusive).

Alpha is a real number or a reference to the cell containing that number which is a parameter to the distribution.

Beta is a real number or a reference to the cell containing that number which is a parameter to the distribution.

Start is a real number or a reference to the cell containing that number which is the lower bound for the result of this function.

End is a real number or a reference to the cell containing that number which is the upper bound for the result of this function.


 * If either of Alpha or Beta is negative or zero then the function returns an error value.
 * If Start is greater than End the function returns an error value.
 * If Number is less than 0 or greater than 1, then the function returns an error value.
 * If Start is not specified, the default value 0 is used.
 * If End is not specified, the default value 1 is used.

Additional details:
For more details on Inverted Beta distribution, visit Wikipedia.

Related LibreOffice functions:
BETA.INV

BETA.DIST

BETADIST

ODF standard:
Section 6.18.8, part 2

Equivalent Excel functions:
BETAINV