LOGNORMDIST

Formulas / LOGNORMDIST
Calculate data that has been logarithmically transformed and divided into a range of values.
=LOGNORMDIST(x,mean,standard_dev)
  • x - required, value to evaluate the function on
  • mean - required
  • standard_dev - required

Examples

  • =LOGNORMDIST(4,A2,A3)

    The LOGNORMDIST function is used to calculate the cumulative lognormal distribution for a given value. For example, this returns the cumulative lognormal distribution at 4.

  • =LOGNORMDIST(A2:A3,A2,A3)

    The LOGNORMDIST function can be used to calculate the cumulative lognormal distribution for a range of values. For example, if A2 and A3 are the lower and upper bounds of a range of values, respectively, you can use the preceding formula to calculate the cumulative lognormal distribution for the entire range.

  • =LOGNORMDIST(0.4,A2,A3)

    The LOGNORMDIST function can also be used to calculate the cumulative lognormal distribution for a given probability. For example, if A2 and A3 are the lower and upper bounds of a range of values, respectively, and 0.4 is the probability, you can use the preceding formula to calculate the cumulative lognormal distribution for the given probability.


Summary

The LOGNORMDIST function calculates the cumulative lognormal distribution of a value, given a mean and standard deviation. It is available for backward compatibility.

  • The LOGNORMDIST function returns the cumulative lognormal distribution of a variable and is used to analyze data that has been logarithmically transformed.
  • The new LOGNORMDIST functions provide improved accuracy.

Frequently Asked Questions

What is the LOGNORMDIST function?
The LOGNORMDIST function calculates the cumulative lognormal distribution of a value. It is useful for analyzing data that has been logarithmically transformed.
What are the new LOGNORMDIST functions?
The new LOGNORMDIST functions provide improved accuracy and are named more accurately to reflect their usage.
Where can I find the new LOGNORMDIST functions?
The new LOGNORMDIST functions are available in Sourcetable now, and may be available in future versions of Excel.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV