The `LOGINV` function returns the inverse of the logarithmic normal cumulative distribution for a given mean and standard deviation. This function is commonly used in statistical analysis to model data that has a skewed distribution.

## Usage

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

Parameters:
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

Here are a few example use cases that explain how to use the `LOGINV` formula in Google Sheets.

### 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

`LOGINV` not working? Here are some common mistakes people make when using the `LOGINV` Google Sheets Formula:

### 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.

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.

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