Bioequivalence and Bioavailability Forum • Possible Excel bug?

Possible Excel bug? [Software]

posted by mittyri – Russia, 2019-12-17 15:23 (1585 d 09:26 ago) – Posting: # 20984
Views: 3,393

Hi Shuanghe,

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

Complete thread:

Possible Excel bug? Shuanghe 2019-12-17 13:01
- 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

Admin contact
22,988 posts in 4,825 threads, 1,653 registered users;
93 visitors (0 registered, 93 guests [including 4 identified bots]).
Forum time: 01:50 CEST (Europe/Vienna)

The only way to comprehend what mathematicians mean by Infinity
is to contemplate the extent of human stupidity. Voltaire

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC

Ing. Helmut Schütz