Documentation/How Tos/Calc: LOGINV function
From Apache OpenOffice Wiki
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.