assay
statistical-descriptive

5f77f1

Subject
PERCENTILE
Category
value
Formula
=PERCENTILE({1,2,3,4,5}, 1)
Canonical
5

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

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