How to find or calculate the Degrees of freedom (df) for a
Correlation Test, and the P-value associated with the Test using
Excel ??
Please show screenshots of the steps!
degrees of freedom=n-2
n-no of pairs
p value for the obtained t and df in excel is
For example we obtained
t=1.495943
and df=3 p value is
=T.DIST.2T(1.495943,3)
=0.23156
Exampl:
X | Y | |
2 | 56 | |
3 | 76 | |
5 | 34 | |
8 | 45 | |
7 | 33 | |
-0.65364 | ||
r=CORRELL(A2:A6,B2:B6)=-0.65364 | ||
T=r*sqrt(n-2)/sqrt(1-r^2 | ||
.'=-0.65364*sqrt(5-2)/sqrt(1-(-0.65364)^2 | ||
= 1.132138/ 0.7568057 | ||
T= 1.495943 | ||
df=n-2=5-2=3 | ||
p value | ==T.DIST.2T(1.495943,3)=0.23156 |
Get Answers For Free
Most questions answered within 1 hours.