Possible Excel bug? [Software]
Hi Shuanghe,
try this
If you want more pain, see here
even in the latest Office 365...
try this
=T.DIST(4.5, 10.1,TRUE )-T.DIST(4.5, 10,TRUE)
If you want more pain, see here
- Heiser 2006. Statistical tests, tests of significance, and tests of a hypothesis using Excel. Journal of Applied Statistical Methods, 5:155–171
- McCullough and Heiser 2008. On the accuracy of statistical procedures in Microsoft Excel 2007. Computational Statistics & Data Analysis 52:4570–4578
even in the latest Office 365...
—
Kind regards,
Mittyri
Kind regards,
Mittyri
Complete thread:
- Possible Excel bug? Shuanghe 2019-12-17 13:01 [Software]
- Possible Excel bug? ElMaestro 2019-12-17 13:49
- Possible Excel bug? Shuanghe 2019-12-17 14:15
- Possible Excel bug?mittyri 2019-12-17 14:23
- M$: It’s not a bug, it’s a feature! Helmut 2019-12-17 15:00
- M$: It’s not a bug, it’s a feature! Shuanghe 2019-12-17 15:41
- M$: It’s not a bug, it’s a feature! Helmut 2019-12-17 16:00
- M$: It’s not a bug, it’s a feature! Shuanghe 2019-12-17 15:41
- M$: It’s not a bug, it’s a feature! Helmut 2019-12-17 15:00
- Possible Excel bug? ElMaestro 2019-12-17 13:49