Export (0) Print
Expand All
Expand Minimize

2.1.993 Part 1 Section 18.17.7.231, NORMSDIST

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:

Ff532284.9166c3ca-1f2a-4f01-a01b-09bee3070f28(en-us,office.12).jpg

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.

Show:
© 2014 Microsoft