Excel

LOGNORM.DIST: Excel Formulae Explained

How do you use LOGNORM.DIST in Excel?

LOGNORM.DIST is a function in Excel that calculates the log-normal distribution for a given set of parameters. It takes four arguments: the mean, the standard deviation, the lower bound, and the upper bound. It returns a value between 0 and 1 that represents the probability that a given value is less than or equal to the given input. This function is useful for estimating the probability of a given event occurring, especially in cases where the event is not perfectly normal.

What is the syntax of LOGNORM.DIST in Excel?

LOGNORM.DIST is a function in Excel that calculates the logarithmic normal distribution for a given set of parameters. The syntax for this function is as follows: LOGNORM.DIST(x,mean,standard_deviation,cumulative) Where x is the value for which you want to calculate the logarithmic normal distribution, mean is the mean of the distribution, standard_deviation is the standard deviation of the distribution, and cumulative is a boolean value that, if set to TRUE, returns the cumulative distribution function instead of the probability density function.

What is an example of how to use LOGNORM.DIST in Excel?

The LOGNORM.DIST function in Excel is used to calculate the normal distribution for a given set of data. The function takes five arguments: the first is the mean of the data set, the second is the standard deviation of the data set, the third is the number of tails, the fourth is the lower bound of the desired area, and the fifth is the upper bound of the desired area. The function then calculates the probability of the data set occurring within the given bounds. An example of how to use the LOGNORM.DIST function in Excel is shown below. In this example, the function is used to calculate the probability of a data set with a mean of 100 and a standard deviation of 15 occurring within the bounds of 85 and 115.

=LOGNORMDIST(100,15,2,85,115)

The function returns a value of .0902, which indicates that the probability of the data set occurring within the given bounds is 9.02%.

When should you not use LOGNORM.DIST in Excel?

LOGNORM.DIST should not be used when there are only a few data points. It should also not be used when the data points are not evenly distributed.

What are some similar formulae to LOGNORM.DIST in Excel?

In Excel, there are a few similar formulae to LOGNORM.DIST. The NORM.DIST function returns the normal distribution for a given set of parameters, while the NORM.INV function returns the inverse of the normal distribution for a given set of parameters. The NORM.S.DIST function returns the standard deviation of a normal distribution, while the NORM.S.INV function returns the inverse of the standard deviation of a normal distribution. Finally, the LOGNORM.INV function returns the inverse of the logarithm of the normal distribution.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.