Calculate the inverse of the lognormal cumulative distribution function.
`LOGINV(probability, mean, standard_dev)`
• Probability - required, probability associated with the lognormal distribution
• Mean - required, average of ln(x)
• Standard_dev - required, standard deviation of ln(x)

## Examples

• `=LOGINV(0.7, 2, 0.75)`

The LOGINV function can be used to compute the inverse of the lognormal cumulative distribution function. This is useful if you need to calculate the value of x associated with a given cumulative probability. For example, this function returns the x value that has a cumulative probability of 0.7 when the lognormal distribution has a mean of 2 and a standard deviation of 0.75.

• `=LOGINV(A2, 2, 0.75)`

The LOGINV function can also be used to calculate the value of a probability associated with a given x value. This function returns the x value that has a cumulative probability equal to the probability in A2 when the lognormal distribution has a mean of 2 and a standard deviation of 0.75.

• `=LOGINV(A2, A3, A4)`

You can also use the LOGINV function to calculate the probability associated with a given x value. For example: , where A2 is a cell containing an x value, A3 is a cell containing the mean of the lognormal distribution, and A4 is a cell containing the standard deviation of the lognormal distribution. This function returns the cumulative probability associated with the x value in A2 when the lognormal distribution has a mean and standard deviation equal to the values in A3 and A4.

## Summary

The LOGINV function calculates the inverse of the lognormal cumulative distribution function, used to analyze logarithmically transformed data. It offers improved accuracy compared to other functions.

• The LOGINV function returns the inverse of the lognormal cumulative distribution function of a variable, and requires two arguments - a probability and a mean.
• The probability argument is the probability associated with the lognormal distribution, and the mean argument is the mean of ln(x).
• A new LOGNORM.INV function may be available in future versions of Excel, providing improved accuracy.