NORMSDIST function - The function returns the normal cumulative distribution in Excel

The following article details how to use the NORMSDIST function - the function returns the cumulative normal distribution in excel.

Description: The function returns a normalized cumulative distribution, whose distribution has a mean of 0 and a standard deviation of 1. The purpose of the function is to replace tables containing normalized curves.

Syntax: NORMSDIST (z) .

Inside:

- z is the value to determine the distribution, is a required parameter.

Attention:

- How to calculate the value of the NORMSDIST function:

NORMSDIST function - The function returns the normal cumulative distribution in Excel Picture 1

- Force z in numeric format otherwise the function returns the #VALUE! Error value

For example:

Find the distribution of the value 6.6666666.

NORMSDIST function - The function returns the normal cumulative distribution in Excel Picture 2

In the cell to be calculated enter the following formula: = NORMSDIST (D6) .

NORMSDIST function - The function returns the normal cumulative distribution in Excel Picture 3

After pressing Enter the result is:

NORMSDIST function - The function returns the normal cumulative distribution in Excel Picture 4

Thus the distribution of 6.6666666 is 1.

Above is a detailed guide for the NORMSDIST function.

Good luck!