Returns the normal distribution for the specified mean and standard deviation.
תחביר
NORM.DIST(x, mean, standard_dev, cumulative)ארגומנטים
xחובה
The value for which you want the distribution.
meanחובה
The arithmetic mean of the distribution.
standard_devחובה
The standard deviation of the distribution.
cumulativeחובה
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).