NORM_S_DIST

Updated 2023-11-03 21:57:21.813000

Syntax

SELECT [westclintech].[wct].[NORM_S_DIST](
  <@X, float,>
 ,<@Cumulative, bit,>)

Description

Use the scalar function NORM_S_DIST to calculate the probability density or the lower cumulative probability of the standard normal distribution (mean = 0, standard deviation = 1).

Arguments

@Cumulative

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

@X

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

Return Type

float

Examples

In this example we calculate the probability density function of the standard normal distribution at 1.96.

SELECT wct.NORM_S_DIST(   1.96,   --@X
                          'False' --@cumulative
                      ) as pdf;

This produces the following result.

{"columns":[{"field":"pdf","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"pdf":"0.0584409443334515"}]}

Using the same data. we calculate the cumulative distribution function.

SELECT wct.NORM_S_DIST(   1.96,  --@X
                          'True' --@cumulative
                      ) as cdf;