In this article
LOGNORM.DIST models values whose logarithm is normal: incomes, house prices, stock prices, file sizes.
Advertisement
Syntax
=LOGNORM.DIST(x, mean, standard_dev, cumulative)| Argument | What it means |
|---|---|
x |
Value |
mean, standard_dev |
Of ln(x) |
cumulative |
TRUE/FALSE |
Examples
Example 1
=ROUND(LOGNORM.DIST(A2,B2,C2,TRUE),4)Result: 0.637. See the worked example table below for more cases.
LOGNORM.DIST in practice
Where you will use it
- Share price ranges
- Income distributions
- Delivery-time models
Worked example
| x | mean of ln | sd of ln | Formula | Result |
|---|---|---|---|---|
| 100 | 4.5 | 0.3 | =ROUND(LOGNORM.DIST(A2,B2,C2,TRUE),4) | 0.637 |
| 150 | 4.5 | 0.3 | =ROUND(LOGNORM.DIST(A3,B3,C3,TRUE),4) | 0.9556 |
| 50 | 4 | 0.5 | =ROUND(LOGNORM.DIST(A4,B4,C4,TRUE),4) | 0.4302 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Using the plain mean | mean and SD are of LN(x) |
| x of 0 or less | #NUM! |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong