Description
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 = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x.
Use the lognormal distribution to analyze logarithmically transformed data.
Sample Usage
Syntax
LOGNORM.INV(probability, mean, standard_dev)
The LOGNORM.INV function syntax has the following arguments:
-
Probability Required. A probability associated with the lognormal distribution.
-
Mean Required. The mean of ln(x).
-
Standard_dev Required. The standard deviation of ln(x).
Remarks
-
If any argument is nonnumeric, LOGNORM.INV returns the #VALUE! error value.
-
If probability <= 0 or probability >= 1, LOGNORM.INV returns the #NUM! error value.
-
If standard_dev <= 0, LOGNORM.INV returns the #NUM! error value.
In order to use the LOGNORM.INV formula, start with your edited Excellentable
Then type in the LOGNORM.INV formula in the area you would like to display the outcome:
By adding the values you would like to calculate the LOGNORM.INV formula for, Excellentable will generate the outcome:
There were errors rendering macro:
- An unknown error occurred.