NORM.S.DIST Function

Basic Description

The Excel NORM.S.DIST function calculates the Standard Normal Cumulative Distribution Function for a supplied value. The Norm.S.Dist function is new in Excel 2010 and so is not available in earlier versions of Excel. However, the function is simply a new version of the Normsdist function that is available in earlier versions of Excel.

Syntax: NORM.S.DIST( z, cumulative )

Where the function arguments are listed in the table below :

z The value at which you want to evaluate the function
cumulative A logical argument which denotes the type of distribution to be used:

TRUE = Cumulative Normal Distribution Function
FALSE = Normal Probability Density Function

 

Norm.S.Dist Function Examples

Example 1 – Standard Normal Probability Density Function

The chart on the right shows the the Standard Normal Probability Density Function.

If you want to calculate the value of this function at x = 0.5, this can be done using the Excel Norm.S.Dist function, as follows:

=NORM.S.DIST( 0.5, FALSE )

This gives the result 0.352065327.

Plot of Standard Normal Probability Density Function

Standard Normal Probability Density Function
Example 2 – Standard Cumulative Distribution Function

The chart on the right shows the the Standard Cumulative Normal Distribution Function.

If you want to calculate the value of this function at x = 0.8, this can be done using the Excel Norm.S.Dist function, as follows:

=NORM.S.DIST( 0.8, TRUE )

This gives the result 0.788144601.

Plot of Standard Normal Cumulative Distribution Function

Standard Normal Cumulative Distribution Function

 

Norm.S.Dist Function Error

If you get an error from the Excel Norm.S.Dist function this is likely to be the #VALUE! error:

#VALUE! Occurs if the supplied argument is not recognised as a numeric value

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment