Returns the inverse of the beta distribution[1].
Syntax:
BETA.INV( probability:Number, alpha:Number, beta:Number {, lower_limit:Number {, upper_limit:Number} } } )
For the given probability in [0,1], returns the corresponding x-value which yields that probability in the cumulative distribution function for the beta distribution with given alpha and beta shape parameters.
If lower_limit is omitted the standard beta distribution lower limit of zero is used.
If upper_limit is omitted the standard beta distribution upper limit of one is used.
If given, these parameters are used to scale and shift the standardized result from [0,1] into [lower_limit,upper_limit].
Revisions:
This function was added in Fireworkz 2.00.