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. https://doi.org/10.4324/97802 03771587
n Size video (Building in Statistics – Counting Sample Size Collected Example)
https://youtu.be/mILWnNUeMZY

Conditional Formatting for Cells Based on Values or Text in Excel
https://youtu.be/KiF4-YgOo3A
Link to Downloadable Dataset
https://digitalcommons.montclair.edu/data/8/

Link to Published Study Using This Dataset
https://pubmed.ncbi.nlm.nih.gov/33417732/
Master Research Spreadsheet Creation Playlist
https://youtube.com/playlist?list=PLf85BhZ0yM_sItPJ_UZWEc65prIy0ibFJ
Excel Skills Playlist That Goes Beyond The Skills for Setting Up a Master Spreadsheet
https://www.youtube.com/playlist?list=PLf85BhZ0yM_siy9l4nDMG1kOveyTcWYBs
Link to Dr. Evan Matthews website.
https://sites.google.com/site/evanmatthewseportfolio/home

Видео Pearson Correlation r and p Values in Excel канала Vivo Phys - Evan Matthews