📎 This article includes 1 downloadable practice file ↓
In this article
NORM.S.DIST is NORM.DIST with mean 0 and standard deviation 1 — perfect for z-scores.
Syntax
=NORM.S.DIST(z, cumulative)| Argument | What it means |
|---|---|
z |
A z-score. |
Examples
Example 1
=NORM.S.DIST(1.96, TRUE)About 0.975 — 97.5% of values fall below z = 1.96.
NORM.S.DIST in practice
Where you will use it
- Probability from a z-score
- Statistical tests
- Percentiles
Worked example
| z | Formula | Result |
|---|---|---|
| 1.96 | =ROUND(NORM.S.DIST(A2,TRUE),4) | 0.975 |
| 0 | =ROUND(NORM.S.DIST(A3,TRUE),4) | 0.5 |
| -1 | =ROUND(NORM.S.DIST(A4,TRUE),4) | 0.1587 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Forgetting cumulative | TRUE for probabilities |
| Raw values | Convert to z first (STANDARDIZE) |
Related functions
NORM.S.INV · STANDARDIZE
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
⚡ Interactive Practice Lab & Formula Tester:
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Statistics advanced33 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 36 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong