The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Quintile cutoffs - weighted and unweighted
Quintile cutoffs - weighted and unweighted Sun, 22 May 2016 20:44
 KenzoFry Messages: 21Registered: December 2015 Location: UK Member
Hi,

It appears that in the composite tab of many of the the excel files, the quintile cut-offs are given from an unweighted analysis. For example, Kenya DHS 2014 or Cambodia DHS 2014 have an n that is the same as the number of respondents in the dataset. In other countries, such as Philippines DHS 2013 or Madagascar DHS 2008 the quintile cutoffs are presented from a weighted analysis. It would be great to know why this is. Also, am I right to think that generally, the quintile cutoffs should be calculated after weighting using hhmemwt?

Thanks

Kenzo

EquityTool.org
Re: Quintile cutoffs - weighted and unweighted [message #10107 is a reply to message #9804] Tue, 28 June 2016 10:18
 k322a Messages: 3Registered: June 2016 Member
Hi,

Hope to know if you managed to solve this? I am also having issues replicating the quintile (cutoffs). This is my code for the 2010 Tanzania DHS -

xtile _5=hv271 [pw=cond(hv012==0,hv005*hv013,hv005*hv012)] , n(5)

. ta _5 hv270

5 |
quantiles | Wealth index
of hv271 | Poorest Poorer Middle Richer Richest | Total
-----------+------------------------------------------------ -------+----------
1 | 1,889 93 0 0 0 | 1,982
2 | 0 1,802 12 0 0 | 1,814
3 | 0 0 1,711 0 0 | 1,711
4 | 0 0 188 1,841 0 | 2,029
5 | 0 0 0 221 1,866 | 2,087
-----------+------------------------------------------------ -------+----------
Total | 1,889 1,895 1,911 2,062 1,866 | 9,623

Any help would be much appreciated.

Kerry
Re: Quintile cutoffs - weighted and unweighted [message #10734 is a reply to message #10107] Tue, 06 September 2016 17:18
 Liz-DHS Messages: 1516Registered: February 2013 Senior Member
Dear User,
Do you still need assistance with this post?
Thanks!
Re: Quintile cutoffs - weighted and unweighted [message #11594 is a reply to message #9804] Fri, 13 January 2017 16:03
 KenzoFry Messages: 21Registered: December 2015 Location: UK Member
Hi Liz,

yes a reply as to why some of the composite tabs show weighted analysis and some show unweighted would be much appreciated. Thanks,

Kenzo

EquityTool.org
 Previous Topic: Wealth Index Spatial Data Next Topic: Indonesia Sanitation Options
Goto Forum:

Current Time: Sun Jun 23 12:49:25 Coordinated Universal Time 2024