Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data.

LOGNORM.INV takes 3 required arguments and no optional arguments:

Syntax: LOGNORM.INV(probability , mean, standard_dev)

The arguments for the LOGNORM.INV function are:
Argument Required? Description
probability Required A probability associated with the lognormal distribution.
mean Required The mean of ln(x).
standard_dev Required The standard deviation of ln(x).
comments powered by Disqus