GAUSS

The GAUSS function in Google Sheets returns the probability that a random variable drawn from a standard normal distribution falls between the mean and z standard deviations from the mean. It's a convenient shortcut for working with the standard normal distribution without manually adjusting other statistical functions. Dive into our comprehensive guide to master its application.

Parameters

• z: The number of standard deviations from the mean.

Step-by-Step Tutorial

1. Calculating a probability with GAUSS:
   • Example: =GAUSS(2)
   • Result: will return the probability that a value falls between the mean and 2 standard deviations above it (approximately 0.4772).

Use Cases and Scenarios

1. Statistical Analysis: Estimate the probability of a value occurring within a certain range of the mean.
2. Quality Control: Evaluate how likely a measurement is to fall within a set number of standard deviations.
3. Academic Statistics: Teach or demonstrate properties of the standard normal distribution.

Related Functions

• NORM.S.DIST: Returns the standard normal cumulative distribution.
• NORMDIST: Returns values for the normal distribution.
• PHI: Returns the value of the density function for a standard normal distribution.

Related Articles

• Understanding Statistical Functions in Google Sheets