Difference between revisions of "Manuals/calci/NORMSDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 21: Line 21:
  
 
==References==
 
==References==
 +
[http://en.wikipedia.org/wiki/Normal_distribution Normal distribution ]

Revision as of 23:58, 6 January 2014

NORMSDIST(x)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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:Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 nonnumeric.

Examples

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

See Also

References

Normal distribution