Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server gamma function


 
Updated: 9 August 2010

Use GAMMA to invoke the (complete) gamma function Γ(x). This is equivalent of 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
 
 GAMMA
Syntax
SELECT [wctStatistics].[wct].[GAMMA] (
   <@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 ≤, GAMMA will return an error.
Examples

Select
wct.GAMMA(10)

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

Select
wct.GAMMA(7.5)
 

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


Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service