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.
Frequently Asked Questions
What is the LOGNORM.DIST function?
The LOGNORM.DIST function calculates the lognormal distribution of a value. The lognormal distribution is analyzed with logarithmic transformation data.
What type of data is analyzed with the LOGNORM.DIST function?
The LOGNORM.DIST function is used to analyze logarithmic transformation data.
How is the lognormal distribution calculated?
The lognormal distribution is calculated using the LOGNORM.DIST function.
What is the purpose of the LOGNORM.DIST function?
The LOGNORM.DIST function is used to calculate the lognormal distribution of a value.
What is the lognormal distribution?
The lognormal distribution is a type of probability distribution. It is often used in finance, economics, and other fields to analyze logarithmic transformation data.
