Documentation/Calc Functions/BETA.INV

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

BETA.INV

Category:

Statistical Analysis

Summary:

Returns the inverse of the cumulative beta probability density function.

Syntax:

BETA.INV(Number; Alpha; Beta [; Start [; End]])

Returns:

Returns a real number such that if Number = BETA.DIST(P;A;B;TRUE();S;E), then BETA.INV(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.

Examples:

Formula Description Returns
=BETA.INV(0.5;5;10) The function calculates the inverse of the cumulative beta probability density function 0.325751155286213
=BETA.INV(0.5;3;4;3;4) The function calculates the inverse of the cumulative beta probability density function. This can be alternatively considered as =BETA.DIST(3.42140719069071;3;4;TRUE();3;4) gives 0.5 3.42140719069071
=BETA.INV(3.5,3,4,3,4) The Number is not between 0 and 1 so the function returns an error value. Err:502

Related LibreOffice functions:

BETAINV

BETA.DIST

BETADIST

ODF standard:

None

Equivalent Excel functions:

BETA.INV