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