Documentation/How Tos/Calc: LOGINV function

LOGINV

Calculates the inverse of the LOGNORMDIST function.

Syntax:

LOGINV(p; μ; σ;)

A variable is lognormally distributed if its natural logarithm is normally distributed. Parameters of the distribution are μ (mean) and σ (standard deviation).

LOGINV returns the value x, such that LOGNORMDIST(x; μ; σ;) is p.

Example:

LOGINV(0.5; 0; 1)

returns 1.

LOGNORMDIST(1; 0; 1)

returns 0.5.

See also:

LOGNORMDIST, NORMDIST, NORMSDIST, NORMSINV, NORMINV

Statistical functions