The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
Zimbabwe 2015 Wealth Index quintiles
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=13560&th=6545#msg_13560
I am working with the 2015 Zimbabwe DHS to replicate the wealth quintiles. I want to apply the cut-off values to a wealth index we collected in rural Zimbabwe (we asked the same questions used in ZDHS 2015) to show how our sample compares to the population of Masvingo county (where our survey was fielded).
I am trying to replicate the quintiles in Stata. But they are not exactly as in the spreadsheet provided.
In the spreadsheet, the values are:
Mean -.1347808
Std. Error of Mean .00903679
Median -.3942115
Mode .03433a
Std. Deviation .92749292
Minimum -1.63862
Maximum 3.24577
Percentiles
20 -1.0280612
40 -.6095050
60 -.0076580
80 .8723670
Here is how I calculated the HHMEMWT:
gen dejure = hv012
replace dejure = hv013 if hv012 == 0
gen HHMEMWT = (dejure*hv005)/1000000
After weighting, I have the same number of observations and min/max as the spreadsheet but a different mean and slightly different standard deviation: :
. sum hv271 [aw=HHMEMWT]
Variable | Obs Weight Mean Std. Dev. Min Max
-------------+---------------------------------------------- -------------------
hv271 | 10,534 42909.8382 -183250.4 927336 -1638620 3245770
The output from using xtile in Stata gives the below, which does not match the spreadsheet:
Why does creating quintiles in Stata not match the principal component output?
Many thanks!
Amy]]>amyfinnegan2017-11-18T21:17:12-00:00Re: Zimbabwe 2015 Wealth Index quintiles
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14150&th=6545#msg_14150
Quote:
The statistics of the combined national wealth score are calculated using the household weights (hv005, not hhmemwt). The quintiles are calculated using hhmemwt. That is the difference.
]]>Liz-DHS2018-02-26T16:47:37-00:00Re: Zimbabwe 2015 Wealth Index quintiles
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14154&th=6545#msg_14154
Thank you for this information!
I can see now that when we want to know the population level statistics of the wealth distribution, we use the household weight (hv005). When we want to know how to divide the households into quintiles, we must use the hhmemwt.
All the best,
Amy]]>amyfinnegan2018-02-26T19:00:06-00:00Re: Zimbabwe 2015 Wealth Index quintiles
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14328&th=6545#msg_14328
Do you happen to have the state a syntax that creates wealth quintiles for Zimbabwe. I need to use it elsewhere. With thanks]]>mmapingure2018-03-23T02:03:17-00:00Re: Zimbabwe 2015 Wealth Index quintiles
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=15321&th=6545#msg_15321
Liz-DHS2018-06-28T15:50:05-00:00