NORM.S.DIST Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. To get the standard normal cumulative distribution (CDF) and the standard normal probability density function (PDF), you can use the NORM.S.DIST function.
In this post, we are going to explore how to use Excel NORM.S.DIST Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:
Explanation of NORM.S.DIST Function
- It is one of the built-in functions in Microsoft Excel.
- This function returns the standard normal distribution.
- NORM.S.DIST Function returns values for the standard normal probability density function (PDF), standard normal cumulative distribution function (CDF).
- This distribution considers mean value as 0 and the standard deviation value as 1.
- Here, you will see the syntax of the NORM.S.DIST function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
- z – The input value to which you want to find the distribution.
- Cumulative – The boolean value that represents the form of the function. If it is TRUE, this function returns the cumulative distribution function (CDF). If it is FALSE, it returns the probability density function (PDF).
If the argument z is non-numeric values such as letters, and symbols, then this function returns #VALUE! Error.
Let’s see some examples to make you understand how NORM.S.DIST function will work.
- In the below screenshot, you can see the input ranges in Column B & E, its output CDF values are listed in Columns C and PDF values are displayed in Column F.
- To find CDF values, you have to give boolean value as TRUE.
- In the below screenshot, you can see the output PDF values in Column G. To get PDF values, you need to give the boolean value as FALSE.
- If the argument z is non-numeric values such as letters, and symbols, then this function returns #VALUE! Error.
From the above examples, you can understand how to give inputs to this function and get the proper result.
In this post, you can learn the usage of Excel NORM.S.DIST Function with its syntax, explanation, and examples. Leave your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Use the following video to know how to apply the Excel NORM.S.DIST function in the spreadsheet with examples.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?