XLeratorDB/statistics Documentation
Updated: 30 May 2017
Use the SQL Server scalar function GAMMA to calculate Γ(z). The GAMMA function can be defined as a definite integral for R[z] > 0.
Syntax
SELECT [wct].[GAMMA] (
<@Z, float,>)
Arguments
| Input Name | Definition |
| @z | The value of interest |
Return Type
Remarks
Examples
Example #1
SELECT wct.GAMMA(2.5) as Gamma
This produces the following result.
Example #2
SELECT wct.GAMMA(-3.75) as Gamma
This produces the following result.
Example #3
The following SQL can be run using the SeriesFloat function to create GAMMA values from -4 to 4 which can then be pasted into Excel and graphed.
SELECT
z,
wct.GAMMA(z) as Gamma
FROM (
SELECT
SeriesValue as z
FROM
wct.SeriesFloat(-4,4,0.01,NULL,NULL)
)n
This produces the following result.
See Also