The LOGNORM.INV function 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.
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).
Example: Let’s look at some Excel LOGNORM.INV function examples and explore how to use the LOGNORM.INV function as a worksheet function in Microsoft Excel:
Suppose we are given the following data:
Using the probability, mean, and standard deviation given above, the formula for calculating the inverse of lognormal cumulative distribution is shown below:
Syntax: =LOGNORM.INV(B1,B2,B3)
Result: 9.722271014
Note:
- #NUM! error – Occurs when:
- The argument x given is less than or equal to zero; or
- The argument standard_dev is less than or equal to zero.
- #VALUE! error – Occurs when any of the given arguments is non-numeric.
- The LOGNORM.INV function was introduced in Excel 2010 and hence is unavailable in earlier versions. For older versions, we can use the LOGINV function.
