Pearson Correlation r and p Values in Excel
HTML-код
- Опубликовано: 22 авг 2024
- 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...
What a mad lad. Well explained guide on how to calculate P-Values.
Thank you
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!
You are welcome.
Thx! This is really helpful!
You are welcome.
Thank you for the video!
Question: can the same formula be used to calculate p-value of spearman r?
I don't know. If you check it vs a software program please comment back to let me know if the p values match.
@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"
Hi sir I have a doubt in my research work about statistical analysis. How I can contact you.
I am not a statistician. I'm not your best bet for help. Sorry.