BETA.INV Function

The BETA.INV function is one of the statistical functions. It is used to return the inverse of the beta cumulative probability density function (BETA.DIST).

Syntax

BETA.INV(probability, alpha, beta, [A], [B])

The BETA.INV function has the following arguments:

Argument	Description
probability	A probability associated with the beta distribution. A numeric value greater than 0 and less than or equal to 1.
alpha	The first parameter of the distribution, a numeric value greater than 0.
beta	The second parameter of the distribution, a numeric value greater than 0.
A	The lower bound to the interval of probability. It is an optional parameter. If it is omitted, the default value of 0 is used.
B	The upper bound to the interval of probability. It is an optional parameter. If it is omitted, the default value of 1 is used.

Notes

How to apply the BETA.INV function.

Examples

The figure below displays the result returned by the BETA.INV function.