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 lognormal cumulative distribution.
• This distribution is the continuous probability distribution.
• Lognomal 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

1. Any one of the argument is nonnumeric.
2. prob<0 or prob>1 or sd<=0

Examples

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

References

Bessel Function