The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Estimation of cutoff points for Rwanda 2014-15 wealth index
Re: Estimation of cutoff points for Rwanda 2014-15 wealth index [message #12387 is a reply to message #12298] Mon, 08 May 2017 16:26 Go to previous messageGo to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 805
Registered: January 2013
Senior Member
Combscor is the same as hv271, but the percentiles from combscor that you show below are actually weighted percentiles for households (total of 12699 households), not for household members, so are not the actual quintile cutoffs.

Your code for calculating the quintiles produces virtually identical results to those in hv270, apart from four cases:
. list hv271 hv270 hhwealth if hv270 != hhwealth

       +-----------------------------+
       |  hv271     hv270   hhwealth |
       |-----------------------------|
 7064. | -66470    poorer          1 |
 7743. |  40088   richest          4 |
 7973. | -63769    poorer          . |
11711. | -14147    richer          3 |
       +-----------------------------+

I think there are two reasons for the slight differences:
1) There is one case for which you have hhwealth == . This is because there is 1 household with 0 de jure members listed. For the few households that we get with 0 de jure members listed, we use the de facto number of members instead. thus we might have
gen ppl=hv012
replace ppl=hv013 if hv012==0
gen hhweight = (hv005*ppl)/1000000

2) I think there is some rounding going on. The other 3 cases above are all right at the quintile boundaries that you calculated. When we calculate the quintiles we actually have more digits of precision of the scores. We use the SPSS Rank command and I expect that there are slightly different rules about selection of quintiles between the SPSS Rank and the Stata _pctile commands, in addition to the precision issue.
So I can't fully explain the differences, but hopefully this gives you enough to work with.
 
Read Message
Read Message
Read Message
Previous Topic: PCA Results for Sierra Leone 2013 Survey?
Next Topic: Construction
Goto Forum:
  


Current Time: Sun Dec 22 02:48:19 Coordinated Universal Time 2024