Returns the standard normal distribution for a given value.
Синтаксис
NORM.S.DIST(z, cumulative)Аргументы
zобязательно
The value for which you want the distribution.
cumulativeобязательно
A logical value that determines the form of the function: TRUE for the cumulative distribution function, FALSE for the probability mass function.
This function calculates the probability that a random variable follows a standard normal distribution (mean of 0 and standard deviation of 1). It is commonly used in hypothesis testing and statistical analysis to determine the area under the normal curve.
=NORM.S.DIST(1, TRUE)→0.841344746Returns the cumulative probability for a z-score of 1.
=NORM.S.DIST(0, FALSE)→0.39894228Returns the probability density for a z-score of 0.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =NORM.S.DIST(z, cumulative) and replace the arguments with your specific values or cell references.
NORM.S.DIST is specifically for the standard normal distribution (mean=0, std_dev=1), while NORM.DIST allows you to specify any mean and standard deviation.