How to Create a Correlation Table in APA Style Using Excel 2016 (Windows and Mac)
HTML-код
- Опубликовано: 21 авг 2024
- This video describes how to create a correlation table that is APA 6th formatted using Excel 2016, which you can copy and paste into a Word document. See note below for APA 7th formatting.
The data file can be downloaded here for free: www.researchga...
The critical value calculator can be downloaded here for free: www.researchga...
This video was made for APA6th edition. For APA 7th edition formatting, the note would change. The new note should be:
Note. N = 100.
aMale = 1, female = 2.
*p [less than] .05, **p [less than] .01, two-tailed.
In this new format, each type of note has its own separate line.
The word "Note" and each "p" should be in italics.
[less than] should be replaced with a less than symbol which RUclips doesn't allow in video descriptions.
"a" should be in superscript, and "a" in superscript should also be added to end of the word "Sex" within the table.
just what I was looking for amazing! thanks David!
This is a life saver!
Thanks so much
Hello, is there any rule for listing the variables in the correlation table? I have listed them in the following order: 1 to 10 control variables, 11. Independent Variable 12. Dependent variable 13. Mediator
Thank you in advance!
So professor is the .412 very strongly corelated because it has three asterick? I thought that it only has medium effect so why there is three stars?
+SANDHUA DHUNGEL You're correct that an r of .412 is considered a medium effect size. The asterisks refer the p value. *** means p < .001. The p value indicates the certainty we have that the correlation value is 0, that is, that it isn't real and we just got it due to chance. So *** indicates that we are very sure that the correlation is real (that is, positive), not how strong it is.
@@DavidDunaetz oh i now am much more clear about p value.Thank you so much professor and how do i interpreat the data where i got similar to .412 ? So do i say it is positively correlated but not strongly ? Is that okay and when i get for example .612 or higher ?
@@zoharism It's true that .612 is a stronger correlation than .412. We can say that .412 is a medium effect size and that .612 is a medium to large effect size. However, significance does not just depend on the value of r. It depends also on the sample size N. If the samples size is small, it's possible that the correlation is not significant (p < .05). Here's a video that shows how to calculate the p-value on excel and how to report the results in APA format: ruclips.net/video/EEtyX0Au0Xc/видео.html
@@DavidDunaetz my sample size is 100 and i am confused with interpretation .So do i need to do significance test individually with each variables for interpretation .
@@zoharism For N = 100, the absolute value of a correlation needs to be greater than .1654 to be significant for a 1-tailed hypothesis (p < .05) and greater than .1966 for a 2-tailed hypothesis. See my video on calculating the critical value of r: ruclips.net/video/LBmqPmTOFGg/видео.html