M$: It’s not a bug, it’s a feature! [Software]

posted by Helmut Homepage – Vienna, Austria, 2019-12-17 15:00 (317 d 13:46 ago) – Posting: # 20985
Views: 1,650

Hi all,

known for ages. All (‼) versions of Excel round the degrees of freedom down to the nearest integer.

df <- seq(10, 11, 0.2)
q  <- 4.5
res <- data.frame(df = df, correct = pt(q, df), Excel = pt(q, floor(df)))
print(res, row.names = FALSE)

[image]  df   correct     Excel
10.0 0.9994284 0.9994284
10.2 0.9994561 0.9994284
10.4 0.9994818 0.9994284
10.6 0.9995059 0.9994284
10.8 0.9995284 0.9994284
11.0 0.9995494 0.9995494


Quoting Martin:

Never never never never use Excel. Not even for calculation of arithmetic means.


[image]

Congratulations to M$ for making a continuous function discrete. :thumb down:

I had fun comparing papers by regulators based on Luther Gwaza’s Excel-Sheet for adjusted indirect comparisons with my R-package. Satterthwaite’s degrees of freedom are practically never* integers. Remember this goody of the EMA?

Results obtained by alternative, validated statistical programs are also acceptable except spreadsheets because outputs of spreadsheets are not suitable for secondary assessment.




Dif-tor heh smusma 🖖
Helmut Schütz
[image]

The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes

Complete thread:

Activity
 Admin contact
21,179 posts in 4,414 threads, 1,474 registered users;
online 4 (0 registered, 4 guests [including 4 identified bots]).
Forum time: Friday 04:47 CET (Europe/Vienna)

The idea is to try and give all the information to help others
to judge the value of your contribution;
not just the information that leads to judgment
in one particular direction or another.    Richard Feynman

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