Syntax. LOGNORM.INV(probability,mean,standard_dev)
Definition. This function returns the quantile of the lognormal distribution of x, where ln(x) is normally distributed with the parameters mean and standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORN.INV(p,...) = x. If the probability is p, you can calculate the quantile of the lognormal distribution.
Use the lognormal distribution to analyze logarithmically transformed data.
Arguments
probability (required). A probability associated with the lognormal distribution
mean (required). The mean of the lognormal distribution
standard_dev (required). The standard deviation of the lognormal distribution
If one of the arguments isn’t a numeric expression, the LOGNORM.INV() function returns the #VALUE!
error.
If probability is less than 0 or greater than 1, the LOGNORM.INV() function returns the #NUM!
error.
If standard_dev is less than or equal to 0, the function returns the #NUM!
error.
Background. The inverse of the lognormal distribution function is:
You will find more information about lognormal distributions in the description of LOGNORM.DIST().
Example. Use the following values to calculate LOGNORM.INV():
0.039084 = the probability associated with the lognormal distribution (probability)
3.5 = the mean of ln(x) (mean)
1.2 = the standard deviation of ln(x) (standard_dev)
Figure 12-93 shows the calculation of LOGNORM.INV().
The LOGNORM.INV() function returns the quantile 4.000025 of the lognormal distribution based on the parameters shown in Figure 12-93.
3.138.67.27