LOGINV
Returns the inverse of the lognormal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Legacy inverse lognormal function.
Syntax
LOGINV(probability, mean, standard_dev)
Arguments
probability(number) — Prob.mean(number) — Ln(mean).standard_dev(number) — Ln(SD).
Examples
Legacy Inv Lognorm
Calculate inv.
FORMULA
=LOGINV(0.5, 0, 1)
RESULT
1
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | p | m | s |
| 2 | 0.5 | 0 | 1 |