WorksheetFunction.NormSDist Method
| Excel Developer Reference |
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
Syntax
expression.NormSDist(Arg1)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Double | Z - the value for which you want the distribution. |
Return Value
Double
Remarks
If z is nonnumeric, NORMSDIST returns the #VALUE! error value.
The equation for the standard normal density function is:
.gif "Equation")
See Also