Bioequivalence and Bioavailability Forum • Possible Excel bug?

Possible Excel bug? [Software]

posted by mittyri – Russia, 2019-12-17 15:23 (1590 d 13:51 ago) – Posting: # 20984
Views: 3,408

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 [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

Admin contact
22,993 posts in 4,828 threads, 1,656 registered users;
97 visitors (0 registered, 97 guests [including 11 identified bots]).
Forum time: 06:15 CEST (Europe/Vienna)

Never never never never use Excel.
Not even for calculation of arithmetic means. Martin Wolfsegger

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC

Ing. Helmut Schütz