Possible Excel bug? [Software]

posted by Shuanghe  – Spain, 2019-12-17 15:15 (1615 d 19:00 ago) – Posting: # 20983
Views: 3,500

Hi ElMaestro,

❝ I do not have Excel, but it sounds like an embarrassing implementation.


I guess that I shouldn't be surprised given its history...

❝ Can you try, just for the fun of it, to ask Excel what it thinks the critical value at df=10.1 is for:


❝ a. p=0.9994425014527133

❝ b. p=0.999428447456598


Good idea.
T.INV(0.999442501452713, 10.1) = 4.51612251417097
T.INV(0.999428447456598, 10.1) = 4.50000000000000

In fact, I just checked that T.DIST(4.5, df, TRUE) will give exactly the same result for df = 10.1, 10.2, ... 10.9, (increase df but let df < 11). The result only changed when df = 11!

Nice work, M$.

All the best,
Shuanghe

Complete thread:

UA Flag
Activity
 Admin contact
23,033 posts in 4,835 threads, 1,643 registered users;
47 visitors (0 registered, 47 guests [including 19 identified bots]).
Forum time: 11:15 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