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

NEW VERSION Pearson Correlation r and p Values in Excel    • Pearson Correlation r and p Values in Exce...   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.    • Basic Scatter Plot in Excel   Link to video showing how to improve the appearance of this graph to mimic the appearance of graphs typical in physiology research papers.    • Publication Quality Scatter Plot in Excel ...   Link to video of how to perform a t-test in Excel.    • T-Test in Excel (NEW VERSION IN DESCRIPTION)   Excel Skills Playlist    • Excel Microsoft Office   Link to Dr. Evan Matthews website. https://sites.google.com/site/evanmat...