Products, services, and OS functions
may not be available in this country.

BETAINV

The BETAINV function returns the inverse of the given cumulative beta distribution probability value. All arguments are number values.

BETAINV(probability, alpha, beta, x-lower, x-upper)

probability: The probability associated with the distribution. probability must be greater than 0 and less than 1.

alpha: One of the shape parameters of the distribution. alpha must be greater than 0.

beta: One of the shape parameters of the distribution. beta must be greater than 0.

x-lower: An optional lower limit or bound for the specified x value or probability. x-lower must be less than or equal to probability. If x-lower is omitted, 0 is used.

x-upper: An optional upper limit or bound for the specified x value or probability. x-upper must be greater than or equal to probability. If x-upper is omitted, 1 is used.

Examples

=BETAINV(0.5, 1, 2, 0.3, 2) returns 0.797918471982869.

=BETAINV(0.99, 1, 2, 0, 1) returns 0.9.

=BETAINV(0.1, 2, 2, 0, 2) returns 0.391600211318183.

See alsoBETADIST
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.