QUARTILE
Returns the quartile of a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Returns the quartile of a dataset (Legacy).
Syntax
QUARTILE(array, quart)
Arguments
array(range) — Data.quart(number) — Quartile (0-4).
Examples
Legacy Quartile
Get Q1 (25%).
FORMULA
=QUARTILE(A1:A5, 1)
RESULT
2
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |
| 5 | 4 |
| 6 | 5 |