Google Sheets LOGNORM.DIST Function: Syntax, Examples & Tips

x: The value at which to evaluate the distribution.

mean: The mean or average of the distribution.

standard_deviation: The standard deviation of the distribution.

What is LOGNORM.DIST?

The LOGNORM.DIST function in Google Sheets is a statistical function used to calculate the lognormal distribution of a specified value. A lognormal distribution is a probability distribution of a random variable whose logarithm is normally distributed. This function is particularly useful in fields such as finance, economics, and environmental studies, where it can model phenomena that are positively skewed.

In simpler terms, LOGNORM.DIST allows you to determine the probability of a variable that follows a lognormal distribution, given a specific value, mean, and standard deviation.

A Practical Example

Imagine you are analyzing the distribution of incomes in a certain region, and you want to find the probability that a randomly selected individual has an income less than a certain amount.

Income Distribution Table:

You want to calculate the probability of an individual earning less than $50,000, assuming the income follows a lognormal distribution with a mean of 10 and a standard deviation of 0.5.

LOGNORM.DIST Formula

To achieve this, you would use the LOGNORM.DIST function as follows:

=LOGNORM.DIST(50000, 10, 0.5, TRUE)

In this formula:

• 50000 is the value for which you want to calculate the probability.
• 10 is the mean of the natural logarithm of the distribution.
• 0.5 is the standard deviation of the natural logarithm of the distribution.
• TRUE indicates that you want the cumulative distribution function (CDF), which gives the probability that a random variable is less than or equal to the specified value.

Result of the Formula

When you apply the LOGNORM.DIST formula, it will return a probability value that represents the likelihood of an individual earning less than $50,000 based on the specified lognormal distribution parameters.

Example Output:

In this case, the probability of an individual earning less than $50,000 is approximately 0.5000, or 50%.

Why Use LOGNORM.DIST?

LOGNORM.DIST is beneficial because it provides a way to model and analyze data that is positively skewed, which is common in real-world scenarios such as income distribution, stock prices, and other financial metrics. It allows for a more accurate representation of data that cannot be adequately described by a normal distribution.

Key Takeaways:

• LOGNORM.DIST: A statistical function that calculates the lognormal distribution for a specified value.
• Cumulative Probability: Can return the cumulative probability, indicating the likelihood of a random variable being less than or equal to a specified value.
• Real-World Applications: Useful in finance, economics, and any field where data is positively skewed.
• Data Analysis: Enhances the ability to analyze and interpret data distributions effectively.

LOGNORM.DIST is an essential function for anyone working with statistical data in Google Sheets, providing a powerful tool for understanding and modeling lognormally distributed variables.

Happy spreadsheeting!