BETAINV
Updated: 31 July 2015
Use BETAINV to calculate the quartiles of the beta cumulative distribution function.
Syntax
SELECT [wct].[BETAINV](
<@Probability, float,>
,<@Alpha, float,>
,<@Beta, float,>
,<@A, float,>
,<@B, float,>)
Arguments
@Probability
The quartile to be evaluated. @Probability must be of a type float or of type that intrinsically converts to float.
@Alpha
The first shape parameter for the distribution. @Alpha must be of a type float or of a type that intrinsically converts to float.
@Beta
The second shape parameter for the distribution. @Beta must be of a type float or of a type that intrinsically converts to float.
@A
The lower bound of the interval for @X. @A must be of a type float or of a type that intrinsically converts to float.
@B
The upper bound of the interval for @X. @B must be of a type float or of a type that intrinsically converts to float.
Return Type
float
Remarks
· @Alpha > 0
· @Beta > 0
· If @A = @B Then NULL is returned
· If @A is NULL then @A = 0
· If @B is NULL then @B = 1
Examples
In this example we calculate the 95th percentile of a beta cumulative distribution function.
SELECT
wct.BETAINV(
0.95 --@Probability
,8 --@Alpha
,10 --@Beta
,1 --@A
,3 --@B
) as BETAINV
This produces the following result
See Also