Difference between revisions of "Manuals/calci/NORMSDIST"

From ZCubes Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''NORMSDIST(x)'''</div><br/>
+
<div style="font-size:30px">'''NORMSDIST (Number,Accuracy)'''</div><br/>
*<math>x</math>  is the value of the function  
+
*<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==

Latest revision as of 16:22, 10 August 2018

NORMSDIST (Number,Accuracy)


  • 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 Number} is the value of the function .
  • 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 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: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 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} 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

References

Normal distribution