GEOMEAN Function (Gnumeric)

GEOMEAN summarizes multiplicative quantities: growth factors, proportional changes and ratios. The geometric mean of N positive values is the Nth root of their product. It differs from AVERAGE, which adds the values before dividing by N. For example, 4 and 16 have arithmetic mean 10 but geometric mean 8. Gnumeric’s official Statistics manual gives this mathematical definition and identifies the function as Excel-compatible (official Gnumeric Statistics reference, accessed 2026-10-13).

Current-release note: Gnumeric 1.12.62 (September 2026) specifically lists improved GEOMEAN accuracy in its release notes. That establishes a documented change, not that this tutorial’s calculations have been executed or numerically compared between releases (official 1.12.62 release notes, accessed 2026-10-13).

=GEOMEAN(number1,number2,…)

The official synopsis uses number1,number2,…, not an invented values or weights parameter. There is no documented weighting parameter or numerical default. A single range such as A2:A5 supplies multiple observations in one argument. The release’s statistical-function implementation enumerates numeric inputs and ignores empty cells, text and Boolean worksheet cells when collecting a range; to keep the tutorial reproducible, all example data below are explicitly numeric. The source implementation’s collection and error-handling details are corroborated by its 1.12.62 statistical-function source listing, while the Gnumeric manual establishes the contract.

Version/platform: References concern the upstream Gnumeric 1.12.62 desktop release and its Statistics function catalogue. The function is catalogued Complete / Basic testing; those labels describe the upstream implementation and project tests, not the result of this page’s tests. Support in a particular distro package or non-Linux build has not been executed here (official function catalogue, accessed 2026-10-13). Locale: Examples use English function names, a dot decimal point and comma argument separators. In decimal-comma locales Gnumeric may use semicolons between arguments; use Insert → Function for the correct local syntax (GNOME Gnumeric locale discussion, accessed 2026-10-13).

Enter these values and formula in a blank Gnumeric sheet:

Expected B2: 8, because 1 × 4 × 16 × 64 = 4096 and the fourth root of 4096 is 8. Expected =AVERAGE(A2:A5) for comparison: 21.25. This is independent calculation, not observed application output; the difference explains why the two functions cannot be substituted in a multiplicative problem.

The last formula is also the numeric example printed in the 1.12.62 source function-help metadata (release source listing); its value here was independently computed, not copied from a running worksheet. Gnumeric may display fewer digits depending on cell formatting.

If sales rose by 5%, then 8%, then 4% in three successive years, enter the growth factors (not percent-change numbers) into B2:B4:

Expected C2: approximately 0.05653072496, or 5.6531% when formatted as a percentage. Independently, (1.05 × 1.08 × 1.04)^(1/3) − 1 yields the same figure. Using =AVERAGE(B2:B4)-1 would instead give about 5.6667% and is not the compound-rate calculation. This workflow assumes successive positive factors, which corresponds to each period’s return being greater than −100%. This is an applied arithmetic derivation of Gnumeric’s documented definition, not a separately validated built-in CAGR feature.

For a positive-only example with A2:A5 known numeric, a non-destructive validation formula is =IF(MIN(A2:A5)>0,GEOMEAN(A2:A5),"Review nonpositive inputs"); this presumes every row expected to be counted contains a number. Do not mistake this optional guard for universal validation of imported mixed-type records. Unlike native GEOMEAN error behavior, the intended guard logic is a worksheet design recommendation.

The official Gnumeric help marks GEOMEAN as Excel-compatible, meaning it implements the corresponding named function—not that error codes, type coercion or locale behavior match every Excel/LibreOffice release. Gnumeric’s official catalogue registers the function as Complete with Basic project tests; catalogue registration is not proof of native runtime availability or this guide’s result (Statistics manual, official catalogue).

• HARMEAN averages rate-like quantities using reciprocal weights under its mathematical assumptions.
• AVERAGE computes the arithmetic mean.
• MEDIAN selects the middle numerical value rather than multiplying observations.
• COUNT helps assess whether expected observations are numeric.
• IF can add a guard for known-positive numeric inputs.

Primary source verification: The official Gnumeric 1.12.62 source archive was checked against GNOME’s SHA-256 checksum. The statistical callback and collector flags were inspected without compiling or running Gnumeric.

1. Gnumeric Statistics manual, GEOMEAN entry, accessed 2026-10-13 — exact syntax/argument order, mathematical definition, Excel-compatibility note and related functions.
2. Gnumeric official function catalogue, accessed 2026-10-13 — implemented/Basic project-testing classification, not runtime evidence.
3. Gnumeric 1.12.62 announcement, accessed 2026-10-13 — GEOMEAN accuracy improvement.
4. Gnumeric release archive, accessed 2026-10-13 — release 1.12.62 scope and package availability. The official source archive was checksum-verified and inspected; no native build was performed.
5. Indexed Gnumeric 1.12.62 statistical-function source, accessed 2026-10-13 through indexed source excerpts — identifies help_geomean, source callback and collection flags; not a native evaluation.
6. Gnumeric developer-list locale guidance, accessed 2026-10-13 — separators in decimal-comma locales.

Validation limits: Examples were checked by independent arithmetic and the checksum-verified official Gnumeric 1.12.62 source. No native Gnumeric execution, screenshots, locale regression or workbook round-trip was performed.