LOGINV

Formulas / LOGINV
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.


Frequently Asked Questions

What is the LOGINV function?
The LOGINV function calculates the inverse of the lognormal cumulative distribution function. This function is used to analyze logarithmically transformed data.
What are the benefits of using the LOGINV function?
The LOGINV function may provide improved accuracy compared to other methods and may be more reliable than other functions.
Will the LOGINV function be replaced in the future?
The LOGINV function may be replaced in the future with one or more new functions.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.