Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data.
Syntax
LOGINV(probability,mean,standard_dev)
Probability is a probability associated with the lognormal distribution.
Mean is the mean of ln(x).
Standard_dev is the standard deviation of ln(x).
Remarks
-
If any argument is nonnumeric, LOGINV returns the #VALUE! error value.
-
If probability < 0 or probability > 1, LOGINV returns the #NUM! error value.
-
If standard_dev <= 0, LOGINV returns the #NUM! error value.
-
The inverse of the lognormal distribution function is:
Example
|
Probability |
Mean |
StdDev |
Formula |
Description (Result) |
|
0.039084 |
3.5 |
1.2 |
=LOGINV([Probability], [Mean], [StdDev]) |
Inverse of the lognormal cumulative distribution function for the specified arguments (4.000028) |
