The LOGNORM.DIST function calculates the probability density function or the cumulative distribution function for a lognormal distribution.


=LOGNORM.DIST(x, mean, standard_dev, cumulative)

x The value at which to evaluate the function.
mean The mean of the ln(x) values of the distribution.
standard_dev The standard deviation of the ln(x) values of the distribution.
cumulative A logical value that determines the form of the function to be calculated. If TRUE it returns the cumulative distribution function; if FALSE it returns the probability density function.


In the mathematical terrain of probability and distribution analysis, the LOGNORM.DIST function emerges as a valuable ally for deciphering the characteristics of lognormal distributions. This function aids in computing the probability density or cumulative distribution function for a lognormal distribution, providing insights into the behavior of variables whose logarithms follow a normal distribution pattern. Whether you are exploring financial models, risk analysis, or natural phenomena, LOGNORM.DIST equips you with the tools to navigate complex statistical landscapes with ease and precision. To leverage LOGNORM.DIST effectively, you input the specific value 'x' for evaluation, the mean and standard deviation of the ln(x) values representing the lognormal distribution, and a logical indicator ('cumulative') to determine the type of function to compute. By toggling the 'cumulative' parameter, you can seamlessly switch between obtaining cumulative distribution information or probability density insights, catering to the distinct analytical needs dictated by your statistical inquiries. LOGNORM.DIST shines when dissecting logarithmically transformed data exhibiting normal behavior, offering a robust mechanism for calculating the distribution metrics crucial for informed decision-making in diverse analytical scenarios.


If you wish to find the cumulative distribution function value for x = 2, with a mean of 1 and standard deviation of 0.5 in a lognormal distribution, you would use the following formula: =LOGNORM.DIST(2, 1, 0.5, TRUE)

To calculate the probability density function value for x = 3, with a mean of 2 and standard deviation of 1 in a lognormal distribution, you can employ the formula: =LOGNORM.DIST(3, 2, 1, FALSE)


What significance does the 'cumulative' parameter hold in the LOGNORM.DIST function?

The 'cumulative' parameter in the LOGNORM.DIST function is pivotal as it determines whether the function calculates the cumulative distribution function (when set to TRUE) or the probability density function (when set to FALSE) for the lognormal distribution. This feature provides flexibility in obtaining different types of distribution information based on the analytical requirements at hand.

How does the LOGNORM.DIST function contribute to statistical analysis?

The LOGNORM.DIST function plays a crucial role in statistical analysis by facilitating the computation of probability density and cumulative distribution functions for lognormal distributions. By operating on logarithmically transformed data that behaves according to normal distribution guidelines, this function allows analysts to glean essential insights and metrics required for making informed decisions in various analytical contexts.

Can the LOGNORM.DIST function handle negative values?

No, the LOGNORM.DIST function is designed to work with positive values since lognormal distributions are characterized by variables that exhibit only positive values. It is essential to ensure that the input values align with the distribution assumptions to obtain accurate results.

Related functions