BETAINV Function

The BETAINV function is one of the statistical functions. It is used to return the inverse of the cumulative beta probability density function for a specified beta distribution.

Syntax

BETAINV(probability, alpha, beta, [A], [B])

The BETAINV 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 BETAINV function.

Examples

The figure below displays the result returned by the BETAINV function.

BETAINV Function