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.

Frequently Asked Questions

What is the NORMSDIST function?
The NORMSDIST function is a function that calculates the standard normal cumulative distribution function. It has a mean of 0 and a standard deviation of 1.
What is the new NORM.S.DIST function?
The new NORM.S.DIST function is an improved version of the NORMSDIST function. It provides improved accuracy, and its names better reflect their usage.
What is a standard normal cumulative distribution function?
A standard normal cumulative distribution function is a function used to describe a probability distribution. It has a mean of 0 and a standard deviation of 1.
What is the advantage of the new NORM.S.DIST function?
The new NORM.S.DIST function provides improved accuracy compared to the original NORMSDIST function. Additionally, the names of the functions better reflect their usage.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV