| Re: Calculating a Representative Wealth Index for Clusters Using DHS Sample Weights [message #30616 is a reply to message #30598] |
Wed, 08 January 2025 14:11  |
Janet-DHS
Messages: 937 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
Yes, the sample weight is the same for all households in the same cluster. If you want a single number to describe the cluster, it would be the unweighted mean. The best number to describe dispersion is probably just the standard deviation. The following analytical study could be helpful: https://www.dhsprogram.com/pubs/pdf/AS76/AS76.pdf.
Note that the wealth index is calculated with households as units. I would recommend calculating the cluster-level means and standard deviations within the HR file, and then copying those numbers into the other files you are using.
|
|
|
|
|
|
| Re: Calculating a Representative Wealth Index for Clusters Using DHS Sample Weights [message #30705 is a reply to message #30669] |
Tue, 21 January 2025 16:06  |
Janet-DHS
Messages: 937 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
I'm not sure that I understand the difference between your two calculations, but I will suggest a requirement or criterion: the weighted mean of the RWI should be the same as the weighted mean of hv270, in each cluster and in the sample of households as a whole. Here are the Stata commands I would use, illustrated for the Kenya 2022 survey, and within that, for cluster #1.
use "...KEHR8CFL.DTA" , clear
keep hv001 hv002 hv005 hv270
* Construct RWI
egen RWI=mean(hv270), by(hv001)
list if hv001==1, table clean nolabel
* compare the weighted means of hv270 and RWI within a specific cluster
summarize hv270 RWI [iweight=hv005/1000000] if hv001==1
* compare the weighted means of hv270 and RWI in the entire sample
summarize hv270 RWI [iweight=hv005/1000000]
If you are doing something other than this, I wonder what it is. If you are just comparing weighted and unweighted estimates, then it is not surprising that there will be some differences in any analysis. My preference would be for weighted estimates. Here I do not use weights to calculate RWI but DO use weights in any statistical analysis, exactly as I would do with hv270.
|
|
|
|