# GAUSS

The `GAUSS` function returns the area under a Gaussian distribution curve with mean zero and standard deviation 1. This function is useful in statistics for hypothesis testing and confidence interval calculations.

## Usage

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

Parameters:
1. z (required):
The value for which to calculate the area under the Gaussian distribution curve.

## Examples

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

### Calculate probability

Use `GAUSS` to calculate the probability of a certain value occurring in a normal distribution.

### Hypothesis testing

Use `GAUSS` to calculate the probability of obtaining a certain sample mean assuming a normal distribution for a population.

### Confidence intervals

Use `GAUSS` in conjunction with other statistical functions to calculate confidence intervals for population parameters.

## Common Mistakes

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

### Using the wrong input value

The `GAUSS` function requires a value between negative infinity and positive infinity as input. Make sure you are using the correct value in your formula.

### Misunderstanding the output

The output of the `GAUSS` function is a probability value between 0 and 1. Make sure you understand what this value represents in the context of your analysis.

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

• `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.

• `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.

• `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.

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