Manuals/calci/NORMSDIST

NORMSDIST (Number,Accuracy)

• $Number$ is the value of the function .
• $Accuracy$ 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:$f(x)={\frac {1}{{\sqrt {2}}\pi }}.e^{-{\tfrac {x^{2}}{2}}}$
• This function will return the result as error when the $x$ value is non-numeric.

Examples

1. =NORMSDIST(4.74) = 0.9999975333
2. =NORMSDIST(5.0021) = 0.9999999738
3. =NORMSDIST(1.00006) = 0.8413586589
4. =NORMSDIST(12) = 1.0000002451499

Related Videos

NORMSDIST

See Also

• NORMDIST
• NORMINV
• NORMSINV

References

Normal distribution

• List of Main Z Functions

• Z3 home