Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
QUARTILE.EXC
Returns a quartile of a data set based on percentile values from 0 to 1, exclusive.
Rarely usedDifficulty 1300 · ProficientUsage rank #309 of 520
When to use it
Quartiles with the exclusive method. Only quart values 1, 2, and 3 are valid.
The shape of it
- Syntax
=QUARTILE.EXC(array, quart)
Worked examples
Q1
=QUARTILE.EXC({1,2,3,4,5},1) → 1.5
First quartile, lower than the inclusive 2.
Q3
=QUARTILE.EXC({1,2,3,4,5},3) → 4.5
Third quartile.
Median
=QUARTILE.EXC({1,2,3,4,5},2) → 3
The median agrees with the inclusive method.
Worth knowing
- Box plots in Excel 2016 and later offer both methods; pick the one your audience expects.
- The same as PERCENTILE.EXC at 0.25, 0.5, 0.75.
- Wider IQR than the inclusive version on small samples.
Where it goes wrong
- #NUM! for quart 0 or 4.
- Needs at least three values for Q1 and Q3.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.