Calculates values of the cumulative distribution function for the standard normal distribution. The standard normal distribution has a mean of zero and a standard deviation of one. It is GAUSS(x)=NORMSDIST(x)-0.5
Returns a real number in the range [0, 1] which is the value of the cumulative distribution function for the standard normal distribution for the specified value.
Number is a real number or a reference to the cell containing that number which is the value for which the standard normal distribution is to be calculated.
- The formula for NORMSDIST is:
- this is exactly NORMDIST(x;0;1;TRUE()).
- For more details on the standard normal distribution, visit Wikipedia.
|=NORMSDIST(1)||The area below the standard normal distribution curve to the left of X value 1 is around 84% of the total area.||0.841344746068543|
|=NORMSDIST(7.14)||Calculates the cumulative distribution function of the standard normal distribution for the given value.||0.999999999999533|
|=NORMSDIST(-7.14)||Calculates the cumulative distribution function of the standard normal distribution for the given value.||4.66654595751322E-13|
Related LibreOffice functions:
Equivalent Excel functions: