How to Use Excel NORM.S.DIST Function in Office 365? – [with Examples]

NORM.S.DIST Function:

In this post, we are going to explore how to use Excel NORM.S.DIST Function in Office 365 with its syntax, explanation, and examples. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

NORM.S.DIST Function – Explanation:

• 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 a standard deviation value as 1.

Syntax:

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

Example 1:

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

Example 2:

• 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 in Office 365 with its syntax, explanation, and examples. Leave your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Similar Functions:

• NORM.DIST Function
• NORM.INV Function
• NORM.S.INV Function

See Also:

• How to Use Excel STDEVA Function in Office 365? – [with Examples]
• How to Use “Excel RAND Function” in Office 365? – {with Examples}