How to Use the LOGNORMDIST Function in Excel
Today, we’ll explore the LOGNORMDIST function, available in both Excel and Google Sheets. This function is crucial for calculating the logarithmic normal distribution for specified values, mean, and standard deviation.
LOGNORMDIST Syntax
The LOGNORMDIST function has the following syntax:
LOGNORMDIST(x, mean, standard_dev, cumulative)x: The data point at which the function is evaluated.mean: The mean of the natural logarithm ofx.standard_dev: The standard deviation of the natural logarithm ofx.cumulative: A logical value specifying the function’s output format. If TRUE, the function returns the cumulative distribution; if FALSE, it returns the probability density function.
Examples and Applications
Example 1: Cumulative Distribution Function
This example determines the cumulative probability that a random variable does not exceed a specified value.
| x | Mean | Standard Deviation | Cumulative | LOGNORMDIST Result |
|---|---|---|---|---|
| 2 | 1 | 0.5 | TRUE | =LOGNORMDIST(2, 1, 0.5, TRUE) |
In this scenario, the expression =LOGNORMDIST(2, 1, 0.5, TRUE) computes the cumulative distribution function value for x=2 with a mean of 1 and a standard deviation of 0.5.
Example 2: Probability Density Function
This example calculates the probability density function value at a specified value.
| x | Mean | Standard Deviation | Cumulative | LOGNORMDIST Result |
|---|---|---|---|---|
| 2 | 1 | 0.5 | FALSE | =LOGNORMDIST(2, 1, 0.5, FALSE) |
Utilizing the formula =LOGNORMDIST(2, 1, 0.5, FALSE), we find the probability density function value for x=2 with a mean of 1 and a standard deviation of 0.5.
These examples illustrate how the LOGNORMDIST function can be applied within Excel and Google Sheets to determine logarithmic normal distribution probabilities accurately.
More information: https://support.microsoft.com/en-us/office/lognormdist-function-f8d194cb-9ee3-4034-8c75-1bdb3884100b