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 [message #9804] Sun, 22 May 2016 20:44 Go to next message
KenzoFry is currently offline  KenzoFry
Messages: 21
Registered: 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 Go to previous messageGo to next message
k322a is currently offline  k322a
Messages: 3
Registered: 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 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: 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 Go to previous message
KenzoFry is currently offline  KenzoFry
Messages: 21
Registered: 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: Thu Dec 5 22:39:22 Coordinated Universal Time 2024