# 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

Import data

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')

delete test cases/responses

AsianData1 <- dplyr::filter (AsianData1, Q51 != "test")

nrow(AsianData1)
## [1] 171

Number of actual participants (NOT TESTING) = 1 1 case deleted

Confirm Validity Check

#*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

Delete Variables Double Check this

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

Check Structure

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]

Duration

#*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

Analyze item level data missingness and patterns

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.

Analyzing Missing Data Patterns Item Level

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.

Recoding

#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")

Reverse Scored Items (need to do for Asian, item 1,2,3)

#*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

Aggregate Items into Subscales

#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)

Internal Consistency of Scales/Subscales

Alpha Coefficient

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

Missing Analysis: Scale level

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!

Revisiting Missing Analysis at the Scale Level

#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.

Scale Level: Patterns of Missing Data

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

FINAL CSV File of Cleaned & Scored Data with Items AND Scales

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.

Analyze scale level assumptions normality on continuous variables

AsianData_Subscales <-(dplyr::select (AsianData_scored2, SSRPH:ESC))

skewness and kurtosis - Item Level

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

Shapiro-Wilk test of normality

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!

histogram and Q-Q plot

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.

Workon - Analyze scale level assumptions linearity

public stigma self stigma etc, hel seeking, contextualizing, chacking all variables of paper spec

Workon - Visual inspection of CR plots

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

Workon - Analyze scale level assumptions homoscedasticity

Wait on this for data analysis

Workon - inspect scatterplot of variable (x axis) and unstandardized residuals (y axis)

Mahalanobis distance test

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)) 

FINAL CSV File of Scrubbed & Scored Data - Demographics, Scales & Subscales NO ITEMS (averages)

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!