NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel

The following article introduces you to the NORM.S.DIST function - one of the functions in the statistical function group is very popular in Excel.

NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel Picture 1

Description: The normalized distribution function has a mean of 0 and a standard deviation of 1. Use the function instead of a table containing normalized curve areas. Support functions from Excel 2010 onwards.

Syntax: NORM.S.DIST (z, cumulative)

Inside:

- z: The value you want to calculate the distribution, is a required parameter .

- cumulative: A logical value that determines the form of the function, which is a required parameter, including:

+ cumulative = True -> returns the cumulative distribution function.

+ cumulative = False -> returns the probability density function.

Attention:

- If z is not a number -> the function returns the #VALUE! Error value

- The equation for the standardized density function is:

[fleft (z right) = frac {1} {{sqrt {2pi}}} {e ^ {- frac {{{z ^ 2}}} {2}}}]

For example:

Find the normalized distribution of values ​​in the following data table:

NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel Picture 2

- Calculate the value of standardized cumulative distribution function (corresponding to True value ) In a cell to calculate, enter the formula : = NORM.S.DIST (D6, D7)

- Press Enter -> standard cumulative distribution function value is:

NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel Picture 3

- Calculate the value of the standard probability distribution function (corresponding to the value of False). In a cell to calculate, enter the formula : = NORM.S.DIST (D6, D8)

NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel Picture 4

- Press Enter -> the standard probability distribution function value is:

NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel Picture 5

Above are instructions and some specific examples when using the NORM.S.DIST function in Excel.

Good luck!