p-value in excel

#1
the formula =TDIST(ABS(X10),18,2) gives the p-value.
How does it do this? I know there's the degrees of freedom, but i have no idea what that is all about. HELP!

Thanks in advance!
 

vinux

Dark Knight
#3
the formula =TDIST(ABS(X10),18,2) gives the p-value.
How does it do this? I know there's the degrees of freedom, but i have no idea what that is all about. HELP!

Thanks in advance!

I guess you need the following.

X10 is the t-statistic value.
and
Pvalue = TDIST(ABS(X10),18,2) = P[ T<-X10 or T >X10 ]

where T follows Student's T distribution with 18 df