Sampling Weight Demo

Sampling Weights

Dataset used: Ghana MICS6 Packages used: survey, srvyr

Importing the Ghana MICS6 Dataset

The Ghana MICS6 Dataset:

1. Non-self-weighted
2. Multi-stage, stratified cluster sampling approach.
3. Sampling Weights: To handle non-response and sub-samples. fsweight and fshweight are the Children 5-17’s and Children 5-17’s household sample weight respectively.
4. PSU is the Primary Sampling Unit : The Enumeration Areas
5. stratum is the strata variable that factors in the Region (WESTERN,CENTRAL,GREATER ACCRA,VOLTA,EASTERN,ASHANTI,BRONG AHAFO,NORTHERN,UPPER EAST,UPPER WEST) and the Area (urban or rural)

Importing the Ghana MICS6 Dataset.

# <- read_sav("C:/Users/user/Downloads/Raw Datasets MICS6/Ghana MICS6 SPSS Datasets/Ghana MICS6 SPSS Datasets/wm.sav") 

fs_ghana <- read_sav("C:/Users/user/Downloads/Raw Datasets MICS6/Ghana MICS6 SPSS Datasets/Ghana MICS6 SPSS Datasets/fs.sav")
Ghana <- Child_Labour(fs_ghana)
#str(Ghana)

fsweight and fshweight are the Children 5-17’s and Children 5-17’s household sample weight respectively

The sum of all weights in fs_weight shoul give the total population it is representing.

According to the Findings Report, https://mics.unicef.org/sites/mics/files/Ghana%202017-18%20MICS%20Survey%20Findings%20Report_English.pdf “A sub-sample of children age 5-17 years was used to administer the questionnaire for children of age 5-17 years. Only one child was selected randomly in each household interviewed, and there were 21,760 children (5-17 years) listed in the household questionnaires. Of these, 8,965 children (5-17 years) were selected, and questionnaires were completed for 8,946 which corresponds to a response rate of 99.8 percent within the interviewed households. Overall response rates of 97.8, 96.7, 99.2 and 99.2 percent are calculated for the individual interviews of women, men, under-5s, and children age 5-17 years, respectively”

sum(fs_ghana[["fsweight"]])

## [1] 21871.24

For ages 10 -17:

sum(Ghana[["fsweight"]])

## [1] 12295.53

Univariate Analysis

Without Weights (Continuous Data Univariates)

Variable	Question	Valid.Number	Mean	SD	Minimum	Maximum
CB3	Age of Child	5,107	13.23	2.23	10.00	17.00
CB5B	Highest grade attended at that level	4,933	3.34	1.70	1.00	6.00
CB8B	Grade attended at that level attended current school year	4,576	3.36	1.71	1.00	6.00
CL3	Hours worked in past week	2,317	9.09	10.94	0.00	80.00
CL8	Hours spent fetching water in past week	3,404	6.16	8.99	0.00	80.00
CL10	Hours spent collecting firewood in past week	1,229	4.35	5.97	0.00	60.00
CL13	Number of hours engaged in past week	4,580	8.07	10.37	0.00	80.00
PSU	Primary sampling unit	5,107	346.79	190.89	1.00	660.00
fsweight	Children 5-17's sample weight	5,107	2.41	3.09	0.03	66.64
fshweight	Children 5-17's household sample weight	5,107	0.97	0.93	0.03	16.66

With Weights (Continuous Data Univariates) using Univariate_Continuous_weight(Ghana).

The difference is that its uses the package srvyr

Change data from “tbl_df” to “tbl_svy” using as_survey_design

frame_zap <- zap_labels(frame) frame_survey <- frame_zap %>% as_survey_design(ids = PSU, weights = fsweight)

Functions used in analysis:survey_mean(),survey_sd(),survey_quantile(),survey_total,etc.

Variable	Question	Weighted Total	Mean	SD	Minimum	Maximum
CB3	Age of Child	12,296	13.21	2.20	10	17
CB5B	Highest grade attended at that level	11,926	3.33	1.66	1	6
CB8B	Grade attended at that level attended current school year	11,066	3.34	1.67	1	6
CL3	Hours worked in past week	5,607	8.55	9.98	0	80
CL8	Hours spent fetching water in past week	8,386	5.62	8.45	0	80
CL10	Hours spent collecting firewood in past week	3,143	4.17	6.31	0	60
CL13	Number of hours engaged in past week	11,134	7.73	9.91	0	80
PSU	Primary sampling unit	12,296	310.82	167.59	1	660
fsweight	Children 5-17's sample weight	12,296	6.36	7.30	0	67
fshweight	Children 5-17's household sample weight	12,296	1.87	1.69	0	17

With Weights (Categorical Data Univariates)

Variable	Question	Factors	Frequency	Percentage	ValidPercentage
HL4	Sex	Female	6,089	49.52	49.52
		Male	6,206	50.48	50.48
		Total	12,295	100.00	100.00
CB4	School or Early Childhood Programme	NO	322	2.62	2.62
		YES	11,973	97.38	97.38
		Total	12,295	100.00	100.00
CB5A	Highest level of education attended	EARLY CHILDHOOD EDUCATION	48	0.40	0.40
		Higher	7	0.06	0.06
		JSS/JHS	4,428	36.98	36.98
		MIDDLE	0	0.00	0.00
		PRIMARY	6,828	57.02	57.02
		SSS/SHS/TECH/VOC/COMM	663	5.54	5.54
		Total	11,974	100.00	100.00
CB7	Attended school or early childhood programme during current school year	NO	864	7.22	7.22
		YES	11,109	92.78	92.78
		Total	11,973	100.00	100.00
CB8A	Level of education attended current school year	EARLY CHILDHOOD EDUCATION	43	0.39	0.39
		Higher	7	0.06	0.06
		JSS/JHS	4,097	36.88	36.88
		PRIMARY	6,338	57.05	57.05
		SECONDARY/TECH/VOC/COMM	0	0.00	0.00
		SSS/SHS/TECH/VOC/COMM	625	5.63	5.63
		Total	11,110	100.00	100.00
caretakerdis	Functional difficulties (18-49 years old)	7	3,814	31.02	31.02
		Has a functional difficulty (A une difficulté fonctionnelle)	1,053	8.56	8.56
		Has no functional difficulty (N'a aucune difficulté fonctionnelle)	7,428	60.41	60.41
		Total	12,295	100.00	100.00
CL1TOTAL	Engaged in any income generating activity in past week	NO	6,683	54.38	54.38
		YES	5,607	45.62	45.62
		Total	12,290	100.00	100.00
CL1A	Worked or helped on garden in past week	NO	8,259	67.17	67.17
		YES	4,036	32.83	32.83
		Total	12,295	100.00	100.00
CL1B	Helped in family business in past week	NO	9,853	80.13	80.13
		YES	2,443	19.87	19.87
		Total	12,296	100.00	100.00
CL1C	Produced or sold articles in past week	NO	10,963	89.20	89.20
		YES	1,328	10.80	10.80
		Total	12,291	100.00	100.00
CL1X	Engaged in any other activity for income in past week	NO	10,871	88.41	88.41
		YES	1,425	11.59	11.59
		Total	12,296	100.00	100.00
CL4	Activities required carrying heavy loads	NO	3,762	67.09	67.09
		YES	1,845	32.91	32.91
		Total	5,607	100.00	100.00
CL5	Activities required working with dangerous tools or heavy machinery	NO	3,651	65.12	65.12
		YES	1,956	34.88	34.88
		Total	5,607	100.00	100.00
CL6A	Description of work: exposed to dust, fumes, or gas	NO	4,225	75.35	75.35
		YES	1,382	24.65	24.65
		Total	5,607	100.00	100.00
CL6B	Description of work: exposed to extreme temperatures or humidity	NO	3,902	69.59	69.59
		YES	1,705	30.41	30.41
		Total	5,607	100.00	100.00
CL6C	Description of work: exposed to loud noise or vibration	NO	5,229	93.26	93.26
		YES	378	6.74	6.74
		Total	5,607	100.00	100.00
CL6D	Description of work: required to work at heights	NO	5,238	93.42	93.42
		YES	369	6.58	6.58
		Total	5,607	100.00	100.00
CL6E	Description of work: required to work with chemicals	NO	5,251	93.65	93.65
		YES	356	6.35	6.35
		Total	5,607	100.00	100.00
CL6X	Description of work: exposed to other conditions bad for health	NO	5,125	91.44	91.44
		YES	480	8.56	8.56
		Total	5,605	100.00	100.00
CL7	Fetched water in past week	NO	3,909	31.79	31.79
		YES	8,386	68.21	68.21
		Total	12,295	100.00	100.00
CL9	Collected firewood in past week	NO	9,147	74.43	74.43
		YES	3,143	25.57	25.57
		Total	12,290	100.00	100.00
CL11A	Household chores in past week: shopping	NO	8,038	65.37	65.37
		YES	4,258	34.63	34.63
		Total	12,296	100.00	100.00
CL11B	Household chores in past week: cooking	NO	7,005	56.97	56.97
		YES	5,291	43.03	43.03
		Total	12,296	100.00	100.00
CL11C	Household chores in past week: washing dishes or cleaning around the house	NO	3,506	28.51	28.51
		YES	8,790	71.49	71.49
		Total	12,296	100.00	100.00
CL11D	Household chores in past week: washing clothes	NO	3,055	24.85	24.85
		YES	9,240	75.15	75.15
		Total	12,295	100.00	100.00
CL11E	Household chores in past week: caring for children	NO	8,256	67.15	67.15
		YES	4,039	32.85	32.85
		Total	12,295	100.00	100.00
CL11F	Household chores in past week: caring for old or sick	NO	11,659	94.83	94.83
		YES	636	5.17	5.17
		Total	12,295	100.00	100.00
CL11X	Household chores in past week: other household tasks	NO	10,435	84.86	84.86
		YES	1,861	15.14	15.14
		Total	12,296	100.00	100.00
FCF25	How often child seems very anxious, nervous or worried	A few times a year	4,621	37.60	37.60
		Daily	531	4.32	4.32
		Monthly	952	7.75	7.75
		Never	5,769	46.94	46.94
		Weekly	418	3.40	3.40
		Total	12,291	100.00	100.00
FCF26	How often child seems very sad or depressed	A few times a year	5,008	40.73	40.73
		Daily	382	3.11	3.11
		Monthly	882	7.17	7.17
		Never	5,623	45.73	45.73
		Weekly	401	3.26	3.26
		Total	12,296	100.00	100.00

Without Weights (Categorical Data Univariates)

## Warning in Univariate_Categorical(Ghana): CB3 is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): CB5B is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): CB8B is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): CL3 is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): CL8 is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): CL10 is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): CL13 is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): PSU is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): fsweight is numeric, Univariate
## Categorical ignores this variable.

## Warning in Univariate_Categorical(Ghana): fshweight is numeric, Univariate
## Categorical ignores this variable.

Variable	Question	Frequency	Percentage	Valid Percentage
HL4	Sex
Female		2532	49.6%	49.6%
Male		2575	50.4%	50.4%
Total		5107	100.0%	100.0%
CB4	School or Early Childhood Programme
NO		155	3.0%	3.0%
YES		4952	97.0%	97.0%
Total		5107	100.0%	100.0%
CB5A	Highest level of education attended
EARLY CHILDHOOD EDUCATION		19	0.4%	0.4%
Higher		5	0.1%	0.1%
JSS/JHS		1798	35.2%	36.3%
MIDDLE		1	0.0%	0.0%
PRIMARY		2840	55.6%	57.4%
SSS/SHS/TECH/VOC/COMM		289	5.7%	5.8%
		155	3.0%	-
Total		5107	100.0%	100.0%
CB7	Attended school or early childhood programme during current school year
NO		354	6.9%	7.1%
YES		4598	90.0%	92.9%
		155	3.0%	-
Total		5107	100.0%	100.0%
CB8A	Level of education attended current school year
EARLY CHILDHOOD EDUCATION		22	0.4%	0.5%
Higher		5	0.1%	0.1%
JSS/JHS		1656	32.4%	36.0%
PRIMARY		2642	51.7%	57.5%
SECONDARY/TECH/VOC/COMM		1	0.0%	0.0%
SSS/SHS/TECH/VOC/COMM		272	5.3%	5.9%
		509	10.0%	-
Total		5107	100.0%	100.0%
caretakerdis	Functional difficulties (18-49 years old)
7		1946	38.1%	38.1%
Has a functional difficulty (A une difficulté fonctionnelle)		375	7.3%	7.3%
Has no functional difficulty (N'a aucune difficulté fonctionnelle)		2786	54.6%	54.6%
Total		5107	100.0%	100.0%
CL1TOTAL	Engaged in any income generating activity in past week
NO		2789	54.6%	54.6%
YES		2317	45.4%	45.4%
		1	0.0%	-
Total		5107	100.0%	100.0%
CL1A	Worked or helped on garden in past week
NO		3439	67.3%	67.3%
YES		1668	32.7%	32.7%
Total		5107	100.0%	100.0%
CL1B	Helped in family business in past week
NO		4151	81.3%	81.3%
YES		956	18.7%	18.7%
Total		5107	100.0%	100.0%
CL1C	Produced or sold articles in past week
NO		4624	90.5%	90.6%
YES		482	9.4%	9.4%
		1	0.0%	-
Total		5107	100.0%	100.0%
CL1X	Engaged in any other activity for income in past week
NO		4516	88.4%	88.4%
YES		591	11.6%	11.6%
Total		5107	100.0%	100.0%
CL4	Activities required carrying heavy loads
NO		1560	30.5%	67.3%
YES		757	14.8%	32.7%
		2790	54.6%	-
Total		5107	100.0%	100.0%
CL5	Activities required working with dangerous tools or heavy machinery
NO		1594	31.2%	68.8%
YES		722	14.1%	31.2%
		2791	54.7%	-
Total		5107	100.0%	100.0%
CL6A	Description of work: exposed to dust, fumes, or gas
NO		1771	34.7%	76.4%
YES		546	10.7%	23.6%
		2790	54.6%	-
Total		5107	100.0%	100.0%
CL6B	Description of work: exposed to extreme temperatures or humidity
NO		1666	32.6%	71.9%
YES		650	12.7%	28.1%
		2791	54.7%	-
Total		5107	100.0%	100.0%
CL6C	Description of work: exposed to loud noise or vibration
NO		2166	42.4%	93.5%
YES		151	3.0%	6.5%
		2790	54.6%	-
Total		5107	100.0%	100.0%
CL6D	Description of work: required to work at heights
NO		2174	42.6%	93.8%
YES		143	2.8%	6.2%
		2790	54.6%	-
Total		5107	100.0%	100.0%
CL6E	Description of work: required to work with chemicals
NO		2181	42.7%	94.1%
YES		136	2.7%	5.9%
		2790	54.6%	-
Total		5107	100.0%	100.0%
CL6X	Description of work: exposed to other conditions bad for health
NO		2128	41.7%	91.9%
YES		187	3.7%	8.1%
		2792	54.7%	-
Total		5107	100.0%	100.0%
CL7	Fetched water in past week
NO		1702	33.3%	33.3%
YES		3404	66.7%	66.7%
		1	0.0%	-
Total		5107	100.0%	100.0%
CL9	Collected firewood in past week
NO		3875	75.9%	75.9%
YES		1229	24.1%	24.1%
		3	0.1%	-
Total		5107	100.0%	100.0%
CL11A	Household chores in past week: shopping
NO		3380	66.2%	66.2%
YES		1727	33.8%	33.8%
Total		5107	100.0%	100.0%
CL11B	Household chores in past week: cooking
NO		3010	58.9%	58.9%
YES		2097	41.1%	41.1%
Total		5107	100.0%	100.0%
CL11C	Household chores in past week: washing dishes or cleaning around the house
NO		1401	27.4%	27.4%
YES		3706	72.6%	72.6%
Total		5107	100.0%	100.0%
CL11D	Household chores in past week: washing clothes
NO		1221	23.9%	23.9%
YES		3886	76.1%	76.1%
Total		5107	100.0%	100.0%
CL11E	Household chores in past week: caring for children
NO		3588	70.3%	70.3%
YES		1519	29.7%	29.7%
Total		5107	100.0%	100.0%
CL11F	Household chores in past week: caring for old or sick
NO		4762	93.2%	93.2%
YES		345	6.8%	6.8%
Total		5107	100.0%	100.0%
CL11X	Household chores in past week: other household tasks
NO		4228	82.8%	82.8%
YES		879	17.2%	17.2%
Total		5107	100.0%	100.0%
FCF25	How often child seems very anxious, nervous or worried
A few times a year		1796	35.2%	35.2%
Daily		247	4.8%	4.8%
Monthly		482	9.4%	9.4%
Never		2354	46.1%	46.1%
Weekly		226	4.4%	4.4%
		2	0.0%	-
Total		5107	100.0%	100.0%
FCF26	How often child seems very sad or depressed
A few times a year		1954	38.3%	38.3%
Daily		158	3.1%	3.1%
Monthly		422	8.3%	8.3%
Never		2359	46.2%	46.2%
Weekly		214	4.2%	4.2%
Total		5107	100.0%	100.0%

Logistic Regressions:

Ghana_1<- Ghana

Ghana_1$FCF25_dich <- ifelse(Ghana$FCF25 %in% c("Weekly", "Daily", "Monthly","A few times a year"), 1, 0)
logistic <- glm(FCF25_dich ~ CL1A + CL1B + CL1C + CL1X + CB5A + CB3, data = Ghana_1, family = "binomial",weights = fsweight)

## Warning in eval(family$initialize): non-integer #successes in a binomial glm!

summary(logistic)

## 
## Call:
## glm(formula = FCF25_dich ~ CL1A + CL1B + CL1C + CL1X + CB5A + 
##     CB3, family = "binomial", data = Ghana_1, weights = fsweight)
## 
## Coefficients:
##                            Estimate Std. Error z value Pr(>|z|)    
## (Intercept)                 0.14357    0.34248   0.419 0.675072    
## CL1AYES                    -0.08812    0.04137  -2.130 0.033170 *  
## CL1BYES                     0.02028    0.05289   0.383 0.701408    
## CL1CYES                     0.25513    0.07017   3.636 0.000277 ***
## CL1XYES                     0.22986    0.06965   3.300 0.000966 ***
## CB5AHigher                 -2.74319    1.09522  -2.505 0.012256 *  
## CB5AJSS/JHS                -0.93767    0.31865  -2.943 0.003255 ** 
## CB5AMIDDLE                  8.63956  136.18225   0.063 0.949415    
## CB5APRIMARY                -0.66323    0.31655  -2.095 0.036156 *  
## CB5ASSS/SHS/TECH/VOC/COMM  -0.95733    0.32888  -2.911 0.003604 ** 
## CB3                         0.05508    0.01123   4.905 9.33e-07 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## (Dispersion parameter for binomial family taken to be 1)
## 
##     Null deviance: 16549  on 4950  degrees of freedom
## Residual deviance: 16453  on 4940  degrees of freedom
##   (156 observations deleted due to missingness)
## AIC: 16247
## 
## Number of Fisher Scoring iterations: 8