Statistical - NORM.S.DIST Function

Description

The NORM.S.DIST function returns the standard normal distribution (has a mean of zero and a standard deviation of one). Use this function in place of a table of standard normal curve areas.

Syntax

NORM.S.DIST (z,cumulative)

Arguments

Argument	Description	Required/ Optional
Z	The value for which you want the distribution.	Required
Cumulative	Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function. If cumulative is FALSE, NORMS.DIST returns the probability mass function.	Required

Argument

Description

Required/ Optional

The value for which you want the distribution.

Required

Cumulative

Cumulative is a logical value that determines the form of the function.

If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function.

If cumulative is FALSE, NORMS.DIST returns the probability mass function.

Required

Notes

The equation for the standard normal density function is −

$$f\left ( z \right )=\frac{1}{\sqrt{2x}}e^-\frac{z^2}{2}$$
If z is nonnumeric, NORM.S.DIST returns the #VALUE! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016.

Example

advanced_excel_statistical_functions.htm