LOGNORM.DIST
Formulas / LOGNORM.DISTCalculate the lognormal distribution.
LOGNORM.DIST(x,mean,standard_dev,cumulative)
- x - required, the value to evaluate the function on
- mean - required, the mean of ln(x)
- standard_dev - required, the standard deviation of ln(x)
Examples
=LOGNORM.DIST(A2,A3,A4,TRUE)The LOGNORM.DIST function can be used to calculate the cumulative lognormal distribution at a given point. For example, this will calculate the cumulative lognormal distribution at 4 using the arguments in A2, A3, A4, and TRUE.
=LOGNORM.DIST(A2,A3,A4,FALSE)The LOGNORM.DIST function can also be used to calculate the probability of a lognormal distribution at a given point. For example, this will calculate the probability of the lognormal distribution at 4 using the same arguments.
Summary
The LOGNORM.DIST function is used to calculate the lognormal distribution of a set of data that has been logarithmically transformed. This is useful for analyzing and understanding the data in a more meaningful way.
- The LOGNORM.DIST function returns the lognormal distribution of a value after logarithmic transformation.
Need help with Formulas?
Frequently Asked Questions
What is the LOGNORM.DIST function?
What type of data is analyzed with the LOGNORM.DIST function?
How is the lognormal distribution calculated?
What is the purpose of the LOGNORM.DIST function?
What is the lognormal distribution?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.