LOGNORM.DIST Function Explained
The LOGNORM.DIST Function in Microsoft Excel calculates the cumulative lognormal distribution for a given set of parameters. It takes three arguments: x, mean, and standard_dev. x is the value at which to evaluate the function, mean is the mean of the lognormal distribution, and standard_dev is the standard deviation of the lognormal distribution. The function returns the cumulative lognormal distribution for the given parameters.
LOGNORM.DIST Function Syntax
LOGNORM.DIST(x, mean, standard_dev, cumulative)
- x: The value at which you want to evaluate the distribution.
- mean: The arithmetic mean of the distribution.
- standard_dev: The standard deviation of the distribution.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.