Manuals/calci/NORMINV

NORMINV(prob,m,sd)

• $prob$ is the probability corresponding to the Normal Distribution, $m$ is the Mean, and $sd$ is the Standard Deviation.

Description

• This function gives the inverse of the Normal Cumulative Distribution for the particular Mean and Standard Deviation.
• If $NORMDIST(x,m,sd,TRUE)=prob$, then $NORMINV(prob,m,sd)=x$.
• $NORMINV$ 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 $NORMINV(prob,m,sd)$, where $prob$ is the corresponding probability of the Normal Distribution, $m$ is the Arithmetic Mean of the Normal Distribution and $sd$ 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 $prob<0$ or $prob>1$
3.$sd<=0$.

• If $m=0$ and $sd=1$, NORMINV uses the Standard Normal Distribution.

Examples

1. =NORMINV(0.01884908749,17.4,3.2) = 10.750011
2. =NORMINV(0.998742,5.4,2.3) = 12.349244172
3. =NORMINV(1,7.2,2.3) = NULL

Related Videos

NORMDIST AND NORMINV

See Also

• NORMDIST
• NORMSDIST
• NORMSINV

References

Normal distribution