WorksheetFunction.Norm_S_Dist Method (Excel)
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
Version Information
Version Added: Excel 2010
Syntax
expression .Norm_S_Dist(Arg1)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Double |
Z - The value for which you want the distribution. |
Arg2 |
Optional |
Variant |
Cumulative - A logical value that determines the form of the function. If cumulative is TRUE, NORM_S_DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function. |
Return Value
Double
Remarks
If z is non-numeric, NORM_S_DIST returns the #VALUE! error value.
The equation for the standard normal density function is:
.gif "Ff840462.awfnrmsd_ZA06051214(en-us,office.14).gif")