One way to quantify the relationship between two variables is to use the Pearson correlation coefficient, which is a measure of the linear association between two variables.

It always takes on a value between -1 and 1 where:

- -1 indicates a perfectly negative linear correlation between two variables
- 0 indicates no linear correlation between two variables
- 1 indicates a perfectly positive linear correlation between two variables

To determine if a correlation coefficient is statistically significant, you can calculate the corresponding t-score and p-value.

The formula to calculate the t-score of a correlation coefficient (r) is:

**t** = r√(n-2) / √(1-r^{2})

The p-value is calculated as the corresponding two-sided p-value for the t-distribution with n-2 degrees of freedom.

The following example shows how to calculate a p-value for a correlation coefficient in Excel.

**P-Value for a Correlation Coefficient in Excel**

The following formulas show how to calculate the p-value for a given correlation coefficient and sample size in Excel:

For a correlation coefficient of r = 0.56 and sample size n = 14, we find that:

**t-score:**2.341478**p-value:**0.037285

Recall that for a correlation test we have the following null and alternative hypotheses:

**The null hypothesis (H _{0}):** The correlation between the two variables is zero.

**The alternative hypothesis: (Ha):** The correlation between the two variables is *not *zero, e.g. there is a statistically significant correlation.

If we use a significance level of α = .05, then we would reject the null hypothesis in this case since the p-value (0.037285) is less than .05.

We would conclude that the correlation coefficient is statistically significant.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Calculate Rolling Correlation in Excel

How to Create a Correlation Matrix in Excel

How to Calculate Spearman Rank Correlation in Excel

hi

about the hypothesis, isn’t it vice versa?

I mean since the p value is less than 0.05 then the correlation is statistically significant?

Thank you so much for this! I was struggling to make an excel sheet for projects with the formulas for easy access when evaluating datasets (and to avoid using SPSS for some simple p-values), and this has helped me immensely on my projects since reading.

TDist does not take a negative value. What do you do for negative correlations?

yours is missing a multiplication in the denominator??