LOGNORMDIST

Owned by Juliane Wetzel
Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

Syntax

LOGNORMDIST( <number>, <number>, <number>; <boolean>)

Description

Returns the log-normal distribution for a certain value with given mean and standard deviation.

or

Returns the log-normal density function or the cumulative distribution function for the log-normal distribution. This function is frequently used to measure the degree of diversity between two data sets.

The function arguments are:

  • x: The value for which the distribution should be computed (NUMERIC)
  • Mean: The mean of the distribution (NUMERIC)
  • Standard deviation: The standard deviation of the distribution (NUMERIC)
  • Cumulative: Constant indicating the form of the function. If true then the cumulative distribution function is used. If false then the probability mass function is used. (BOOLEAN)
Cumulative/BooleanLogical argument which defines the type of distribution to be calculated
Trueuses the cumulative distribution function
Falseuses the probability density function

Examples

LOGNORMDIST(#input!VALUE; #input!Mean; #input!Standard_deviation; false) 

Value
Mean
Standard_deviationCumulative valueLOGNORMDIST returns
0.75105false0.01281
0.75105true0.01987

Common Errors

#NUM!-

Occurs if either:

  • The x value is less than 0
  • The numerator or denominator is less than 1
#VALUE!-Occurs if the argument type isn't numeric