Excel NORM.S.DIST Function
The NORM.S.DIST calculates and returns the standard normal cumulative distribution function or probability density function of a value for an arithmetic mean of 0 and standard deviation of 1.
The NORM.S.DIST function returns a numeric value.
- The #VALUE! error occurs if any of the supplied arguments is nonnumeric.
Suppose that you have a list of z values, to calculate the cumulative distribution function at the values, please copy or enter the formula below in top cell of the Cumulative distribution function table (cell C3), press Enter to get the first result, and then drag the fill handle of the result cell down to apply the formula to the below cells:
√ Note: The dollar signs ($) above indicate absolute references, which means the array argument in the formula won't change when you move or copy the formula to other cells. However, there are no dollar signs added to x since you want it to be dynamic. After entering the formula, drag the fill handle down to apply the formula to the below cells.
To calculate the probability density function at the values, please copy or enter the formula below in top cell of the Probability density function table (cell 10), press Enter to get the first result, and then drag the fill handle down to apply the formula to the below cells:
NORM.S.DIST VS. NORM.DIST
- NORM.S.DIST uses the standard normal distribution which is a special case of the normal distribution where the mean is 0 and the standard deviation is 1;
- NORM.DIST uses the normal distribution with the mean and standard deviation you specified.