Difference between revisions of "Manuals/calci/NORMSDIST"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''NORMSDIST( | + | <div style="font-size:30px">'''NORMSDIST (Number,Accuracy)'''</div><br/> |
− | *<math> | + | *<math>Number</math> is the value of the function . |
+ | *<math>Accuracy</math> is correct decimal places for the result. | ||
+ | **NORMSDIST(),returns the standard normal cumulative distribution | ||
+ | |||
==Description== | ==Description== |
Revision as of 17:12, 14 June 2018
NORMSDIST (Number,Accuracy)
- is the value of the function .
- is correct decimal places for the result.
- NORMSDIST(),returns the standard normal cumulative distribution
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
Related Videos
See Also
References