statistical-analytics

`z-test-canonical`

Subject: Z.TEST
Category: value
Formula: =Z.TEST(A1:A5, 3)
Canonical: 0.5

Owning divergences (2)

DV-0004 libreoffice, pycel: function not implemented — ACOTH, ARABIC, BINOM.INV (+27 more)
missing-function libreofficepycel
DV-0018 lattice: different error code — ADD, AVERAGE, AVERAGE.WEIGHTED (+5 more)
error-code lattice

Per-engine results

matches canonical diverges no fixture

Engine	Verdict	Value
gsheets	match	[object Object]
excel	match	[object Object]
lattice	match	0.5
ironcalc	match	0.5
hyperformula	match	0.5
libreoffice	diverge	—
formulas	match	0.5
pycel	diverge	#NAME?