Hello,

i am taking a grad level statistics, out of 5-6 years of an intro statistics classes and something got me confused.

just functions are based in the a, some in the 1-a in excel. Let me explain

If i want to find the Z critical, for two tailed testing, all i have to do is =normsinv(0,95) and if the absolute value of Z is higher than that, i can reject hypothesis 0.

If i wanna do the similar activity with the t student, or F, i need to type =tinv(0,05, degrees of freedom) or = finv(0,05, df)

Why do we insert the complementary probability and not the direct? Am i the only one thinking this is inconsistent.

i am taking a grad level statistics, out of 5-6 years of an intro statistics classes and something got me confused.

just functions are based in the a, some in the 1-a in excel. Let me explain

If i want to find the Z critical, for two tailed testing, all i have to do is =normsinv(0,95) and if the absolute value of Z is higher than that, i can reject hypothesis 0.

If i wanna do the similar activity with the t student, or F, i need to type =tinv(0,05, degrees of freedom) or = finv(0,05, df)

Why do we insert the complementary probability and not the direct? Am i the only one thinking this is inconsistent.

Last edited: