The LOGNORMDIST function returns the log-normal distribution. All arguments are number values.
LOGNORMDIST(pos-x-value, mean, stdev)
pos-x-value: The x value at which you want to evaluate the function. pos-x-value must be greater than 0.
mean: The mean of the natural logarithm, that is, ln(x). mean is the average (arithmetic mean) of ln(x), the natural logarithm of x.
stdev: The standard deviation of the population. stdev must be greater than 0.
Example |
|---|
=LOGNORMDIST(0.78, 1.7, 2.2) returns 0.187899237956868. |