Google Sheets LOGNORMDIST Function: Syntax, Examples & Tips

x:
The value at which you want to evaluate the lognormal distribution.

mean:
The mean of the natural logarithm of the distribution.

standard_deviation:
The standard deviation of the natural logarithm of the distribution.

What is a LOGNORMDIST?

The LOGNORMDIST function in Google Sheets is a statistical function used to calculate the cumulative distribution function (CDF) of the log-normal distribution for a given value. This function is particularly useful in scenarios where the data is positively skewed, such as in financial modeling, environmental studies, and other fields where the log-normal distribution is applicable.

In simpler terms, LOGNORMDIST helps you understand the probability that a random variable from a log-normal distribution is less than or equal to a specified value.

A Practical Example

Imagine you are analyzing the distribution of incomes in a certain region and you have the following parameters:

• Mean (μ): 10
• Standard Deviation (σ): 0.5

You want to find out the probability that a randomly selected income is less than or equal to 15.

LOGNORMDIST Formula

To achieve this, you would use the LOGNORMDIST function as follows:

=LOGNORMDIST(15, 10, 0.5)

In this formula:

• 15 is the value for which you want to calculate the cumulative probability.
• 10 is the mean of the underlying normal distribution.
• 0.5 is the standard deviation of the underlying normal distribution.

Result of the Formula

When you apply the LOGNORMDIST formula, it will return a probability value, which indicates the likelihood that a randomly selected income is less than or equal to 15. For example, if the result is 0.8413, it means there is an 84.13% chance that a randomly selected income will be less than or equal to 15.

Why Use LOGNORMDIST?

LOGNORMDIST is beneficial because it allows analysts and researchers to work with data that follows a log-normal distribution without needing to transform the data. It simplifies the process of probability calculations and helps in making informed decisions based on statistical analysis.

Key Takeaways:

• LOGNORMDIST: A statistical function that calculates the cumulative distribution function of the log-normal distribution.
• Applications: Useful in fields like finance, environmental studies, and any scenario where data is positively skewed.
• Probability Calculation: Helps determine the likelihood of a random variable being less than or equal to a specified value.
• User-Friendly: Simplifies the analysis of log-normally distributed data without requiring data transformation.

LOGNORMDIST is an essential function for anyone working with statistical data in Google Sheets, providing a powerful way to enhance data analysis and reporting capabilities.

Happy spreadsheeting!