Check Sheet Logo
Check Sheet

NORM.S.DIST

The NORM.S.DIST function returns the standard normal cumulative distribution function. It calculates the probability that a random variable with a standard normal distribution is less than or equal to x. This function is commonly used in statistical analysis and hypothesis testing.

Usage

Use the NORM.S.DIST formula with the syntax shown below, it has 1 required parameter:

=NORM.S.DIST(x)
Parameters:
  1. x (required):
    The value for which you want to calculate the standard normal cumulative distribution function. Must be a numeric value.

Examples

Here are a few example use cases that explain how to use the NORM.S.DIST formula in Google Sheets.

Calculate the probability of a random variable with standard normal distribution

By providing a value for x, you can calculate the probability that a random variable with a standard normal distribution is less than or equal to x.

Compare values in a dataset using z-scores

By calculating the z-score for each value in a dataset and using the NORM.S.DIST function, you can compare values to the mean and standard deviation of the dataset.

Perform hypothesis testing

The NORM.S.DIST function can be used in hypothesis testing to determine the probability of observing a certain test statistic under the null hypothesis.

Common Mistakes

NORM.S.DIST not working? Here are some common mistakes people make when using the NORM.S.DIST Google Sheets Formula:

Incorrect argument type

One common mistake is providing an argument that is not a number for the x parameter. This can be corrected by ensuring that the input is a number or by using a function to convert the input into a number.

Incorrect number of arguments

Another mistake is providing an incorrect number of arguments. The NORM.S.DIST formula requires only one argument, x. Providing more or less than one argument will result in an error. Ensure that only one argument is provided for this formula.

Incorrect parameter value

A common mistake is providing an x value that is outside the range of -37 to 37. This can be corrected by ensuring that the input is within the valid range or by using a different formula to calculate the result.

Related Formulas

The following functions are similar to NORM.S.DIST or are often used with it in a formula:

  • NORM.DIST

    The NORM.DIST formula is a statistical function that returns the normal distribution of a specified variable. It is used to determine the probability of a random variable falling within a specified range of values. This function is commonly used in finance and scientific research.

  • NORM.INV

    The NORM.INV function returns the inverse of the cumulative normal distribution for a specified mean and standard deviation. It is commonly used in statistical analysis to find the value at which a specified percentage of observations occur below that value.

  • T.DIST

    The T.DIST function returns the probability of a Student's t-distribution with a specified degrees of freedom. This function is usually used in hypothesis testing to determine the probability that a sample mean is within a specified range of values.

  • T.TEST

    The T.TEST function calculates the probability associated with a Student's t-test. This function is commonly used in statistics to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. It returns the probability that the two samples are different. The function assumes that the two samples are independent of each other and have equal variances.

Learn More

You can learn more about the NORM.S.DIST Google Sheets function on Google Support.