The NORM.DIST function returns the value of the normal distribution for the specified mean and standard deviation.
Syntax
NORM.DIST(
x,
mean,
standard_dev,
cumulative
)
Parameters
- x: Value for which you want to calculate the normal distribution.
- mean: Arithmetic mean of the distribution
- standard_dev: Standard deviation of the distribution.
- cumulative: Logical value that determines the form of the function: if it takes the value True, it returns the cumulative distribution function. If it takes the value False, it returns the probability mass function.
Returned value
The NORM.DIST function returns a real number.
Examples
We can calculate the value of the normal distribution of mean 4 and standard deviation 1.2 for point 3.6 with the following measure:
distribución normal = NORM.DIST(3.6, 4, 1.2, FALSE())
Related functions
Category
Statistical
