How to Use Excel NORM.S.DIST Function?

Ads

Listen to this article.

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:

https://www.microsoft.com/en-in/microsoft-365/excel

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.

Syntax

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.

=NORM.S.DIST(z, cumulative)

Arguments Explanation:

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

Note:
If the argument z is non-numeric values such as letters, and symbols, then this function returns #VALUE! Error.

Examples

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.

Verdict

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.