Related Topics: | ||
Description: Returns the inverse of the lognormal cumulative distribution.
Syntax: lognorminv(Probability, Mean, Standard_dev)
Probability is the value at which teh cumulative lognormal distribution is evaluated.
Mean is the mean of ln(X).
Standard_dev is the standard deviation of ln(X).
Remarks:
Probability and Standard_dev must be numerical and > 0.
Mean must be numerical.
All parameter values can include:
Numerical values
Standard operands (+, -, *, /)
Predefined mathematical functions (exp, log, sin, etc.)
References to any analysis workbooks
Example:
lognorminv(0.039, 3.5, 1.2)
Returns:
3.995256
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.