Description Computes the inverse of the BETADIST function.
Syntax BETAINV(probability, alpha, beta [, A] [, B])
| Argument | Description |
|---|---|
| probability | The probability, as obtained from the BETADIST function. It must be a number between zero and 1 that represents a probability. |
| alpha | The parameter to the beta function. It must be a number greater than zero. |
| beta | A second parameter to the beta function. It must be a number greater than zero. |
| [A] | Optional. The lower bound to the interval of x. It must be a number smaller than x and B. If this argument is omitted, 0 is used. |
| [B] | Optional. The upper bound to the interval of x. It must be a number larger than x and A. If this argument is omitted, 1 is used. |
Examples This function returns 2:
This function returns 0.5:
This function returns 0.5:
See Also BETADIST
