library(tidyverse)
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.1 ──
## ✓ ggplot2 3.3.3 ✓ purrr 0.3.4
## ✓ tibble 3.1.2 ✓ dplyr 1.0.6
## ✓ tidyr 1.1.3 ✓ stringr 1.4.0
## ✓ readr 1.4.0 ✓ forcats 0.5.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## x dplyr::filter() masks stats::filter()
## x dplyr::lag() masks stats::lag()
library(flextable)
##
## Dołączanie pakietu: 'flextable'
## Następujący obiekt został zakryty z 'package:purrr':
##
## compose
library(lubridate)
##
## Dołączanie pakietu: 'lubridate'
## Następujące obiekty zostały zakryte z 'package:base':
##
## date, intersect, setdiff, union
options(digits = 3)
data <- read_csv("data/results-survey811918.csv")
##
## ── Column specification ────────────────────────────────────────────────────────
## cols(
## .default = col_character(),
## id = col_double(),
## submitdate = col_datetime(format = ""),
## lastpage = col_double(),
## seed = col_double(),
## Inst = col_logical()
## )
## ℹ Use `spec()` for the full column specifications.
data <- data %>% filter((`attCheck1[Satz]` == 0) & (`attCheck2[Satz]` == 'plus2'))
data_long <- pivot_longer(data, cols = ends_with("[Satz]"), names_to = "sentence", values_to = "score")
data_long$score <- recode(data_long$score,
`min2` = -2,
`min1` = -1,
`0` = 0,
`plus1` = 1,
`plus2` = 2,
)
data_long <- data_long %>% rowwise() %>% mutate(popr = str_split(sentence, "X", simplify = T)[3])
summ <- data_long %>%
filter(! sentence %in% c('attCheck1[Satz]', 'attCheck2[Satz]') ) %>%
group_by(popr, sentence) %>% summarise(M = mean(score), SD = sd(score)) %>% arrange(M)
## `summarise()` has grouped output by 'popr'. You can override using the `.groups` argument.
pvals <- data_long %>% filter(! sentence %in% c('attCheck1[Satz]', 'attCheck2[Satz]') ) %>%
group_by(popr, sentence) %>% rstatix::t_test(data = ., score ~ 1, mu = 0) %>%
rowwise() %>%
mutate(p = scales::pvalue(p))
left_join(summ, pvals, by = c('sentence', 'popr')) %>% select(popr, sentence, M, SD, p) %>% flextable()
popr | sentence | M | SD | p |
filler34[Satz] | -1.923 | 0.277 | <0.001 | |
N | NX2XNXT20X1X2[Satz] | -1.846 | 0.555 | <0.001 |
filler20[Satz] | -1.846 | 0.555 | <0.001 | |
filler29[Satz] | -1.846 | 0.555 | <0.001 | |
N | WX1XNXT22X2X1[Satz] | -1.769 | 0.599 | <0.001 |
filler24[Satz] | -1.769 | 0.832 | <0.001 | |
N | JX1XNXT12X2X2[Satz] | -1.692 | 0.630 | <0.001 |
N | NX1XNXT11X2X2[Satz] | -1.692 | 0.630 | <0.001 |
N | NX1XNXT16X2X2[Satz] | -1.692 | 0.630 | <0.001 |
N | WX2XNXT13X2X2[Satz] | -1.692 | 0.855 | <0.001 |
N | WX2XNXT17X2X2[Satz] | -1.692 | 0.630 | <0.001 |
P | JX1XPXT20X1X2[Satz] | -1.692 | 0.480 | <0.001 |
P | WX1XPXT17X1X2[Satz] | -1.692 | 0.480 | <0.001 |
N | JX1XNXT15X2X1[Satz] | -1.615 | 0.650 | <0.001 |
N | JX1XNXT7X2X2[Satz] | -1.615 | 0.870 | <0.001 |
N | JX2XNXT11X1X2[Satz] | -1.615 | 0.650 | <0.001 |
N | WX1XNXT4X2X1[Satz] | -1.615 | 0.870 | <0.001 |
N | WX2XNXT7X2X2[Satz] | -1.615 | 0.506 | <0.001 |
P | WX1XPXT13X1X2[Satz] | -1.615 | 0.870 | <0.001 |
N | JX1XNXT1X2X2[Satz] | -1.538 | 0.660 | <0.001 |
N | JX2XNXT23X2X2[Satz] | -1.538 | 0.877 | <0.001 |
N | NX1XNXT14X2X2[Satz] | -1.538 | 1.127 | <0.001 |
N | WX1XNXT16X2X1[Satz] | -1.538 | 0.519 | <0.001 |
N | WX2XNXT21X2X2[Satz] | -1.538 | 0.660 | <0.001 |
N | JX1XNXT23X2X1[Satz] | -1.462 | 0.660 | <0.001 |
N | JX1XNXT4X2X2[Satz] | -1.462 | 0.877 | <0.001 |
N | NX1XNXT14X2X1[Satz] | -1.462 | 1.127 | <0.001 |
N | NX1XNXT8X2X1[Satz] | -1.462 | 0.967 | <0.001 |
N | WX1XNXT6X2X2[Satz] | -1.462 | 0.776 | <0.001 |
N | WX2XNXT12X1X2[Satz] | -1.462 | 0.877 | <0.001 |
N | JX2XNXT5X2X2[Satz] | -1.385 | 0.961 | <0.001 |
N | NX2XNXT10X2X2[Satz] | -1.385 | 1.121 | <0.001 |
N | WX1XNXT11X2X1[Satz] | -1.385 | 1.121 | <0.001 |
N | WX2XNXT2X2X2[Satz] | -1.385 | 0.870 | <0.001 |
N | JX1XNXT6X2X1[Satz] | -1.308 | 1.182 | 0.002 |
N | NX2XNXT9X1X2[Satz] | -1.308 | 0.947 | <0.001 |
N | JX1XNXT8X2X2[Satz] | -1.231 | 1.092 | 0.002 |
N | NX2XNXT4X2X2[Satz] | -1.231 | 1.092 | 0.002 |
N | WX2XNXT8X1X2[Satz] | -1.231 | 0.832 | <0.001 |
N | JX1XNXT2X2X2[Satz] | -1.154 | 1.281 | 0.007 |
N | NX1XNXT19X2X2[Satz] | -1.154 | 1.281 | 0.007 |
N | NX2XNXT15X2X2[Satz] | -1.154 | 1.281 | 0.007 |
N | WX2XNXT3X2X2[Satz] | -1.077 | 1.188 | 0.007 |
N | JX1XNXT3X2X1[Satz] | -1.000 | 1.581 | 0.042 |
N | NX1XNXT20X2X1[Satz] | -0.923 | 1.441 | 0.040 |
N | NX2XNXT16X2X2[Satz] | -0.923 | 1.256 | 0.021 |
N | NX2XNXT18X2X2[Satz] | -0.923 | 1.441 | 0.040 |
N | NX2XNXT24X2X2[Satz] | -0.923 | 1.441 | 0.040 |
N | WX2XNXT14X2X2[Satz] | -0.923 | 1.441 | 0.040 |
N | WX1XNXT7X2X1[Satz] | -0.769 | 1.641 | 0.117 |
P | NX1XPXT17X1X1[Satz] | -0.769 | 1.589 | 0.106 |
N | WX2XNXT22X1X2[Satz] | -0.615 | 1.121 | 0.071 |
P | JX0XPXT6X2X1[Satz] | -0.615 | 1.387 | 0.136 |
P | NX0XPXT4X2X1[Satz] | -0.462 | 1.391 | 0.255 |
P | WX0XPXT17X2X1[Satz] | -0.462 | 1.561 | 0.307 |
N | JX1XNXT18X2X2[Satz] | -0.308 | 1.548 | 0.487 |
P | NX0XPXT23X2X1[Satz] | 0.000 | 1.414 | >0.999 |
N | NX2XNXT6X1X2[Satz] | 0.231 | 1.423 | 0.570 |
N | JX2XNXT1X1X2[Satz] | 0.615 | 1.557 | 0.180 |
P | WX0XPXT10X1X1[Satz] | 0.769 | 1.301 | 0.054 |
P | NX0XPXT14X1X1[Satz] | 0.923 | 1.256 | 0.021 |
N | WX2XNXT19X1X2[Satz] | 1.000 | 1.080 | 0.006 |
P | JX1XPXT3X1X2[Satz] | 1.000 | 1.155 | 0.009 |
P | NX0XPXT18X2X1[Satz] | 1.000 | 1.225 | 0.012 |
P | NX0XPXT11X2X1[Satz] | 1.077 | 1.441 | 0.020 |
P | NX0XPXT9X2X1[Satz] | 1.231 | 1.092 | 0.002 |
P | WX1XPXT10X1X1[Satz] | 1.231 | 1.166 | 0.002 |
P | WX1XPXT5X1X2[Satz] | 1.231 | 1.166 | 0.002 |
P | JX0XPXT12X1X1[Satz] | 1.308 | 1.109 | 0.001 |
P | NX0XPXT21X2X1[Satz] | 1.308 | 1.377 | 0.005 |
P | NX0XPXT16X2X1[Satz] | 1.385 | 0.768 | <0.001 |
P | NX1XPXT24X1X1[Satz] | 1.385 | 1.193 | 0.001 |
P | NX0XPXT7X1X1[Satz] | 1.462 | 0.967 | <0.001 |
P | NX1XPXT9X1X2[Satz] | 1.462 | 1.050 | <0.001 |
P | WX0XPXT15X2X1[Satz] | 1.462 | 1.330 | 0.002 |
P | WX1XPXT21X1X1[Satz] | 1.462 | 1.127 | <0.001 |
P | JX0XPXT8X2X1[Satz] | 1.538 | 1.127 | <0.001 |
P | WX1XPXT9X1X1[Satz] | 1.538 | 0.967 | <0.001 |
P | JX0XPXT3X1X1[Satz] | 1.615 | 0.506 | <0.001 |
P | JX1XPXT21X1X2[Satz] | 1.615 | 0.870 | <0.001 |
P | NX0XPXT13X2X1[Satz] | 1.615 | 0.870 | <0.001 |
P | NX0XPXT19X2X1[Satz] | 1.615 | 0.768 | <0.001 |
P | NX1XPXT22X1X2[Satz] | 1.615 | 0.650 | <0.001 |
P | WX1XPXT5X1X1[Satz] | 1.615 | 0.961 | <0.001 |
P | NX1XPXT19X1X1[Satz] | 1.692 | 0.630 | <0.001 |
P | JX0XPXT20X2X1[Satz] | 1.769 | 0.599 | <0.001 |
P | JX0XPXT5X2X1[Satz] | 1.769 | 0.439 | <0.001 |
P | JX1XPXT23X1X2[Satz] | 1.769 | 0.599 | <0.001 |
P | JX1XPXT24X1X2[Satz] | 1.769 | 0.439 | <0.001 |
P | WX0XPXT1X2X1[Satz] | 1.769 | 0.832 | <0.001 |
P | WX1XPXT13X1X1[Satz] | 1.769 | 0.599 | <0.001 |
P | WX1XPXT18X1X1[Satz] | 1.769 | 0.599 | <0.001 |
filler1[Satz] | 1.769 | 0.439 | <0.001 | |
P | JX0XPXT24X2X1[Satz] | 1.846 | 0.376 | <0.001 |
P | JX0XPXT2X1X1[Satz] | 1.846 | 0.376 | <0.001 |
P | JX1XPXT15X1X2[Satz] | 1.846 | 0.376 | <0.001 |
P | NX1XPXT10X1X2[Satz] | 1.846 | 0.376 | <0.001 |
P | NX1XPXT1X1X1[Satz] | 1.846 | 0.376 | <0.001 |
P | WX1XPXT12X1X1[Satz] | 1.846 | 0.555 | <0.001 |
P | WX1XPXT2X1X1[Satz] | 1.846 | 0.376 | <0.001 |
P | WX0XPXT22X1X1[Satz] | 1.923 | 0.277 | <0.001 |
filler7[Satz] | 1.923 | 0.277 | <0.001 |