Difference between revisions of "Manuals/calci/LOGINV"
Jump to navigation
Jump to search
Line 15: | Line 15: | ||
<math>prob<0</math> or <math>prob>1</math> or <math>sd \le 0</math> | <math>prob<0</math> or <math>prob>1</math> or <math>sd \le 0</math> | ||
− | ==ZOS | + | ==ZOS== |
*The syntax is to calculate Log normal distribution in ZOS is <math>LOGINV(probability,mean,standarddev,accuracy,normdistaccuracy,recursivelimit)</math> | *The syntax is to calculate Log normal distribution in ZOS is <math>LOGINV(probability,mean,standarddev,accuracy,normdistaccuracy,recursivelimit)</math> | ||
**<math>probability</math> is the probability associated with lognormal distribution | **<math>probability</math> is the probability associated with lognormal distribution | ||
Line 21: | Line 21: | ||
**<math>standarddev</math> is the standard deviation of ln(x). | **<math>standarddev</math> is the standard deviation of ln(x). | ||
**<math>accuracy</math> gives accurate value of the solution. | **<math>accuracy</math> gives accurate value of the solution. | ||
− | |||
==Examples== | ==Examples== |
Revision as of 11:08, 3 June 2015
LOGINV(probability,mean,standarddev,accuracy,normdistaccuracy,recursivelimit)
- is the probability associated with lognormal distribution
- is the mean value of ln(x)
- is the standard deviation of ln(x).
- gives accurate value of the solution.
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
ZOS
- The syntax is to calculate Log normal distribution in ZOS is
- is the probability associated with lognormal distribution
- is the mean value of ln(x)
- is the standard deviation of ln(x).
- gives accurate value of the solution.
Examples
- LOGINV(0.039084,3.5,1.2) = 3.9957031
- LOGINV(0.039084,3.5,1.2,0.02,0.4) = 3.5
- LOGINV(0.039084,3.5,1.2,0.02,0.9) = 5.525
- LOGINV(0.24786,6.25,3.12) = NULL
- LOGINV(0.007543,5.82,2.9) = NULL