The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Angola MIS 2011 - uneven quintile distribution
Angola MIS 2011 - uneven quintile distribution [message #9415] Thu, 24 March 2016 22:29 Go to next message
KenzoFry is currently offline  KenzoFry
Messages: 21
Registered: December 2015
Location: UK
Member
Hi,

In the household recode (SPSS) for Angola MIS 2011, I weighted by hhmemwt calculated as hv012*hv005/1000000 which I think is the usual procedure for the wealth index. Normally, running frequencies on HV270 (wealth quintiles) then shows that 20% of the weighted dataset is in each quintile.

However, in this case, each quintile did not have 20% of the population in each. Rather the distribution (according to HV270) was as follows: Poorest - 11.9%, Poorer - 12.3%, Middle - 16.5%, Richer - 28%, Richest - 31.4%.

I think I may have missed or misunderstood something. Could you let us know why this might be?

Thanks for your help,

Kenzo


EquityTool.org
Re: Angola MIS 2011 - uneven quintile distribution [message #9429 is a reply to message #9415] Sat, 26 March 2016 22:24 Go to previous messageGo to next message
user-rhs is currently offline  user-rhs
Messages: 132
Registered: December 2013
Senior Member
Did you try weighting by hv005/1000000 instead of hv012*hv005/1000000?
Re: Angola MIS 2011 - uneven quintile distribution [message #9441 is a reply to message #9429] Mon, 28 March 2016 17:20 Go to previous message
KenzoFry is currently offline  KenzoFry
Messages: 21
Registered: December 2015
Location: UK
Member
Hi, yes I tried that and also tried it unweighted. None produced an even 20% in each quintile.

EquityTool.org
Previous Topic: Pakistan DHS 2012-13 - difference in number of respondents
Next Topic: SPSS ORDERS WEALTH INDEX
Goto Forum:
  


Current Time: Fri Mar 29 04:54:51 Coordinated Universal Time 2024