DV-0042
hyperformula: numeric precision differs — NORM.INV, NORM.S.INV, NORMINV (+1 more)
Subjects (4)
Tests (4)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
NORM.INV/norm-inv-at-0-5 |
=NORM.INV(0.5, 0, 1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice— | formulas0 | pycel#NAME? |
NORM.S.INV/norm-s-inv-at-0-5 |
=NORM.S.INV(0.5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice— | formulas0 | pycel#NAME? |
NORMINV/norminv-at-0-5 |
=NORMINV(0.5, 0, 1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula-7.681e-17 | libreoffice— | formulas0 | pycel#NAME? |
NORMSINV/normsinv-at-0-5 |
=NORMSINV(0.5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula-7.681e-17 | libreoffice— | formulas0 | pycel#NAME? |