Difference between revisions of "Manuals/calci/NORMSINV"

Revision as of 02:33, 13 March 2017

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 30: / Line 30: @@
 ==References==
 [http://en.wikipedia.org/wiki/Normal_distribution Normal Distribution]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]