NORM.S.DISTThe 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
- Examples of using
NORM.S.DISTformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
NORM.S.DISTformula 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.
NORM.S.DISTnot working? Here are some common mistakes people make when using the
NORM.S.DISTGoogle 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.DISTformula 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.INVfunction 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.DISTfunction 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.TESTfunction 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.