The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Problem with recreating Asset quintiles
Problem with recreating Asset quintiles Wed, 08 June 2022 14:33
 Preksha Mishra Messages: 5Registered: June 2022 Member
Hi, I am attempting to recreate the Asset Quintiles for India(2015-16) as provided in the data basis cut-off points derived from the wealth index factor score (hv271 in PR file). I haves subset for de cure population before creation of quintiles.

My issue is that finding quintile cut-off points in R is not giving me the same Asset quintiles for roughly 780 observations. I am assuming that this is because my cut-off points are incorrect.

a) Can the factor score given in the dataset directly be used to make quintiles weighted by hv005/100000 (Wt_nat) in the PR file? If not then how to go about it?

b) If (a) is correct, then what could be the reason why my cut off points differ from the one used to the construct the quintile?

This is what I got using the following:
check_bins\$quintile2 <- with(check_bins, cut(hv271,
breaks= wtd.quantile (hv271, q=seq(0,1, by=0.2), na.rm = FALSE, weight = Wt_nat),
include.lowest=TRUE, labels = c(1,2,3,4,5)))

20% -0.92065
40% -0.26808
60% 0.38776
80%. 1.06845

However, this is what was given in the wealth index excel file under Combined national wealth score tab. Are these the cut-off points?

20% -.9294019
40% -.2665299
60% .3948751
80% 1.0727570

I would really appreciate any help in this regard!

[Updated on: Wed, 08 June 2022 14:43]

Report message to a moderator

 Problem with recreating Asset quintiles By: Preksha Mishra on Wed, 08 June 2022 14:33 Re: Problem with recreating Asset quintiles By: Janet-DHS on Thu, 09 June 2022 08:36 Re: Problem with recreating Asset quintiles By: Preksha Mishra on Fri, 10 June 2022 02:07 Re: Problem with recreating Asset quintiles By: Preksha Mishra on Fri, 10 June 2022 02:30 Re: Problem with recreating Asset quintiles By: Janet-DHS on Mon, 13 June 2022 11:11
 Previous Topic: sub-national wealth quintiles in STATcompiler Next Topic: Not positive definite correlation matrix
Goto Forum:

Current Time: Fri Mar 1 15:20:05 Coordinated Universal Time 2024