Manuals/calci/LOGINV

LOGINV(prob,m,sd)

• $prob$ is the probability associated with lognormal distribution
• $m$ is the mean value of ln(x)
• $sd$ is the standard deviation of ln(x)

Description

• This function gives the inverse value of Log-normal Cumulative Distribution.
• This distribution is the Continuous Probability Distribution.
• Log-normal Distribution is also called Galton's distribution.
• A random variable which is log-normally distributed takes only positive real values.
• If $LOGNORMDIST(x,m,sd)=prob$, then $LOGINV(prob,m,d)=x$.
• This function will give the result as error when

Any one of the argument is non-numeric.
$prob<0$ or $prob>1$ or $sd\leq 0$

Examples

1. LOGINV(0.039084,3.5,1.2) = 3.9957031
2. LOGINV(0.24786,6.25,3.12) = NULL
3. LOGINV(0.007543,5.82,2.9) = NULL

See Also

• LOG
• EXP
• LN

References

Log-normal Distribution