Functions
LOGNORM.DIST
Lognormal distribution
Try it
When to use it
When should I use LOGNORM.DIST?
Use LOGNORM.DIST when your data is positively skewed and cannot go below zero — such as asset prices, incomes, or species population sizes. Supply cumulative=TRUE for the probability that the random variable is at most x, or FALSE for the probability density at x.
Used in
Syntax
LOGNORM.DIST(x,mean,stdev,cumulative)Examples
=LOGNORM.DIST(4,4,6,TRUE) // => 0.33155709720516946
=LOGNORM.DIST(4,4,6,FALSE) // => 0.015117931652006736