LOGNORM.INV Function Explained
The LOGNORM.INV Function in Microsoft Excel returns the inverse of the lognormal cumulative distribution function for a specified mean and standard deviation. It takes three arguments: probability, mean, and standard_dev. It returns the value that corresponds to the given probability in a lognormal distribution with the given mean and standard deviation.
LOGNORM.INV Function Syntax
LOGNORM.INV(probability, mean, standard_dev)
- probability: The probability associated with the lognormal distribution.
- mean: The mean of the lognormal distribution.
- standard_dev: The standard deviation of the lognormal distribution.