Table of Contents
The NORMDIST function in Excel can be used to calculate probabilities of a normal distribution. This function uses four parameters: the value for which you want the probability, the mean of the distribution, the standard deviation of the distribution, and whether the cumulative probability or the probability density is required. You can use this function to calculate the probability of a given value, the probability between two values, or the area under the normal curve.
A is the most commonly used distribution in all of statistics.
To calculate probabilities related to the normal distribution in Excel, you can use the function, which uses the following basic syntax:
=NORMDIST(x, mean, standard_dev, cumulative)
where:
- x: The value of interest in the normal distribution
- mean: The mean of the normal distribution
- standard_dev: The standard deviation of the normal distribution
- cumulative: Whether to calculate cumulative probabilities (this is usually TRUE)
The following examples show how to use this function to calculate probabilities related to the normal distribution.
Example 1: Calculate Probability Less than Some Value
Suppose the scores for an exam are normally distributed with a mean of 90 and a standard deviation of 10.
Find the probability that a randomly selected student receives a score less than 80.
The following screenshot shows how to use the NORMDIST() function in Excel to calculate this probability:
The probability that a randomly selected student receives a score less than 80 is 0.1587.
Example 2: Calculate Probability Greater than Some Value
Suppose the scores for an exam are normally distributed with a mean of 90 and a standard deviation of 10.
Find the probability that a randomly selected student receives a score greater than 80.
To find this probability, we can simply do 1 – NORMDIST() in Excel as follows:
Example 3: Calculate Probability Between Two Values
Suppose the scores for an exam are normally distributed with a mean of 90 and a standard deviation of 10.
Find the probability that a randomly selected student receives a score between 87 and 93.
To find this probability, we can subtract the larger value of NORMDIST() from the smaller value of another NORMDIST() in Excel as follows:
The probability that a randomly selected student receives a score between 87 and 93 is 0.2358.
The following tutorials explain how to perform other tasks related to the normal distribution in Excel: