The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Indonesia DHS 2012 published factor weight file mislabelling
Indonesia DHS 2012 published factor weight file mislabelling [message #10063] Tue, 21 June 2016 12:45 Go to next message
KenzoFry is currently offline  KenzoFry
Messages: 21
Registered: December 2015
Location: UK
Member
Hi,

while working through Indonesia DHS 2012's wealth index to help a colleague that had used it, I noticed that two variables relating to toilet type - 'Flush toilet to sewer' (mean = 0.5936) and 'Flush toilet to septic tank' (mean = 0.0627) - may have been mislabelled.

The variable HV205 (toilet type) does not contain these options. It contains the options 'Private - with Septic Tank' and 'Private - without Septic Tank'. These also match the questionnaire as in the report.

The unweighted proportion of people with 'Private with septic tank' is 59.4% and for Private without septic tank it is 6.3% - matching the means for the two mislabelled variables. In other words, if this is correct, I think the file should be corrected as follows:

'Flush toilet to sewer' changed to 'Private with septic tank'
'Flush toilet to septic tank' change to 'Private without septic tank'

Another issue is with the variable "Bedroom available for sleep". Scores are given for this variable for 'if has' and 'if doesn't have', as if this is a binary variable. However, since its mean is 2.2 it seems this is actually a continuous variable more accurately described as 'number of bedrooms available for sleep'.

Thanks,

Kenzo



EquityTool.org
Re: Indonesia DHS 2012 published factor weight file mislabelling [message #10101 is a reply to message #10063] Mon, 27 June 2016 16:37 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 800
Registered: January 2013
Senior Member
Thanks - this looks like you are correct. We will review and update as necessary.
Re: Indonesia DHS 2012 published factor weight file mislabelling [message #10103 is a reply to message #10101] Mon, 27 June 2016 16:49 Go to previous message
KenzoFry is currently offline  KenzoFry
Messages: 21
Registered: December 2015
Location: UK
Member
Brilliant thank you Trevor

EquityTool.org
Previous Topic: Comparative Wealth Index for BDHS-2014
Next Topic: Equity index
Goto Forum:
  


Current Time: Thu Jul 18 12:43:07 Coordinated Universal Time 2024