0

I have got a strange problem. I'm using Office 2007. In Excel, I type the formula

=T.INV(0,975;99)

It is giving me 0,013417295 as a result. However, this should be 1,984. What could be wrong?

Improve this question
6
  • 1
    In my region I need to use a different syntax, i.e. =T.INV(0.975,99)....but I get 1.984
    – barry houdini
    Nov 7, 2013 at 22:46
  • The T.INV function is the left-tailed inverse of the Student's t-distribution. The T.INV.2T function is the two-tailed inverse of the Student's t-distribution – and so is the TINV function. Are you sure that you aren’t calling TINV?
    – Scott - Слава Україні
    Nov 7, 2013 at 23:45
  • I'm sure I inserted correct formula, according to the regional settings. If I insert =T.INV(0.975,99) it will give a syntax error
    – user270370
    Nov 8, 2013 at 16:13
  • I second Barry's result. I also get 1.984.
    – guitarthrower
    Nov 8, 2013 at 21:34
  • This doesn’t make any sense. How can =T.INV(anything) return any result in Excel 2007 when T.INV didn’t exist in Excel before 2010? BTW, I get 0.031417295 for =TINV(0.975, 99).
    – Scott - Слава Україні
    Nov 9, 2013 at 1:01

1 Answer 1

Reset to default
0

The problem is that you are using 0.975 as a whole. I guess you want a 95% confindence interval, then you should use 0.025 (2.5% in each tail)

The absolute value of that answer is exactly the one you were looking for :) Hope it helps!!!

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .