Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server GAMMALN function


 
Updated: 9 August 2010

Use GAMMALN to calculate the natural logarithm of the (complete) gamma function Γ(x). This is equivalent of Log[Gamma[z]] in Mathematica. The GAMMA function is an extension of the factorial function to real and complex numbers. For a complex number z with a positive real part the GAMMA function is defined by
GAMMALN
 
And the GAMMALN function as 
GAMMALN
Syntax
SELECT [wctStatistics].[wct].[GAMMALN] (
   <@Z, float,>)
Arguments
@Z
is any real number. @Z is an expression of type float or of a type that can be implicitly converted to float
Return Types
float
Remarks
·         If @Z is less than or equal to zero, GAMMALN will return an error.
Examples

SELECT
wct.GAMMALN(10)

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

SELECT
wct.GAMMALN(7.5)
 

This produces the following result
----------------------
7.53436423675873
 
(1 row(s) affected)
See Also
·         FACT - factorial
·         BICO - binomial coefficient


Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service