Expand Minimize

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 Added: Excel 2010

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

  • If z is non-numeric, NORM_S_DIST returns the #VALUE! error value.

  • The equation for the standard normal cumulative distribution function is:

    abbf5ae3-a27b-4e9c-eff8-009885a4ccf2

Show:
© 2015 Microsoft