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.