LOGNORMDIST Function Explained
The LOGNORMDIST
Function in Microsoft Excel calculates the cumulative log-normal distribution for a given set of parameters. It takes three arguments: x
, mean
, and standard_dev
. It returns the probability that a random variable, which follows a log-normal distribution, is less than or equal to x
.
LOGNORMDIST Function Syntax
LOGNORMDIST(x, mean, standard_dev)
- x: The value for which you want the distribution.
- mean: The arithmetic mean of the distribution.
- standard_dev: The standard deviation of the distribution.