Manuals/calci/NORMSINV

NORMSINV(prob)

• $prob$ prob is the probability value.

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

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

Examples

1. =NORMSINV(0.9999975333) = 4.567600
2. =NORMSINV(0.00241) = -2.818823592
3. =NORMSINV(1) = Null
4. =NORMSINV(0.00001) = -4.264890794

Related Videos

NORMSINV

See Also

• NORMDIST
• NORMINV
• NORMSDIST

References

Normal Distribution