Compatibility
Excel 2007 (Compatibility)
◉ 29 views
=NORMDIST()
This function 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.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=NORMDIST(x,mean,standard_dev,cumulative)
Hover argument names in the table for details.
Output typeNumber
Popularity28 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =NORMDIST() 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)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
x |
Number | Required | The value for which you want the distribution |
mean |
Number | Required | The arithmetic mean of the distribution |
standard_dev |
Number | Required | The standard deviation of the distribution |
cumulative |
Logical | Required | A logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if cumulative is FALSE, it returns the probability mass function. |
▣ Examples
▦ Data
| Cell | Value | Description |
|---|---|---|
A2 |
42 | Value for which you want the distribution |
A3 |
40 | Arithmetic mean of the distribution |
A4 |
1.5 | Standard deviation of the distribution |
A5 |
42 | Value for which you want the distribution |
A6 |
40 | Arithmetic mean of the distribution |
A7 |
1.5 | Standard deviation of the distribution |
Cumulative distribution function for the terms above
=NORMDIST(A2,A3,A4,TRUE)
Result:
0.9087888
Probability mass function for the terms above
=NORMDIST(A2,A3,A4,FALSE)
Result:
0.10934
§ Remarks
- If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value.
- If standard_dev ≤ 0, NORMDIST returns the #NUM! error value.
- If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST.
- The equation for the normal density function (cumulative = FALSE) is:
- When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.
✦ Tips
- This function has been replaced along with other functions that may provide improved accuracy and whose names better reflect their purpose. This function remains available for backward compatibility but may not be available in future versions of Excel. Consider now using the newer functions.
- If mean = 0, standard_dev = 1, and cumulative = TRUE, NORMDIST returns the standard normal distribution, NORMSDIST.
- The equation for the normal density function (cumulative = FALSE) is:
- When cumulative = TRUE, the formula is the integral from negative infinity to x of the given formula.
⚠ Common Errors
#VALUE!
If mean or standard_dev is nonnumeric, NORMDIST returns the #VALUE! error value.
Fix: برای mean و standard_dev مقادیر عددی وارد کنید.
#NUM!
If standard_dev ≤ 0, NORMDIST returns the #NUM! error value.
Fix: >0
💬 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!