# will install the package if not already installed
if(!require(qualtRics)){install.packages('qualtRics')}
## Loading required package: qualtRics
if(!require(tidyverse)){install.packages('tidyverse')}
## Loading required package: tidyverse
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.3 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ ggplot2 3.4.3 ✔ tibble 3.2.1
## ✔ lubridate 1.9.2 ✔ tidyr 1.3.0
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
if(!require(psych)){install.packages('psych')}
## Loading required package: psych
##
## Attaching package: 'psych'
##
## The following objects are masked from 'package:ggplot2':
##
## %+%, alpha
if(!require(mice)){install.packages('mice')}
## Loading required package: mice
##
## Attaching package: 'mice'
##
## The following object is masked from 'package:stats':
##
## filter
##
## The following objects are masked from 'package:base':
##
## cbind, rbind
if(!require(sjstats)){install.packages('sjstats')}
## Loading required package: sjstats
##
## Attaching package: 'sjstats'
##
## The following object is masked from 'package:psych':
##
## phi
if(!require(formattable)){install.packages('formattable')}
## Loading required package: formattable
library(readxl)
AsianData0 <- read.csv ("Stigma Project 2023 - Asian_November 4, 2023_20.05.csv", header = TRUE)
#174 objects of 145 variables
#Consent - move to top
AsianData0<- dplyr::rename(AsianData0, Consent = 'Q40')
AsianData1 <- dplyr::filter (AsianData0, Consent == "1")
nrow(AsianData1)
## [1] 172
This also got rid of the “useless” code that Qualtrics has under each column header
Everyone who opened the survey also consented
Number of people who opened the survey = 172 Number of people who consented = 172 100% of participants consented
AsianData1 <- dplyr::filter (AsianData1, Q51 != "test")
nrow(AsianData1)
## [1] 171
Number of actual participants (NOT TESTING) = 1 1 case deleted
#*confirm validity check Q34 2=valid
#record % of valid in codebook
AsianData1 <- dplyr::filter (AsianData1, Q34 == "2")
nrow(AsianData1)
## [1] 161
Number of participants who responded correctly to validity check = 161 10 cases deleted
AsianData2 <- subset(AsianData1, select = -c(StartDate, EndDate, Status, IPAddress, Finished, RecordedDate, ResponseId, RecipientLastName, RecipientFirstName, RecipientEmail, ExternalReference, LocationLatitude, LocationLongitude, DistributionChannel, UserLanguage, Q51))
#library(dplyr)
#AsianData2 = select(AsianData1, -c(StartDate, EndDate, Status, IPAddress, Finished, RecordedDate, ResponseId, RecipientLastName, RecipientFirstName, RecipientEmail, ExternalReference, LocationLatitude, LocationLongitude, DistributionChannel, UserLanguage, Q51))
Now 161 observations of 129 variables
str(AsianData2)
## 'data.frame': 161 obs. of 129 variables:
## $ Progress : chr "100" "100" "100" "100" ...
## $ Duration..in.seconds.: chr "496" "596" "398" "1077" ...
## $ Consent : chr "1" "1" "1" "1" ...
## $ SSRPH_1 : chr "3" "3" "3" "3" ...
## $ SSRPH_2 : chr "3" "2" "3" "2" ...
## $ SSRPH_3 : chr "3" "2" "4" "3" ...
## $ SSRPH_4 : chr "3" "2" "3" "3" ...
## $ SSRPH_5 : chr "2" "2" "3" "3" ...
## $ SSOSH_1 : chr "4" "2" "4" "2" ...
## $ SSOSH_2 : chr "4" "2" "4" "4" ...
## $ SSOSH_3 : chr "3" "2" "4" "2" ...
## $ SSOSH_4 : chr "3" "3" "2" "5" ...
## $ SSOSH_5 : chr "2" "3" "3" "3" ...
## $ SSOSH_6 : chr "3" "3" "4" "2" ...
## $ SSOSH_7 : chr "3" "3" "2" "5" ...
## $ SSOSH_8 : chr "2" "3" "4" "2" ...
## $ SSOSH_9 : chr "3" "3" "3" "3" ...
## $ SSOSH_10 : chr "4" "2" "4" "2" ...
## $ MHSAS_1 : chr "6" "6" "1" "5" ...
## $ MHSAS_2 : chr "6" "2" "7" "3" ...
## $ MHSAS_3 : chr "7" "5" "4" "5" ...
## $ MHSAS_4 : chr "5" "5" "1" "6" ...
## $ MHSAS_5 : chr "4" "2" "7" "3" ...
## $ MHSAS_6 : chr "3" "2" "7" "3" ...
## $ MHSAS_7 : chr "1" "5" "1" "6" ...
## $ MHSAS_8 : chr "3" "4" "7" "3" ...
## $ MHSAS_9 : chr "4" "3" "7" "3" ...
## $ AHELP : chr "Housemates" "My girlfriend" "A missionary." "I have talked to a phone psychologist from my work" ...
## $ PRE_HELP : chr "1" "2" "1" "1" ...
## $ PR_PF_1 : chr "5" "5" "4" "5" ...
## $ PR_PF_2 : chr "5" "5" "5" "5" ...
## $ PR_PF_3 : chr "5" "5" "5" "5" ...
## $ PR_PF_4 : chr "5" "5" "4" "5" ...
## $ PR_AD_1 : chr "3" "2" "4" "2" ...
## $ PR_AD_2 : chr "3" "2" "4" "1" ...
## $ PR_AD_3 : chr "2" "2" "4" "1" ...
## $ PR_AD_4 : chr "2" "2" "4" "1" ...
## $ PR_AD_5 : chr "3" "2" "4" "1" ...
## $ PR_AD_6 : chr "3" "2" "4" "1" ...
## $ PR_AD_7 : chr "4" "2" "4" "1" ...
## $ PR_AD_8 : chr "4" "2" "4" "1" ...
## $ PR_SR_1 : chr "4" "4" "2" "5" ...
## $ PR_SR_2 : chr "3" "4" "2" "5" ...
## $ PR_SR_3 : chr "4" "4" "3" "5" ...
## $ PR_SR_4 : chr "4" "4" "3" "5" ...
## $ PR_PI_1 : chr "1" "2" "2" "1" ...
## $ PR_PI_2 : chr "1" "2" "2" "1" ...
## $ PR_PI_3 : chr "1" "2" "2" "2" ...
## $ PR_PI_4 : chr "1" "2" "2" "1" ...
## $ PR_INT : chr "1" "2" "3" "2" ...
## $ Q34 : chr "2" "2" "2" "2" ...
## $ ANG_1 : chr "3" "3" "4" "2" ...
## $ ANG_2 : chr "2" "3" "4" "1" ...
## $ ANG_3 : chr "2" "3" "4" "1" ...
## $ ANG_4 : chr "3" "3" "4" "1" ...
## $ ANG_5 : chr "3" "3" "4" "1" ...
## $ CSA_1 : chr "1" "3" "3" "1" ...
## $ CSA_2 : chr "2" "2" "3" "0" ...
## $ CSA_3 : chr "2" "1" "2" "0" ...
## $ CSA_4 : chr "1" "3" "3" "0" ...
## $ CSA_5 : chr "1" "1" "4" "1" ...
## $ CSA_6 : chr "1" "1" "1" "0" ...
## $ CSA_7 : chr "3" "1" "1" "0" ...
## $ CSA_8 : chr "1" "1" "3" "0" ...
## $ CSA_9 : chr "1" "1" "1" "0" ...
## $ CSA_10 : chr "3" "2" "2" "0" ...
## $ CSA_11 : chr "0" "0" "1" "0" ...
## $ CSA_12 : chr "4" "1" "3" "0" ...
## $ CSA_13 : chr "1" "1" "3" "0" ...
## $ CSA_14 : chr "2" "2" "3" "0" ...
## $ CSA_15 : chr "3" "3" "4" "0" ...
## $ CSA_16 : chr "3" "2" "3" "0" ...
## $ CSA_17 : chr "2" "2" "4" "0" ...
## $ CSA_18 : chr "1" "2" "1" "0" ...
## $ CSA_19 : chr "1" "2" "2" "0" ...
## $ CSA_20 : chr "0" "1" "2" "0" ...
## $ CSA_21 : chr "3" "2" "2" "0" ...
## $ CSA_22 : chr "2" "1" "2" "0" ...
## $ CSA_23 : chr "1" "1" "3" "0" ...
## $ CSA_24 : chr "3" "2" "4" "0" ...
## $ CSA_25 : chr "0" "0" "2" "0" ...
## $ IEQ_1 : chr "2" "1" "2" "1" ...
## $ IEQ_2 : chr "2" "1" "1" "1" ...
## $ IEQ_3 : chr "1" "1" "2" "1" ...
## $ IEQ_4 : chr "1" "1" "2" "1" ...
## $ IEQ_5 : chr "1" "1" "2" "1" ...
## $ SLESQ_1 : chr "1" "1" "1" "1" ...
## $ SLESQ_2 : chr "1" "1" "1" "1" ...
## $ SLESQ_3 : chr "1" "1" "1" "1" ...
## $ SLESQ_4 : chr "2" "1" "2" "1" ...
## $ SLESQ_5 : chr "1" "1" "1" "1" ...
## $ SLESQ_6 : chr "2" "1" "1" "1" ...
## $ SLESQ_7 : chr "2" "1" "1" "1" ...
## $ SLESQ_8 : chr "1" "1" "1" "1" ...
## $ SLESQ_9 : chr "2" "1" "1" "1" ...
## $ SLESQ_10 : chr "1" "1" "1" "1" ...
## $ SLESQ_11 : chr "1" "1" "1" "1" ...
## $ SLESQ_12 : chr "1" "1" "1" "1" ...
## $ SLESQ_13 : chr "1" "1" "1" "1" ...
## [list output truncated]
#Convert all characters into integers for anything that has a number
#install.packages("hablar")
library(hablar)
##
## Attaching package: 'hablar'
## The following object is masked from 'package:mice':
##
## squeeze
## The following object is masked from 'package:forcats':
##
## fct
## The following object is masked from 'package:dplyr':
##
## na_if
## The following object is masked from 'package:tibble':
##
## num
AsianData2 <- AsianData2 %>% #convert dataframe to integer
#watch out for asian american value
convert(int(Progress:MHSAS_9, PRE_HELP:GEN, EDU, EMP:ETH, INC, BORN, BORN_2))
## Warning: There was 1 warning in `mutate()`.
## ℹ In argument: `ETH = (structure(function (..., .x = ..1, .y = ..2, . = ..1)
## ...`.
## Caused by warning in `as_reliable_int()`:
## ! NAs introduced by coercion
str(AsianData2)
## 'data.frame': 161 obs. of 129 variables:
## $ Progress : int 100 100 100 100 100 100 100 100 100 100 ...
## $ Duration..in.seconds.: int 496 596 398 1077 472 1278 1012 501 391 571 ...
## $ Consent : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SSRPH_1 : int 3 3 3 3 3 3 2 2 3 3 ...
## $ SSRPH_2 : int 3 2 3 2 1 3 2 1 3 2 ...
## $ SSRPH_3 : int 3 2 4 3 3 3 1 1 3 3 ...
## $ SSRPH_4 : int 3 2 3 3 2 3 1 1 2 1 ...
## $ SSRPH_5 : int 2 2 3 3 3 3 1 3 2 1 ...
## $ SSOSH_1 : int 4 2 4 2 1 4 1 1 2 3 ...
## $ SSOSH_2 : int 4 2 4 4 5 3 5 5 4 2 ...
## $ SSOSH_3 : int 3 2 4 2 1 4 1 1 2 2 ...
## $ SSOSH_4 : int 3 3 2 5 2 3 4 3 4 3 ...
## $ SSOSH_5 : int 2 3 3 3 4 3 4 4 4 2 ...
## $ SSOSH_6 : int 3 3 4 2 1 4 1 1 2 3 ...
## $ SSOSH_7 : int 3 3 2 5 5 3 4 5 4 4 ...
## $ SSOSH_8 : int 2 3 4 2 1 3 1 1 2 2 ...
## $ SSOSH_9 : int 3 3 3 3 5 3 4 5 4 2 ...
## $ SSOSH_10 : int 4 2 4 2 1 4 2 1 2 4 ...
## $ MHSAS_1 : int 6 6 1 5 6 4 6 7 6 6 ...
## $ MHSAS_2 : int 6 2 7 3 2 3 1 1 3 2 ...
## $ MHSAS_3 : int 7 5 4 5 6 5 7 7 6 6 ...
## $ MHSAS_4 : int 5 5 1 6 5 4 7 7 6 7 ...
## $ MHSAS_5 : int 4 2 7 3 1 3 2 1 3 2 ...
## $ MHSAS_6 : int 3 2 7 3 3 4 2 1 3 1 ...
## $ MHSAS_7 : int 1 5 1 6 6 3 6 7 6 7 ...
## $ MHSAS_8 : int 3 4 7 3 4 5 2 1 4 4 ...
## $ MHSAS_9 : int 4 3 7 3 2 5 1 1 3 2 ...
## $ AHELP : chr "Housemates" "My girlfriend" "A missionary." "I have talked to a phone psychologist from my work" ...
## $ PRE_HELP : int 1 2 1 1 2 2 1 1 2 2 ...
## $ PR_PF_1 : int 5 5 4 5 5 5 5 5 5 4 ...
## $ PR_PF_2 : int 5 5 5 5 5 5 5 5 5 5 ...
## $ PR_PF_3 : int 5 5 5 5 5 5 5 5 5 5 ...
## $ PR_PF_4 : int 5 5 4 5 5 5 5 5 5 5 ...
## $ PR_AD_1 : int 3 2 4 2 1 3 2 2 2 2 ...
## $ PR_AD_2 : int 3 2 4 1 1 1 2 2 2 3 ...
## $ PR_AD_3 : int 2 2 4 1 1 1 2 2 2 3 ...
## $ PR_AD_4 : int 2 2 4 1 2 2 3 2 2 3 ...
## $ PR_AD_5 : int 3 2 4 1 1 1 2 NA 2 3 ...
## $ PR_AD_6 : int 3 2 4 1 1 1 3 2 2 3 ...
## $ PR_AD_7 : int 4 2 4 1 2 1 2 2 2 3 ...
## $ PR_AD_8 : int 4 2 4 1 1 1 2 2 2 3 ...
## $ PR_SR_1 : int 4 4 2 5 5 5 5 4 4 4 ...
## $ PR_SR_2 : int 3 4 2 5 5 5 5 4 4 5 ...
## $ PR_SR_3 : int 4 4 3 5 5 5 5 4 4 3 ...
## $ PR_SR_4 : int 4 4 3 5 5 5 5 4 4 5 ...
## $ PR_PI_1 : int 1 2 2 1 2 1 1 2 2 2 ...
## $ PR_PI_2 : int 1 2 2 1 1 1 1 2 1 2 ...
## $ PR_PI_3 : int 1 2 2 2 2 1 1 2 2 1 ...
## $ PR_PI_4 : int 1 2 2 1 1 1 1 2 1 2 ...
## $ PR_INT : int 1 2 3 2 3 1 2 3 3 3 ...
## $ Q34 : int 2 2 2 2 2 2 2 2 2 2 ...
## $ ANG_1 : int 3 3 4 2 1 2 3 2 1 2 ...
## $ ANG_2 : int 2 3 4 1 1 1 3 2 1 2 ...
## $ ANG_3 : int 2 3 4 1 1 1 3 1 1 1 ...
## $ ANG_4 : int 3 3 4 1 1 1 2 1 1 2 ...
## $ ANG_5 : int 3 3 4 1 1 1 3 2 1 2 ...
## $ CSA_1 : int 1 3 3 1 2 1 2 1 1 3 ...
## $ CSA_2 : int 2 2 3 0 1 2 2 1 1 2 ...
## $ CSA_3 : int 2 1 2 0 0 0 2 0 0 0 ...
## $ CSA_4 : int 1 3 3 0 0 0 1 1 0 1 ...
## $ CSA_5 : int 1 1 4 1 0 0 1 1 0 1 ...
## $ CSA_6 : int 1 1 1 0 0 0 1 0 0 1 ...
## $ CSA_7 : int 3 1 1 0 0 2 1 0 0 0 ...
## $ CSA_8 : int 1 1 3 0 0 1 1 1 0 1 ...
## $ CSA_9 : int 1 1 1 0 0 1 1 1 0 0 ...
## $ CSA_10 : int 3 2 2 0 0 0 1 2 0 1 ...
## $ CSA_11 : int 0 0 1 0 0 0 1 1 0 0 ...
## $ CSA_12 : int 4 1 3 0 2 0 2 1 0 2 ...
## $ CSA_13 : int 1 1 3 0 0 1 1 1 0 3 ...
## $ CSA_14 : int 2 2 3 0 0 1 NA 0 0 1 ...
## $ CSA_15 : int 3 3 4 0 0 0 1 2 0 1 ...
## $ CSA_16 : int 3 2 3 0 1 0 1 1 0 3 ...
## $ CSA_17 : int 2 2 4 0 2 2 3 1 0 2 ...
## $ CSA_18 : int 1 2 1 0 0 1 2 1 0 3 ...
## $ CSA_19 : int 1 2 2 0 0 0 0 0 0 2 ...
## $ CSA_20 : int 0 1 2 0 0 0 1 1 0 1 ...
## $ CSA_21 : int 3 2 2 0 0 0 1 0 0 1 ...
## $ CSA_22 : int 2 1 2 0 0 2 1 1 0 1 ...
## $ CSA_23 : int 1 1 3 0 0 2 1 1 0 1 ...
## $ CSA_24 : int 3 2 4 0 0 0 1 0 2 0 ...
## $ CSA_25 : int 0 0 2 0 0 0 1 0 0 0 ...
## $ IEQ_1 : int 2 1 2 1 1 0 1 1 1 1 ...
## $ IEQ_2 : int 2 1 1 1 0 0 2 0 1 0 ...
## $ IEQ_3 : int 1 1 2 1 0 0 1 2 1 1 ...
## $ IEQ_4 : int 1 1 2 1 0 0 2 0 1 0 ...
## $ IEQ_5 : int 1 1 2 1 0 0 2 1 1 0 ...
## $ SLESQ_1 : int 1 1 1 1 1 2 2 2 1 1 ...
## $ SLESQ_2 : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_3 : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_4 : int 2 1 2 1 1 1 1 1 1 2 ...
## $ SLESQ_5 : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_6 : int 2 1 1 1 1 1 2 1 1 2 ...
## $ SLESQ_7 : int 2 1 1 1 2 2 1 1 2 1 ...
## $ SLESQ_8 : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_9 : int 2 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_10 : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_11 : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_12 : int 1 1 1 1 1 1 1 1 1 1 ...
## $ SLESQ_13 : int 1 1 1 1 1 1 1 1 1 1 ...
## [list output truncated]
#*calculate average, SD, max/min Duration__in_seconds_
psych::describe(AsianData2, na.rm = FALSE, ranges = TRUE)
## vars n mean sd median trimmed mad min max
## Progress 1 35 99.83 0.75 100 100.00 0.00 96 100
## Duration..in.seconds. 2 35 810.91 673.33 602 684.00 299.49 255 3801
## Consent 3 35 1.00 0.00 1 1.00 0.00 1 1
## SSRPH_1 4 35 2.54 0.85 2 2.55 1.48 1 4
## SSRPH_2 5 35 1.63 0.73 1 1.55 0.00 1 3
## SSRPH_3 6 35 2.23 0.84 2 2.17 0.00 1 4
## SSRPH_4 7 35 1.97 0.75 2 1.97 1.48 1 3
## SSRPH_5 8 35 2.11 0.72 2 2.14 1.48 1 3
## SSOSH_1 9 35 1.97 0.95 2 1.86 1.48 1 4
## SSOSH_2 10 35 3.91 0.95 4 4.03 0.00 1 5
## SSOSH_3 11 35 1.69 0.96 1 1.52 0.00 1 5
## SSOSH_4 12 35 3.14 0.85 3 3.17 1.48 1 5
## SSOSH_5 13 35 3.17 1.10 3 3.17 1.48 1 5
## SSOSH_6 14 35 1.97 1.12 2 1.83 1.48 1 5
## SSOSH_7 15 35 4.03 1.04 4 4.17 1.48 1 5
## SSOSH_8 16 35 1.97 1.01 2 1.83 1.48 1 5
## SSOSH_9 17 35 3.11 1.11 3 3.14 1.48 1 5
## SSOSH_10 18 35 2.80 1.32 3 2.79 1.48 1 5
## MHSAS_1 19 35 5.69 1.66 6 6.00 1.48 1 7
## MHSAS_2 20 35 2.40 1.80 2 2.10 1.48 1 7
## MHSAS_3 21 35 6.09 1.09 6 6.24 1.48 3 7
## MHSAS_4 22 35 5.26 1.50 6 5.45 1.48 1 7
## MHSAS_5 23 35 2.23 1.63 2 1.93 1.48 1 7
## MHSAS_6 24 35 2.71 1.56 2 2.59 1.48 1 7
## MHSAS_7 25 35 5.14 1.61 6 5.31 1.48 1 7
## MHSAS_8 26 35 3.26 1.74 3 3.10 1.48 1 7
## MHSAS_9 27 35 2.97 1.72 3 2.79 1.48 1 7
## AHELP* 28 35 14.86 8.20 16 14.83 10.38 1 29
## PRE_HELP 29 35 1.46 0.51 1 1.45 0.00 1 2
## PR_PF_1 30 35 4.46 0.89 5 4.62 0.00 1 5
## PR_PF_2 31 35 4.43 1.07 5 4.66 0.00 1 5
## PR_PF_3 32 35 4.66 0.73 5 4.83 0.00 2 5
## PR_PF_4 33 35 4.57 0.78 5 4.72 0.00 2 5
## PR_AD_1 34 35 2.37 1.09 2 2.31 1.48 1 5
## PR_AD_2 35 35 2.46 1.31 2 2.38 1.48 1 5
## PR_AD_3 36 35 2.66 1.26 3 2.62 1.48 1 5
## PR_AD_4 37 35 2.66 1.21 2 2.62 1.48 1 5
## PR_AD_5 38 35 2.77 1.33 3 2.72 1.48 1 5
## PR_AD_6 39 35 2.63 1.31 2 2.55 1.48 1 5
## PR_AD_7 40 35 2.74 1.42 2 2.69 1.48 1 5
## PR_AD_8 41 35 2.69 1.47 2 2.62 1.48 1 5
## PR_SR_1 42 35 3.71 1.10 4 3.83 1.48 1 5
## PR_SR_2 43 35 3.66 1.21 4 3.72 1.48 1 5
## PR_SR_3 44 35 3.80 1.18 4 3.93 1.48 1 5
## PR_SR_4 45 35 3.66 1.14 4 3.76 1.48 1 5
## PR_PI_1 46 35 2.09 0.98 2 1.97 1.48 1 5
## PR_PI_2 47 35 2.17 1.10 2 2.07 1.48 1 5
## PR_PI_3 48 35 2.09 0.95 2 2.00 1.48 1 4
## PR_PI_4 49 35 2.09 1.07 2 1.97 1.48 1 5
## PR_INT 50 35 4.03 2.38 3 3.97 2.97 1 9
## Q34 51 35 2.00 0.00 2 2.00 0.00 2 2
## ANG_1 52 35 2.54 1.20 2 2.48 1.48 1 5
## ANG_2 53 35 2.49 1.17 2 2.45 1.48 1 5
## ANG_3 54 35 2.37 1.31 2 2.28 1.48 1 5
## ANG_4 55 35 2.51 1.12 2 2.45 1.48 1 5
## ANG_5 56 35 2.91 1.17 3 2.90 1.48 1 5
## CSA_1 57 35 2.17 1.25 2 2.21 1.48 0 4
## CSA_2 58 35 2.43 0.92 2 2.41 1.48 1 4
## CSA_3 59 35 1.43 1.24 1 1.34 1.48 0 4
## CSA_4 60 35 1.77 1.29 2 1.76 1.48 0 4
## CSA_5 61 35 1.43 1.36 1 1.31 1.48 0 4
## CSA_6 62 35 0.63 1.00 0 0.45 0.00 0 3
## CSA_7 63 35 1.03 1.15 1 0.86 1.48 0 4
## CSA_8 64 35 1.89 1.28 2 1.86 1.48 0 4
## CSA_9 65 35 1.51 1.25 1 1.41 1.48 0 4
## CSA_10 66 35 1.54 0.98 2 1.55 1.48 0 3
## CSA_11 67 35 0.57 0.81 0 0.45 0.00 0 3
## CSA_12 68 35 1.97 1.29 2 1.97 1.48 0 4
## CSA_13 69 35 1.83 1.20 2 1.83 1.48 0 4
## CSA_14 70 35 1.63 1.29 2 1.55 1.48 0 4
## CSA_15 71 35 2.20 1.21 2 2.24 1.48 0 4
## CSA_16 72 35 1.94 1.16 2 1.93 1.48 0 4
## CSA_17 73 35 2.14 1.24 2 2.17 1.48 0 4
## CSA_18 74 35 1.94 1.21 2 1.93 1.48 0 4
## CSA_19 75 35 0.91 1.09 1 0.76 1.48 0 4
## CSA_20 76 35 1.14 1.19 1 1.03 1.48 0 4
## CSA_21 77 35 1.34 1.14 1 1.28 1.48 0 4
## CSA_22 78 35 1.20 1.13 1 1.10 1.48 0 4
## CSA_23 79 35 1.63 1.19 1 1.55 1.48 0 4
## CSA_24 80 35 1.34 1.41 1 1.21 1.48 0 4
## CSA_25 81 35 0.86 1.00 0 0.76 0.00 0 3
## IEQ_1 82 35 1.00 0.77 1 1.00 1.48 0 2
## IEQ_2 83 35 0.83 0.66 1 0.79 0.00 0 2
## IEQ_3 84 35 1.03 0.82 1 1.03 1.48 0 2
## IEQ_4 85 35 0.89 0.80 1 0.86 1.48 0 2
## IEQ_5 86 35 0.69 0.72 1 0.62 1.48 0 2
## SLESQ_1 87 35 1.20 0.41 1 1.14 0.00 1 2
## SLESQ_2 88 35 1.17 0.38 1 1.10 0.00 1 2
## SLESQ_3 89 35 1.03 0.17 1 1.00 0.00 1 2
## SLESQ_4 90 35 1.17 0.38 1 1.10 0.00 1 2
## SLESQ_5 91 35 1.06 0.24 1 1.00 0.00 1 2
## SLESQ_6 92 35 1.26 0.44 1 1.21 0.00 1 2
## SLESQ_7 93 35 1.31 0.47 1 1.28 0.00 1 2
## SLESQ_8 94 35 1.14 0.36 1 1.07 0.00 1 2
## SLESQ_9 95 35 1.37 0.49 1 1.34 0.00 1 2
## SLESQ_10 96 35 1.03 0.17 1 1.00 0.00 1 2
## SLESQ_11 97 35 1.06 0.24 1 1.00 0.00 1 2
## SLESQ_12 98 35 1.09 0.28 1 1.00 0.00 1 2
## SLESQ_13 99 35 1.17 0.38 1 1.10 0.00 1 2
## OD_1 100 35 2.00 0.69 2 1.97 0.00 1 4
## OD_2 101 35 1.94 0.94 2 1.79 0.00 1 5
## OD_3 102 35 2.09 0.78 2 2.03 0.00 1 4
## PCL5_1 103 35 1.09 1.04 1 1.00 1.48 0 3
## PCL5_2 104 35 1.57 1.31 1 1.48 1.48 0 4
## PCL5_3 105 35 1.46 1.38 1 1.34 1.48 0 4
## PCL5_4 106 35 1.14 1.09 1 1.07 1.48 0 3
## ESC_1 107 35 4.51 1.50 5 4.48 1.48 2 7
## ESC_2 108 35 5.00 1.24 5 5.03 1.48 2 7
## ESC_3 109 35 4.74 1.38 5 4.76 1.48 2 7
## ESC_4 110 35 4.17 1.65 4 4.17 1.48 1 7
## ESC_5 111 35 4.89 1.37 5 4.93 1.48 2 7
## ESC_6 112 35 3.71 1.51 4 3.76 1.48 1 6
## ESC_7 113 35 3.66 1.47 4 3.59 1.48 1 7
## ESC_8 114 35 4.91 1.36 5 4.93 1.48 2 7
## AGE 115 35 39.74 11.21 39 39.52 13.34 22 64
## GEN 116 35 1.37 0.49 1 1.34 0.00 1 2
## GEN_8_TEXT* 117 35 1.00 0.00 1 1.00 0.00 1 1
## EDU 118 35 6.11 1.43 6 6.00 1.48 4 10
## EDU_11_TEXT* 119 35 1.00 0.00 1 1.00 0.00 1 1
## EMP 120 35 1.63 0.94 1 1.48 0.00 1 4
## INS_1 121 35 1.00 0.00 1 1.00 0.00 1 1
## INS_2 122 35 1.40 0.81 1 1.24 0.00 1 4
## ETH 123 35 8.17 6.57 7 7.90 8.90 1 18
## ETH_22_TEXT* 124 35 1.00 0.00 1 1.00 0.00 1 1
## ETH_26_TEXT* 125 35 1.00 0.00 1 1.00 0.00 1 1
## INC 126 35 6.74 2.09 7 6.90 2.97 2 9
## BORN 127 35 2.00 0.00 2 2.00 0.00 2 2
## BORN_1* 128 35 9.69 5.46 9 9.76 7.41 1 18
## BORN_2 129 35 1884.46 464.58 1999 1996.59 10.38 25 2014
## range skew kurtosis se
## Progress 4 -4.25 17.75 0.13
## Duration..in.seconds. 3546 2.79 8.94 113.81
## Consent 0 NaN NaN 0.00
## SSRPH_1 3 0.15 -0.76 0.14
## SSRPH_2 2 0.66 -0.93 0.12
## SSRPH_3 3 0.72 -0.03 0.14
## SSRPH_4 2 0.04 -1.26 0.13
## SSRPH_5 2 -0.16 -1.11 0.12
## SSOSH_1 3 0.84 -0.18 0.16
## SSOSH_2 4 -1.23 1.37 0.16
## SSOSH_3 4 1.59 2.40 0.16
## SSOSH_4 4 -0.26 -0.25 0.14
## SSOSH_5 4 -0.07 -0.86 0.19
## SSOSH_6 4 1.02 0.02 0.19
## SSOSH_7 4 -1.11 0.62 0.18
## SSOSH_8 4 1.04 0.65 0.17
## SSOSH_9 4 -0.22 -0.79 0.19
## SSOSH_10 4 -0.16 -1.44 0.22
## MHSAS_1 6 -1.58 1.71 0.28
## MHSAS_2 6 1.26 0.43 0.30
## MHSAS_3 4 -0.95 -0.01 0.19
## MHSAS_4 6 -1.09 0.64 0.25
## MHSAS_5 6 1.55 1.36 0.28
## MHSAS_6 6 0.73 -0.30 0.26
## MHSAS_7 6 -0.80 -0.25 0.27
## MHSAS_8 6 0.53 -0.48 0.29
## MHSAS_9 6 0.55 -0.42 0.29
## AHELP* 28 -0.04 -1.26 1.39
## PRE_HELP 1 0.16 -2.03 0.09
## PR_PF_1 4 -1.97 4.36 0.15
## PR_PF_2 4 -1.73 1.95 0.18
## PR_PF_3 3 -2.11 3.84 0.12
## PR_PF_4 3 -1.69 1.96 0.13
## PR_AD_1 4 0.45 -0.69 0.18
## PR_AD_2 4 0.43 -1.27 0.22
## PR_AD_3 4 0.04 -1.23 0.21
## PR_AD_4 4 0.27 -1.18 0.20
## PR_AD_5 4 0.12 -1.21 0.22
## PR_AD_6 4 0.38 -1.03 0.22
## PR_AD_7 4 0.32 -1.28 0.24
## PR_AD_8 4 0.37 -1.38 0.25
## PR_SR_1 4 -0.73 -0.02 0.19
## PR_SR_2 4 -0.50 -1.10 0.20
## PR_SR_3 4 -0.76 -0.34 0.20
## PR_SR_4 4 -0.61 -0.37 0.19
## PR_PI_1 4 0.92 0.61 0.17
## PR_PI_2 4 0.58 -0.55 0.19
## PR_PI_3 3 0.43 -0.86 0.16
## PR_PI_4 4 0.82 -0.07 0.18
## PR_INT 8 0.32 -1.38 0.40
## Q34 0 NaN NaN 0.00
## ANG_1 4 0.30 -0.96 0.20
## ANG_2 4 0.19 -1.16 0.20
## ANG_3 4 0.39 -1.19 0.22
## ANG_4 4 0.39 -0.58 0.19
## ANG_5 4 0.05 -1.04 0.20
## CSA_1 4 -0.05 -1.18 0.21
## CSA_2 3 -0.02 -0.93 0.15
## CSA_3 4 0.43 -1.01 0.21
## CSA_4 4 -0.15 -1.30 0.22
## CSA_5 4 0.52 -1.14 0.23
## CSA_6 3 1.27 0.19 0.17
## CSA_7 4 1.07 0.37 0.19
## CSA_8 4 0.21 -1.09 0.22
## CSA_9 4 0.50 -0.84 0.21
## CSA_10 3 -0.12 -1.07 0.17
## CSA_11 3 1.20 0.50 0.14
## CSA_12 4 0.05 -1.20 0.22
## CSA_13 4 -0.08 -1.15 0.20
## CSA_14 4 0.21 -1.11 0.22
## CSA_15 4 -0.08 -0.97 0.20
## CSA_16 4 0.22 -0.93 0.20
## CSA_17 4 0.01 -1.14 0.21
## CSA_18 4 0.11 -0.74 0.20
## CSA_19 4 0.95 -0.01 0.19
## CSA_20 4 0.54 -0.95 0.20
## CSA_21 4 0.38 -0.91 0.19
## CSA_22 4 0.56 -0.71 0.19
## CSA_23 4 0.52 -0.81 0.20
## CSA_24 4 0.62 -1.02 0.24
## CSA_25 3 0.61 -1.11 0.17
## IEQ_1 2 0.00 -1.35 0.13
## IEQ_2 2 0.18 -0.85 0.11
## IEQ_3 2 -0.05 -1.56 0.14
## IEQ_4 2 0.19 -1.44 0.13
## IEQ_5 2 0.51 -1.00 0.12
## SLESQ_1 1 1.44 0.07 0.07
## SLESQ_2 1 1.67 0.81 0.06
## SLESQ_3 1 5.42 28.17 0.03
## SLESQ_4 1 1.67 0.81 0.06
## SLESQ_5 1 3.65 11.68 0.04
## SLESQ_6 1 1.06 -0.89 0.07
## SLESQ_7 1 0.77 -1.45 0.08
## SLESQ_8 1 1.95 1.88 0.06
## SLESQ_9 1 0.51 -1.79 0.08
## SLESQ_10 1 5.42 28.17 0.03
## SLESQ_11 1 3.65 11.68 0.04
## SLESQ_12 1 2.83 6.21 0.05
## SLESQ_13 1 1.67 0.81 0.06
## OD_1 3 0.53 0.61 0.12
## OD_2 4 1.36 1.97 0.16
## OD_3 3 0.58 0.13 0.13
## PCL5_1 3 0.45 -1.11 0.18
## PCL5_2 4 0.34 -1.17 0.22
## PCL5_3 4 0.61 -0.86 0.23
## PCL5_4 3 0.52 -1.08 0.18
## ESC_1 5 0.12 -1.23 0.25
## ESC_2 5 -0.27 -0.46 0.21
## ESC_3 5 -0.01 -0.69 0.23
## ESC_4 6 -0.15 -0.85 0.28
## ESC_5 5 -0.47 -0.71 0.23
## ESC_6 5 -0.13 -1.00 0.25
## ESC_7 6 0.32 -0.74 0.25
## ESC_8 5 -0.12 -0.91 0.23
## AGE 42 0.13 -1.03 1.89
## GEN 1 0.51 -1.79 0.08
## GEN_8_TEXT* 0 NaN NaN 0.00
## EDU 6 0.51 0.39 0.24
## EDU_11_TEXT* 0 NaN NaN 0.00
## EMP 3 1.18 0.07 0.16
## INS_1 0 NaN NaN 0.00
## INS_2 3 1.76 1.80 0.14
## ETH 17 0.39 -1.62 1.11
## ETH_22_TEXT* 0 NaN NaN 0.00
## ETH_26_TEXT* 0 NaN NaN 0.00
## INC 7 -0.32 -1.10 0.35
## BORN 0 NaN NaN 0.00
## BORN_1* 17 0.02 -1.50 0.92
## BORN_2 1989 -3.65 11.67 78.53
Mean: 810.91 SD: 673.33 Max: 3801 Min: 255
AsianData2_Missingness <-(dplyr::select (AsianData2, SSRPH_1:MHSAS_9, PRE_HELP:GEN, EDU, INS_1, ETH, INC, BORN))
NOTE: Without demographics textboxes
# analyze item level data missingness and patterns
## typically want >80% of data
#Calculating number and proportion of item-level missingness
AsianData2_Missingness$nmiss <- AsianData2_Missingness%>%
dplyr::select(SSRPH_1:BORN) %>% #the colon allows us to include all variables between the two listed (the variables need to be in order)
is.na %>%
rowSums
AsianData2_Missingness <- AsianData2_Missingness%>%
dplyr::mutate(prop_miss = (nmiss/117)*100) #117 is the number of variables included in calculating the proportion.
psych::describe(AsianData2_Missingness$prop_miss)
## vars n mean sd median trimmed mad min max range skew kurtosis se
## X1 1 161 0.65 4.36 0 0.16 0 0 54.7 54.7 11.87 143.9 0.34
across cases that were deemed eligible on the basis of the inclusion/exclusion criteria, missingness ranged from 0% to 54.7%
AsianData2_Missingness <- dplyr::filter(AsianData2_Missingness, prop_miss <= 90)
update df to have only those with at least 90% of complete data. Still have 161 cases
#further update to exclude the n_miss and prop_miss variables since these will mess with our analyses
AsianData2_Missingness <- AsianData2_Missingness %>%
dplyr::select (-c(nmiss, prop_miss))
#what proportion of cells missing across entire dataset
formattable::percent(mean(is.na(AsianData2_Missingness)))
## [1] 0.65%
#what proportion of cases (rows) are complete (nonmissing)
formattable::percent(mean(complete.cases(AsianData2_Missingness)))
## [1] 75.16%
Across cases that were deemed eligible on the basis of the inclusion/exclusion criteria, missingness ranged from 0% to 54.7%. Across the dataset, 0.65% of cells had missing data and 75.16% of cases had nonmissing data.
NOTE: This looks overwhelming, I am thinking there is just too much data?
missing_data_patterns_Asian <- mice::md.pattern(AsianData2_Missingness, plot = TRUE, rotate.names = TRUE)
missing_data_patterns_Asian
## Q34 ANG_1 ANG_2 ANG_3 ANG_4 ANG_5 CSA_1 CSA_2 CSA_3 CSA_4 CSA_5 CSA_6 CSA_7
## 121 1 1 1 1 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 0 0 0 0 0 0 0 0 0 0 0 0 0
## CSA_9 CSA_11 CSA_13 CSA_15 CSA_16 CSA_19 CSA_20 CSA_24 CSA_25 IEQ_1 IEQ_2
## 121 1 1 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 0 0 0 0 0 0 0 0 0 0 0
## IEQ_3 IEQ_5 SLESQ_4 SLESQ_6 SLESQ_7 SLESQ_9 SLESQ_12 SLESQ_13 OD_1 OD_2
## 121 1 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 0 0 0 0 0 0 0 0 0 0
## OD_3 SSRPH_1 SSRPH_4 SSRPH_5 SSOSH_1 SSOSH_2 SSOSH_3 SSOSH_4 SSOSH_5
## 121 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 0 0 0 0 0 0 0 0
## 0 1 1 1 1 1 1 1 1
## SSOSH_6 SSOSH_9 SSOSH_10 MHSAS_1 PRE_HELP PR_PF_2 PR_PF_4 PR_AD_1 PR_AD_2
## 121 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 0 1 1 1 1
## 1 0 0 0 0 1 0 0 0 0
## 1 1 1 1 1 1 1 1 1
## PR_AD_4 PR_AD_6 PR_AD_7 PR_SR_1 PR_SR_2 PR_SR_3 PR_SR_4 PR_PI_1 PR_PI_3
## 121 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 0 0 0 0 0 0 0 0 0
## 1 1 1 1 1 1 1 1 1
## PR_PI_4 PR_INT CSA_8 CSA_10 CSA_12 CSA_14 CSA_18 CSA_21 CSA_22 CSA_23 IEQ_4
## 121 1 1 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 0
## 1 1 1 1 1 1 1 1 1 1 0 1
## 1 1 1 1 1 1 1 1 1 0 1 1
## 1 1 1 1 1 1 1 1 0 1 1 1
## 1 1 1 1 1 1 1 0 1 1 1 1
## 1 1 1 1 1 1 0 1 1 1 1 1
## 1 1 1 1 1 0 1 1 1 1 1 1
## 1 1 1 1 0 1 1 1 1 1 1 1
## 1 1 1 0 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1
## 1 0 0 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## SLESQ_1 SLESQ_2 SLESQ_3 SLESQ_5 SLESQ_8 SLESQ_10 SLESQ_11 PCL5_1 PCL5_2
## 121 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 0 1 1 1
## 1 1 1 1 0 0 1 0 1 1
## 1 0 0 0 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 0 0
## 1 1 1 1 1 1 1 1 1
## PCL5_3 PCL5_4 ESC_1 ESC_2 ESC_3 ESC_4 ESC_5 ESC_6 ESC_7 ESC_8 GEN EDU INS_1
## 121 1 1 1 1 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 0 0 0 0 0 0 0 0 0 0 0 0 0
## 1 1 1 1 1 1 1 1 1 1 1 1 1
## INC BORN SSRPH_2 SSRPH_3 SSOSH_7 SSOSH_8 MHSAS_2 MHSAS_4 MHSAS_5 MHSAS_6
## 121 1 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 0 0 0 0
## 1 1 1 1 1 1 0 1 1 1 1
## 1 1 1 1 0 1 1 1 1 1 1
## 1 1 1 0 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 0 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 0 0 0 0 0 0 0 0 0 0
## 1 1 2 2 2 2 2 2 2 2
## MHSAS_7 MHSAS_8 MHSAS_9 PR_PF_1 PR_PF_3 PR_AD_3 PR_AD_8 PR_PI_2 CSA_17 AGE
## 121 1 1 1 1 1 1 1 1 1 1
## 15 1 1 1 1 1 1 1 1 1 1
## 2 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 0
## 1 1 1 1 1 1 1 1 1 0 1
## 1 1 1 1 1 1 1 0 1 1 1
## 1 1 1 1 1 0 1 1 1 1 1
## 1 0 0 0 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 0 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 0 1 0 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 0 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1
## 1 0 0 0 0 0 0 0 0 1 0
## 2 2 2 2 2 2 2 2 2 2
## MHSAS_3 PR_AD_5 ETH
## 121 1 1 1 0
## 15 1 1 0 1
## 2 1 0 1 1
## 1 0 1 1 1
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 1
## 1 0 1 1 8
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 2
## 1 1 1 0 2
## 1 1 1 0 5
## 1 1 1 0 4
## 1 1 1 1 3
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 1
## 1 1 1 1 2
## 1 1 1 1 1
## 1 1 1 1 1
## 1 0 0 0 64
## 3 3 19 122
write.csv (missing_data_patterns_Asian, file="missing_data_patterns_Asian.csv") #optional to write it to a .csv file
#scroll to the bottom of r console, a lot easier to see the patterns.
#WE DON'T NEED THIS CODE, but may be helpful for us in the future
#AsianData2$SSOSH_2 <- car::recode(AsianData2$SSOSH_2, "7=5")
#*SSOSH (scale 5 point, range 1-5)
AsianData2<- AsianData2 %>%
dplyr::mutate(SSOSH_2r = 6 - SSOSH_2) %>%
dplyr::mutate(SSOSH_4r = 6 - SSOSH_4) %>%
dplyr::mutate(SSOSH_5r = 6 - SSOSH_5) %>%
dplyr::mutate(SSOSH_7r = 6 - SSOSH_7) %>%
dplyr::mutate(SSOSH_9r = 6 - SSOSH_9)
AsianData2<- AsianData2 %>%
dplyr::mutate(MHSAS_2r = 8 - MHSAS_2) %>%
dplyr::mutate(MHSAS_5r = 8 - MHSAS_5) %>%
dplyr::mutate(MHSAS_6r = 8 - MHSAS_6) %>%
dplyr::mutate(MHSAS_8r = 8 - MHSAS_8) %>%
dplyr::mutate(MHSAS_9r = 8 - MHSAS_9)
#Emotional Self Control
AsianData2<- AsianData2 %>%
dplyr::mutate(ESC_1r = 8 - ESC_1) %>%
dplyr::mutate(ESC_2r = 8 - ESC_2) %>%
dplyr::mutate(ESC_3r = 8 - ESC_3)
#8-esc-1, create a new column with new object names
#if you had multiple items, you could add a pipe (%>%) at the end of the line and add more until the last one #R IN FRONT TO SHOW REVERSE CODE
#pay attention to what was reverse coded
SSRPH <- c('SSRPH_1','SSRPH_2','SSRPH_3','SSRPH_4','SSRPH_5')
SSOSH <- c('SSOSH_1','SSOSH_2r','SSOSH_3','SSOSH_4r','SSOSH_5r','SSOSH_6','SSOSH_7r','SSOSH_8','SSOSH_9r','SSOSH_10')
MHSAS <- c('MHSAS_1','MHSAS_2r','MHSAS_3','MHSAS_4','MHSAS_5r','MHSAS_6r','MHSAS_7','MHSAS_8r','MHSAS_9r')
PR_PF <- c('PR_PF_1','PR_PF_2','PR_PF_3','PR_PF_4')
#Anxiety
PR_A <- c('PR_AD_1','PR_AD_2','PR_AD_3','PR_AD_4')
#Depression
PR_D <- c('PR_AD_5','PR_AD_6','PR_AD_7','PR_AD_8')
PR_SR <- c('PR_SR_1','PR_SR_2','PR_SR_3','PR_SR_4')
PR_PI <- c('PR_PI_1','PR_PI_2','PR_PI_3','PR_PI_4')
#PROMIS Total
PR_TOTAL <- c('PR_PF_1','PR_PF_2','PR_PF_3','PR_PF_4','PR_AD_1','PR_AD_2','PR_AD_3','PR_AD_4','PR_AD_5','PR_AD_6','PR_AD_7','PR_AD_8','PR_SR_1','PR_SR_2','PR_SR_3','PR_SR_4','PR_PI_1','PR_PI_2','PR_PI_3','PR_PIR_4')
ANG <- c('ANG_1','ANG_2','ANG_3','ANG_4', 'ANG_5')
CSA <- c('CSA_1','CSA_2','CSA_3','CSA_4','CSA_5','CSA_6','CSA_7','CSA_8','CSA_9','CSA_10','CSA_11','CSA_12','CSA_13','CSA_14','CSA_15','CSA_16','CSA_17','CSA_18','CSA_19','CSA_20','CSA_21','CSA_22','CSA_23','CSA_24','CSA_25')
IEQ <- c('IEQ_1','IEQ_2','IEQ_3','IEQ_4', 'IEQ_5')
SLESQ <- c('SLESQ_1','SLESQ_2','SLESQ_3','SLESQ_4','SLESQ_5','SLESQ_6','SLESQ_7','SLESQ_8','SLESQ_9', 'SLESQ_10','SLESQ_11','SLESQ_12','SLESQ_13')
OD <- c('OD_1','OD_2','OD_3')
PCL5 <- c('PCL5_1','PCL5_2','PCL5_3','PCL5_4')
# we won't keep this, change with esc (emotional self control)
#Need to reverse score item ESC 1, 3, 6, 8, 10
ESC <- c('ESC_1r', 'ESC_2r','ESC_3r','ESC_4','ESC_5','ESC_6','ESC_7','ESC_8')
#create new variables #80% of items should be present to get the mean
AsianData2$SSRPH <- mean_n(AsianData2[,SSRPH], .80)
AsianData2$SSOSH <- mean_n(AsianData2[,SSOSH], .80)
AsianData2$MHSAS <- mean_n(AsianData2[,MHSAS], .80)
AsianData2$PR_PF <- mean_n(AsianData2[,PR_PF], .80)
AsianData2$PR_A <- mean_n(AsianData2[,PR_A], .80)
AsianData2$PR_D <- mean_n(AsianData2[,PR_D], .80)
AsianData2$PR_SR <- mean_n(AsianData2[,PR_SR], .80)
AsianData2$PR_PI <- mean_n(AsianData2[,PR_PI], .80)
AsianData2$ANG <- mean_n(AsianData2[,ANG], .80)
AsianData2$CSA <- mean_n(AsianData2[,CSA], .80)
AsianData2$IEQ <- mean_n(AsianData2[,IEQ], .80)
AsianData2$SLESQ <- mean_n(AsianData2[,SLESQ], .80)
AsianData2$OD <- mean_n(AsianData2[,OD], .80)
AsianData2$PCL5 <- mean_n(AsianData2[,PCL5], .80)
AsianData2$ESC <- mean_n(AsianData2[,ESC], .80)
psych::alpha(AsianData2[c('SSRPH_1','SSRPH_2','SSRPH_3','SSRPH_4','SSRPH_5')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("SSRPH_1", "SSRPH_2", "SSRPH_3",
## "SSRPH_4", "SSRPH_5")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.79 0.79 0.78 0.43 3.8 0.026 2.2 0.59 0.51
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.74 0.79 0.84
## Duhachek 0.74 0.79 0.84
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## SSRPH_1 0.80 0.80 0.76 0.49 3.9 0.026 0.0049 0.51
## SSRPH_2 0.77 0.77 0.74 0.46 3.4 0.029 0.0121 0.51
## SSRPH_3 0.70 0.70 0.66 0.37 2.3 0.038 0.0144 0.35
## SSRPH_4 0.74 0.74 0.72 0.42 2.9 0.033 0.0194 0.44
## SSRPH_5 0.75 0.75 0.72 0.43 3.0 0.032 0.0195 0.51
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## SSRPH_1 160 0.64 0.64 0.51 0.43 2.7 0.78
## SSRPH_2 159 0.71 0.70 0.60 0.52 1.8 0.80
## SSRPH_3 159 0.84 0.84 0.82 0.73 2.3 0.81
## SSRPH_4 160 0.76 0.76 0.68 0.61 2.1 0.82
## SSRPH_5 160 0.75 0.75 0.66 0.59 2.2 0.79
##
## Non missing response frequency for each item
## 1 2 3 4 miss
## SSRPH_1 0.07 0.27 0.53 0.13 0.01
## SSRPH_2 0.42 0.39 0.16 0.03 0.01
## SSRPH_3 0.17 0.43 0.35 0.06 0.01
## SSRPH_4 0.24 0.44 0.27 0.04 0.01
## SSRPH_5 0.19 0.49 0.28 0.04 0.01
psych::alpha(AsianData2[c('SSOSH_1','SSOSH_2r','SSOSH_3','SSOSH_4r','SSOSH_5r','SSOSH_6','SSOSH_7r','SSOSH_8','SSOSH_9r','SSOSH_10')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("SSOSH_1", "SSOSH_2r", "SSOSH_3",
## "SSOSH_4r", "SSOSH_5r", "SSOSH_6", "SSOSH_7r", "SSOSH_8",
## "SSOSH_9r", "SSOSH_10")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.89 0.89 0.9 0.45 8.3 0.013 2.3 0.8 0.41
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.86 0.89 0.91
## Duhachek 0.87 0.89 0.92
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## SSOSH_1 0.87 0.87 0.88 0.43 6.8 0.015 0.019 0.40
## SSOSH_2r 0.89 0.89 0.90 0.48 8.2 0.013 0.023 0.44
## SSOSH_3 0.87 0.87 0.88 0.44 7.0 0.015 0.020 0.40
## SSOSH_4r 0.89 0.89 0.90 0.48 8.3 0.013 0.019 0.42
## SSOSH_5r 0.89 0.89 0.89 0.47 7.9 0.013 0.025 0.42
## SSOSH_6 0.87 0.87 0.88 0.43 6.7 0.016 0.018 0.40
## SSOSH_7r 0.87 0.88 0.88 0.44 7.0 0.015 0.024 0.40
## SSOSH_8 0.87 0.87 0.88 0.43 6.8 0.015 0.020 0.40
## SSOSH_9r 0.89 0.89 0.90 0.48 8.3 0.013 0.022 0.43
## SSOSH_10 0.88 0.88 0.89 0.46 7.7 0.013 0.025 0.41
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## SSOSH_1 160 0.82 0.82 0.81 0.76 2.2 1.15
## SSOSH_2r 160 0.61 0.59 0.52 0.49 2.4 1.25
## SSOSH_3 160 0.78 0.79 0.78 0.73 1.9 1.08
## SSOSH_4r 160 0.55 0.57 0.50 0.46 2.5 0.96
## SSOSH_5r 160 0.64 0.64 0.58 0.55 2.6 1.09
## SSOSH_6 160 0.85 0.85 0.85 0.80 2.1 1.18
## SSOSH_7r 159 0.78 0.79 0.77 0.72 2.0 1.01
## SSOSH_8 159 0.83 0.83 0.83 0.78 2.0 1.09
## SSOSH_9r 160 0.58 0.58 0.51 0.48 2.7 1.12
## SSOSH_10 160 0.68 0.67 0.62 0.58 2.7 1.29
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## SSOSH_1 0.35 0.33 0.13 0.16 0.03 0.01
## SSOSH_2r 0.24 0.40 0.11 0.16 0.08 0.01
## SSOSH_3 0.46 0.35 0.07 0.09 0.03 0.01
## SSOSH_4r 0.13 0.37 0.36 0.11 0.03 0.01
## SSOSH_5r 0.17 0.32 0.25 0.22 0.03 0.01
## SSOSH_6 0.41 0.24 0.17 0.15 0.03 0.01
## SSOSH_7r 0.38 0.38 0.15 0.06 0.03 0.01
## SSOSH_8 0.40 0.34 0.14 0.09 0.03 0.01
## SSOSH_9r 0.16 0.29 0.31 0.19 0.06 0.01
## SSOSH_10 0.22 0.27 0.14 0.30 0.07 0.01
psych::alpha(AsianData2[c('MHSAS_1','MHSAS_2r','MHSAS_3','MHSAS_4','MHSAS_5r','MHSAS_6r','MHSAS_7','MHSAS_8r','MHSAS_9r')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("MHSAS_1", "MHSAS_2r", "MHSAS_3",
## "MHSAS_4", "MHSAS_5r", "MHSAS_6r", "MHSAS_7", "MHSAS_8r",
## "MHSAS_9r")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.93 0.94 0.94 0.62 15 0.0077 5.6 1.2 0.62
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.92 0.93 0.95
## Duhachek 0.92 0.93 0.95
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## MHSAS_1 0.93 0.93 0.93 0.62 13 0.0088 0.0054 0.62
## MHSAS_2r 0.93 0.93 0.93 0.63 13 0.0084 0.0041 0.63
## MHSAS_3 0.93 0.93 0.94 0.63 14 0.0084 0.0055 0.64
## MHSAS_4 0.93 0.93 0.93 0.62 13 0.0088 0.0048 0.62
## MHSAS_5r 0.92 0.93 0.93 0.61 13 0.0090 0.0053 0.60
## MHSAS_6r 0.92 0.93 0.93 0.61 13 0.0089 0.0056 0.60
## MHSAS_7 0.93 0.93 0.94 0.63 14 0.0081 0.0046 0.64
## MHSAS_8r 0.93 0.93 0.93 0.62 13 0.0089 0.0050 0.60
## MHSAS_9r 0.93 0.93 0.93 0.62 13 0.0088 0.0052 0.62
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## MHSAS_1 160 0.83 0.83 0.81 0.78 5.9 1.5
## MHSAS_2r 159 0.79 0.79 0.76 0.72 5.6 1.6
## MHSAS_3 158 0.77 0.78 0.75 0.72 6.2 1.1
## MHSAS_4 159 0.83 0.83 0.81 0.77 5.5 1.4
## MHSAS_5r 159 0.85 0.85 0.83 0.80 5.9 1.4
## MHSAS_6r 159 0.84 0.84 0.82 0.79 5.6 1.4
## MHSAS_7 159 0.76 0.76 0.72 0.69 5.3 1.6
## MHSAS_8r 159 0.83 0.82 0.81 0.78 5.0 1.6
## MHSAS_9r 159 0.83 0.82 0.80 0.77 5.3 1.6
##
## Non missing response frequency for each item
## 1 2 3 4 5 6 7 miss
## MHSAS_1 0.03 0.03 0.03 0.04 0.12 0.31 0.44 0.01
## MHSAS_2r 0.04 0.04 0.05 0.06 0.14 0.28 0.40 0.01
## MHSAS_3 0.01 0.01 0.03 0.03 0.11 0.28 0.54 0.02
## MHSAS_4 0.02 0.04 0.03 0.10 0.23 0.30 0.28 0.01
## MHSAS_5r 0.02 0.02 0.04 0.06 0.15 0.26 0.45 0.01
## MHSAS_6r 0.03 0.01 0.05 0.12 0.22 0.26 0.32 0.01
## MHSAS_7 0.03 0.04 0.06 0.13 0.19 0.22 0.31 0.01
## MHSAS_8r 0.04 0.02 0.09 0.25 0.16 0.23 0.21 0.01
## MHSAS_9r 0.03 0.03 0.08 0.19 0.18 0.18 0.31 0.01
psych::alpha(AsianData2[c('PR_PF_1','PR_PF_2','PR_PF_3','PR_PF_4')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("PR_PF_1", "PR_PF_2", "PR_PF_3",
## "PR_PF_4")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.84 0.84 0.82 0.57 5.2 0.02 4.5 0.68 0.53
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.8 0.84 0.88
## Duhachek 0.8 0.84 0.88
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## PR_PF_1 0.78 0.77 0.72 0.53 3.4 0.030 0.0167 0.51
## PR_PF_2 0.85 0.85 0.81 0.66 5.7 0.020 0.0122 0.67
## PR_PF_3 0.81 0.81 0.77 0.59 4.3 0.025 0.0220 0.51
## PR_PF_4 0.73 0.74 0.66 0.48 2.8 0.035 0.0039 0.49
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## PR_PF_1 159 0.87 0.85 0.80 0.73 4.3 0.95
## PR_PF_2 160 0.72 0.74 0.58 0.54 4.6 0.75
## PR_PF_3 159 0.79 0.80 0.70 0.64 4.6 0.75
## PR_PF_4 160 0.90 0.90 0.88 0.81 4.5 0.86
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## PR_PF_1 0.01 0.04 0.17 0.20 0.58 0.01
## PR_PF_2 0.01 0.01 0.09 0.14 0.75 0.01
## PR_PF_3 0.00 0.03 0.07 0.16 0.74 0.01
## PR_PF_4 0.00 0.04 0.13 0.16 0.68 0.01
psych::alpha(AsianData2[c('PR_AD_1','PR_AD_2','PR_AD_3','PR_AD_4')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("PR_AD_1", "PR_AD_2", "PR_AD_3",
## "PR_AD_4")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.89 0.89 0.87 0.67 8.2 0.014 2.6 0.94 0.68
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.86 0.89 0.92
## Duhachek 0.87 0.89 0.92
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## PR_AD_1 0.90 0.90 0.86 0.75 9.1 0.014 0.0038 0.72
## PR_AD_2 0.83 0.83 0.77 0.62 4.9 0.023 0.0069 0.57
## PR_AD_3 0.84 0.84 0.79 0.64 5.4 0.021 0.0053 0.64
## PR_AD_4 0.86 0.86 0.83 0.68 6.3 0.019 0.0167 0.64
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## PR_AD_1 160 0.80 0.80 0.68 0.65 2.3 1.0
## PR_AD_2 160 0.92 0.91 0.90 0.84 2.6 1.1
## PR_AD_3 159 0.91 0.89 0.87 0.81 2.7 1.1
## PR_AD_4 160 0.86 0.86 0.79 0.76 2.7 1.0
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## PR_AD_1 0.26 0.36 0.28 0.09 0.02 0.01
## PR_AD_2 0.19 0.31 0.29 0.16 0.04 0.01
## PR_AD_3 0.19 0.25 0.34 0.17 0.06 0.01
## PR_AD_4 0.13 0.28 0.35 0.20 0.04 0.01
psych::alpha(AsianData2[c('PR_AD_5','PR_AD_6','PR_AD_7','PR_AD_8')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("PR_AD_5", "PR_AD_6", "PR_AD_7",
## "PR_AD_8")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.94 0.94 0.93 0.8 16 0.0076 2.6 1.1 0.8
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.92 0.94 0.95
## Duhachek 0.93 0.94 0.96
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## PR_AD_5 0.93 0.93 0.90 0.82 13.3 0.0096 0.0022 0.82
## PR_AD_6 0.92 0.92 0.89 0.80 11.7 0.0107 0.0012 0.81
## PR_AD_7 0.93 0.93 0.90 0.82 13.4 0.0095 0.0018 0.81
## PR_AD_8 0.91 0.91 0.87 0.77 9.9 0.0126 0.0001 0.77
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## PR_AD_5 158 0.91 0.91 0.86 0.84 2.6 1.2
## PR_AD_6 160 0.92 0.92 0.89 0.86 2.6 1.1
## PR_AD_7 160 0.91 0.91 0.86 0.83 2.8 1.2
## PR_AD_8 159 0.95 0.95 0.94 0.90 2.6 1.3
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## PR_AD_5 0.23 0.25 0.33 0.13 0.07 0.02
## PR_AD_6 0.21 0.29 0.31 0.14 0.06 0.01
## PR_AD_7 0.16 0.24 0.28 0.22 0.10 0.01
## PR_AD_8 0.25 0.28 0.21 0.16 0.09 0.01
psych::alpha(AsianData2[c('PR_SR_1','PR_SR_2','PR_SR_3','PR_SR_4')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("PR_SR_1", "PR_SR_2", "PR_SR_3",
## "PR_SR_4")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.93 0.93 0.91 0.76 13 0.0093 3.6 1.1 0.77
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.91 0.93 0.94
## Duhachek 0.91 0.93 0.95
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## PR_SR_1 0.91 0.91 0.88 0.77 9.9 0.013 0.00466 0.76
## PR_SR_2 0.90 0.90 0.86 0.76 9.3 0.013 0.00131 0.76
## PR_SR_3 0.92 0.92 0.89 0.80 12.2 0.010 0.00088 0.79
## PR_SR_4 0.89 0.89 0.85 0.73 8.3 0.015 0.00195 0.72
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## PR_SR_1 160 0.90 0.91 0.86 0.83 3.6 1.1
## PR_SR_2 160 0.92 0.91 0.88 0.85 3.6 1.2
## PR_SR_3 160 0.87 0.88 0.81 0.78 3.5 1.1
## PR_SR_4 160 0.93 0.93 0.91 0.88 3.5 1.2
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## PR_SR_1 0.04 0.11 0.26 0.32 0.26 0.01
## PR_SR_2 0.06 0.15 0.23 0.27 0.29 0.01
## PR_SR_3 0.06 0.13 0.26 0.32 0.23 0.01
## PR_SR_4 0.06 0.12 0.29 0.28 0.24 0.01
psych::alpha(AsianData2[c('PR_PI_1','PR_PI_2','PR_PI_3','PR_PI_4')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("PR_PI_1", "PR_PI_2", "PR_PI_3",
## "PR_PI_4")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.93 0.93 0.92 0.78 14 0.0086 2 0.98 0.77
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.92 0.93 0.95
## Duhachek 0.92 0.93 0.95
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## PR_PI_1 0.91 0.91 0.89 0.78 10.5 0.0123 0.00657 0.74
## PR_PI_2 0.90 0.90 0.86 0.75 9.1 0.0136 0.00087 0.76
## PR_PI_3 0.93 0.93 0.91 0.82 13.4 0.0096 0.00301 0.82
## PR_PI_4 0.91 0.91 0.88 0.78 10.6 0.0119 0.00144 0.78
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## PR_PI_1 160 0.92 0.92 0.88 0.85 2.1 1.0
## PR_PI_2 159 0.95 0.94 0.93 0.89 2.0 1.1
## PR_PI_3 160 0.89 0.89 0.82 0.80 2.0 1.1
## PR_PI_4 160 0.91 0.92 0.89 0.85 2.0 1.1
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## PR_PI_1 0.33 0.39 0.17 0.06 0.04 0.01
## PR_PI_2 0.42 0.29 0.19 0.08 0.02 0.01
## PR_PI_3 0.45 0.27 0.17 0.09 0.03 0.01
## PR_PI_4 0.42 0.31 0.17 0.07 0.03 0.01
#PROMIS Total
psych::alpha(AsianData2[c('PR_PF_1','PR_PF_2','PR_PF_3','PR_PF_4','PR_AD_1','PR_AD_2','PR_AD_3','PR_AD_4','PR_AD_5','PR_AD_6','PR_AD_7','PR_AD_8','PR_SR_1','PR_SR_2','PR_SR_3','PR_SR_4','PR_PI_1','PR_PI_2','PR_PI_3','PR_PI_4')])
## Warning in psych::alpha(AsianData2[c("PR_PF_1", "PR_PF_2", "PR_PF_3", "PR_PF_4", : Some items were negatively correlated with the first principal component and probably
## should be reversed.
## To do this, run the function again with the 'check.keys=TRUE' option
## Some items ( PR_PF_1 PR_PF_2 PR_PF_3 PR_PF_4 PR_SR_1 PR_SR_2 PR_SR_3 PR_SR_4 ) were negatively correlated with the first principal component and
## probably should be reversed.
## To do this, run the function again with the 'check.keys=TRUE' option
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("PR_PF_1", "PR_PF_2", "PR_PF_3",
## "PR_PF_4", "PR_AD_1", "PR_AD_2", "PR_AD_3", "PR_AD_4", "PR_AD_5",
## "PR_AD_6", "PR_AD_7", "PR_AD_8", "PR_SR_1", "PR_SR_2", "PR_SR_3",
## "PR_SR_4", "PR_PI_1", "PR_PI_2", "PR_PI_3", "PR_PI_4")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.58 0.54 0.86 0.056 1.2 0.046 3.1 0.36 -0.12
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.48 0.58 0.67
## Duhachek 0.49 0.58 0.67
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## PR_PF_1 0.61 0.58 0.87 0.067 1.36 0.040 0.27 0.31
## PR_PF_2 0.60 0.58 0.88 0.067 1.37 0.042 0.28 0.32
## PR_PF_3 0.59 0.56 0.87 0.064 1.30 0.043 0.28 0.31
## PR_PF_4 0.60 0.56 0.86 0.064 1.29 0.041 0.27 0.31
## PR_AD_1 0.52 0.48 0.85 0.046 0.92 0.054 0.27 -0.20
## PR_AD_2 0.50 0.47 0.84 0.045 0.89 0.057 0.26 -0.15
## PR_AD_3 0.49 0.46 0.84 0.043 0.85 0.057 0.27 -0.16
## PR_AD_4 0.50 0.47 0.85 0.044 0.88 0.056 0.27 -0.15
## PR_AD_5 0.49 0.46 0.84 0.043 0.86 0.058 0.26 -0.15
## PR_AD_6 0.48 0.45 0.83 0.042 0.83 0.058 0.26 -0.15
## PR_AD_7 0.50 0.47 0.84 0.044 0.88 0.058 0.26 -0.15
## PR_AD_8 0.47 0.45 0.83 0.041 0.81 0.061 0.26 -0.15
## PR_SR_1 0.66 0.62 0.88 0.080 1.66 0.035 0.26 0.32
## PR_SR_2 0.65 0.61 0.88 0.076 1.56 0.034 0.26 0.31
## PR_SR_3 0.65 0.61 0.88 0.076 1.56 0.035 0.26 0.31
## PR_SR_4 0.66 0.62 0.88 0.078 1.61 0.034 0.26 0.31
## PR_PI_1 0.53 0.49 0.85 0.049 0.98 0.053 0.27 -0.15
## PR_PI_2 0.53 0.50 0.84 0.049 0.98 0.053 0.27 -0.15
## PR_PI_3 0.53 0.50 0.85 0.050 1.01 0.052 0.27 -0.15
## PR_PI_4 0.54 0.51 0.85 0.052 1.05 0.052 0.27 -0.15
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## PR_PF_1 159 -0.055 0.036 -0.016 -0.181 4.3 0.95
## PR_PF_2 160 -0.074 0.025 -0.073 -0.171 4.6 0.75
## PR_PF_3 159 0.013 0.110 0.041 -0.088 4.6 0.75
## PR_PF_4 160 0.023 0.120 0.083 -0.096 4.5 0.86
## PR_AD_1 160 0.610 0.588 0.553 0.504 2.3 1.01
## PR_AD_2 160 0.672 0.622 0.636 0.573 2.6 1.11
## PR_AD_3 159 0.707 0.670 0.680 0.608 2.7 1.14
## PR_AD_4 160 0.673 0.639 0.626 0.581 2.7 1.04
## PR_AD_5 158 0.713 0.665 0.674 0.616 2.6 1.18
## PR_AD_6 160 0.741 0.694 0.715 0.652 2.6 1.15
## PR_AD_7 160 0.678 0.634 0.643 0.569 2.8 1.22
## PR_AD_8 159 0.771 0.729 0.758 0.687 2.6 1.29
## PR_SR_1 160 -0.363 -0.321 -0.386 -0.483 3.6 1.11
## PR_SR_2 160 -0.253 -0.206 -0.262 -0.399 3.6 1.21
## PR_SR_3 160 -0.268 -0.212 -0.278 -0.403 3.5 1.15
## PR_SR_4 160 -0.314 -0.265 -0.316 -0.447 3.5 1.15
## PR_PI_1 160 0.551 0.507 0.509 0.430 2.1 1.05
## PR_PI_2 159 0.559 0.504 0.515 0.439 2.0 1.06
## PR_PI_3 160 0.516 0.469 0.453 0.383 2.0 1.10
## PR_PI_4 160 0.479 0.418 0.417 0.350 2.0 1.06
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## PR_PF_1 0.01 0.04 0.17 0.20 0.58 0.01
## PR_PF_2 0.01 0.01 0.09 0.14 0.75 0.01
## PR_PF_3 0.00 0.03 0.07 0.16 0.74 0.01
## PR_PF_4 0.00 0.04 0.13 0.16 0.68 0.01
## PR_AD_1 0.26 0.36 0.28 0.09 0.02 0.01
## PR_AD_2 0.19 0.31 0.29 0.16 0.04 0.01
## PR_AD_3 0.19 0.25 0.34 0.17 0.06 0.01
## PR_AD_4 0.13 0.28 0.35 0.20 0.04 0.01
## PR_AD_5 0.23 0.25 0.33 0.13 0.07 0.02
## PR_AD_6 0.21 0.29 0.31 0.14 0.06 0.01
## PR_AD_7 0.16 0.24 0.28 0.22 0.10 0.01
## PR_AD_8 0.25 0.28 0.21 0.16 0.09 0.01
## PR_SR_1 0.04 0.11 0.26 0.32 0.26 0.01
## PR_SR_2 0.06 0.15 0.23 0.27 0.29 0.01
## PR_SR_3 0.06 0.13 0.26 0.32 0.23 0.01
## PR_SR_4 0.06 0.12 0.29 0.28 0.24 0.01
## PR_PI_1 0.33 0.39 0.17 0.06 0.04 0.01
## PR_PI_2 0.42 0.29 0.19 0.08 0.02 0.01
## PR_PI_3 0.45 0.27 0.17 0.09 0.03 0.01
## PR_PI_4 0.42 0.31 0.17 0.07 0.03 0.01
psych::alpha(AsianData2[c('ANG_1','ANG_2','ANG_3','ANG_4', 'ANG_5')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("ANG_1", "ANG_2", "ANG_3", "ANG_4",
## "ANG_5")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.92 0.92 0.91 0.69 11 0.011 2.7 0.98 0.67
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.89 0.92 0.93
## Duhachek 0.89 0.92 0.94
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## ANG_1 0.91 0.91 0.90 0.71 9.9 0.012 0.0054 0.69
## ANG_2 0.89 0.89 0.87 0.67 8.2 0.015 0.0051 0.67
## ANG_3 0.90 0.90 0.88 0.70 9.4 0.013 0.0023 0.68
## ANG_4 0.90 0.90 0.88 0.69 8.9 0.013 0.0053 0.68
## ANG_5 0.89 0.89 0.87 0.67 8.1 0.015 0.0058 0.67
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## ANG_1 161 0.84 0.83 0.77 0.74 2.9 1.2
## ANG_2 161 0.89 0.89 0.87 0.83 2.5 1.1
## ANG_3 161 0.85 0.85 0.81 0.76 2.2 1.2
## ANG_4 161 0.87 0.87 0.83 0.78 2.7 1.2
## ANG_5 161 0.89 0.89 0.86 0.83 3.0 1.0
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## ANG_1 0.16 0.20 0.34 0.22 0.09 0
## ANG_2 0.22 0.26 0.35 0.12 0.04 0
## ANG_3 0.39 0.25 0.22 0.09 0.06 0
## ANG_4 0.17 0.25 0.34 0.17 0.07 0
## ANG_5 0.09 0.19 0.40 0.25 0.07 0
psych::alpha(AsianData2[c('CSA_1','CSA_2','CSA_3','CSA_4','CSA_5','CSA_6','CSA_7','CSA_8','CSA_9','CSA_10','CSA_11','CSA_12','CSA_13','CSA_14','CSA_15','CSA_16','CSA_17','CSA_18','CSA_19','CSA_20','CSA_21','CSA_22','CSA_23','CSA_24','CSA_25')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("CSA_1", "CSA_2", "CSA_3", "CSA_4",
## "CSA_5", "CSA_6", "CSA_7", "CSA_8", "CSA_9", "CSA_10", "CSA_11",
## "CSA_12", "CSA_13", "CSA_14", "CSA_15", "CSA_16", "CSA_17",
## "CSA_18", "CSA_19", "CSA_20", "CSA_21", "CSA_22", "CSA_23",
## "CSA_24", "CSA_25")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.94 0.94 0.95 0.38 15 0.0069 1.6 0.72 0.39
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.92 0.94 0.95
## Duhachek 0.92 0.94 0.95
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## CSA_1 0.94 0.94 0.95 0.38 15 0.0071 0.0095 0.39
## CSA_2 0.94 0.93 0.95 0.37 14 0.0073 0.0103 0.38
## CSA_3 0.93 0.93 0.95 0.37 14 0.0073 0.0108 0.38
## CSA_4 0.94 0.94 0.95 0.38 15 0.0072 0.0108 0.39
## CSA_5 0.94 0.94 0.95 0.38 15 0.0071 0.0109 0.39
## CSA_6 0.94 0.94 0.95 0.38 15 0.0071 0.0107 0.39
## CSA_7 0.94 0.94 0.95 0.38 15 0.0072 0.0110 0.39
## CSA_8 0.93 0.93 0.95 0.37 14 0.0073 0.0099 0.38
## CSA_9 0.94 0.93 0.95 0.37 14 0.0073 0.0107 0.38
## CSA_10 0.94 0.94 0.95 0.38 14 0.0072 0.0110 0.38
## CSA_11 0.94 0.94 0.95 0.39 15 0.0070 0.0087 0.39
## CSA_12 0.94 0.94 0.95 0.38 15 0.0072 0.0102 0.38
## CSA_13 0.93 0.93 0.95 0.37 14 0.0073 0.0104 0.38
## CSA_14 0.94 0.94 0.95 0.38 15 0.0072 0.0108 0.39
## CSA_15 0.94 0.94 0.95 0.37 14 0.0073 0.0105 0.38
## CSA_16 0.93 0.93 0.95 0.37 14 0.0074 0.0101 0.38
## CSA_17 0.93 0.93 0.95 0.37 14 0.0074 0.0096 0.38
## CSA_18 0.93 0.93 0.95 0.37 14 0.0073 0.0102 0.38
## CSA_19 0.94 0.94 0.95 0.38 15 0.0071 0.0105 0.39
## CSA_20 0.94 0.94 0.95 0.38 14 0.0072 0.0109 0.38
## CSA_21 0.94 0.94 0.95 0.39 15 0.0070 0.0101 0.39
## CSA_22 0.94 0.94 0.95 0.38 15 0.0072 0.0111 0.39
## CSA_23 0.94 0.94 0.95 0.37 14 0.0072 0.0108 0.38
## CSA_24 0.94 0.94 0.95 0.38 15 0.0072 0.0109 0.39
## CSA_25 0.94 0.94 0.95 0.38 15 0.0071 0.0104 0.39
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## CSA_1 161 0.55 0.54 0.52 0.51 2.29 1.06
## CSA_2 161 0.68 0.68 0.67 0.65 2.20 1.05
## CSA_3 161 0.69 0.69 0.68 0.65 1.42 1.19
## CSA_4 161 0.65 0.64 0.63 0.60 1.59 1.29
## CSA_5 161 0.58 0.58 0.56 0.54 1.40 1.20
## CSA_6 161 0.59 0.60 0.58 0.56 0.74 0.88
## CSA_7 161 0.63 0.63 0.60 0.59 1.15 1.21
## CSA_8 160 0.71 0.70 0.69 0.67 1.97 1.18
## CSA_9 161 0.68 0.68 0.67 0.64 1.38 1.15
## CSA_10 160 0.66 0.66 0.64 0.61 1.60 1.04
## CSA_11 161 0.41 0.43 0.40 0.37 0.53 0.79
## CSA_12 160 0.65 0.64 0.62 0.60 2.13 1.29
## CSA_13 161 0.69 0.69 0.69 0.66 1.91 1.14
## CSA_14 160 0.62 0.62 0.60 0.58 1.76 1.30
## CSA_15 161 0.69 0.68 0.66 0.65 2.27 1.21
## CSA_16 161 0.74 0.74 0.74 0.71 1.96 1.15
## CSA_17 159 0.76 0.75 0.74 0.72 2.23 1.12
## CSA_18 160 0.69 0.68 0.67 0.65 2.00 1.26
## CSA_19 161 0.60 0.60 0.59 0.56 0.93 1.09
## CSA_20 161 0.66 0.66 0.65 0.62 1.27 1.16
## CSA_21 160 0.48 0.49 0.46 0.43 1.29 1.09
## CSA_22 160 0.62 0.63 0.61 0.58 1.24 1.12
## CSA_23 160 0.67 0.68 0.66 0.64 1.63 1.03
## CSA_24 161 0.63 0.63 0.61 0.58 1.50 1.30
## CSA_25 161 0.53 0.55 0.53 0.49 0.65 0.90
##
## Non missing response frequency for each item
## 0 1 2 3 4 miss
## CSA_1 0.04 0.21 0.31 0.31 0.13 0.00
## CSA_2 0.06 0.18 0.39 0.25 0.12 0.00
## CSA_3 0.27 0.29 0.25 0.12 0.06 0.00
## CSA_4 0.26 0.24 0.24 0.17 0.09 0.00
## CSA_5 0.28 0.29 0.23 0.14 0.06 0.00
## CSA_6 0.52 0.27 0.18 0.04 0.00 0.00
## CSA_7 0.40 0.27 0.18 0.10 0.06 0.00
## CSA_8 0.12 0.25 0.28 0.26 0.10 0.01
## CSA_9 0.26 0.32 0.25 0.11 0.06 0.00
## CSA_10 0.16 0.30 0.34 0.17 0.03 0.01
## CSA_11 0.63 0.23 0.11 0.02 0.00 0.00
## CSA_12 0.13 0.20 0.25 0.24 0.17 0.01
## CSA_13 0.14 0.20 0.35 0.22 0.08 0.00
## CSA_14 0.21 0.24 0.28 0.14 0.13 0.01
## CSA_15 0.11 0.15 0.29 0.29 0.17 0.00
## CSA_16 0.11 0.25 0.33 0.21 0.11 0.00
## CSA_17 0.06 0.21 0.31 0.27 0.14 0.01
## CSA_18 0.15 0.17 0.36 0.15 0.16 0.01
## CSA_19 0.47 0.26 0.17 0.07 0.03 0.00
## CSA_20 0.34 0.24 0.26 0.12 0.04 0.00
## CSA_21 0.30 0.27 0.29 0.12 0.02 0.01
## CSA_22 0.34 0.24 0.27 0.12 0.03 0.01
## CSA_23 0.14 0.31 0.35 0.16 0.04 0.01
## CSA_24 0.31 0.19 0.29 0.11 0.10 0.00
## CSA_25 0.58 0.22 0.16 0.03 0.01 0.00
psych::alpha(AsianData2[c('IEQ_1','IEQ_2','IEQ_3','IEQ_4', 'IEQ_5')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("IEQ_1", "IEQ_2", "IEQ_3", "IEQ_4",
## "IEQ_5")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.86 0.86 0.84 0.56 6.4 0.017 0.89 0.61 0.56
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.83 0.86 0.89
## Duhachek 0.83 0.86 0.90
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## IEQ_1 0.85 0.85 0.82 0.59 5.7 0.019 0.0032 0.60
## IEQ_2 0.83 0.83 0.80 0.55 5.0 0.022 0.0067 0.54
## IEQ_3 0.83 0.83 0.79 0.55 4.9 0.022 0.0044 0.56
## IEQ_4 0.82 0.82 0.78 0.53 4.6 0.023 0.0028 0.54
## IEQ_5 0.84 0.84 0.81 0.57 5.3 0.020 0.0033 0.56
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## IEQ_1 161 0.76 0.76 0.67 0.62 1.01 0.73
## IEQ_2 161 0.81 0.81 0.75 0.70 0.84 0.75
## IEQ_3 161 0.83 0.82 0.76 0.70 1.05 0.80
## IEQ_4 160 0.84 0.84 0.80 0.74 0.86 0.74
## IEQ_5 161 0.79 0.79 0.71 0.66 0.70 0.75
##
## Non missing response frequency for each item
## 0 1 2 miss
## IEQ_1 0.26 0.47 0.27 0.00
## IEQ_2 0.37 0.41 0.22 0.00
## IEQ_3 0.30 0.35 0.35 0.00
## IEQ_4 0.36 0.43 0.21 0.01
## IEQ_5 0.47 0.35 0.17 0.00
psych::alpha(AsianData2[c('SLESQ_1','SLESQ_2','SLESQ_3','SLESQ_4','SLESQ_5','SLESQ_6','SLESQ_7','SLESQ_8','SLESQ_9', 'SLESQ_10','SLESQ_11','SLESQ_12','SLESQ_13')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("SLESQ_1", "SLESQ_2", "SLESQ_3",
## "SLESQ_4", "SLESQ_5", "SLESQ_6", "SLESQ_7", "SLESQ_8", "SLESQ_9",
## "SLESQ_10", "SLESQ_11", "SLESQ_12", "SLESQ_13")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.72 0.73 0.76 0.17 2.7 0.032 1.2 0.19 0.16
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.65 0.72 0.78
## Duhachek 0.66 0.72 0.78
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## SLESQ_1 0.72 0.72 0.75 0.18 2.6 0.032 0.013 0.17
## SLESQ_2 0.70 0.70 0.74 0.16 2.4 0.034 0.014 0.15
## SLESQ_3 0.71 0.71 0.74 0.17 2.5 0.033 0.013 0.17
## SLESQ_4 0.70 0.71 0.74 0.17 2.4 0.034 0.014 0.15
## SLESQ_5 0.71 0.72 0.75 0.18 2.6 0.033 0.011 0.17
## SLESQ_6 0.71 0.72 0.75 0.18 2.6 0.033 0.013 0.18
## SLESQ_7 0.70 0.71 0.74 0.17 2.4 0.035 0.013 0.16
## SLESQ_8 0.69 0.70 0.72 0.16 2.3 0.035 0.012 0.15
## SLESQ_9 0.70 0.71 0.74 0.17 2.5 0.034 0.013 0.17
## SLESQ_10 0.70 0.70 0.73 0.16 2.4 0.034 0.011 0.16
## SLESQ_11 0.70 0.70 0.73 0.16 2.4 0.034 0.013 0.16
## SLESQ_12 0.72 0.73 0.75 0.18 2.7 0.032 0.012 0.20
## SLESQ_13 0.69 0.71 0.73 0.17 2.4 0.035 0.013 0.15
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## SLESQ_1 160 0.39 0.40 0.31 0.24 1.2 0.39
## SLESQ_2 160 0.54 0.54 0.48 0.39 1.3 0.44
## SLESQ_3 160 0.43 0.49 0.43 0.32 1.1 0.28
## SLESQ_4 161 0.52 0.52 0.46 0.38 1.2 0.42
## SLESQ_5 160 0.39 0.38 0.31 0.27 1.1 0.33
## SLESQ_6 161 0.48 0.43 0.34 0.31 1.3 0.47
## SLESQ_7 161 0.56 0.50 0.44 0.40 1.4 0.49
## SLESQ_8 160 0.58 0.58 0.55 0.46 1.2 0.39
## SLESQ_9 161 0.54 0.48 0.41 0.36 1.6 0.50
## SLESQ_10 160 0.47 0.55 0.51 0.40 1.1 0.24
## SLESQ_11 160 0.51 0.55 0.51 0.40 1.1 0.33
## SLESQ_12 161 0.27 0.34 0.25 0.18 1.1 0.24
## SLESQ_13 161 0.56 0.52 0.47 0.42 1.2 0.42
##
## Non missing response frequency for each item
## 1 2 miss
## SLESQ_1 0.81 0.19 0.01
## SLESQ_2 0.74 0.26 0.01
## SLESQ_3 0.91 0.09 0.01
## SLESQ_4 0.78 0.22 0.00
## SLESQ_5 0.88 0.12 0.01
## SLESQ_6 0.66 0.34 0.00
## SLESQ_7 0.60 0.40 0.00
## SLESQ_8 0.82 0.18 0.01
## SLESQ_9 0.44 0.56 0.00
## SLESQ_10 0.94 0.06 0.01
## SLESQ_11 0.88 0.12 0.01
## SLESQ_12 0.94 0.06 0.00
## SLESQ_13 0.78 0.22 0.00
psych::alpha(AsianData2[c('OD_1','OD_2','OD_3')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("OD_1", "OD_2", "OD_3")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.87 0.87 0.83 0.7 6.9 0.018 2 0.68 0.71
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.83 0.87 0.90
## Duhachek 0.84 0.87 0.91
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## OD_1 0.83 0.83 0.71 0.71 4.9 0.027 NA 0.71
## OD_2 0.85 0.86 0.75 0.75 6.0 0.023 NA 0.75
## OD_3 0.77 0.77 0.63 0.63 3.4 0.036 NA 0.63
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## OD_1 161 0.88 0.89 0.81 0.75 2.0 0.70
## OD_2 161 0.88 0.87 0.76 0.72 1.9 0.81
## OD_3 161 0.92 0.92 0.87 0.81 2.1 0.77
##
## Non missing response frequency for each item
## 1 2 3 4 5 miss
## OD_1 0.16 0.68 0.12 0.02 0.01 0
## OD_2 0.29 0.58 0.09 0.03 0.02 0
## OD_3 0.16 0.63 0.16 0.03 0.02 0
psych::alpha(AsianData2[c('PCL5_1','PCL5_2','PCL5_3','PCL5_4')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("PCL5_1", "PCL5_2", "PCL5_3", "PCL5_4")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.86 0.86 0.84 0.61 6.4 0.018 1.5 1.1 0.59
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.82 0.86 0.89
## Duhachek 0.83 0.86 0.90
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## PCL5_1 0.79 0.79 0.72 0.55 3.7 0.029 0.0043 0.53
## PCL5_2 0.81 0.81 0.76 0.59 4.3 0.026 0.0116 0.56
## PCL5_3 0.83 0.83 0.78 0.61 4.8 0.024 0.0149 0.56
## PCL5_4 0.87 0.87 0.83 0.70 6.9 0.018 0.0041 0.71
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## PCL5_1 160 0.89 0.90 0.87 0.81 1.3 1.2
## PCL5_2 160 0.87 0.86 0.81 0.75 1.7 1.3
## PCL5_3 160 0.85 0.84 0.77 0.71 1.8 1.3
## PCL5_4 160 0.77 0.77 0.63 0.59 1.3 1.2
##
## Non missing response frequency for each item
## 0 1 2 3 4 miss
## PCL5_1 0.31 0.27 0.24 0.14 0.04 0.01
## PCL5_2 0.25 0.24 0.22 0.17 0.11 0.01
## PCL5_3 0.22 0.25 0.21 0.19 0.12 0.01
## PCL5_4 0.35 0.30 0.14 0.15 0.06 0.01
psych::alpha(AsianData2[c('ESC_1r', 'ESC_2r','ESC_3r','ESC_4','ESC_5','ESC_6','ESC_7','ESC_8')])
##
## Reliability analysis
## Call: psych::alpha(x = AsianData2[c("ESC_1r", "ESC_2r", "ESC_3r", "ESC_4",
## "ESC_5", "ESC_6", "ESC_7", "ESC_8")])
##
## raw_alpha std.alpha G6(smc) average_r S/N ase mean sd median_r
## 0.86 0.87 0.88 0.45 6.5 0.016 3.5 1.1 0.45
##
## 95% confidence boundaries
## lower alpha upper
## Feldt 0.83 0.86 0.89
## Duhachek 0.83 0.86 0.90
##
## Reliability if an item is dropped:
## raw_alpha std.alpha G6(smc) average_r S/N alpha se var.r med.r
## ESC_1r 0.84 0.84 0.85 0.44 5.4 0.019 0.013 0.45
## ESC_2r 0.85 0.85 0.85 0.44 5.5 0.019 0.011 0.45
## ESC_3r 0.84 0.84 0.85 0.43 5.4 0.019 0.013 0.45
## ESC_4 0.84 0.85 0.86 0.44 5.5 0.019 0.023 0.41
## ESC_5 0.86 0.86 0.87 0.47 6.3 0.017 0.019 0.49
## ESC_6 0.84 0.84 0.86 0.44 5.4 0.019 0.022 0.41
## ESC_7 0.85 0.86 0.87 0.46 6.0 0.018 0.022 0.47
## ESC_8 0.86 0.86 0.87 0.47 6.2 0.017 0.019 0.49
##
## Item statistics
## n raw.r std.r r.cor r.drop mean sd
## ESC_1r 160 0.75 0.77 0.75 0.66 3.0 1.5
## ESC_2r 160 0.73 0.75 0.74 0.65 2.8 1.2
## ESC_3r 160 0.75 0.77 0.76 0.67 2.7 1.4
## ESC_4 160 0.77 0.76 0.71 0.67 3.4 1.7
## ESC_5 160 0.64 0.63 0.55 0.52 4.7 1.5
## ESC_6 160 0.77 0.77 0.72 0.68 3.3 1.5
## ESC_7 160 0.69 0.68 0.61 0.57 3.7 1.6
## ESC_8 160 0.65 0.64 0.56 0.52 4.6 1.5
##
## Non missing response frequency for each item
## 1 2 3 4 5 6 7 miss
## ESC_1r 0.17 0.26 0.28 0.12 0.12 0.04 0.01 0.01
## ESC_2r 0.15 0.28 0.30 0.18 0.06 0.02 0.01 0.01
## ESC_3r 0.22 0.26 0.24 0.17 0.08 0.03 0.01 0.01
## ESC_4 0.12 0.28 0.17 0.12 0.17 0.09 0.05 0.01
## ESC_5 0.02 0.09 0.11 0.17 0.32 0.21 0.09 0.01
## ESC_6 0.11 0.22 0.26 0.16 0.16 0.05 0.03 0.01
## ESC_7 0.10 0.18 0.19 0.22 0.16 0.11 0.04 0.01
## ESC_8 0.03 0.06 0.17 0.21 0.21 0.20 0.12 0.01
str(AsianData2$SSRPH)
## num [1:161] 2.8 2.2 3.2 2.8 2.4 3 1.4 1.6 2.6 2 ...
#double checking that new subscores are a number with two decimal places
AsianData2_Missingness2 <-(dplyr::select (AsianData2, SSRPH:ESC))
In the script below we create a variable that counts the number of missing variables and then creates a proportion by dividing it by the number of total variables.
#Create a variable (n_miss) that counts the number missing
AsianData2_Missingness2$n_miss <- AsianData2_Missingness2%>%
dplyr::select(SSRPH:ESC) %>%
is.na %>%
rowSums
#Create a proportion missing by dividing n_miss by the total number of scale variables (15)
#Pipe to sort in order of descending frequency to get a sense of the missingness
AsianData2_Missingness2<- AsianData2_Missingness2%>%
dplyr::mutate(prop_miss = (n_miss/15)*100)%>%
arrange(desc(n_miss))
psych::describe(AsianData2_Missingness2$prop_miss)
## vars n mean sd median trimmed mad min max range skew kurtosis se
## X1 1 161 0.46 5.28 0 0 0 0 66.67 66.67 12.28 150.95 0.42
Across the 259 cases for which the scoring protocol was applied, missingness ranged from 0 to 66.67%.
Let’s delete all cases with missingness at 20% or greater. So, need to have at least 80% of data present.
#update df to have only those with at least 20% of complete data (this is an arbitrary decision)
AsianData_scored <- dplyr::filter(AsianData2_Missingness2, prop_miss <= 20) #RETAIN ONES THAT HAVE 20% OF DATA OR LESS OF MISSING
#the variable selection just lops off the proportion missing
#AsianData_scored2 <-(select (AsianData_scored, SSRPH, SSOSH, PR_PF, PR_A, PR_D, PR_SR, PR_PI, ANG, CSA, IEQ, SLESQ, OD, PCL5, ESC))
AsianData_scored2 <- subset(AsianData_scored, select = SSRPH:ESC)
#this produces the number of cases retained
nrow(AsianData_scored2)
## [1] 160
After eliminating cases with greater than 20% missing, the dataset analyzed included 160 cases. So, 1 case was removed.
If we had cases that were removed, would need to save the data with those cases removed!
#percent missing across df
formattable::percent(mean(is.na(AsianData_scored2)))
## [1] 0.04%
#percent of rows with nonmissing data
formattable::percent(mean(complete.cases(AsianData_scored2)))
## [1] 99.38%
In this dataset we had less than 1% (0.04%) missing across the df; 99.38% of the rows had nonmissing data at the scale level.
mice_ScaleLvl_Asian <- mice::md.pattern(AsianData_scored2, plot = TRUE, rotate.names=TRUE)
mice_ScaleLvl_Asian
## SSRPH SSOSH PR_PF PR_A PR_D PR_SR PR_PI ANG CSA IEQ SLESQ OD PCL5 ESC MHSAS
## 159 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0
## 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
##
## 159 0
## 1 1
## 1
At the scale-level, this is much easier to interpret. There are 2 rows of data because there are only 2 patterns of missingness. The most common pattern is non-missing data (n = 159).
moved consent to top : Rename Consent
Note: ID = X
write.csv(AsianData2, 'AsianData_ItemsandScales.csv')
AsianDataScored <- read.csv("AsianData_ItemsandScales.csv", header = TRUE) #Refer Back to this CSV file for Cleaned Data
FROM BIKOS TEXTBOOK!!! Update this, helpful to remember how we managed missing data https://lhbikos.github.io/ReC_MultivModel/score.html#on-missing-data >> Joel will want to explain how we explain missingness >>Available item analysis (AIA; (Parent, 2013)) is a strategy for managing missing data that uses available data for analysis and excludes cases with missing data points only for analyses in which the data points would be directly involved. Parent (2013) suggested that AIA is equivalent to more complex methods (e.g., multiple imputation) across a number of variations of sample size, magnitude of associations among items, and degree of missingness. Thus, we utilized Parent’s recommendations to guide our approach to managing missing data. Missing data analyses were conducted with tools in base R as well as the R packages, psych (v. 2.3.6) and mice (v. 3.16.0).
Across cases that were deemed eligible on the basis of the inclusion/exclusion criteria, missingness ranged from 0% to 7.02%. Across the dataset, 0.25% of cells had missing data and 76.83% of cases had nonmissing data. At this stage in the analysis, we allowed all cases with less than 90% missing to continue to the scoring stage. Guided by Parent’s (2013) AIA approach, scales were scored if 80% of the items were non-missing.
Across the 259 cases for which the scoring protocol was applied, missingness ranged from 0 to 6.67%. After eliminating cases with greater than 20% missing, the dataset remained consistent by analyzing 259 cases. In this dataset we had less than 1% (0.05%) missing across the data set; 99.23% of the rows had nonmissing data.
AsianData_Subscales <-(dplyr::select (AsianData_scored2, SSRPH:ESC))
descriptives <- psych::describe(AsianData_Subscales, type = 1)
descriptives
## vars n mean sd median trimmed mad min max range skew kurtosis
## SSRPH 1 160 2.22 0.59 2.20 2.21 0.59 1.00 4.00 3.00 0.24 0.31
## SSOSH 2 160 2.32 0.80 2.20 2.28 0.89 1.00 5.00 4.00 0.56 -0.01
## MHSAS 3 159 5.59 1.20 5.89 5.73 1.16 1.00 7.00 6.00 -1.06 1.23
## PR_PF 4 160 4.50 0.68 5.00 4.62 0.00 2.75 5.00 2.25 -1.11 -0.14
## PR_A 5 160 2.56 0.94 2.50 2.52 0.74 1.00 5.00 4.00 0.25 -0.57
## PR_D 6 160 2.63 1.11 2.50 2.58 1.11 1.00 5.00 4.00 0.30 -0.68
## PR_SR 7 160 3.58 1.05 3.62 3.65 0.93 1.00 5.00 4.00 -0.44 -0.45
## PR_PI 8 160 2.01 0.98 1.75 1.89 1.11 1.00 5.00 4.00 0.85 0.02
## ANG 9 160 2.67 0.99 2.60 2.63 1.19 1.00 5.00 4.00 0.31 -0.44
## CSA 10 160 1.56 0.72 1.54 1.55 0.74 0.04 3.44 3.40 0.07 -0.49
## IEQ 11 160 0.90 0.61 1.00 0.88 0.89 0.00 2.00 2.00 0.09 -1.10
## SLESQ 12 160 1.22 0.19 1.15 1.19 0.12 1.00 1.85 0.85 0.98 0.52
## OD 13 160 2.03 0.68 2.00 1.97 0.49 1.00 5.00 4.00 1.21 3.06
## PCL5 14 160 1.50 1.07 1.50 1.44 1.11 0.00 4.00 4.00 0.39 -0.77
## ESC 15 160 3.52 1.08 3.50 3.49 1.11 1.12 7.00 5.88 0.25 -0.01
## se
## SSRPH 0.05
## SSOSH 0.06
## MHSAS 0.10
## PR_PF 0.05
## PR_A 0.07
## PR_D 0.09
## PR_SR 0.08
## PR_PI 0.08
## ANG 0.08
## CSA 0.06
## IEQ 0.05
## SLESQ 0.01
## OD 0.05
## PCL5 0.08
## ESC 0.09
All skew values fall below 3.0 All kurtosis values fall below 10.0 *As per Kline, 2016
We can also apply the Shapiro-Wilk test of normality to each of our
variables. When the
p value is < .05, the variable’s distribution is deviates from a
normal distribution to a degree that is statistically significant.
shapiro.test(AsianData_Subscales$SSRPH)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$SSRPH
## W = 0.97804, p-value = 0.01192
#abnormal
shapiro.test(AsianData_Subscales$PR_PF)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$PR_PF
## W = 0.74451, p-value = 0.000000000000002218
#abnormal
shapiro.test(AsianData_Subscales$PR_A)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$PR_A
## W = 0.97296, p-value = 0.003131
#abnormal
shapiro.test(AsianData_Subscales$PR_D)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$PR_D
## W = 0.95244, p-value = 0.0000294
#abnormal
shapiro.test(AsianData_Subscales$PR_SR)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$PR_SR
## W = 0.94676, p-value = 0.000009579
#abnormal
shapiro.test(AsianData_Subscales$PR_PI)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$PR_PI
## W = 0.88864, p-value = 0.000000001317
#abnormal
shapiro.test(AsianData_Subscales$ANG)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$ANG
## W = 0.97322, p-value = 0.003352
#abnormal
shapiro.test(AsianData_Subscales$CSA)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$CSA
## W = 0.98991, p-value = 0.3118
#normal
p value is > .05, so the variables distribution does NOT deviate from a normal distribution!
shapiro.test(AsianData_Subscales$IEQ)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$IEQ
## W = 0.9394, p-value = 0.000002449
#abnormal
shapiro.test(AsianData_Subscales$SLESQ)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$SLESQ
## W = 0.90193, p-value = 0.000000007394
#abnormal
shapiro.test(AsianData_Subscales$OD)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$OD
## W = 0.85606, p-value = 0.00000000003141
#abnormal
shapiro.test(AsianData_Subscales$PCL5)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$PCL5
## W = 0.94974, p-value = 0.0000171
#abnormal
shapiro.test(AsianData_Subscales$ESC)
##
## Shapiro-Wilk normality test
##
## data: AsianData_Subscales$ESC
## W = 0.99137, p-value = 0.4458
#normal
p value is > .05, so the variables distribution does NOT deviate from a normal distribution!
psych::pairs.panels(AsianData_Subscales[c("SSRPH", "PR_PF", "PR_A",
"PR_D", "PR_SR","PR_PI","ANG","CSA","IEQ","SLESQ","OD","PCL5","ESC")], stars = TRUE, lm = TRUE)
The histograms displayed in the diagonal graph for us what we learned from the Shapiro Wilk’s test of normality. We can clearly see the non-normal distribution is most of these variables, for example, PR_PF is really negatively skewed (meaning most people had higher physical functioning) and PR_PI is more positively skewed, meaning that pain highly interfered in most of our participants lives.
public stigma self stigma etc, hel seeking, contextualizing, chacking all variables of paper spec
These functions construct component+residual plots (also called partial-residual plots) for linear and generalized linear models.
Wait on this until we know what our linear model is
Wait on this for data analysis
AsianData_Subscales$Mahal <- psych::outlier(AsianData_Subscales[c("SSRPH", "PR_PF", "PR_A",
"PR_D", "PR_SR","PR_PI","ANG","CSA","IEQ","SLESQ","OD","PCL5","ESC")])
To the degree that the plotted line stays on the straight line (representing the theoretical normal distribution), the data is multivariate normally distributed. The data is very not staying on a straight line.
psych::describe(AsianData_Subscales$Mahal)
## vars n mean sd median trimmed mad min max range skew kurtosis se
## X1 1 160 12.92 6.84 12.03 12.08 5.88 2.14 48.65 46.5 1.78 5.45 0.54
Mean = 12.92 Median = 12.03 SD = 6.84
# creates a variable indicating TRUE or FALSE if an item is an
# outlier
AsianData_Subscales$MOutlier <- dplyr::if_else(AsianData_Subscales$Mahal > (median(AsianData_Subscales$Mahal) +
(3 * sd(AsianData_Subscales$Mahal))), TRUE, FALSE)
#3 = 3 sd above or below
# shows us the first 6 rows of the data so we can see the new
# variables (Mahal, MOutlier)
head(AsianData_Subscales)
## SSRPH SSOSH MHSAS PR_PF PR_A PR_D PR_SR PR_PI ANG CSA IEQ SLESQ OD PCL5
## 1 2.4 1.6 NA 4.25 3.75 4.00 2.00 1.75 4.0 2.32 1.4 1.46 4.33 3.75
## 2 2.8 3.1 4.33 5.00 2.50 3.50 3.75 1.00 2.6 1.68 1.4 1.31 2.00 2.00
## 3 2.2 2.8 5.33 5.00 2.00 2.00 4.00 2.00 3.0 1.52 1.0 1.00 2.00 2.00
## 4 3.2 3.6 1.33 4.50 4.00 4.00 2.50 2.00 4.0 2.48 1.8 1.08 1.00 2.00
## 5 2.8 2.0 5.22 5.00 1.25 1.00 5.00 1.25 1.2 0.08 1.0 1.00 1.33 0.50
## 6 2.4 1.4 5.67 5.00 1.25 1.25 5.00 1.50 1.0 0.32 0.2 1.08 2.00 0.00
## ESC Mahal MOutlier
## 1 3.75 17.962579 FALSE
## 2 4.12 8.090853 FALSE
## 3 4.12 6.352344 FALSE
## 4 4.50 18.233942 FALSE
## 5 4.88 13.228719 FALSE
## 6 2.38 6.906309 FALSE
No outliers
# counts frequency TRUE and FALSE indicating outlier or not
OutlierCount <- AsianData_Subscales %>%
dplyr::count(MOutlier)
# calculating how many outliers a slightly different way
nrow(AsianData_Subscales) - OutlierCount
## MOutlier n
## 1 160 3
## 2 159 157
We evaluated multivariate normality with the Mahalanobis distance test. Specifically, we used the psych::outlier() function and included all continuous variables in the calculation. Our visual inspection of the Q-Q plot suggested that the plotted line strayed from the straight line as the quantiles increased. Additionally, we appended the Mahalanobis distance scores as a variable to the data. Analyzing this variable, we found that while there were 3 cases that exceed three standard deviations beyond the median. Given that the Mahalanobis distance values increased in a consistent manner (i.e., no extreme “jumps”) we retained all cases. # delete single scale outlier
AsianData2Final <- AsianData2[-90,]
#AsianData2final <- dplyr::filter (AsianData1, Q51 != "test")
nrow(AsianData2Final)
## [1] 160
write.csv(AsianData2Final, 'AsianData2Final.csv')
#the variable selection just lops off the proportion missing
#the variable selection just lops off the proportion missing
AsianData_Final_Dataset<-(select (AsianData2Final, AGE:BORN_2, AHELP, PRE_HELP, SSRPH:PR_PI, PR_INT, ANG:ESC))
write.csv(AsianData_Final_Dataset, 'AsianData_FINAL_Dataset_Scales.csv')
#AsianData_Subscales <- read.csv("AsianData_FINAL_Dataset_Scales.csv", header = TRUE) #Refer Back to this CSV file for Cleaned Data
#Code from before DO NOT USE
#FINAL CSV File of Cleaned & Scored Data JUST SUBSCALES!
#write.csv(AsianData_Subscales, 'AsianData_Subscales.csv')
#AsianData_Subscales <- read.csv("AsianData_Subscales.csv", header = TRUE) #Refer Back to this CSV file for Cleaned Data
##Choosing the variables for final CSV
#the variable selection just lops off the proportion missing
#AsianData_Final_Dataset<-(select (AsianData2Final, AGE:BORN_2, AHELP, PRE_HELP, SSRPH:PR_PI, PR_INT, ANG:ESC))
#Final CSV of scrubbed and scored data INCLUDING Demographics, Scales, and Subscales (average)
write.csv(AsianData_Final_Dataset, 'AsianData_FINAL_Dataset.csv')
FINI!