LOGNORM.INV

Returns the inverse of the log-normal distribution[1].

Syntax:

LOGNORM.INV( probability:Number, mean:Number, standard deviation:Number )

For the given probability in [0,1], returns the corresponding x-value which yields that probability in the cumulative distribution function for the log-normal distribution with given mean and standard deviation.

Revisions:

This function was added in Fireworkz 2.00.

  1. Weisstein, Eric W. "Log Normal Distribution." From MathWorld--A Wolfram Web Resource. https://mathworld.wolfram.com/LogNormalDistribution.html