ID EN
…
#Statistical

NORM.DIST

Excel Functions

Get values and areas for the normal distribution

Syntax

EXCEL 
=NORM.DIST(x, mean, standard_dev, cumulative)

Arguments

Parameter Description
x The input value x.
mean The center of the distribution.
standard_dev The standard deviation of the distribution.
cumulative A boolean value that determines whether the probability density function or the cumulative distribution function is used.

Return Value

Output of the normal PDF and CDF

Details

The NORM.DIST function returns values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF). For example, NORM.DIST(5,3,2,TRUE) returns 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. If the cumulative flag is set to FALSE, as in NORM.DIST(5,3,2,FALSE), the output is 0.121 which corresponds to the point on the curve at 5. The output of the function is visualized by drawing the bell-shaped curve defined by the input to the function. If the cumulative flag is set to TRUE, the return value is equal to the area to the left of the input. If the cumulative flag is set to FALSE, the return value is equal to the value on the curve. The normal PDF is

Examples

Example 1

The NORM.DIST function returns values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF). For exa

EXCEL 
=NORM.DIST(5,3,2,TRUE)=0.841
Example 2
EXCEL 
=NORM.DIST(5,3,2,FALSE)=0.121
Explanation

Probability density functions model problems over continuous ranges. The area under the function represents the probability of an event occurring in t

EXCEL 
=NORM.DIST(95,μ,σ,TRUE)-NORM.DIST(90,μ,σ,TRUE)
Explanation

In this example, if we substitute a mean of 80 in for μ and a standard deviation of 10 in for σ, then the probability of the student scoring between 9

EXCEL 
=NORM.DIST(95,80,10,TRUE)-NORM.DIST(90,80,10,TRUE)=0.0918

See Also

NORM.S.DIST NORM.INV