XLeratorDB/statistics Documentation
NORM_S_DIST
Updated: 31 July 2015
Use NORM_S_DIST to calculate the probability density or the lower cumulative probability of the standard normal distribution (mean = 0, standard deviation = 1).
Syntax
SELECT [wct].[NORM_S_DIST](
<@X, float,>
,<@Cumulative, bit,>)
Arguments
@X
The value of interest to be evaluated. @X must be of a type float or of type that intrinsically converts to float.
@Cumulative
A bit value indicating whether the probability density function ('False') or the cumulative distribution function ('True') should be returned.
Return Type
float
Examples
In this example we calculate the probability density function of the standard normal distribtuion at 1.96.
SELECT
wct.NORM_S_DIST(
1.96 --@X
,'False' --@cumulative
) as pdf
This produces the following result
Using the same data. we calculate the cumulative distribution function.
SELECT
wct.NORM_S_DIST(
1.96 --@X
,'True' --@cumulative
) as cdf
This produces the following result.
See Also