MicroStrategy ONE

InverseLognormalDistribution (Inverse of Lognormal Distribution)

Returns the inverse of the lognormal cumulative distribution. Ln(x) is normally distributed using mean and standard deviation as parameters.

For more information on the lognormal cumulative distribution function, see LognormalDistribution.

Syntax

InverseLognormalDistribution(x, Mean, Stdev)

Where:

x is the probability associated with the lognormal distribution.

Mean is the mean of ln(x).

Stdev is the standard deviation of ln(x).

Expression

In the expression that follows, mean = m, stdev =s.

Usage Notes

The following conditions are invalid:

  • One of the arguments is nonnumeric
  • x < 0
  • x > 1
  • stdev < 0