Difference between revisions of "Documentation/How Tos/Calc: LOGINV function"

Revision as of 08:18, 17 July 2018

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.

• LOGNORMDIST
• NORMDIST
• NORMSDIST
• NORMSINV
• NORMINV

• Statistical functions

• Functions listed alphabetically
• Functions listed by category