Difference between revisions of "Manuals/calci/NORMINV"

Revision as of 00:39, 22 January 2014

NORMINV(prob,m,sd)

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

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$ .

@@ Line 3: / Line 3: @@
 ==Description==
-*This function gives the inverse of the normal cumulative distribution for the particular mean and standard deviation.
+*This function gives the inverse of the Normal Cumulative Distribution for the particular Mean and Standard Deviation.
 *If <math>NORMDIST(x,m,sd,TRUE)=prob</math>, then <math>NORMINV(prob,m,sd)=x</math>.
 *<math>NORMINV</math> 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 <math>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the normal distribution, <math>m</math> is the arithmetic mean of the normal distribution and <math>sd</math> is the standard deviation of the normal distribution.
+*In <math>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the Normal Distribution, <math>m</math> is the Arithmetic Mean of the Normal Distribution and <math>sd</math> is the Standard Deviation of the Normal Distribution.
 *This function will return the result as error when
 .any one of the argument is non-numeric
 .Suppose <math>prob<0</math> or <math>prob>1</math>
 .<math>sd<=0</math>.
-*If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the standard normal distribution.
+*If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the Standard Normal Distribution.
 ==Examples==