Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server upper cdf of the GAMMA distribution function


 
Updated: 9 August 2010
Use GAMMAQ to calculate the regularized gamma function Q(a, x). The equation for this function is:
 
 GAMMAQ
Where 
GAMMAQ
Syntax
SELECT [wctStatistics].[wct].[GAMMAQ] (
   <@A, float,>
 ,<@X, float,>)
Arguments
@A
a value to be passed to the function. @A is an expression of type float or of a type that can be implicitly converted to float
@X
a value to be passed to the function. @X is an expression of type float or of a type that can be implicitly converted to float
Return Types
float
Remarks
·         If @A < 0 or @X < 0, GAMMAQ returns an error.
·         GAMMAP(@A, @X) + GAMMAQ(@A, @X) = 1
Examples

Select
wct.GAMMAQ(5,2)

This produces the following result
----------------------
0.947346982712349
 
(1 row(s) affected)
 

Select
wct.GAMMAINC(5,2)/wct.gamma(5)

This produces the following result
----------------------
0.947346982712349
 
(1 row(s) affected)
 

Select
wct.GAMMAP(5,2)+wct.GAMMAQ(5,2)

This produces the following result
----------------------
1
 
(1 row(s) affected)
See Also
·         BETADIST - beta distribution


Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service