NORM.S.DIST()/NORMSDIST()

Syntax. NORM.S.DIST(z,cumulative)

Definition. This function returns the values or probabilities of the distribution function of a standard normal distributed random variable. The standard normal distribution has a mean of 0 and a standard deviation of 1. Use this function instead of a table containing the values of the distribution function of a standard normal distribution.

Arguments

  • z (required). The distribution value (quantile) for which you want to calculate the probability

  • cumulative (required). The logical value that represents the type of the function. If cumulative is TRUE, the NORM.S.DIST() function returns the value of the distribution function (cumulative density function). If cumulative is FALSE, the NORM.S.DIST() ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial