Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server BETA.INV function


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
·         BETA - Beta function

 



Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service