DV-0017
hyperformula, libreoffice, pycel: function not implemented — BETA.DIST, BINOM.DIST, ERF.PRECISE (+10 more)
Subjects (13)
Tests (17)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
ERF.PRECISE/erf-precise-zero |
=ERF.PRECISE(0) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice— | formulas0 | pycel#NAME? |
ERFC.PRECISE/erfc-precise-at-0 |
=ERFC.PRECISE(0) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas1 | pycel#NAME? |
RANK.EQ/rank-eq-descending-with-tie |
=RANK.EQ(20, A1:A4) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice— | formulas2 | pycel#NAME? |
RANK.EQ/rank-eq-ascending |
=RANK.EQ(3, A1:A5, 1) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula#NAME? | libreoffice— | formulas3 | pycel#NAME? |
RANK.EQ/rank-eq-top |
=RANK.EQ(5, A1:A5) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas1 | pycel#NAME? |
RANK.AVG/rank-avg-descending-with-tie |
=RANK.AVG(20, A1:A4) |
2.5 | gsheets2.5 | excel2.5 | lattice2.5 | ironcalc2.5 | hyperformula#NAME? | libreoffice— | formulas2.5 | pycel#NAME? |
RANK.AVG/rank-avg-no-tie |
=RANK.AVG(3, A1:A5) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula#NAME? | libreoffice— | formulas3 | pycel#NAME? |
RANK.AVG/rank-avg-triple-tie |
=RANK.AVG(20, A1:A5) |
3 | gsheets3 | excel3 | lattice3 | ironcalc3 | hyperformula#NAME? | libreoffice— | formulas3 | pycel#NAME? |
BETA.DIST/beta-dist-cdf-at-boundary |
=BETA.DIST(1, 2, 5, TRUE, 0, 1) |
1 | gsheets1 | excel1 | lattice1 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas1 | pycel#NAME? |
BINOM.DIST/binom-dist-cdf-at-n |
=BINOM.DIST(10, 10, 0.5, TRUE) |
1 | gsheets1 | excel1 | lattice1.00000 | ironcalc1 | hyperformula#NAME? | libreoffice— | formulas1 | pycel#NAME? |
EXPON.DIST/expon-dist-pdf-at-0 |
=EXPON.DIST(0, 2, FALSE) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice— | formulas2 | pycel#NAME? |
GAMMA.INV/gamma-inv-roundtrip |
=GAMMA.INV(GAMMA.DIST(2, 2, 1, TRUE), 2, 1) |
2 | gsheets2 | excel2 | lattice2 | ironcalc2 | hyperformula#NAME? | libreoffice— | formulas2 | pycel#NAME? |
NORM.DIST/norm-dist-at-mean-cdf |
=NORM.DIST(0, 0, 1, TRUE) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc0.5 | hyperformula#NAME? | libreoffice— | formulas0.5 | pycel#NAME? |
NORM.S.DIST/norm-s-dist-at-0-cdf |
=NORM.S.DIST(0, TRUE) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc0.5 | hyperformula#NAME? | libreoffice— | formulas0.5 | pycel#NAME? |
T.DIST/t-dist-cdf-at-0 |
=T.DIST(0, 10, TRUE) |
0.5 | gsheets0.5 | excel0.5 | lattice0.5 | ironcalc0.5 | hyperformula#NAME? | libreoffice— | formulas0.5 | pycel#NAME? |
WEIBULL.DIST/weibull-dist-at-0 |
=WEIBULL.DIST(0, 2, 1, TRUE) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula#NAME? | libreoffice— | formulas0 | pycel#NAME? |
TEXTJOIN/textjoin-comma-separator |
=TEXTJOIN(", ", TRUE, A1:A3) |
Monday, Tuesday, Wedne… | gsheetsMonday, Tuesday, Wedne… | excelMonday, Tuesday, Wedne… | latticeMonday, Tuesday, Wedne… | ironcalcMonday, Tuesday, Wedne… | hyperformula#NAME? | libreoffice— | formulasMonday, Tuesday, Wedne… | pycel#NAME? |