How to Use the LOGINV Function in Excel
Welcome to our guide on the LOGINV function in Excel and Google Sheets. The LOGINV function is a statistical tool that calculates the inverse of the cumulative lognormal distribution based on a given probability and the distribution’s parameters.
Syntax
The syntax for the LOGINV function is consistent across both Excel and Google Sheets:
LOGINV(probability, mean, standard_dev)probability: The probability corresponding to the inverse lognormal distribution.mean: The mean of the natural logarithm of the variable, ln(x).standard_dev: The standard deviation of the natural logarithm of the variable, ln(x).
Examples
Here are some practical examples to demonstrate the use of the LOGINV function:
Example 1
Find the inverse lognormal distribution for a probability of 0.2, with a mean of 1 and a standard deviation of 0.5.
In Excel and Google Sheets:
=LOGINV(0.2, 1, 0.5)Example 2
Consider a scenario where you possess a dataset that includes mean and standard deviation values, and you need to compute the inverse lognormal distributions for probabilities listed in a range of cells.
| Probability | Mean | Standard Deviation | Result |
|---|---|---|---|
| 0.3 | 2 | 1.5 | =LOGINV(A2, B2, C2) |
| 0.5 | 3 | 2 | =LOGINV(A3, B3, C3) |
This example illustrates using the LOGINV function to apply a range of probabilities with corresponding mean and standard deviation values to compute the inverse lognormal distribution.
These examples showcase how the LOGINV function can be utilized in Excel and Google Sheets to analyze lognormal distributions effectively and perform robust statistical analysis.
More information: https://support.microsoft.com/en-us/office/loginv-function-0bd7631a-2725-482b-afb4-de23df77acfe