GAUSS Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Statistical module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

GAUSS(x) is Phi(x)−0.5, the signed standard-normal area from zero to x. It is not the full standard-normal CDF and it is not the normal density. Negative x therefore gives a negative result, which is valid for this signed-area definition. Function help.

=GAUSS(x)

Exactly one argument is registered. Use a finite numeric standardized value x. The helper converts values to a number; in the tested engine numeric text is accepted, booleans become 1 or 0 and invalid text becomes zero. Those conversion results do not validate the original data. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee. NaN and infinity are nonfinite outputs; an engine error flag is checked separately from those values.

GAUSS(1) is approximately 0.341344746069. Adding 0.5 gives the standard-normal probability below 1, approximately 0.841344746069. GAUSS(−1) is the negative of the positive result; adding 0.5 then gives approximately 0.158655253931.

For a normally distributed measurement with known mean mu and positive standard deviation sigma, standardize it as z=(x−mu)/sigma before applying the standard-normal relationship. GAUSS alone does not estimate those parameters or establish normality.

The function is odd: GAUSS(−x)=−GAUSS(x). The displayed native sum at ±1 returns zero. For z≥0, the central standard-normal probability between −z and z is 2×GAUSS(z); at z=2 it is approximately 0.954499736104.

For a positive upper-tail cutoff, 0.5−GAUSS(z) is the mathematical tail probability. In a far tail, subtracting two nearly equal values can lose precision. The native value at 10 is exactly 0.5 in this representation, so that subtraction yields zero even though the mathematical tail is positive.

The executed advanced check was:

=GAUSS(1)+GAUSS(-1)

Its engine result was 0.

A valid zero at x=0 must remain distinct from invalid text that was converted to zero. The helper uses different polynomial regions and an asymptotic expression; these cases establish ordinary behavior, not arbitrary-tail relative accuracy. Missing or excess arguments are rejected by registration. Use input validation before interpreting a returned signed area as evidence about a model.

• Function-specific implementation
• Versioned function help
• Gauss helper

The statistical module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version native output, every locale or arbitrary extreme-parameter accuracy.

NORMDIST, NORMSDIST.