Excel functions / Statistics

GAUSS function

The chance that a standard normal value falls between the mean and z standard deviations above it.

Syntax

=GAUSS(z)

Arguments

When to use it

GAUSS gives the share of a standard normal distribution between the mean and a z-score: NORM.S.DIST(z, TRUE) minus 0.5.

Examples

  1. Between the mean and 2 standard deviations

    ABC
    1z
    2247.7%

    In C2: =GAUSS(A2) → 47.7%

    Try this example

Common mistakes

GAUSS in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try GAUSS in the playground

Related functions