NORM.S.DIST

Formulas / NORM.S.DIST
Calculate the standard normal CDF and PDF.
=NORM.S.DIST(z, cumulative)
  • z - required, the value for which the distribution is being calculated
  • cumulative - required, determines the form of the function

Examples

  • =NORM.S.DIST(1,TRUE)

    The NORM.S.DIST function returns the standard normal cumulative distribution function (CDF) for a given value of x. This means that it returns the probability that a value from the standard normal distribution will be less than or equal to the given x value. For example, this returns 0.8413, which is the probability that a value from the standard normal distribution will be less than or equal to 1.

  • =NORM.S.DIST(1,FALSE)

    The NORM.S.DIST function can also be used to return the probability density function (PDF) of the standard normal distribution for a given value of x. This means that it returns the probability that a value from the standard normal distribution will be equal to the given x value. For example, this returns the standard normal PDF.

  • =NORM.S.DIST(1,TRUE)=0.8413

    The NORM.S.DIST function can also be used to calculate the standard normal distribution for a given value of x. This means that it returns the probability that a value from the standard normal distribution is equal to the given x value. For example, this returns the standard normal distribution.


Summary

The NORM.S.DIST function is a useful Sourcetable tool that returns the standard normal distribution for a data set with a mean of 0 and a standard deviation of 1. It can be used to create tables of standard normal curve areas.

  • The NORM.S.DIST function returns the standard normal CDF and PDF when the cumulative flag is set to TRUE.
  • The standardized input is a z-score value, which represents how far a value is from the mean of a distribution.
  • The NORM.S.S.DIST function uses the standard normal distribution when the cumulative flag is set to FALSE.

Frequently Asked Questions

What is the NORM.S.DIST function?
The NORM.S.DIST function is a function that returns the standard normal distribution. The standard normal distribution has a mean of 0 and a standard deviation of 1.
What can I use the NORM.S.DIST function for?
The NORM.S.DIST function can be used in place of a table of standard normal curve areas.
What is a standard normal curve?
A standard normal curve is a type of normal distribution curve where the mean is 0 and the standard deviation is 1.
What is the format of the NORM.S.DIST function?
The format of the NORM.S.DIST function is NORM.S.DIST(x, cumulative). The x parameter is the value for which you want the standard normal distribution and the cumulative parameter is a logical value that determines the form of the function.
Are there any specific parameters required for the NORM.S.DIST function?
Yes, there are two parameters required for the NORM.S.DIST function. The first parameter is the x value which is the value for which you want the standard normal distribution. The second parameter is a logical value that determines the form of the function (cumulative or not).

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV