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).

SELECT [wct].[NORM_S_DIST](

<@X, float,>

,<@Cumulative, bit,>)

The value of interest to be evaluated. *@X* must be of a type **float** or of type that intrinsically converts to **float**.

A **bit** value indicating whether the probability density function ('False') or the cumulative distribution function ('True') should be returned.

float

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.