Difference between revisions of "Manuals/calci/LOGINV"

From ZCubes Wiki
Jump to navigation Jump to search
Line 12: Line 12:
 
*A random variable which is log-normally distributed takes only positive real values.
 
*A random variable which is log-normally distributed takes only positive real values.
 
*If <math>LOGNORMDIST (Number,Mean,StandardDeviation,Accuracy)=probability</math>,  
 
*If <math>LOGNORMDIST (Number,Mean,StandardDeviation,Accuracy)=probability</math>,  
then <math>LOGINV (probability,mean,standard_dev,accuracy,somenormdistaccuracy,recursivelimit)=x</math>.  
+
then <math>LOGINV (probability,mean,standarddev,accuracy,somenormdistaccuracy,recursivelimit)=x</math>.  
 
*This function will give the result as error when  
 
*This function will give the result as error when  
 
  Any one of the argument is non-numeric.
 
  Any one of the argument is non-numeric.
  <math>prob<0</math> or <math>prob>1</math> or <math>sd \le 0</math>
+
  <math>probability<0</math> or <math>probability>1</math> or <math>standarddev \le 0</math>
  
 
==ZOS==
 
==ZOS==

Revision as of 13:25, 8 June 2018

LOGINV (probability,mean,standard_dev,accuracy,somenormdistaccuracy,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

  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

References

Log-normal Distribution