The NORM.S.DIST function returns the standard normal distribution of a supplied value.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- The NORM.S.DIST function replaces the NORMSDIST function included in earlier versions of Excel.
|z||The value for which you want the distribution|
|cumulative||A logical value that determines the form of the function
|2||=NORM.S.DIST(1.5,TRUE)||0.933193||Normal cumulative distribution function at 1.5|
|3||=NORM.S.DIST(1.5,FALSE)||0.129518||Normal probability distribution function at 1.5|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the supplied arguments are not recognized as numeric values|
The standard normal distribution is a simplified version of the normal distribution function which arises when the mean of the distribution is 0 and the standard deviation is 1.
The equation for the standard normal density function is:
See Wikipedia for more information on normal distribution.