Documentation/How Tos/Calc: LOGINV function

From Apache OpenOffice Wiki
Jump to: navigation, search



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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_LOGINV_function&oldid=243477"
Views
Personal tools
Navigation
Print/export
Tools