LOGNORM.DIST - Function returns the logarithmic distribution of x in Excel
The following article introduces you to the LOGNORM.DIST function - one of the functions in the statistical group is very popular in Excel.
Description: The function returns the logarithmic distribution of x. Where LN (x) is usually distributed with parameter mean and standard deviation. Support functions from Excel 2010 onwards.
Syntax: LOGNORM.DIST (x, mean, standard_dev, cumulative)
Inside:
- x : Value to evaluate the function, is a required parameter.
- mean: The average value of LN (x) , is a required parameter.
- standard_dev: Standard deviation of LN (x), is a required parameter.
- cumulative: A logical value that determines the form of the function, which is a required parameter, including:
+ cumulative = True -> returns the cumulative distribution function.
+ cumulative = False -> returns the probability density function.
Attention:
- Any argument except ( cumulative) is not a number -> function returns the #VALUE! Error value
- If x ≤ 0 or standard_dev ≤ 0 -> the function returns the #NUM! Error value
- The cumulative standard logarithmic distribution equation is:
LOGNORM.DIST (x, µ, o) = NORM.S.DIST (1n (x) -µ / o)
For example:
Find the cumulative standard probability and logarithmic distribution as described in the data table below:
1. Calculate cumulative standard logarithmic distribution.
- In the cell to calculate enter the formula : = LOGNORM.DIST (D6, D7, D8, D9)
- Press Enter -> cumulative standard logarithmic distribution is:
2. Calculate probability distribution logarithm.
- In the cell to calculate enter the formula: = LOGNORM.DIST (D6, D7, D8, D10)
- Press Enter -> probability plot distribution. was:
Above are instructions and some specific examples when using the LOGNORM.DIST function in Excel.
Good luck!
You should read it
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
- GAMMA.DIST function - The function returns the gamma distribution in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- BETA.DIST function - The function returns the Beta distribution in Excel
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excel
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel
- F.DIST - The function returns the probability distribution F in Excel
- T.DIST - The function returns the Student t-distribution on the left in Excel
- CHISQ.DIST - Function returns the distribution when squared in Excel
- T.DIST.2T - The function returns the two-tailed Student distribution in Excel
- NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
- F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
Maybe you are interested
Differences between Windows 10 Feature Update and Cumulative Update
NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel
BETADIST function - Cumulative distribution function Beta in Excel
CUMPRINC function - The function calculates the cumulative capital amount payable in Excel