0

I want to find the value of a T-distribution for a level of significance set at 5% and degrees of freedom equaling 10 in an excel sheet. When manually calculating from a table, I found the value is 2.228, but Excel gives a value of 0.961. Am I doing something wrong here?

I used the following equation in Excel for the two-tailed test.

  T.DIST.2T(0.05,10) = 0.961

This is the t-distribution table. From this table, the value for the 5% level of significance and 10 degrees of freedom is 2.228.

Shawn Hemelstrand
  • 2,676
  • 4
  • 17
  • 30
Madhav
  • 9
  • 1
  • 5

1 Answers1

1

The function to find critical value needs to be inverse function. If you refer to the T.DIST.2T function documentation, you can observe that X argument is the value at which to evaluate the distribution; not level of significance.

What you need is the inverse function T.INV.2T function documentation.

  T.INV.2T(0,05;10) = 2,228138852
Slybot
  • 588
  • 1
  • 11