QUARTILE.EXC Function (Gnumeric)

• Introduced: Gnumeric 1.12.23 release notes record its addition.
• Supported in: Gnumeric 1.12.62; no retirement is established.
• Scope: Desktop Gnumeric with its Statistics plugin. English comma-separated formulas are shown.
• Checked: October 14, 2026. The tables and named advanced check use 1.12.57 ssconvert. Current 1.12.62 source was inspected; that release was not executed.

QUARTILE.EXC applies the exclusive percentile convention at k=quart/4. The usual selectors are 1 for the lower quartile, 2 for the median and 3 for the upper quartile. Unlike inclusive QUARTILE, selectors 0 and 4 do not return the minimum and maximum in the tested implementation. Versioned function help.

=QUARTILE.EXC(array,quart)

• array: numeric data; text, booleans and blank cells are ignored.
• quart: the selector, floored before calculation. Use integers 1,2 or 3 deliberately. A valid selector can still fail if the sample is too small for its exclusive position.

Current implementation.

Enter these columns as numbers, except for the explicitly typed H column. F7 and H7 are genuinely empty.

Use an apostrophe entry marker if needed to store H5 as text; it is not part of the stored value. The results below are native outputs rounded to 12 decimal places for readability, rather than application screenshots.

For 1,2,3,4,10 in F2:F6, =QUARTILE.EXC(F2:F6,1) gives 1.5, selector 2 gives 3, and selector 3 gives 7. These are the same type-6 percentiles at 0.25,0.5,0.75.

The help includes an inherited note suggesting quart=0 returns the minimum; that is inconsistent with the exclusive implementation and the native #NUM! result. Use a documented minimum function for a minimum, rather than treating this selector as supported.

For sorted data the one-based position is (n+1)*floor(quart)/4. With four observations 1,2,3,4, the lower and upper positions are 1.25 and 3.75, giving 1.25 and 3.75. With just two observations, the lower position is 0.75 and upper position 2.25, both outside the data, so only the median is defined.

For the tied five-value dataset G2:G6, lower and upper quartiles are 15 and 45. The native =QUARTILE.EXC(G2:G6,3)-QUARTILE.EXC(G2:G6,1) gives 30. Preserve the chosen exclusive method when interpreting this interquartile range.

The relevant argument guards and calculation sequence are preserved in the retained 1.12.57 and 1.12.62 callbacks. This is a source comparison; later-release output was not tested.

Selectors 0 and 4, a singleton and an empty numeric array return #NUM!. The tested fractional selectors 1.9 and 3.9 act as 1 and 3. A negative fraction is floored downward; avoid using fractional selectors as a substitute for an explicitly chosen percentile.

• Current worksheet implementation
• Tested-version worksheet implementation

Both the stale SUM cache and the uncached SUM recalculated correctly. Saved formula identities and typed inputs were checked in the native workbook exports. The importer reported unsupported style-extension elements; this does not establish complete formatting support. GUI entry, other locales and later-version execution were not tested.

QUARTILE, PERCENTILE, MEDIAN.