NORM S DIST

The NORM.S.DIST function in Excel is a statistical function that returns the standard normal distribution, which has a mean of zero and a standard deviation of one. This function is used to calculate both the cumulative distribution function (CDF) and the probability density function (PDF) for a standard normal distribution. The syntax of the function is NORM.S.DIST(z, cumulative), where z is the value for which you want the distribution, and cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORM.S.DIST returns the CDF, which gives the probability that a standard normal random variable is less than or equal to z. If cumulative is FALSE, it returns the PDF, which gives the height of the probability density function at z. This function is particularly useful in statistical analyses for calculating probabilities and assessing the likelihood of different outcomes in a standard normal distribution.