Collapse the table of content
Expand the table of content
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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

Show:
© 2016 Microsoft