LOGINV Function Explained
The LOGINV
Function in Microsoft Excel returns the inverse of the lognormal cumulative distribution. It takes three arguments: probability
, mean
, and standard_dev
. The probability
argument is a probability associated with the lognormal distribution, the mean
argument is the mean of the lognormal distribution, and the standard_dev
argument is the standard deviation of the lognormal distribution.
LOGINV Function Syntax
LOGINV(probability, mean, standard_dev)
- probability: The probability associated with the lognormal distribution. Must be between 0 and 1.
- mean: The mean of the lognormal distribution.
- standard_dev: The standard deviation of the lognormal distribution.