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:

See Also

Concepts

WorksheetFunction Object

WorksheetFunction Object Members