NORM.DIST function
The NORM.DIST function in Excel returns the probability density function (PDF) or the cumulative distribution function (CDF) for the normal distribution. This function is widely used in statistics to calculate the probability of a value occurring within a specified range of a normally distributed dataset.
Syntax:
NORM.DIST(x, mean, standard_dev, cumulative)
Arguments:
- x: Required. The value for which you want to calculate the distribution. This is the value for which you will calculate the probability.
- mean: Required. The mean (average) of the normal distribution.
- standard_dev: Required. The standard deviation of the normal distribution. It must be a positive number.
- cumulative: Required. A logical value that determines the form of the function:
- TRUE: Returns the cumulative distribution function (CDF), which gives the probability that a value is less than or equal to
xin the distribution. - FALSE: Returns the probability density function (PDF), which gives the probability of observing a specific value of
xin the distribution.
- TRUE: Returns the cumulative distribution function (CDF), which gives the probability that a value is less than or equal to
Output:
- If cumulative = TRUE, the function returns the cumulative probability that a value from the distribution is less than or equal to
x. - If cumulative = FALSE, the function returns the probability density (height of the curve) for the given
xin the distribution.
How It Works:
- Normal distribution is a symmetric, bell-shaped distribution characterized by the mean (which represents the center) and the standard deviation (which controls the spread of the distribution).
- The cumulative distribution function (CDF) gives the probability that a value will fall less than or equal to
xin a normal distribution. This is useful for finding probabilities within a range. - The probability density function (PDF) gives the likelihood of a specific value of
xoccurring, which is useful for understanding the shape and behavior of the normal distribution curve.
Example 1: Cumulative Probability
Suppose you have a normal distribution with a mean of 50 and a standard deviation of 10, and you want to find the probability that a value is less than or equal to 55.
Use the formula:
=NORM.DIST(55, 50, 10, TRUE)
This will return the cumulative probability that a value from this normal distribution is less than or equal to 55. In other words, it gives the probability of observing a value ≤ 55.
Example 2: Probability Density
Using the same normal distribution, suppose you want to find the probability density at 55 (i.e., the height of the probability curve at this point).
Use the formula:
=NORM.DIST(55, 50, 10, FALSE)
This will return the probability density function (PDF) for the value 55, indicating how likely it is to observe a value around 55 in the normal distribution.
Example 3: Cumulative Probability for a Range
If you want to find the probability that a value falls between 40 and 60 in the same distribution, you can calculate the cumulative probabilities for both 60 and 40 and subtract the two results:
=NORM.DIST(60, 50, 10, TRUE) - NORM.DIST(40, 50, 10, TRUE)
This will give the probability that a value from the distribution falls between 40 and 60.
Key Points:
NORM.DISTis used to compute either the cumulative probability or the probability density for a normal distribution.- Cumulative Distribution (TRUE) provides the probability that a value will be less than or equal to
x. - Probability Density (FALSE) provides the height of the normal distribution curve at
x, but not the actual probability for a specific value (since the probability of a single point is 0 in a continuous distribution). - Normal distribution is symmetric, with the mean at the center and the standard deviation determining the spread.
Use Cases:
- Statistics: Finding probabilities for data that follows a normal distribution.
- Risk management: Calculating probabilities of values falling below or above a certain threshold.
- Finance: Estimating the likelihood of returns falling within a specific range.
- Quality control: Determining the likelihood that measurements fall within a given tolerance.
Notes:
NORM.DISTwas introduced in Excel 2010 and is available in later versions. In earlier versions, you would useNORMDIST.- The mean and standard deviation must be set according to your specific dataset, as these parameters define the shape of the normal distribution.