GAUSS

The GAUSS function in Google Sheets returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean.

Function Syntax and Parameters

Syntax: GAUSS(z)

Parameters:

• z: The value at which to evaluate the function.

Step-by-Step Tutorial

1. Using GAUSS function:
   • Example: =GAUSS(1.5)
   • Result: The probability that a random variable, drawn from a normal distribution, will be between the mean and 1.5 standard deviations above the mean.

Use Cases and Scenarios

1. Statistical Analysis: Calculate the probability of a certain value occurring in a normal distribution.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know