Manuals/calci/LOGINV
LOGINV(prob,m,sd)
- is the probability associated with lognormal distribution
- is the mean value of ln(x)
- 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 , then .
- This function will give the result as error when
Any one of the argument is non-numeric. or or
Examples
- LOGINV(0.039084,3.5,1.2) = 3.9957031
- LOGINV(0.24786,6.25,3.12) = NULL
- LOGINV(0.007543,5.82,2.9) = NULL