NORM.S.DIST
Definition
Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
Use this function in place of a table of standard normal curve areas.
Sample Usage
Syntax – Standard Normal Distribution
NORM.S.DIST(z,cumulative)
The NORM.S.DIST function syntax has the following arguments:
Z Required. The value for which you want the distribution.
Cumulative Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.
Remarks
If z is nonnumeric, NORM.S.DIST returns the #VALUE! error value.
The equation for the standard normal density function is:
In order to use the NORM.S.DIST formula, start with your edited Excellentable
Then type in the NORM.S.DIST formula in the area you would like to display the outcome:
By adding the values you would like to calculate the NORM.S.DIST formula for, Excellentable will generate the outcome:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|