次の方法で共有


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: Ff840462.awfnrmsd_ZA06051214(en-us,office.14).gif

See Also

Concepts

WorksheetFunction Object

WorksheetFunction Object Members