Description Computes the inverse of the cumulative lognormal distribution of x, where the logarithm of x is normally distributed.
Syntax LOGINV (prob, mean, st_dev)
| Argument | Description |
|---|---|
| prob | The probability, as computed by the LOGNORMDIST function. |
| mean | The arithmetic mean of the logarithm of x. |
| st_dev | The standard deviation of the logarithm of x. |
Remarks LOGINV assumes the logarithm of x is normally distributed, meaning that, if you graph the distribution with a logarithmic X axis, the bell-shaped curve will appear.
Equation
Example This function returns 16.0002:
See Also LOGNORMDIST
