Buzz
This article provides a detailed guide on using the NORMSDIST function – the function that returns the standardized cumulative distribution in Excel.
Description: The function returns a standardized cumulative distribution with a mean of 0 and a standard deviation of 1. Its purpose is to replace tables containing normalized curves.
Syntax: NORMSDIST(z).
In this context:
- z represents the value to determine the distribution, serving as a mandatory parameter.
Note:
- The method for calculating the value of the NORMSDIST function:
- It is mandatory for z to be in numerical format; otherwise, the function will return a #VALUE! error.
Example:
Find the distribution of the value 6.6666666.
In the cell where calculation is required, input the following formula: =NORMSDIST(D6).
Upon pressing Enter, the result is:
Thus, the distribution of 6.6666666 is 1.
The above provides detailed guidance on the NORMSDIST function.
Wishing you all success!
