LOGNORM.INV
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:
A
|
B
|
|
---|---|---|
1
|
||
2
|
||
3
|
||
4
|
||
5
|
||
6
|