Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1:  
<div style="font-size:30px">'''NORMSDIST(x)'''</div><br/>
 
<div style="font-size:30px">'''NORMSDIST(x)'''</div><br/>
 
*<math>x</math>  is the value of the function  
 
*<math>x</math>  is the value of the function  
      
==Description==
 
==Description==
*This function gives the Standard normal cumulative distribution function.
+
*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.
+
*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:<math> f(x)=\frac{1}{\sqrt 2 \pi}. e^{-{\tfrac{x^2}{2}}}</math>
+
*The equation for the Standard Normal Density function is:<math> f(x)=\frac{1}{\sqrt 2 \pi}. e^{-{\tfrac{x^2}{2}}}</math>
*This function will return the result as error when the x value is non-numeric.
+
*This function will return the result as error when the <math>x</math> value is non-numeric.
    
==Examples==
 
==Examples==
writer
5,435

edits

Navigation menu