assay
statistical-descriptive

quartile-exc-q1-on-1-5

Subject
QUARTILE.EXC
Category
value
Formula
=QUARTILE.EXC(A1:A5, 1)
Canonical
1.5

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

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