Question

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!

Answer 1

The correlation test is t test for correlation. If sample size is n, let n=10, then degree of freedom of t test is

df=n-2 = 8

Let ts= 1.89 shows the value of test statistics.

If test is two tailed, the hypotheses are:

So the p-value of the test is

p-value = 0.0954

Following is the screen shot of excel:

-------------------

If test is one tailed, the p-value of the test is

p-value = 0.0477

Following is the screen shot of excel:

Last argument in TDiST shows the number of tails 1 or 2 . If the value of test statistics is negative, we need to enter the absolute value of test statistics.