Difference between revisions of "Manuals/calci/NORMINV"

Revision as of 18:07, 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 12: / Line 12: @@
 *This function will return the result as error when
 .any one of the argument is non-numeric
-.Suppose <math>Probability<0</math> or <math>Probability>1</math>
+.Suppose Probability<0 or Probability>1
-.<math>StandardDeviation<=0</math>.
+. StandardDeviation<=0.
-*If <math>Mean=0</math> and <math>StandardDeviation=1</math>, NORMINV uses the Standard Normal Distribution.
+*If Mean=0 and StandardDeviation=1, NORMINV uses the Standard Normal Distribution.
 ==Examples==