Difference between revisions of "Manuals/calci/NORMSDIST"
Jump to navigation
Jump to search
Line 6: | Line 6: | ||
*This function gives the Standard normal cumulative distribution function. | *This function gives the Standard normal cumulative distribution function. | ||
*In normal distribution formula, when the mean is zero and the standard deviation is 1 then it is called Standard normal distribution. | *In normal distribution formula, when the mean is zero and the standard deviation is 1 then it is called Standard normal distribution. | ||
− | *The equation for the standard normal density function is:<math> f(x)=\frac{1}{\sqrt | + | *The equation for the standard normal density function is:<math> f(x)=\frac{1}{\sqrt 2 \pi}. e^-{\frac{x^2}{2}}</math> |
*This function will return the result as error when the x value is nonnumeric. | *This function will return the result as error when the x value is nonnumeric. | ||
Revision as of 03:21, 2 January 2014
NORMDIST(x)
- is the value of the function
Description
- This function gives the Standard normal cumulative distribution function.
- In normal distribution formula, when the mean is zero and the standard deviation is 1 then it is called Standard normal distribution.
- The equation for the standard normal density function is:
- This function will return the result as error when the x value is nonnumeric.
Examples
- NORMSDIST(4.74)=0.9999975333
- NORMSDIST(5.0021)=0.9999999738
- NORMSDIST(1.00006)=0.8413586589
- NORMSDIST(12)=1.0000002451499