LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel

The following article introduces you to the LOGNORM.INV function - one of the functions in the statistical function group is very popular in Excel.

LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel Picture 1

Description: The function returns the inverse of the logarithmic distribution of x. Where LN (x) is usually distributed with parameter mean and standard deviation. Use functions to analyze logarithmic change data. Support function from Excel 2010 version.

Syntax: LOGNORM.INV (probability, mean, standard_dev)

Inside:

- probability : Probability associated with a standard logarithmic distribution, which is a required parameter.

- mean: The average value of LN (x) , is a required parameter.

- standard_dev: Standard deviation of LN (x), is a required parameter.

Attention:

- Any argument except ( cumulative) is not a number -> function returns the #VALUE! Error value

- If probability ≤ 0 or probability ≥ 1 -> the function returns the #NUM! Error value

- If standard_dev ≤ 0 -> the function returns the #NUM! Error value

For example:

Find the inverse value of the cumulative standard logarithmic distribution function as described in the following data table:

LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel Picture 2

- In the cell to calculate, enter the formula : = LOGNORM.INV (D6, D7, D8)

LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel Picture 3

- Press Enter -> the inverse value of the cumulative standard logarithmic distribution function is:

LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel Picture 4

- Where the probability associated with a standard cumulative distribution is less than 0 or greater than 1-> the function returns the #NUM! Error value

LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel Picture 5

- Where the standard deviation is less than 0 -> the function returns the #NUM! Error value

LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel Picture 6

Above are instructions and some specific examples when using the LOGNORM.INV function in Excel.

Good luck!