Possible Excel bug? [Software]

posted by Shuanghe  – Spain, 2019-12-17 15:15 (1083 d 23:52 ago) – Posting: # 20983
Views: 2,821

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
22,428 posts in 4,694 threads, 1,598 registered users;
13 visitors (0 registered, 13 guests [including 6 identified bots]).
Forum time: 15:07 CET (Europe/Vienna)

Statistics is the art of never having to say you’re wrong.
Variance is what any two statisticians are at.    C.J. Bradfield

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