QUARTILE.EXC in Collabora Office: Exclusive Quartiles and Required Observation Counts

• Introduced: original Collabora release and launch date are not established by the reviewed sources.
• Availability: currently documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployments are not inferred from this desktop-help release.
• Checked: October 14, 2026. Function-specific documentation and independent calculations; no native Collabora execution.

=QUARTILE.EXC(data;type)

Both arguments are required. Type 1 requests the first quartile, type 2 the median, and type 3 the third quartile. Unlike QUARTILE.INC, this dedicated signature does not accept 0 and 4 as minimum/maximum selectors.

The numeric model maps type to alpha=type/4 and position (n+1)×alpha. The related PERCENTILE.EXC source explicitly documents this exclusive interpolation grid and its usable window. The examples below stay within the stated count rules.

Enter 6,18,30,54,90 in A2:A6:

=QUARTILE.EXC(A2:A6;1)
=QUARTILE.EXC(A2:A6;2)
=QUARTILE.EXC(A2:A6;3)

Expected results: 12,30,72. The positions are 1.5,3,4.5. Twelve is halfway between 6 and 18; 72 is halfway between 54 and 90.

The exclusive IQR is 60, from 72-12. The full range is 84, from 90-6. Neither difference is a count of records.

Put 10,30,70 in C2:C4. With three numeric observations, the exclusive model positions for types 1,2,3 are 1,2,3.

Expected quartiles are therefore 10,30,70. This complies with the source’s requirement for more than two values when type is 1 or 3.

For only two observations, a request for the first or third quartile violates that documented count requirement. This guide does not assign a specific native error display. The absence of a stated restriction for type 2 is not used to certify every singleton or empty-range case.

On the original five-value fixture, the inclusive model gives first and third quartiles 18 and 54, with IQR 36. The exclusive results are 12 and 72, with IQR 60.

The observations did not change. The rule for locating the quartiles changed. Label the function or convention in a report before comparing its dispersion with another report.

QUARTILE.INC documents the inclusive counterpart. It also supports minimum/maximum selectors that are outside this function’s stated integer range.

The original exclusive upper quartile is 72. Only 90 is at or above 72. Using the inclusive upper quartile 54 would accept 54 and 90.

=COUNTIF(A2:A6;">="&QUARTILE.EXC(A2:A6;3))

Expected count: 1. That is 20% of five observations, not exactly 25%. Discrete records and ties make a threshold rule different from selecting a fixed number of rows.

Add 5 to each original observation. The new list is 11,23,35,59,95, and its expected exclusive quartiles are 17,35,77. The IQR remains 60.

Double the original values instead. Expected quartiles become 24,60,144, and the IQR becomes 120. Positive scaling changes the measurement units and spread, while a common additive shift changes only location.

The current dedicated section requires integer types 1–3. It does not authorize truncating a fractional type or provide a complete invalid-input error-code table. Text, Boolean, empty-string and source-error behavior also remain unverified here.

PERCENTILE.EXC accepts a chosen alpha rather than a quartile selector, with its own n-dependent window. Inspect the numeric observation count before hiding an unavailable result behind a fallback zero.

The namespace COM.MICROSOFT.QUARTILE.EXC is documented outside the cited OpenFormula 1.3 standard. That format detail does not establish native export/import fidelity or a first introduction date.

• Collabora Office 26.04: QUARTILE.EXC.
• Editorial testing standards.

Complete function-specific documentation reviewed. Worked outputs are independent mathematical models or explicitly documented rules, not application screenshots or native test results. Precision, type and error boundaries retain their stated limits.