The NORM.S.DIST function in Excel returns the standard normal distribution (i.e., it has a mean of zero and a standard deviation of one). You can use this function in place of using a table of standard normal curve areas.
Syntax
For a standard normal distribution, this is the syntax:
NORM.S.DIST(z,cumulative)
This function syntax uses the following arguments:
-
z Required. This is the value for which you want the distribution.
-
cumulative Required. The cumulative argument can be either TRUE or FALSE. 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.
Remarks
-
If z is nonnumeric, NORM.S.DIST returns the #VALUE! error.
-
The standard normal density function is determined with this equation:
Example
Copy the following entire table. Paste it into cell A1 (and adjacent cells) in a new Excel worksheet. If you do not automatically see results, select the formula, press F2 and press Enter. Adjust column widths if needed to see everything.
|
Formula |
Description |
Result |
|---|---|---|
|
=NORM.S.DIST(1.333333,TRUE) |
Normal cumulative distribution function at 1.333333 |
0.908788726 |
|
=NORM.S.DIST(1.333333,FALSE) |
Normal probability distribution function at 1.333333 |
0.164010148 |
