GAMMALN

Updated: 30 May 2017

Use the SQL Server scalar function GAMMALN to calculate the natural logarithm of Γ(z). The GAMMA function can be defined as a definite integral for R[z] > 0.

Syntax

SELECT [wct].[GAMMALN] (

<@Z, float,>)

Arguments

Input Name | Definition |

@z | The value of interest |

Return Type

float

Remarks

- GAMMA is undefined for negative integers.
- GAMMA is undefined at zero.
- Available in XLeratorDB / statistics 2008 only

Examples

Example #1

SELECT wct.GAMMALN(2.5) as Gammaln

This produces the following result.

Example #2

SELECT wct.GAMMA(-3.75) as Gammaln

This produces the following result.

Example #3

The following SQL can be run using the SeriesFloat function to create GAMMALN values from -4 to 4 which can then be pasted into Excel and graphed.

SELECT

z,

wct.GAMMALN(z) as Gammaln

FROM (

SELECT

SeriesValue as z

FROM

wct.SeriesFloat(-4,4,0.01,NULL,NULL)

)n

This produces the following result.

See Also