Manuals/calci/LOGINV

LOGINV (probability,mean,standard_dev,accuracy,somenormdistaccuracy,recursivelimit)

• $probability$ is the probability associated with lognormal distribution
• $mean$ is the mean value of ln(x)
• $standarddev$ is the standard deviation of ln(x).
• $accuracy$ gives accurate value of the solution.
  • LOGINV(), returns the inverse of the lognormal distribution.

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(Number,Mean,StandardDeviation,Accuracy)=probability$,

then $LOGINV(probability,mean,standarddev,accuracy,somenormdistaccuracy,recursivelimit)=x$.

• This function will give the result as error when

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

ZOS

• The syntax is to calculate Log normal distribution in ZOS is $LOGINV(probability,mean,standarddev,accuracy,somenormdistaccuracy,recursivelimit)$
  • $probability$ is the probability associated with lognormal distribution
  • $mean$ is the mean value of ln(x)
  • $standarddev$ is the standard deviation of ln(x).
  • $accuracy$ gives accurate value of the solution.

Examples

1. LOGINV(0.039084,3.5,1.2) = 3.9957031
2. LOGINV(0.039084,3.5,1.2,0.02,0.4) = 3.5
3. LOGINV(0.039084,3.5,1.2,0.02,0.9) = 5.525
4. LOGINV(0.24786,6.25,3.12) = NULL
5. LOGINV(0.007543,5.82,2.9) = NULL

Related Videos

Log-Normal Distribution

See Also

• LOG
• EXP
• LN

References

Log-normal Distribution

• List of Main Z Functions

• Z3 home