QUARTILE.INC in Collabora Office: Inclusive Quartiles and Finite-Sample Thresholds

• 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.INC(data;type)

Both arguments are required. The source distinguishes its inclusive scale from QUARTILE.EXC. These examples use integer selectors 0,1,2,3,4 and fully numeric data.

The independent inclusive-position model is 1+(n-1)×type/4 in sorted observations. The compact help identifies the quartile points without printing the complete calculation algorithm; expected outputs below are independently reproducible checks, not native screenshots.

The dedicated QUARTILE.INC section does not repeat plain QUARTILE’s text-range note. Mixed-type handling is therefore left unverified rather than transferred across the similar names.

Enter 5,15,30,55,95 in A2:A6:

The model positions are exactly 1 through 5. The interquartile range is 40, from 55-15, while the full range is 90, from 95-5.

The first quartile is not one quarter of the maximum: 95/4 is 23.75, which measures a different ratio rather than a distribution position.

Put 5,15,55,95 in C2:C5. The independent first-quartile position is 1.75, yielding 12.5. The median position is 2.5, giving 35. The third-quartile position is 3.25, yielding 65.

=QUARTILE.INC(C2:C5;1)
=QUARTILE.INC(C2:C5;2)
=QUARTILE.INC(C2:C5;3)

The expected outputs 12.5,35,65 need not be input observations. These calculations expose the interpolation model and avoid pretending that every quartile simply selects one existing row.

Return to the original five values. The exclusive position model uses (n+1)×type/4. It gives first and third quartiles 10 and 75, compared with inclusive results 15 and 55.

Both give median 30 for this particular odd-sized dataset. Their interquartile ranges differ: 65 for the exclusive model and 40 for the inclusive one.

A report should name the convention before interpreting a changed IQR as changed data. QUARTILE.EXC also has documented selector and minimum-count constraints.

Use 5,15,30,55,55,95 in E2:E7. The inclusive third-quartile model position is 4.75, between two 55s, so Q3 stays 55.

An inclusive comparison at least 55 accepts three of six observations. A strict comparison greater than 55 accepts only 95. Neither is automatically a fixed top-quarter quota.

If exactly a specified number of records must be selected, define a separate tie-breaking rule. A quartile threshold does not encode one.

For the original five observations, apply 3×value+2 to obtain 17,47,92,167,287. The corresponding summary is those same five positions, and IQR becomes 120, three times the original 40.

The added constant changes location but cancels when subtracting Q1 from Q3. The positive multiplier scales both the quartile values and their difference.

The source names COM.MICROSOFT.QUARTILE.INC outside the cited OpenFormula 1.3 standard. No universal workbook round-trip guarantee follows from that note.

QUARTILE retains its own current section. Fractional selectors, invalid-type error codes, singleton or empty inputs, text/Boolean conversions and mixed source errors remain unverified for QUARTILE.INC. A number formatted as blank is not necessarily an empty input cell.

• Collabora Office 26.04: QUARTILE.INC.
• 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.