Correlation Statistics in Excel Basic (NEW VERSION and CORRECTION IN DESCRIPTION)

NEW VERSION Pearson Correlation r and p Values in Excel https://youtu.be/vqQSNokEdb8 CORRECTION: In the video I used the following formula to calculate p values (=TDIST(ABS(([rValue]*SQRT([nSize]-2)/SQRT(1-([rValue]*[rValue])))), [nSize], 2)). The last [nSize] is the portion of the excel function where the degrees of freedom is entered. This should have been [nSize]-2. I accidentally left out the -2. Fortunately, it makes minimal difference with typical sample sizes. My quick testing suggests that it only matters at the 3rd decimal place with sample sizes of at least 10. Once over 20 participants it is a small enough difference that it would not impact reported data as the difference would be rounded away. Regardless, the formulas given below have been corrected. This video shows Dr. Evan Matthews explaining how to perform a correlation in Excel, and how to interpret those results. The example data in this video represents the predicted 1 repetition maximum of the biceps curl and measured 1 repetition maximum of the biceps curl. Formula for correlation p value: =TDIST(ABS(([Excel reference to cell containing r value]*SQRT([Excel reference to cell containing sample size]-2)/SQRT(1-([Excel reference to cell containing r value]*[Excel reference to cell containing r value])))), [Excel reference to cell containing sample size]-2, 2) Example filled in formula for correlation from video: =TDIST(ABS((F5*SQRT(F8-2)/SQRT(1-(F5*F5)))), F8-2, 2) Link to video of how to create a basic scatter plot graph in Excel. https://youtu.be/MaR87irAyWY Link to video showing how to improve the appearance of this graph to mimic the appearance of graphs typical in physiology research papers. https://youtu.be/rCaDpwAexIo Link to video of how to perform a t-test in Excel. https://youtu.be/SQGWNxNHwgM Excel Skills Playlist https://www.youtube.com/playlist?list=PLf85BhZ0yM_siy9l4nDMG1kOveyTcWYBs Link to Dr. Evan Matthews website. https://sites.google.com/site/evanmatthewseportfolio/home