Possible Excel bug? [Software]

posted by mittyri – Russia, 2019-12-17 13:23 (437 d 08:52 ago) – Posting: # 20984
Views: 1,843

Hi Shuanghe,

try this
=T.DIST(4.5, 10.1,TRUE )-T.DIST(4.5, 10,TRUE)

If you want more pain, see here
  1. Heiser 2006. Statistical tests, tests of significance, and tests of a hypothesis using Excel. Journal of Applied Statistical Methods, 5:155–171
  2. 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,

Complete thread:

 Admin contact
21,357 posts in 4,459 threads, 1,492 registered users;
online 9 (0 registered, 9 guests [including 3 identified bots]).
Forum time: Friday 22:15 UTC (Europe/Vienna)

Those who make no mistakes are making the biggest mistakes of all 
they are attempting nothing new.    Anthony de Mello

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz