Bioequivalence and Bioavailability Forum • M$: It’s not a bug, it’s a feature!

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

posted by Helmut – Vienna, Austria, 2019-12-17 17:00 (2371 d 00:32 ago) – Posting: # 20987
Views: 7,240

Hi Shuanghe,

❝ I knew that many years ago we had some discussion about some "features" in Excel (though I didn't recall it's the t distribution)…

It was the function TINV(alpha, df) in all versions up to 2003. In order to get the correct value people had to use the workaround TINV(2*alpha, df). M$ could not change the implementation because it would break all existing spreadsheets with the workaround in place. Hence in 2007 the new function T.INV(alpha, df) was introduced. However, the degrees of freedom are still flawed.
Of course, the same crap in CHI.INV(), F.INV().

❝ How can they screwed up like this? ...

Too big to fail?

A refund for defective software might be nice,
except it would bankrupt the entire software industry
in the first year. Andrew S. Tanenbaum

—
Dif-tor heh smusma 🖖🏼 Довге життя Україна!
Helmut Schütz

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

Complete thread:

Possible Excel bug? Shuanghe 2019-12-17 13:01
- Possible Excel bug? ElMaestro 2019-12-17 13:49
  - Possible Excel bug? Shuanghe 2019-12-17 14:15
- Possible Excel bug? mittyri 2019-12-17 14:23
  - M$: It’s not a bug, it’s a feature! Helmut 2019-12-17 15:00
    - M$: It’s not a bug, it’s a feature! Shuanghe 2019-12-17 15:41
      - M$: It’s not a bug, it’s a feature!Helmut 2019-12-17 16:00