LOGINV

• How to use LOGINV formula?
• Examples of using LOGINV formula
• LOGINV formula not working?
• Similar formulas to LOGINV

Usage

Use the LOGINV formula with the syntax shown below, it has 3 required parameters:

=LOGINV(x, mean, standard_deviation)

1. x (required):
   The value for which you want to find the inverse of the logarithmic normal cumulative distribution.
2. mean (required):
   The mean of the logarithmic normal distribution.
3. standard_deviation (required):
   The standard deviation of the logarithmic normal distribution. Must be greater than 0.

Examples

Finding the inverse of the logarithmic normal distribution for a given mean and standard deviation

Suppose you have a dataset that follows a logarithmic normal distribution with a mean of 10 and a standard deviation of 2. You can use the LOGINV function to find the value at which the cumulative distribution function equals 0.5.

Modeling stock prices

The logarithmic normal distribution is commonly used to model stock prices. You can use the LOGINV function to find the probability of a stock price reaching a certain level given its mean and standard deviation.

Analyzing financial data

The logarithmic normal distribution is also used in finance to model data such as asset returns and interest rates. You can use the LOGINV function to find the probability of a certain return or interest rate given its mean and standard deviation.

Common Mistakes

Forgetting to convert data to logarithmic scale

The LOGINV function requires that the data follows a lognormal distribution, which means that you need to first convert your data to a logarithmic scale before using this function. If you forget to do this, you will get incorrect results.

Using incorrect parameters

The LOGINV function takes three parameters: x, mean, and standard deviation. If you use the wrong parameters or mix up their order, you will get incorrect results.

Using incorrect data

The LOGINV function assumes that your data follows a lognormal distribution. If your data does not follow this distribution, you will get incorrect results.

Related Formulas

The following functions are similar to LOGINV or are often used with it in a formula:

• LOGNORMDIST

  The LOGNORMDIST function returns the cumulative log-normal distribution of the specified x-value, mean, and standard deviation. The log-normal distribution is often used to model random variables that are positive and skewed. This function is commonly used in finance and probability analysis to estimate the likelihood of an event occurring based on its logarithmic distribution.

• NORMINV

  The NORMINV function returns the inverse of the normal cumulative distribution for a specified value, mean, and standard deviation. It is commonly used in statistics to find the value at which a given percentage of observations lie below that value.

• NORMSINV

  The NORMSINV function calculates the inverse of the standard normal cumulative distribution for a specified value of x. It is commonly used in statistical analysis to transform data from a normal distribution to a standard normal distribution with a mean of 0 and a standard deviation of 1.

Learn More

You can learn more about the LOGINV Google Sheets function on Google Support.