Difference between revisions of "Manuals/calci/NORMINV"

Revision as of 17:06, 14 June 2018

NORMINV (Probability,Mean,StandardDeviation)

This function gives the inverse of the Normal Cumulative Distribution for the particular Mean and Standard Deviation.
If $NORMDIST(Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability$ , then $NORMINV(Probability,Mean,StandardDeviation)=Number$ .
$NORMINV$ using the iterating method to find the value of a Number.
Suppose the iteration has not converged after 100 searches, then the function gives the error result.
In $NORMINV(Probability,Mean,StandardDeviation)$ , where $Probability$ is the corresponding probability of the Normal Distribution, $Mean$ is the Arithmetic Mean of the Normal Distribution and $StandardDeviation$ 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  $Probability<0$  or  $Probability>1$ 
3. $StandardDeviation<=0$ .

If $Mean=0$ and $StandardDeviation=1$ , NORMINV uses the Standard Normal Distribution.

@@ Line 6: / Line 6: @@
 ==Description==
 *This function gives the inverse of the Normal Cumulative Distribution for the particular Mean and Standard Deviation.
-*If <math>NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability</math>, then <math>NORMINV (Probability,Mean,StandardDeviation)=x</math>.
+*If <math>NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability</math>, then <math>NORMINV (Probability,Mean,StandardDeviation)=Number</math>.
-*<math>NORMINV</math> using the iterating method to find the value of x.
+*<math>NORMINV</math> using the iterating method to find the value of a Number.
 *Suppose the iteration has not converged after 100 searches, then the function gives the error result.
 *In <math>NORMINV (Probability,Mean,StandardDeviation)</math>, where <math>Probability</math> is the corresponding probability of the Normal Distribution, <math>Mean</math> is the Arithmetic Mean of the Normal Distribution and <math>StandardDeviation</math> is the Standard Deviation of the Normal Distribution.