Menu
EXCEL NORM.DIST FUNCTION
Excel NORM.DIST Function Introduction
The Excel NORM.DIST function computes the Normal Probability Density Function or the Continuous Normal Gaussian Distribution for a given x value and distribution mean and standard deviation.
Description of Excel NORM.DIST Function
Syntax :
=NORM.DIST( x, mean, standard_dev, cumulative )
Parameters :
- The following argument are:
x –
- The value at which the distribution function should be evaluated.
mean –
- The distribution’s arithmetic mean.
standard dev –
- The distribution’s standard deviation.
cumulative –
- A logical argument indicating the type of distribution to be used:
TRUE denotes Cumulative Normal Distribution Function.
Normal Probability Density Function = FALSE
Step By Step Guide of NORM.DIST Function
Example :
The Normal Probability Distribution Function is depicted on the right, with a mean of 40 and a standard deviation of 20.
If you wish to determine the value of this equation at x = 50, use the Excel Norm.Dist method, as shown below:
Key Points
- #NUM! – This error occurs if the given standard dev parameter is 0.
- #VALUE! – Occurs if any of the given parameters is not a numeric or logical value.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
