#loding packages
library(readxl)
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.4.4 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ 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
library(ggplot2)
#loading data
supportdv <- read_excel("202402_classAssignment.xlsx")
View(supportdv)
#taking a glance at the variables
head(supportdv)
## # A tibble: 6 × 26
## hh1 hh2 ln wb4 wb5 wb6a mt1 mt2 mt3 cm11 mn34b dv1a dv1b
## <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 1 1 1 38 1 3 0 2 0 5 NA 0 0
## 2 1 1 3 21 1 5 0 2 0 0 NA 0 0
## 3 1 2 2 22 1 3 0 3 3 3 2.9 0 0
## 4 1 4 1 29 1 1 0 3 0 4 NA 0 0
## 5 1 5 2 20 1 3 0 1 1 2 NA 0 1
## 6 1 6 2 39 1 1 0 0 3 5 NA 0 0
## # ℹ 13 more variables: dv1c <dbl>, dv1d <dbl>, dv1e <dbl>, dv1g <dbl>,
## # fg3 <dbl>, fg7 <dbl>, fg8 <dbl>, fg9 <dbl>, ma1 <dbl>, ma2 <dbl>,
## # ma4 <dbl>, ma6 <dbl>, windex5 <dbl>
clonedData<-supportdv %>%
select(hh1,hh2,ln, wb4, wb5,wb6a,mt1,mt2,mt3,cm11,fg3,dv1a,dv1b,dv1c,dv1d,dv1e,dv1g,ma2,ma6,windex5) %>%
#Renaming variables
rename(cluster=hh1,
hhNumber=hh2,
lineNumber=ln,
age=wb4,
attendedSchool=wb5,
education=wb6a,
readNewsPaper=mt1,
listenRadio=mt2,
watchTV=mt3,
childrenEverBorn=cm11,
circumcize=fg3,
beatwife_goesOut=dv1a,
beatWife_neglectChildren=dv1b,
beatWife_arguesHusband=dv1c,
beatWife_refuseSex=dv1d,
beatWife_burnFood=dv1e,
supportDV=dv1g,
agePartner=ma2,
maritalStatus=ma6,
wealthStatus=windex5) %>%
# addidng value labels
mutate(attendedSchool=factor(attendedSchool, levels=c(1,2,9),
labels=c('YES','NO','NO RESPONSE')),
education=factor(education, levels=c(0,1,2,3,4,5,6,9),
labels=c('EARLY CHILDHOOD EDUCATION','PRIMARY','MIDDLE','JSS/JHS','SECONDARY/TECH/VOC/COMM','SSS/SHS/TECH/VOC/COMM','HIGHER','NO RESPONSE')),
readNewsPaper=factor(readNewsPaper, levels=c(0,1,2,3,9),
labels=c('NOT AT ALL','ONCE A WEEK','AT LEAST ONCE A WEEK','ALMOST EVERYDAY','NO RESPONSE')),
listenRadio=factor(listenRadio, levels=c(0,1,2,3,9),
labels=c('NOT AT ALL','ONCE A WEEK','AT LEAST ONCE A WEEK','ALMOST EVERYDAY','NO RESPONSE')),
watchTV=factor(watchTV, levels=c(0,1,2,3,9),
labels=c('NOT AT ALL','ONCE A WEEK','AT LEAST ONCE A WEEK','ALMOST EVERYDAY','NO RESPONSE')),
circumcize=factor(circumcize, levels=c(1,2,9),
labels=c('YES','NO','NO RESPONSE')),
beatwife_goesOut=factor(beatwife_goesOut, levels=c(1,2,9),
labels=c('YES','NO','NO RESPONSE')),
beatWife_neglectChildren=factor(beatWife_neglectChildren, levels=c(1,2,9),
labels=c('YES','NO','NO RESPONSE')),
beatWife_arguesHusband=factor(beatWife_arguesHusband, levels=c(1,2,9),
labels=c('YES','NO','NO RESPONSE')),
beatWife_refuseSex=factor(beatWife_refuseSex, levels=c(1,2,9),
labels=c('YES','NO','NO RESPONSE')),
beatWife_burnFood=factor(beatWife_burnFood, levels=c(1,2,9),
labels=c('YES','NO','NO RESPONSE')),
supportDV=factor(supportDV, levels=c(1,2), labels=c('YES','NO')),
#grouping ages
agegroups= case_when(
age >= 15 & age <= 19 ~ "15 - 19",
age >= 20 & age <= 24 ~ "20 - 24",
age >= 25 & age <= 29 ~ "25 - 29",
age >= 30 & age <= 34 ~ "30 - 34",
age >= 35 & age <= 39 ~ "35 - 39",
age >= 40 & age <= 44 ~ "40 - 44",
age >= 45 & age <= 49 ~ "45 - 49"),
ageDiference= agePartner - age) %>%
#filtering age 20-49
filter(age %in% 20:49)
#aAge of woman
data.frame(age = as.numeric(names(table(clonedData$age))),
frequency = as.numeric(table(clonedData$age)))
## age frequency
## 1 20 453
## 2 21 435
## 3 22 521
## 4 23 511
## 5 24 460
## 6 25 495
## 7 26 369
## 8 27 385
## 9 28 336
## 10 29 309
## 11 30 344
## 12 31 303
## 13 32 357
## 14 33 297
## 15 34 317
## 16 35 380
## 17 36 262
## 18 37 325
## 19 38 335
## 20 39 282
## 21 40 361
## 22 41 246
## 23 42 295
## 24 43 304
## 25 44 232
## 26 45 364
## 27 46 216
## 28 47 244
## 29 48 210
## 30 49 222
#Ever attended school
table(clonedData$attendedSchool)
##
## YES NO NO RESPONSE
## 7682 2488 0
#Highest level of school attended
data.frame(education = names(table(clonedData$education)),
frequency = as.numeric(table(clonedData$education)))
## education frequency
## 1 EARLY CHILDHOOD EDUCATION 19
## 2 PRIMARY 1711
## 3 MIDDLE 512
## 4 JSS/JHS 3010
## 5 SECONDARY/TECH/VOC/COMM 172
## 6 SSS/SHS/TECH/VOC/COMM 1531
## 7 HIGHER 726
## 8 NO RESPONSE 2489
#Frequency of reading newspaper or magazine
data.frame(readNewsPaper = names(table(clonedData$readNewsPaper)),
frequency = as.numeric(table(clonedData$readNewsPaper)))
## readNewsPaper frequency
## 1 NOT AT ALL 9099
## 2 ONCE A WEEK 534
## 3 AT LEAST ONCE A WEEK 401
## 4 ALMOST EVERYDAY 136
## 5 NO RESPONSE 0
#Frequency of listening to the radio
data.frame(listenRadio = names(table(clonedData$listenRadio)),
frequency = as.numeric(table(clonedData$listenRadio)))
## listenRadio frequency
## 1 NOT AT ALL 3291
## 2 ONCE A WEEK 1636
## 3 AT LEAST ONCE A WEEK 2040
## 4 ALMOST EVERYDAY 3203
## 5 NO RESPONSE 0
#Frequency of watching TV
data.frame(watchTV = names(table(clonedData$watchTV)),
frequency = as.numeric(table(clonedData$watchTV)))
## watchTV frequency
## 1 NOT AT ALL 3209
## 2 ONCE A WEEK 983
## 3 AT LEAST ONCE A WEEK 1507
## 4 ALMOST EVERYDAY 4471
## 5 NO RESPONSE 0
#Children ever born
data.frame(childrenEverBorn = as.numeric(names(table(clonedData$childrenEverBorn))),
frequency = as.numeric(table(clonedData$childrenEverBorn)))
## childrenEverBorn frequency
## 1 0 1606
## 2 1 1607
## 3 2 1559
## 4 3 1463
## 5 4 1270
## 6 5 962
## 7 6 733
## 8 7 472
## 9 8 254
## 10 9 136
## 11 10 66
## 12 11 26
## 13 12 10
## 14 13 4
## 15 14 1
## 16 15 1
# If she argues with husband: wife beating justified
data.frame(table(clonedData$beatWife_arguesHusband))
## Var1 Freq
## 1 YES 1618
## 2 NO 0
## 3 NO RESPONSE 0
# If she burns the food: wife beating justified
data.frame(table(clonedData$beatWife_burnFood))
## Var1 Freq
## 1 YES 817
## 2 NO 0
## 3 NO RESPONSE 0
#If she goes out with out telling husband: wife beating justified
data.frame(table(clonedData$beatwife_goesOut))
## Var1 Freq
## 1 YES 1689
## 2 NO 0
## 3 NO RESPONSE 0
# If she refuses sex with husband: wife beating justified
data.frame(table(clonedData$beatWife_refuseSex))
## Var1 Freq
## 1 YES 1347
## 2 NO 0
## 3 NO RESPONSE 0
# If she neglects the children: wife beating justified
data.frame(table(clonedData$beatWife_neglectChildren))
## Var1 Freq
## 1 YES 2186
## 2 NO 0
## 3 NO RESPONSE 0
# Ever circumcised
data.frame(table(clonedData$circumcize))
## Var1 Freq
## 1 YES 522
## 2 NO 6981
## 3 NO RESPONSE 4
# Age of husband/partner
data.frame(age_of_Partner = as.numeric(names(table(clonedData$agePartner))),
frequency = as.numeric(table(clonedData$agePartner)))
## age_of_Partner frequency
## 1 13 2
## 2 14 1
## 3 15 1
## 4 16 3
## 5 18 4
## 6 19 6
## 7 20 6
## 8 21 17
## 9 22 35
## 10 23 41
## 11 24 76
## 12 25 138
## 13 26 123
## 14 27 174
## 15 28 168
## 16 29 163
## 17 30 318
## 18 31 177
## 19 32 248
## 20 33 167
## 21 34 179
## 22 35 340
## 23 36 193
## 24 37 238
## 25 38 217
## 26 39 168
## 27 40 358
## 28 41 156
## 29 42 247
## 30 43 203
## 31 44 141
## 32 45 351
## 33 46 161
## 34 47 175
## 35 48 192
## 36 49 168
## 37 50 310
## 38 51 143
## 39 52 189
## 40 53 125
## 41 54 106
## 42 55 133
## 43 56 91
## 44 57 72
## 45 58 42
## 46 59 34
## 47 60 109
## 48 61 30
## 49 62 56
## 50 63 35
## 51 64 16
## 52 65 42
## 53 66 7
## 54 67 12
## 55 68 11
## 56 69 7
## 57 70 25
## 58 71 8
## 59 72 10
## 60 73 2
## 61 74 4
## 62 75 10
## 63 76 4
## 64 77 3
## 65 78 6
## 66 79 3
## 67 80 3
# Marital Status
table(clonedData$maritalStatus)
##
## 1 2 3
## 319 283 576
# Wealth Index
table(clonedData$wealthStatus)
##
## 1 2 3 4 5
## 2220 1692 1899 2000 2359
# Age Difference
data.frame(age_diff = as.numeric(names(table(clonedData$ageDiference))),
frequency = as.numeric(table(clonedData$ageDiference)))
## age_diff frequency
## 1 -28 1
## 2 -26 2
## 3 -25 3
## 4 -24 1
## 5 -23 1
## 6 -22 1
## 7 -21 2
## 8 -19 1
## 9 -18 4
## 10 -17 1
## 11 -15 1
## 12 -14 3
## 13 -13 1
## 14 -11 2
## 15 -10 4
## 16 -9 6
## 17 -8 10
## 18 -7 7
## 19 -6 15
## 20 -5 14
## 21 -4 47
## 22 -3 42
## 23 -2 64
## 24 -1 92
## 25 0 216
## 26 1 383
## 27 2 587
## 28 3 630
## 29 4 620
## 30 5 650
## 31 6 521
## 32 7 463
## 33 8 400
## 34 9 320
## 35 10 356
## 36 11 224
## 37 12 221
## 38 13 163
## 39 14 127
## 40 15 140
## 41 16 93
## 42 17 83
## 43 18 67
## 44 19 58
## 45 20 55
## 46 21 40
## 47 22 38
## 48 23 30
## 49 24 25
## 50 25 26
## 51 26 28
## 52 27 16
## 53 28 12
## 54 29 14
## 55 30 12
## 56 31 6
## 57 32 10
## 58 33 9
## 59 34 7
## 60 35 8
## 61 36 2
## 62 37 1
## 63 39 4
## 64 40 7
## 65 42 1
## 66 43 2
## 67 45 1
## 68 50 1
## 69 52 1
# Age groupings
data.frame(age_groups = names(table(clonedData$agegroups)),
frequency = as.numeric(table(clonedData$agegroups)))
## age_groups frequency
## 1 20 - 24 2380
## 2 25 - 29 1894
## 3 30 - 34 1618
## 4 35 - 39 1584
## 5 40 - 44 1438
## 6 45 - 49 1256
# support Domestic Violence
table(clonedData$supportDV)
##
## YES NO
## 3284 0
mean(clonedData$age)
## [1] 32.6767
median(clonedData$age)
## [1] 32
mean(clonedData$agePartner)
## [1] NA
median(clonedData$agePartner)
## [1] NA
mean (clonedData$childrenEverBorn)
## [1] 3.058899
median(clonedData$childrenEverBorn)
## [1] 3
mean(clonedData$ageDiference)
## [1] NA
median (clonedData$ageDiference)
## [1] NA
table(clonedData$education,clonedData$supportDV)
##
## YES NO
## EARLY CHILDHOOD EDUCATION 11 0
## PRIMARY 644 0
## MIDDLE 117 0
## JSS/JHS 923 0
## SECONDARY/TECH/VOC/COMM 38 0
## SSS/SHS/TECH/VOC/COMM 333 0
## HIGHER 72 0
## NO RESPONSE 1146 0
table(clonedData$beatwife_goesOut,clonedData$supportDV)
##
## YES NO
## YES 1689 0
## NO 0 0
## NO RESPONSE 0 0
table(clonedData$beatWife_arguesHusband,clonedData$supportDV)
##
## YES NO
## YES 1618 0
## NO 0 0
## NO RESPONSE 0 0
table(clonedData$beatWife_neglectChildren,clonedData$supportDV)
##
## YES NO
## YES 2186 0
## NO 0 0
## NO RESPONSE 0 0
table(clonedData$beatWife_refuseSex,clonedData$supportDV)
##
## YES NO
## YES 1347 0
## NO 0 0
## NO RESPONSE 0 0
table(clonedData$beatWife_burnFood,clonedData$supportDV)
##
## YES NO
## YES 817 0
## NO 0 0
## NO RESPONSE 0 0
table(clonedData$agegroups,clonedData$supportDV)
##
## YES NO
## 20 - 24 809 0
## 25 - 29 590 0
## 30 - 34 500 0
## 35 - 39 516 0
## 40 - 44 477 0
## 45 - 49 392 0
table(clonedData$ageDiference,clonedData$supportDV)
##
## YES NO
## -28 0 0
## -26 0 0
## -25 2 0
## -24 0 0
## -23 1 0
## -22 0 0
## -21 0 0
## -19 0 0
## -18 3 0
## -17 1 0
## -15 0 0
## -14 1 0
## -13 0 0
## -11 1 0
## -10 1 0
## -9 1 0
## -8 6 0
## -7 4 0
## -6 6 0
## -5 4 0
## -4 12 0
## -3 16 0
## -2 15 0
## -1 34 0
## 0 59 0
## 1 121 0
## 2 183 0
## 3 208 0
## 4 223 0
## 5 221 0
## 6 156 0
## 7 170 0
## 8 142 0
## 9 100 0
## 10 122 0
## 11 72 0
## 12 77 0
## 13 70 0
## 14 50 0
## 15 65 0
## 16 38 0
## 17 28 0
## 18 26 0
## 19 26 0
## 20 22 0
## 21 20 0
## 22 19 0
## 23 13 0
## 24 11 0
## 25 7 0
## 26 15 0
## 27 6 0
## 28 9 0
## 29 6 0
## 30 5 0
## 31 2 0
## 32 4 0
## 33 6 0
## 34 3 0
## 35 3 0
## 36 0 0
## 37 1 0
## 39 0 0
## 40 4 0
## 42 0 0
## 43 1 0
## 45 1 0
## 50 1 0
## 52 1 0
# t.test cannot be performed because NAs are affecting the factors in the variables
# >t.test(clonedData$education ~ clonedData$supportDV)
#<>Error in t.test.formula(clonedData$ageDiference ~ clonedData$supportDV) :
#<>grouping factor must have exactly 2 levels
boxplot(clonedData$agePartner,clonedData$suportDv, main='age of partners and domestic violence support status', xlab='support domestic violence',ylab='age', col='red')
## Warning: Unknown or uninitialised column: `suportDv`.

boxplot(clonedData$ageDiference,clonedData$suportDv, main='age difference and domestic violence support status', xlab='support domestic violence',ylab='age difference',col = 'gold' )
## Warning: Unknown or uninitialised column: `suportDv`.

boxplot(clonedData$childrenEverBorn,clonedData$suportDv, main='children everborn and domestic violence support status', xlab='support domestic violence',ylab='children everborn',col='green' )
## Warning: Unknown or uninitialised column: `suportDv`.
