NORMSDIST
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.SyntaxNORMSDIST(z)Z is the value for which you want the distribution.ResIf z is nonnumeric, NORMSDIST returns the #VALUE! error value.
The equation for the standard normal density function is:
ExampleNORMSDIST(1.333333) equals 0.908789
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.SyntaxNORMSDIST(z)Z is the value for which you want the distribution.ResIf z is nonnumeric, NORMSDIST returns the #VALUE! error value.
The equation for the standard normal density function is:
ExampleNORMSDIST(1.333333) equals 0.908789
P(x) = 1 -Z(x)*(b1*t+b2*t^2+b3t^3+b4t^4+b5t^5)+error(x), where Z(x) = (1/(sqrt(2*pi()))*exp(-x^2/2))
t = 1/(1+px)
p = 0.2316419
b1 = 0.319381530
b2 = -0.356563782
b3 = 1.781477937
b4 = -1.821255978
b5 = 1.330274429
with these parameters, abs(error(x))<7.5 * 10^-8.
The NORMSDIST function returns the result of the standard normal cumulative distribution function (CDF) for a standard normal random variable Z with a mean of 0 and a standard deviation of 1. The CDF is found by taking the integral of the standard normal probability density function, Z(x) = (1/(sqrt(2*pi()))*exp(-x^2/2)), from negative infinity to the value, z, of the random variable in question. The result.of the integral gives the probability that Z will occur between the values of negative infinity and z.