# 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:

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.

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.

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