BETA.INV

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.

  1. Weisstein, Eric W. "Beta Distribution." From MathWorld--A Wolfram Web Resource. https://mathworld.wolfram.com/BetaDistribution.html