Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server NORM_S_DIST function 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

 



Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service