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:
- Force z in numeric format otherwise the function returns the #VALUE! Error value
For example:
Find the distribution of the value 6.6666666.
In the cell to be calculated enter the following formula: = NORMSDIST (D6) .
After pressing Enter the result is:
Thus the distribution of 6.6666666 is 1.
Above is a detailed guide for the NORMSDIST function.
Good luck!