Difference between revisions of "Manuals/calci/NORMSINV"

Revision as of 00:11, 7 January 2014

NORMSINV(prob)

This function gives the inverse of the Standard Normal Cumulative Distribution.
In Normal Distribution formula, when the Mean is zero and the Standard Deviation is 1 then it is called Standard Normal Distribution.
If $NORMSDIST(x)=prob$ , then $NORMSINV(prob)=x$ .
$NORMSINV$ using the iterating method to find the value of x.
Suppose the iteration has not converged after 100 searches, then the function gives the error result.
In $NORMSINV(prob)$ , where prob is the probability value of the standard normal cumulative distribution.
This function will return the result as error when

1. $prob$  is non-numeric.
2. $prob<0$  or  $prob>1$ .

@@ Line 3: / Line 3: @@
 ==Description==
-*This function gives the inverse of the standard normal cumulative distribution.
+*This function gives the inverse of the Standard Normal Cumulative Distribution.
-*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, when the Mean is zero and the Standard Deviation is 1 then it is called Standard Normal Distribution.
 *If <math> NORMSDIST(x)=prob</math>, then <math>NORMSINV(prob)=x</math>.
 *<math>NORMSINV</math> using the iterating method to find the value of x.
@@ Line 10: / Line 10: @@
 *In <math>NORMSINV(prob)</math>, where prob is the probability value of the standard normal cumulative distribution.
 *This function will return the result as error when
-.prob is nonnumeric.
+.<math>prob</math> is non-numeric.
-.prob<0 or prob>1.
+.<math>prob<0</math> or <math>prob>1</math>.
 ==Examples==