How to Use the NORMDIST Function in Excel
Welcome to the guide on the NORMDIST function in Excel and Google Sheets!
Overview
The NORMDIST function calculates the likelihood that a particular value falls within a certain range, utilizing the normal distribution model. This function is particularly useful in the fields of statistics, probability, and data analysis.
Syntax
The syntax for the NORMDIST function is:
=NORMDIST(x, mean, standard_dev, cumulative)x: The value for which you want to calculate the probability.mean: The arithmetic mean of the distribution.standard_dev: The standard deviation of the distribution.cumulative: A logical value that specifies the function output. Set this to TRUE to obtain the cumulative distribution function; set it to FALSE to get the probability density function.
Examples
Example 1: Cumulative Distribution Function (CDF)
This example demonstrates how to calculate the probability that a value is less than or equal to a specified point.
| x (Value) | Mean | Standard Deviation | Cumulative | Result |
|---|---|---|---|---|
| 85 | 80 | 5 | TRUE | =NORMDIST(85, 80, 5, TRUE) |
Example 2: Probability Density Function (PDF)
This example calculates the probability density at a specified value.
| x (Value) | Mean | Standard Deviation | Cumulative | Result |
|---|---|---|---|---|
| 90 | 85 | 3 | FALSE | =NORMDIST(90, 85, 3, FALSE) |
These examples illustrate the use of the NORMDIST function in Excel and Google Sheets to compute probabilities based on the normal distribution.
More information: https://support.microsoft.com/en-us/office/normdist-function-126db625-c53e-4591-9a22-c9ff422d6d58