The GAUSS function in Excel is designed to return the probability that a standard normal random variable is less than a specified value, adjusted down by 0.5. This adjustment is particularly useful in statistical analyses involving standard normal distributions, providing insights into probabilities in various applications.

Syntax

GAUSS(z)

• z: The standard score (z-value) for which you want to calculate the cumulative probability.

Example #1

GAUSS(1.96)

This function call would compute the probability that a standard normal variable is less than 1.96, adjusted by 0.5. The result is approximately 0.9750.

Example #2

GAUSS(0)

Here, the function determines the probability that a standard normal score is below 0. The outcome of this function would be 0.5, indicating that half of the distribution lies below the mean.

Example #3

GAUSS(-1)

This example calculates the probability for a z-value of -1, resulting in approximately 0.1587. This reflects the probability of a standard normal variable being below this score.

Error handling

• VALUE!: This error occurs when the input (z) is not a numeric value. Ensure that the input is a valid number.
• NUM!: This error arises if the input value is too large or too small (beyond the limits of floating-point numbers). Check the range of the z-value used.

Conclusion

In summary, the GAUSS function in Excel is a powerful tool for statistical analysis, offering insights into probabilities associated with the standard normal distribution. By subtracting 0.5, it enhances the interpretation of results within a statistical context, enabling more informed decision-making in various fields.