LOGINV
TheLOGINV
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.
 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:
 x (required):
The value for which you want to find the inverse of the logarithmic normal cumulative distribution.  mean (required):
The mean of the logarithmic normal distribution.  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 theLOGINV
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.
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 lognormal distribution of the specified xvalue, mean, and standard deviation. The lognormal 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.