Home › Functions › Statistical › =NORM.S.DIST()
Statistical Excel 2010 ◉ 24 views

=NORM.S.DIST()

NORM.S.DIST returns the standard normal distribution (has a mean of zero and a standard deviation of one). Use this function in place of a table of standard normal curve areas.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=NORM.S.DIST(z,cumulative)
Hover argument names in the table for details.
Output typeStatistical
Popularity18 / 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 =NORM.S.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 NORM.S.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
z Number Required This is the value for which you want the distribution.
cumulative Logical Required The
tRUE Number Optional or
fALSE Logical Optional . This logical value determines the form of the function. If cumulative is TRUE then NORM.S.DIST returns the cumulative distribution function. If it is FALSE, it returns the probability mass function.

▣ Examples

Normal cumulative distribution function at 1.333333 =NORM.S.DIST(1.333333,TRUE)
Result: 0.908788726
Normal probability distribution function at 1.333333 =NORM.S.DIST(1.333333,FALSE)
Result: 0.164010148

§ Remarks

  • If z is nonnumeric, NORM.S.DIST returns the #VALUE! error.
  • The standard normal density function is determined with this equation:

✦ Tips

  • The standard normal density function is determined with this equation:

⚠ Common Errors

#VALUE! If z is nonnumeric, NORM.S.DIST returns the #VALUE! error.
Fix: Ensure the arguments are real numbers, not text

⇄ Related Functions

=STANDARDIZE() Returns a normalized value from a distribution characterized by mean and standard_dev. =GAUSS() Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean. =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. =NORM.S.INV() Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

💬 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.