Returns the normal distribution for the specified mean and standard deviation.
Sintaxis
NORM.DIST(x, mean, standard_dev, cumulative)Argumentos
xobligatorio
The value for which you want the distribution.
meanobligatorio
The arithmetic mean of the distribution.
standard_devobligatorio
The standard deviation of the distribution.
cumulativeobligatorio
A logical value that determines the form of the function.
This function calculates the probability density function or the cumulative distribution function for a normal distribution. It is widely used in statistics for hypothesis testing and modeling continuous data.
=NORM.DIST(40, 50, 5, TRUE)→0.02275Calculates the cumulative probability for a value of 40 in a normal distribution with a mean of 50 and standard deviation of 5.
Identify parameters
Determine the value (x), the mean, and the standard deviation of your dataset.
Choose distribution type
Set cumulative to TRUE for the cumulative distribution function or FALSE for the probability density function.
TRUE returns the cumulative distribution function (area under the curve), while FALSE returns the probability density function (height of the curve).