Difference between revisions of "Manuals/calci/NORMSINV"

Latest revision as of 09:29, 2 June 2020

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.
-**NORMSINV(),returns the inverse of the standard normal cumulative distribution.
 ==Description==
@@ Line 18: / Line 17: @@
 #=NORMSINV(0.9999975333) = 4.567600
 #=NORMSINV(0.00241) = -2.818823592
-#=NORMSINV(1) = Null
+#=NORMSINV(1) = #N/A (PROBABILITY >0 (OR) PROBABILITY < 1)
 #=NORMSINV(0.00001) = -4.264890794