I. Intro
The NORM.S.DIST function returns the standard normal distribution, which has a mean value of zero and a standard deviation of one. NORM.S.DIST is the result of NORM.DIST returning the standard normal distribution. You can use this function instead of standard normal curve area tables.
II. About the function
- Formula: =NORM.S.DIST(x,cumulative)
- Parameters:
- x (required): The value whose distribution needs to be calculated.
- cumulative (required): A logic value that determines the function's form. If it is TRUE, then it returns the cumulative distribution function; if it is FALSE, then it returns the probability density function.
- Example: =NORM.S.DIST(2.4,TRUE)
III. Steps
Use the NORM.S.DIST function
- Select a cell and click Formulas on the toolbar, then select Statistical > NORM.S.DIST. You can also directly enter =NORM.S.DIST in a cell.
- Enter the parameters in the cell. For example:
- =NORM.S.DIST(2.4,TRUE)
- =NORM.S.DIST(2.4,FALSE)
- Press Enter to display the results. The results of the examples are:
- 0.991802465
- 0.02239453
250px|700px|reset
Delete the NORM.S.DIST function
Select the cell with the NORM.S.DIST function, and press Delete.