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
Cohen J. Statistical Power Analysis for the Behavioral Sciences. 2nd. Mahwah: Lawrence Erlbaum Associates; 1988. doi.org/10.432... 03771587
n Size video (Building in Statistics - Counting Sample Size Collected Example)
• Building in Statistics...
Conditional Formatting for Cells Based on Values or Text in Excel
• Conditional Formatting...
Link to Downloadable Dataset
digitalcommons...
Link to Published Study Using This Dataset
pubmed.ncbi.nl...
Master Research Spreadsheet Creation Playlist
• Master Research Spread...
Excel Skills Playlist That Goes Beyond The Skills for Setting Up a Master Spreadsheet
• Excel Microsoft Office
Link to Dr. Evan Matthews website.
sites.google.c...

[@amg6225]

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!

[@VivoPhys]

You are welcome.

[@karisreader7999]

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

[@VivoPhys]

Thank you

[@GhostyHoo]

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

[@VivoPhys]

I don't know. If you check it vs a software program please comment back to let me know if the p values match.

[@GhostyHoo]

@VivoPhys So I don't have access to a software to check this, but from what I understand, to calculate p-value, we need to calculate the test statistic (the equation for which I can see in your excel formula) and the equation for test statistic is the same for Pearson and Spearman r. So yes, I think we can use this excel formula for both. Source: search "Methods and formulas for correlation Minitab"

[@SOPPI_srn]

Thx! This is really helpful!

[@VivoPhys]

You are welcome.

[@swathibadabagni105]

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

[@VivoPhys]

I am not a statistician. I'm not your best bet for help. Sorry.