Documentation/Calc Functions/LOGNORMDIST

From The Document Foundation Wiki
Jump to navigation Jump to search


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:

  • The formula for LOGNORMDIST is:

If Cumulative is FALSE(), LOGNORMDIST returns an error value if x <= 0 and the probability density function value

Lognormdistp.png

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

Lognormdistc.png

otherwise

where x = Number μ = Mean σ = StDev

  • For more details on the log-normal distribution, visit Wikipedia.

Examples:

Formula Description Returns
=LOGNORMDIST(0.1;0;1) Calculates the cumulative distribution function for the log-normal distribution for the given argument values. 0.0106510993417
=LOGNORMDIST(7.14,1.5,3.2,1) Calculates the cumulative distribution function for the log-normal distribution for the given argument values. 0.557855853816984
=LOGNORMDIST(7.14,1.5,3.2,0) Calculates the probability density function for the log-normal distribution for the given argument values. 0.017276771409644
=LOGNORMDIST(1,0,0.25,0) Calculates the probability density function for the log-normal distribution for the given argument values. 1.59576912160573
=LOGNORMDIST(-7.14,1.5,3.2,0) For negative and zero value of Number the function returns an error value for the probability density function. Err:502
=LOGNORMDIST(-7.14,1.5,3.2,1) For negative and zero value of Number the function returns zero for the cumulative distribution function. 0
=LOGNORMDIST(2.5) Calculates the cumulative distribution function (default) for the log-normal distribution for the given argument values. Its mean value is 0 and the standard deviation is 1 by default. 0.820242786104214
=LOGNORMDIST(0) For negative and zero value of Number the function returns zero for the cumulative distribution function. 0

Related LibreOffice functions:

LOGINV

LOGNORM.DIST

LOGNORM.INV

ODF standard:

Section 6.18.44, part 2

Equivalent Excel functions:

None