How to use LOGNORM.INV Function in Excel

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:

LOGNORM.INV Function - How to use LOGNORM.INV Function in Excel

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

LOGNORM.INV Function in Excel - How to use LOGNORM.INV Function in Excel

Note:

  1. #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.
  2. #VALUE! error – Occurs when any of the given arguments is non-numeric.
  3. 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.

 

READ:  How to use CHISQ.TEST Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *