GAUSS
TheGAUSS
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.
 How to use
GAUSS
formula?  Examples of using
GAUSS
formula GAUSS
formula not working? Similar formulas to
GAUSS
Usage
Use the GAUSS
formula with the syntax shown below, it has 1 required parameter:
 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 theGAUSS
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.
Related Formulas
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.
Learn More
You can learn more about the GAUSS
Google Sheets function on Google Support.