2.1.1002 Part 1 Section 18.17.7.231, NORMSDIST

  • Article

a.   The standard states that the function returns the standard normal distribution for the specified mean and standard deviation.

Office returns the cumulative standard normal distribution for the specified value.

b.   The standard states that the mathematical formula for the function is: f(z)= (1/√2π) e^(-z^2/2).

In Excel, the NORMSDIST function is described by the following mathematical formula:

Formula describing NORMSDIST function: function of z = the integral from minus infinity to z of 1 over square root of 2 pi times e to the minus x squared over 2 dx.

c.   The standard states that the return value is the standard normal distribution for the specified mean and standard deviation.

Office returns the cumulative standard normal distribution.