# NORMSDIST

Formulas / NORMSDIST
Calculate the standard normal cumulative distribution.
`NORMSDIST(z)`
• Z - required value for which the distribution is calculated

## Examples

• `=NORMSDIST(1.333333)`

The NORMSDIST function returns the normal cumulative distribution function. For example, this returns the normal cumulative distribution function.

• `=NORMSDIST(1.5)`

The NORMSDIST function allows you to calculate a probability given a z-score. For example, if you want to know the probability of a z-score being higher than 1.5, you would use the formula to get the cumulative probability.

• `=NORMSINV(probability)`

The NORMSDIST function can also be used to calculate the inverse of a normal distribution. For example, if you know the probability of a z-score being higher than 1.5, you can use the formula to get the corresponding z-score.

• `=NORMSDIST(2.5)-NORMSDIST(1.5)`

The NORMSDIST function can be used to calculate the area under the curve for a normal distribution. For example, if you want to calculate the area under the curve between 1.5 and 2.5, you can use the formula to calculate the area under the curve.

## Summary

The NORMDIST function in Excel calculates the probability density function (PDF) or the cumulative distribution function (CDF) of the normal distribution for a specified value, mean, and standard deviation. It is commonly used in statistical analysis to determine the likelihood of a particular value occurring within a normally distributed population.

• The NORMSDIST function is supported in Excel 2003 and later versions.
• The NORMSDIST function calculates the probability density function (PDF) or the cumulative distribution function (CDF) of the normal distribution for a given value, mean, and standard deviation.
• The NORMSDIST function is commonly used in statistical analysis and hypothesis testing to calculate probabilities and critical values associated with the normal distribution.
• In Excel 2010 and later versions, the NORMSDIST function has been replaced with the NORM.DIST function, which provides additional functionality and improved accuracy. However, the NORMSDIST function is still available for compatibility with earlier versions.