The DHS Program User Forum: Weighting data

Home » Data » Weighting data » HR Files (Queries regarding percentage calculation)

Show: Today's Messages :: Show Polls :: Message Navigator

HR Files [message #29108]

Wed, 24 April 2024 11:36

Lubana
Messages: 3
Registered: January 2024

Member

Hello,

I am a new DHS data user and I am not familiar with programming languages. Therefore, for my analysis, I am using ArcGIS Pro. My apologies for any inconvenience this may cause.

I am conducting a social vulnerability assessment to climate change impacts using DHS data for Kenya. I am encountering some difficulties in calculating DHS indicators. The following DHS datasets are being utilized for the analysis: KEHR8BSD.zip, KEGC8AFL.zip, and sdr_subnational_boundaries.shp.

I attempted to calculate the percentage of various indicators, such as the percentage of female-headed households (HHs), households with a population aged 65 and over, households with a population aged 13 to 18 years, literate households, households with access to improved water and sanitation, and the wealth index.

It's worth noting that the Humanitarian Data Exchange (HDE) contains the percentage of a range of demographic and socioeconomic indicators at the subnational administrative level 1 for Kenya, derived from DHS 2022 data.

However, upon completing the calculations, I noticed discrepancies between the results obtained from GIS analysis and the percentages provided on the HDE website. I am unsure why these differences exist. I did not apply any weight to my dataset because the process was confusing to me. Despite watching videos and reading resources from the DHS website, I still lack clarity on this matter.

Therefore, I have several questions:

--Why am I getting different results?
--Do I need to apply weight to calculate the percentage of households with access to improved water and sanitation?
--If weight application is necessary, how can I accomplish this in GIS software?

I would greatly appreciate your assistance with this matter. I have attached a document outlining the steps I followed to join DHS Census Data with DHS Spatial Data, aggregate at the subnational administrative level 1, and calculate two indicators as examples (i.e., the percentage of households with access to improved water and the percentage of households with access to improved sanitation). This document also includes results obtained from ArcGIS Pro and the HDE website. I have also attached excel files data downloaded from HDE website for the year 2022 for your convenience.

Any help will be highly appreciated. I need it urgently. Please let me know if you need any other clarification.

Thank you.

Attachment: Results.xlsx
(Size: 14.19KB, Downloaded 106 times)
Attachment: Spatial join and calculation steps.docx
(Size: 29.25KB, Downloaded 84 times)
Attachment: Toilet Facility_subnational Ken_2022_HDE.xlsx
(Size: 225.71KB, Downloaded 72 times)
Attachment: Water_Subnational_Kenya_2022_HDE.xlsx
(Size: 227.61KB, Downloaded 70 times)

Report message to a moderator

[Message index]

		HR Files By: Lubana on Wed, 24 April 2024 11:36
		Re: HR Files By: Bridgette-DHS on Thu, 25 April 2024 07:41
		Re: HR Files By: Lubana on Thu, 25 April 2024 09:40
		Re: HR Files By: Bridgette-DHS on Fri, 26 April 2024 11:09

Previous Topic:	MULTILEVEL MODELING USING DHS SURVEYS: APPROXIMATE LEVEL-WEIGHTS for Kenya DHS Surveys
Next Topic:	STATCompiler for pooled prevalences

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 30 16:31:22 Coordinated Universal Time 2024