XLeratorDB/statistics Documentation
NORMSDIST
Updated: 01 February 2009
Use NORMSDIST to calculate the standard normal cumulative distribution function. The equation for the cumulative distribution function is:
Syntax
SELECT [wctStatistics].[wct].[NORMSDIST] (
<@X, float,>)
Arguments
@X
is the value at which to evaluate the function. @X is an expression of type float or of a type that can be implicitly converted to float.
Return Types
float
Examples
select wct.NORMSDIST(1)
This produces the following result
----------------------
0.841344746068543
(1 row(s) affected)
select wct.NORMSDIST(-1)
This produces the following result
----------------------
0.158655253931457
(1 row(s) affected)
select wct.NORMSDIST(1)-wct.NORMSDIST(-1)
This produces the following result
----------------------
0.682689492137086
(1 row(s) affected)
See Also