library(tidyverse)
library(pastecs)
library(GPArotation)
library(psych)
set.seed(10311993)
data <- psych::bfi
proposed_scale <- psych::bfi[,1:15]
proposed_scale <- proposed_scale %>% na.omit()
proposed_scale <- proposed_scale[sample(nrow(proposed_scale), size=500),]
cor_proposed_scale <- cor(proposed_scale, use = "pairwise.complete.obs")
apaTables::apa.cor.table(cor_proposed_scale,filename = "CorTable.doc")
# For Readability
round(cor(proposed_scale, use = "pairwise.complete.obs"),2)- 1
-
Create a data set using the
bfidataset in thepsychpackage - 2
-
Create a correlation matrix of the
bfiitems using thecor()function - 3
- Create an APA Style correlation output within Word
- 4
- Round correlation matrix to 2 decimal places for readability in R
Means, standard deviations, and correlations with confidence intervals
Variable M SD 1 2 3 4
1. A1 0.01 0.32
2. A2 0.17 0.36 -.77**
[-.92, -.43]
3. A3 0.18 0.37 -.73** .85**
[-.91, -.35] [.59, .95]
4. A4 0.15 0.32 -.60* .72** .69**
[-.85, -.13] [.32, .90] [.28, .89]
5. A5 0.18 0.37 -.65** .77** .90** .70**
[-.87, -.21] [.43, .92] [.73, .97] [.30, .89]
6. C1 0.12 0.33 -.20 .36 .23 .31
[-.65, .35] [-.19, .73] [-.32, .66] [-.24, .71]
7. C2 0.15 0.33 -.24 .38 .21 .38
[-.67, .31] [-.17, .75] [-.34, .65] [-.16, .75]
8. C3 0.12 0.32 -.28 .34 .18 .22
[-.69, .28] [-.21, .73] [-.37, .63] [-.33, .66]
9. C4 -0.01 0.38 .33 -.57* -.43 -.54*
[-.22, .72] [-.84, -.08] [-.77, .11] [-.82, -.03]
10. C5 -0.01 0.36 .33 -.57* -.49 -.61*
[-.22, .72] [-.84, -.08] [-.80, .03] [-.86, -.14]
11. E1 -0.02 0.38 .42 -.71** -.75** -.61*
[-.11, .77] [-.89, -.30] [-.91, -.40] [-.85, -.13]
12. E2 -0.03 0.41 .43 -.72** -.77** -.65**
[-.10, .77] [-.90, -.33] [-.92, -.42] [-.87, -.20]
13. E3 0.17 0.37 -.47 .69** .80** .62*
[-.79, .05] [.28, .89] [.48, .93] [.15, .86]
14. E4 0.14 0.39 -.45 .66** .75** .64**
[-.78, .08] [.22, .88] [.39, .91] [.19, .87]
15. E5 0.15 0.35 -.35 .67** .58* .57*
[-.73, .19] [.24, .88] [.10, .84] [.08, .84]
5 6 7 8 9 10
.24
[-.31, .67]
.18 .78**
[-.37, .63] [.44, .92]
.15 .66** .74**
[-.39, .62] [.22, .87] [.38, .91]
-.45 -.81** -.85** -.77**
[-.78, .08] [-.93, -.50] [-.95, -.60] [-.92, -.42]
-.49 -.75** -.76** -.70** .86**
[-.80, .03] [-.91, -.38] [-.92, -.41] [-.89, -.30] [.63, .95]
-.79** -.32 -.20 -.12 .39 .39
[-.93, -.46] [-.71, .23] [-.65, .35] [-.60, .42] [-.15, .75] [-.15, .75]
-.81** -.40 -.28 -.20 .49 .54*
[-.93, -.50] [-.76, .14] [-.70, .27] [-.65, .35] [-.03, .80] [.04, .83]
.83** .30 .21 .10 -.41 -.51
[.55, .94] [-.25, .70] [-.34, .65] [-.44, .58] [-.76, .13] [-.81, .01]
.84** .30 .18 .11 -.41 -.49
[.58, .95] [-.25, .70] [-.37, .63] [-.43, .59] [-.76, .12] [-.80, .03]
.59* .52* .55* .47 -.70** -.69**
[.10, .84] [.01, .81] [.06, .83] [-.06, .79] [-.89, -.30] [-.89, -.27]
11 12 13 14
.89**
[.70, .96]
-.86** -.89**
[-.95, -.62] [-.96, -.70]
-.88** -.93** .86**
[-.96, -.66] [-.98, -.80] [.61, .95]
-.72** -.78** .69** .64*
[-.90, -.34] [-.92, -.45] [.28, .89] [.18, .87]
Note. M and SD are used to represent mean and standard deviation, respectively.
Values in square brackets indicate the 95% confidence interval.
The confidence interval is a plausible range of population correlations
that could have caused the sample correlation (Cumming, 2014).
* indicates p < .05. ** indicates p < .01.
A1 A2 A3 A4 A5 C1 C2 C3 C4 C5 E1 E2
A1 1.00 -0.36 -0.31 -0.19 -0.23 0.00 -0.02 -0.08 0.12 0.10 0.13 0.14
A2 -0.36 1.00 0.51 0.35 0.40 0.14 0.20 0.19 -0.20 -0.16 -0.26 -0.26
A3 -0.31 0.51 1.00 0.33 0.59 0.08 0.11 0.10 -0.09 -0.14 -0.28 -0.29
A4 -0.19 0.35 0.33 1.00 0.35 0.10 0.22 0.06 -0.16 -0.23 -0.16 -0.19
A5 -0.23 0.40 0.59 0.35 1.00 0.09 0.07 0.09 -0.14 -0.13 -0.29 -0.31
C1 0.00 0.14 0.08 0.10 0.09 1.00 0.44 0.32 -0.38 -0.32 -0.09 -0.13
C2 -0.02 0.20 0.11 0.22 0.07 0.44 1.00 0.41 -0.42 -0.31 0.02 -0.02
C3 -0.08 0.19 0.10 0.06 0.09 0.32 0.41 1.00 -0.35 -0.30 0.04 0.01
C4 0.12 -0.20 -0.09 -0.16 -0.14 -0.38 -0.42 -0.35 1.00 0.52 0.16 0.22
C5 0.10 -0.16 -0.14 -0.23 -0.13 -0.32 -0.31 -0.30 0.52 1.00 0.08 0.26
E1 0.13 -0.26 -0.28 -0.16 -0.29 -0.09 0.02 0.04 0.16 0.08 1.00 0.54
E2 0.14 -0.26 -0.29 -0.19 -0.31 -0.13 -0.02 0.01 0.22 0.26 0.54 1.00
E3 -0.08 0.32 0.44 0.26 0.47 0.14 0.12 0.02 -0.06 -0.17 -0.38 -0.43
E4 -0.09 0.27 0.37 0.30 0.50 0.13 0.06 0.04 -0.10 -0.16 -0.44 -0.55
E5 0.00 0.34 0.25 0.23 0.24 0.21 0.31 0.25 -0.28 -0.24 -0.30 -0.36
E3 E4 E5
A1 -0.08 -0.09 0.00
A2 0.32 0.27 0.34
A3 0.44 0.37 0.25
A4 0.26 0.30 0.23
A5 0.47 0.50 0.24
C1 0.14 0.13 0.21
C2 0.12 0.06 0.31
C3 0.02 0.04 0.25
C4 -0.06 -0.10 -0.28
C5 -0.17 -0.16 -0.24
E1 -0.38 -0.44 -0.30
E2 -0.43 -0.55 -0.36
E3 1.00 0.47 0.36
E4 0.47 1.00 0.26
E5 0.36 0.26 1.00