|
View Full Version : p-value in excel resonance 10-10-2008, 04:45 AM 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! JohnM 10-10-2008, 06:49 AM The p-value is the probability of obtaining the t statistic (or larger) if the null hypothesis is true. vinux 10-10-2008, 09:44 AM 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 |