Difference between revisions of "Manuals/calci/NORMSDIST"
Jump to navigation
Jump to search
Line 10: | Line 10: | ||
==Examples== | ==Examples== | ||
− | #NORMSDIST(4.74)=0.9999975333 | + | #=NORMSDIST(4.74) = 0.9999975333 |
− | #NORMSDIST(5.0021)=0.9999999738 | + | #=NORMSDIST(5.0021) = 0.9999999738 |
− | #NORMSDIST(1.00006)=0.8413586589 | + | #=NORMSDIST(1.00006) = 0.8413586589 |
− | #NORMSDIST(12)=1.0000002451499 | + | #=NORMSDIST(12) = 1.0000002451499 |
==See Also== | ==See Also== |
Revision as of 00:00, 7 January 2014
NORMSDIST(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