LOGNORM.DIST(5,3,1.2)
LOGNORM.DIST(A2:A6)
LOGNORM.DIST(A1:B2,5)
Syntax
LOGNORM.DIST(x, mean, standard_deviation)
- x - The input to the lognormal cumulative distribution function.
- mean - The mean (mu) of the lognormal cumulative distribution function.
- standard_deviation - The standard deviation (sigma) of the lognormal cumulative distribution function.
Examples
LOGNORM.DIST(20,30) returns a value of 25.
LOGNORM.DIST(A2:A6) returns the average of the numbers in cells A2 through A6.
LOGNORM.DIST(A1:B2,5) returns the average of the numbers contained in cells A1 through B2 and the number 5.
Notes
- A minimum of two values must be supplied as value arguments. Else, VARS will return an error.
- VARS will ignore any cells that include text and logical values. To calculate variance while interpreting text values as 0, use VARA
- VARS calculates variance for a sample. To calculate variance for an entire population, use VARP.