Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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.image024(en-us,office.12).png

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:
© 2016 Microsoft