# NORMSDIST

The `NORMSDIST` function returns the area under a normal distribution curve to the left of a specified value. This function is commonly used in statistics to calculate probabilities.

## Usage

Use the `NORMSDIST` formula with the syntax shown below, it has 1 required parameter:

Parameters:
1. x (required):
The value for which you want to calculate the area under the normal distribution curve.

## Examples

Here are a few example use cases that explain how to use the `NORMSDIST` formula in Google Sheets.

### Calculate the probability of a value from a normal distribution

You can use the `NORMSDIST` function to calculate the probability of a value from a normal distribution by providing the value as the `x` argument.

### Calculate the z-score of a value from a normal distribution

If you know the mean and standard deviation of a normal distribution, you can use the `NORMSDIST` function to calculate the z-score of a value by subtracting the mean from the value and dividing the result by the standard deviation.

### Calculate the critical value of a normal distribution

You can use the `NORMSDIST` function to calculate the critical value of a normal distribution for a given level of significance by finding the value of `x` such that `NORMSDIST(x) = α/2`, where `α` is the level of significance.

## Common Mistakes

`NORMSDIST` not working? Here are some common mistakes people make when using the `NORMSDIST` Google Sheets Formula:

### Incorrect use of arguments

One common mistake is to use the wrong type or number of arguments. The NORMSDIST function only takes one argument, which should be a numerical value. If you provide more than one argument or a non-numerical value, you will get an error.

### Missing parentheses

Another common mistake is to forget to use parentheses around the argument. The correct syntax for the NORMSDIST function is NORMSDIST(x), where x is the numerical value you want to evaluate. If you forget the parentheses, you will get an error.

### Incorrect range reference

Sometimes users mistakenly reference a range of cells instead of a single cell. The NORMSDIST function only works with a single value, so if you reference a range of cells, you will get an error. Make sure you reference a single cell that contains the value you want to evaluate.

NORMDIST is a similar function to NORMSDIST, but it returns the probability density function instead of the cumulative distribution function. If you mistakenly use NORMDIST instead of NORMSDIST, you will get a different result than what you intended.

### Incorrect interpretation of the result

One common mistake is to misinterpret the result returned by the NORMSDIST function. The function returns a probability value between 0 and 1, which represents the area under the standard normal curve to the left of the given value. Some users may interpret this value as a percentage or a decimal, which can lead to incorrect conclusions.

The following functions are similar to `NORMSDIST` or are often used with it in a formula:

• `NORMSINV`

The `NORMSINV` function calculates the inverse of the standard normal cumulative distribution for a specified value of x. It is commonly used in statistical analysis to transform data from a normal distribution to a standard normal distribution with a mean of 0 and a standard deviation of 1.

• `NORMDIST`

The `NORMDIST` function in Google Sheets calculates the normal distribution for a specified value, mean, and standard deviation. It returns the probability of a value occurring within a specified range of a normal distribution. It is commonly used in statistics, finance, and science to analyze data and make predictions.

• `NORMINV`

The `NORMINV` function returns the inverse of the normal cumulative distribution for a specified value, mean, and standard deviation. It is commonly used in statistics to find the value at which a given percentage of observations lie below that value.

You can learn more about the `NORMSDIST` Google Sheets function on Google Support.