Home › Functions › Statistical › =LOGNORM.DIST()
Statistical Excel 2010 ◉ 36 views

=LOGNORM.DIST()

Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. Use this function to analyze data that has been logarithmically transformed.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=LOGNORM.DIST(x,mean,standard_dev,cumulative)
Hover argument names in the table for details.
Output typeStatistical
Popularity5 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =LOGNORM.DIST() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download LOGNORM.DIST.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
x Number Required The value at which to evaluate the function.
mean Number Required The mean of ln(x).
standard_dev Number Required The standard deviation of ln(x).
cumulative Logical Required A logical value that determines the form of the function. If cumulative is TRUE, LOGNORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

▣ Examples

▦ Data
CellValueDescription
A2 4 Value at which to evaluate the function (x)
A3 3.5 Mean of ln(x)
A4 1.2 Standard deviation of ln(x)
A5 4 Value at which to evaluate the function (x)
A6 3.5 Mean of ln(x)
A7 1.2 Standard deviation of ln(x)
Cumulative lognormal distribution at 4, using the arguments in A2:A4. =LOGNORM.DIST(A2,A3,A4,TRUE)
Result: 0.0390836
Probability lognormal distribution at 4, using the same arguments. =LOGNORM.DIST(A2,A3,A4,FALSE)
Result: 0.0176176

§ Remarks

  • If any argument is nonnumeric, LOGNORM.DIST returns the #VALUE! error value.
  • If x ≤ 0 or if standard_dev ≤ 0, LOGNORM.DIST returns the #NUM! error value.
  • The equation for the lognormal cumulative distribution function is: LOGNORM.DIST(x,µ,o) = NORM.S.DIST(1n(x)-µ / o)

✦ Tips

  • The equation for the lognormal cumulative distribution function is: LOGNORM.DIST(x,µ,o) = NORM.S.DIST(1n(x)-µ / o)

⚠ Common Errors

#VALUE! If any argument is nonnumeric, LOGNORM.DIST returns the #VALUE! error value.
Fix: برای تمام آرگومان‌ها مقدار عددی وارد کنید.
#NUM! If x ≤ 0 or if standard_dev ≤ 0, LOGNORM.DIST returns the #NUM! error value.
Fix: Correct the input value

⇄ Related Functions

=LOGNORM.INV() Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data. =NORM.DIST() Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing. If mean or standard_dev is nonnumeric, NORM.DIST returns the #VALUE! error value.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.