assay
statistical-descriptive

quartile-exc-q3-on-1-5

Subject
QUARTILE.EXC
Category
value
Formula
=QUARTILE.EXC(A1:A5, 3)
Canonical
4.5

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match 4.5
excel match 4.5
lattice match 4.5
ironcalc diverge #NAME?
hyperformula diverge #NAME?
libreoffice diverge
formulas match 4.5
pycel diverge #NAME?