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 |
|---|---|---|---|---|---|---|---|---|---|---|
statistical-distributions/8d7bbe |
=NORM.INV(0.5, 0, 1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-distributions/679343 |
=NORM.S.INV(0.5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc0 | hyperformula-7.681e-17 | libreoffice#NAME? | formulas0 | pycel#NAME? |
statistical-distributions/86dcd2 |
=NORMINV(0.5, 0, 1) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula-7.681e-17 | libreoffice0 | formulas0 | pycel#NAME? |
statistical-distributions/292a2e |
=NORMSINV(0.5) |
0 | gsheets0 | excel0 | lattice0 | ironcalc#NAME? | hyperformula-7.681e-17 | libreoffice0 | formulas0 | pycel#NAME? |