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. How to use
NORM.S.DIST
formula?  Examples of using
NORM.S.DIST
formula NORM.S.DIST
formula not working? Similar formulas to
NORM.S.DIST
Usage
Use the NORM.S.DIST
formula with the syntax shown below, it has 1 required parameter:
 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 theNORM.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 zscores
By calculating the zscore 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 tdistribution 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 ttest. 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.