Possible Excel bug? [Software]

posted by mittyri – Russia, 2019-12-17 14:23 2001:67c:2660:425:a::391 – Posting: # 20984
Views: 357

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,
Mittyri

Complete thread:

Activity
 Admin contact
20,250 posts in 4,262 threads, 1,398 registered users;
online 19 (0 registered, 19 guests [including 13 identified bots]).
Forum time (Europe/Vienna): 07:01 CET

No written law has ever been more binding than
unwritten custom supported by popular opinion.    Carrie Chapman Catt

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