Sunday, February 25, 2018

NORMSDIST function

NORMSDIST function

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.

Syntax

NORMSDIST(z)

Z     is the value for which you want the distribution.

Remarks

  • If z is nonnumeric, NORMSDIST returns the #VALUE! error value.

  • The equation for the standard normal density function is:

    Equation

Example

Formula

Description (Result)

=NORMSDIST(1.333333)

Normal cumulative distribution function at 1.333333 (0.908789)

No comments:

Post a Comment