NORMDIST

Formulas / NORMDIST
Return values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF).
NORMDIST(x,mean,standard_dev,cumulative)
  • x - the value for which the distribution is being calculated
  • mean - the arithmetic mean of the distribution
  • standard_dev - the standard deviation of the distribution
  • cumulative - determines the form of the function

Examples

  • =NORM.DIST(5,3,2,TRUE)

    The NORMDIST function can be used to calculate the area to the left of a given point within a bell-shaped curve. For example, this will return the output 0.841, which corresponds to the area to the left of 5 under the bell-shaped curve described by a mean of 3 and a standard deviation of 2.

  • =NORM.DIST(5,3,2,FALSE)

    The NORMDIST function can also be used to calculate the point on the curve at a given value. For example, this will return the output 0.121, which corresponds to the point on the curve at 5.

Summary

The NORMDIST function is used to calculate a normal distribution and is used in many statistical applications. It returns the standard normal distribution when mean equals 0, standard_dev equals 1, and cumulative equals TRUE.

  • The NORMDIST function calculates values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF). It returns values for the normal distribution and the CDF.
  • The NORMDIST function returns the output 0.841 for the area to the left of 5 under the bell-shaped curve described by a mean of 3 and a standard deviation of 2 using NORM.DIST(5,3,2,TRUE).
  • The NORMDIST function draws the bell-shaped curve using the input values.


Frequently Asked Questions

What is the NORMDIST function?
The NORMDIST function is a statistical function that calculates the normal distribution. It is commonly used in many areas of statistics.
What is the new NORM.DIST function?
The new NORM.DIST function may provide improved accuracy over the NORMDIST function. It is designed to give more accurate results when calculating the normal distribution.
What is the standard normal distribution?
The standard normal distribution is the normal distribution when mean equals 0, standard_dev equals 1, and cumulative equals TRUE.
What are the applications of NORMDIST function?
  • Calculating probabilities
  • Measuring central tendency
  • Computing confidence intervals
  • Determining outliers

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.