Possible Excel bug? [Software]

posted by mittyri – Russia, 2019-12-17 15:23 (1615 d 19:42 ago) – Posting: # 20984
Views: 3,477

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:

UA Flag
Activity
 Admin contact
23,033 posts in 4,835 threads, 1,642 registered users;
32 visitors (0 registered, 32 guests [including 5 identified bots]).
Forum time: 12:05 CEST (Europe/Vienna)

Competence, like truth, beauty and contact lenses,
is in the eye of the beholder.    Laurence J. Peter

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