Difference between revisions of "Manuals/calci/NORMSDIST"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
<div style="font-size:30px">'''NORMSDIST(x)'''</div><br/> | <div style="font-size:30px">'''NORMSDIST(x)'''</div><br/> | ||
*<math>x</math> is the value of the function | *<math>x</math> is the value of the function | ||
− | |||
==Description== | ==Description== | ||
− | *This function gives the Standard | + | *This function gives the Standard Normal Cumulative Distribution function. |
− | *In | + | *In Normal Distribution formula, if the Mean is zero and the Standard Deviation is 1, then it is called Standard Normal Distribution. |
− | *The equation for the | + | *The equation for the Standard Normal Density function is:<math> f(x)=\frac{1}{\sqrt 2 \pi}. e^{-{\tfrac{x^2}{2}}}</math> |
− | *This function will return the result as error when the x value is non-numeric. | + | *This function will return the result as error when the <math>x</math> value is non-numeric. |
==Examples== | ==Examples== |
Revision as of 00:41, 22 January 2014
NORMSDIST(x)
- is the value of the function
Description
- This function gives the Standard Normal Cumulative Distribution function.
- In Normal Distribution formula, if 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 value is non-numeric.
Examples
- =NORMSDIST(4.74) = 0.9999975333
- =NORMSDIST(5.0021) = 0.9999999738
- =NORMSDIST(1.00006) = 0.8413586589
- =NORMSDIST(12) = 1.0000002451499