Returns the inverse of the cumulative beta probability density function.
Sample Usage
BETAINV(0.3,5,1)
BETAINV(C2,C3,C4,C5,C6)
Syntax
BETAINV(probability, alpha, beta, [start], [end])
- probability - The probability at which to evaluate the function.
- alpha - A parameter to the distribution.
- beta - A parameter to the distribution.
- start - [OPTIONAL] The lower bound for the number.
- end - [OPTIONAL] The upper bound for the number.
Examples
BETAINV(0.3,5,1) returns a value of 0.786.
BETAINV(C2,C3,C4,C5,C6) returns the inverse of the cumulative beta probability density function for the given parameters.
Notes
- probabilty must be between 0 and 1, inclusive.
- alpha and beta must be positive.
- start and end default to 1 if left unspecified.