LOGNORM_DIST

LOGNORM_DIST(arg1, arg2, arg3, arg4) → { number }

Returns the lognormal distribution of x, where ln(x) is normally distributed with the specified parameters.

Parameters:

Name Type Description
arg1 number

The value at which to evaluate the function, a positive number.

arg2 number

The mean of ln(x).

arg3 number

The standard deviation of ln(x), a positive number.

arg4 boolean

A logical value (true or false) that determines the function form. If it is true, the function returns the cumulative distribution function. If it is false, the function returns the probability density function.

Returns:

Type
number