Hi all, I have done a nutrition survey in 3 districts under a region and I want to know the average for the region. I think I have to calculate weight factor for each districts to get the regional level average. Would you please show me how to calculate weight factor? Thanks a lot!
Hi, if you get from this link the WFP Comprehensive Food security and Vulnerability analisys guidelines, you can find in chapter 4 a detailed description on how to calculate weight factor. Hope it helps. http://www.wfp.org/food-security/guidelines
Rossella

Answered:

13 years ago
The usual approach is to take a weighted average. To do this you need to have some idea of the (relative) population of each district. Example: Prevalences: District 1 : 7.6% District 2 : 9.3% District 3 : 5.4% If you have populations : District 1 : 123,000 District 2 : 91,000 District 3 : 52,000 Then the regional average is: (7.6 * 123000 + 9.3 * 91000 + 5.4 * 52000) / (123000 + 91000 + 52000) = 7.75% It is best to have population data but coarse weights based on relative sizes can work. Using the example above we might use small (1), medium (2), large (3) as coarse weights: p = (7.6 * 3 + 9.3 * 2 + 5.4 * 1) / (3 + 2 + 1) = 7.8% There are alternative approaches to weighting but they are usually, at bottom, just alternative ways of taking a weighted average. You may need to use these alternative methods with stats packages. The tricky bit is in calculating a confidence interval. This may be more difficult in your case as you already have a complex (i.e. cluster) sample at the district level. I suggest that you do this with software that can work with such a complex sample. A "rough and ready" approach would be to use a weighted average of the upper and lower 95% confidence limits from the district level samples. This is very much an approximate method. I hope this helps.
Mark Myatt
Technical Expert

Answered:

13 years ago
Please login to post an answer:
Login