Difference between revisions of "Manuals/calci/NORMSINV"

Revision as of 18:19, 14 June 2018

NORMSINV (Probability)

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(Number,Accuracy)=Probability$ , then $NORMSINV(Probability)=Number$ .
$NORMSINV$ using the iterating method to find the value of $Number$ .
Suppose the iteration has not converged after 100 searches, then the function gives the error result.
In $NORMSINV(Probability)$ , where $Probability$ is the probability value of the Standard Normal Cumulative Distribution.
This function will return the result as error when

1. $Probability$  is non-numeric.
2. $Probability<0$  or  $Probability>1$ .

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''NORMSINV(prob)'''</div><br/>
+<div style="font-size:30px">'''NORMSINV (Probability)'''</div><br/>
-*<math>prob</math>  prob is the probability value.
+*<math>Probability</math> is the value of the Probability.
 ==Description==
 *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 <math> NORMSDIST(x)=prob</math>, then <math>NORMSINV(prob)=x</math>.
+*If <math> NORMSDIST (Number,Accuracy)=Probability</math>, then <math>NORMSINV (Probability)=Number</math>.
-*<math>NORMSINV</math> using the iterating method to find the value of <math>x</math>.
+*<math>NORMSINV</math> using the iterating method to find the value of <math>Number</math>.
 *Suppose the iteration has not converged after 100 searches, then the function gives the error result.
-*In <math>NORMSINV(prob)</math>, where <math>prob</math> is the probability value of the Standard Normal Cumulative Distribution.
+*In <math>NORMSINV (Probability)</math>, where <math>Probability</math> is the probability value of the Standard Normal Cumulative Distribution.
 *This function will return the result as error when
-.<math>prob</math> is non-numeric.
+.<math>Probability</math> is non-numeric.
-.<math>prob<0</math> or <math>prob>1</math>.
+.<math>Probability<0</math> or <math>Probability>1</math>.
 ==Examples==