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 nonnumeric
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

See Also

• NORMDIST
• NORMSDIST
• NORMSINV