Question

How do I find critical values in excel given alpha with a two-tailed hypothesis test. I have a t- test statistic/

Answer 1

let

your "t" statistics have DF=r

test is two-tailed so there are two critical values one left tailed and other is right tailed

let level of significance =

then for left tailed critical value in excel write following formula

Left tailed critical value

for right-tailed critical value write this formula

for example let DF=r=10

level of significance =

then left tailed

=T.INV(0.025,10)

=-2.23

right tailed

=T.INV(0.975,10)

=2.23

Note: in excel for writing any formula you have to first write "=" then type formula

that neans your formula is "T.INV(0.975,10)" but it works iff you will write "=T.INV(0.975,10)"