Manuals/calci/NORMINV

NORMINV(prob,m,sd)

$prob$ is the probability corresponding to the Normal Distribution, $m$ is the Mean, and $sd$ is the Standard Deviation.

Description

This function gives the inverse of the normal cumulative distribution for the particular mean and standard deviation.
If $NORMDIST(x,m,sd,TRUE)=prob$ , then $NORMINV(prob,m,sd)=x$ .
$NORMINV$ 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 $NORMINV(prob,m,sd)$ , where $prob$ is the corresponding probability of the normal distribution, $m$ is the arithmetic mean of the normal distribution and $sd$ is the standard deviation of the normal distribution.
This function will return the result as error when

1.any one of the argument is non-numeric
2.Suppose  $prob<0$  or  $prob>1$ 
3. $sd<=0$ .