Difference between revisions of "Manuals/calci/NORMSINV"

Revision as of 17:22, 14 June 2018

NORMSINV (Probability)

is the value of the Probability.
- NORMSINV(),returns the inverse of the standard normal cumulative distribution.

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 (Probability)'''</div><br/>
 *<math>Probability</math> is the value of the Probability.
 ** NORMSINV(),returns the inverse of the standard normal cumulative distribution.