Documentation/Calc Functions/LOGNORMDIST

Function name:
LOGNORMDIST

Category:
Statistical Analysis

Summary:
Calculates either the probability density function or the cumulative distribution function values of the log-normal distribution for the given data.

Syntax:
LOGNORMDIST(Number[; Mean[; StDev[; Cumulative]]])

Returns:
Returns a non-negative real number representing the requested value for the log-normal distribution with the specified mean and standard deviation.

Arguments:
Number is a real number or a reference to the cell containing that number which is the value for which the log-normal distribution is to be calculated.

Mean is a real number or a reference to the cell containing that number which is the mean value of the log-normal distribution. If omitted, the function assumes its value to be 0.

StDev is a positive real number or a reference to the cell containing that number which is the standard deviation of the log-normal distribution. If omitted, the function assumes its value to be 1.

Cumulative can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function. By default, it calculates the cumulative distribution value.


 * If Number is negative or zero then the function returns a zero value for the cumulative distribution function. However, it returns an error for the probability density function for these values.
 * If StDev is negative or zero then the function returns an error value.

Additional details:
If Cumulative is FALSE, LOGNORMDIST returns an error value if x <= 0 and the probability density function value
 * The formula for LOGNORMDIST is:

otherwise If Cumulative is TRUE, LOGNORMDIST returns 0 if x <= 0 and the cumulative distribution function value

otherwise

where x = Number μ = Mean σ = StDev
 * For more details on the log-normal distribution, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/LOGINV LOGINV]

[[Special:MyLanguage/Documentation/Calc_Functions/LOGNORM.DIST LOGNORM.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/LOGNORM.INV LOGNORM.INV]

ODF standard:
Section 6.18.44, part 2

Equivalent Excel functions:
None