I did calculation in Excel with T.INV.2T, function T score number is the same (2.31) but the final result is slightly different (81824-103242 instead of 81806-103261). I notice it might be because the formula actually returned 2.306004135204 but the table is rounded to 2 digits 2.31. My question is does it matter? But math supposed to be precise isn't it? Or I might use the wrong formula, what is the better way to do it because I don't really like looking-at-the-table-manually method since it is hard to automate. Thanks

Hi Nunno, This is obviously a rounding error. It is up to you to decide how to round figures in practice. Usually rounding up to 4 decimal digits is considered a solid practice. Please don't worry too much about this issue as the focus of the lessons is to learn the principles and logic of the tests you are performing. Best, Ned

Follow this topic

Nunno Nugroho

Last answered:

19 Jan 2023

Posted on:

18 Jan 2023

Resolved: Different result with Excel formula

in Statistics / Population variance unknown, t-score

1 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

19 Jan 2023

Helpful answer

Resolved: Different result with Excel formula

Submit an answer

related questions