Pearson Correlation r and p Values in Excel

This video shows Dr. Evan Matthews explaining how to calculate the Pearson's correlation coefficient (r value) and the associated p value without using a statistical package within Microsoft Excel. This video is part of a playlist of videos showing how to set up a large research spreadsheet.

Pearson Correlation p Value Formula for Excel Used in Video:
=TDIST(ABS(([rValue]*SQRT([nSize]-2)/SQRT(1-([rValue]*[rValue])))), [nSize], 2)

Pearson’s Correlation Coefficient Interpretation
0 No Association
0.1 to 0.3 or −0.1 to −0.3 Small Effect
0.3 to 0.5 or −0.3 to −0.5 Medium Effect
0.5 to 1.0 or −0.5 to −1.0 Large Effect

n Size video (Building in Statistics – Counting Sample Size Collected Example)

Conditional Formatting for Cells Based on Values or Text in Excel

Link to Downloadable Dataset

Link to Published Study Using This Dataset

Master Research Spreadsheet Creation Playlist

Excel Skills Playlist That Goes Beyond The Skills for Setting Up a Master Spreadsheet

Link to Dr. Evan Matthews website.

[amg]

Thank you! I really didn't want to have to run R just for the p-value of a correlation. I appreciate you. Thanks for the tutorial!

[karisreader]

What a mad lad. Well explained guide on how to calculate P-Values.

[GhostyHoo]

Thank you for the video!
Question: can the same formula be used to calculate p-value of spearman r?

[adam]

Isn't the second parameter in the TDIST() function supposed to be degrees of freedom (i.e., n-2) rather than n?

[swathibadabagni]

Hi sir I have a doubt in my research work about statistical analysis. How I can contact you.