2022 DHS FGM Prevalence Question [message #27440] |
Mon, 14 August 2023 15:41 |
zoe@kakenyasdream.org
Messages: 1 Registered: August 2023
|
Member |
|
|
I was hoping someone can help me with a calculation related to the FGM prevalence rates reported in the 2022 Kenya DHS.
In the attached PowerPoint downloaded from the DHS site, slide 9 reports that the FGM prevalence for women aged 15-49 in Narok County is 51%, and 77% for Kisii County. I work for a nonprofit organization that services both counties and eliminating FGM is core to our mission. To get a sense of the scope of the prevalence across our full service region, we would like to know what the prevalence of FGM is across both counties combined. I'm unsure of the methodology that was used to derive the aforementioned 51% and 77% figures, and was hoping someone with the DHS Program could kindly make the calculation for me? I have provided below what I assume is correct, but would greatly appreciate if someone could verify the accuracy of my calculations.
I came to the conclusion that the weighted average from Narok and Kisii was 65%. I took into account the population of both counties according to the 2019 Kenya Population and Housing Census on pg 2 of the DHS. 1,146,240 for Narok and 1,259,608 for Kisii.
-
Attachment: 14. FGM.pptx
(Size: 1.87MB, Downloaded 146 times)
|
|
|
Re: 2022 DHS FGM Prevalence Question [message #27472 is a reply to message #27440] |
Fri, 18 August 2023 08:54 |
Bridgette-DHS
Messages: 3199 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
You are on the right track, but it would be preferable to pool the counties using the n's in the data.
I have not used that PowerPoint, but have re-calculated the FGM prevalence by county. (Chapter 18 of the final report does not include county estimates). The Stata lines below show how this is done. The text file "FGM_Kenya_2022_DHS.txt" gives a log file with the results. The pooled estimate for those two counties combined is 65.56%. This could be calculated as a weighted average of 51.01% and 77.29% for the two counties, with n's of 373.65 and 463.22. The n's are weighted frequencies (numbers of women in the sample) and that's why they are not integers. These n's refer to the number of women age 15-49, not the total population.
Rounding the percentage, I get 66%, compared with your 65%. Virtually the same.
use "...KEIR8AFL.DTA" , clear
tab1 g100-g103 [iweight=v005/1000000],m
gen fgm=.
replace fgm=0 if g100==0 | g102==0
replace fgm=1 if g102==1 | g103==1
tab fgm [iweight=v005/1000000]
* convert to a percentage
replace fgm=100*fgm
* get the percentages and n's by counties
tab v024 fgm [iweight=v005/1000000], row
* estimates for Narok + Kisii
tab v024 fgm [iweight=v005/1000000] if v024==33 | v024==45, row
* pooled estimate for Narok + Kisii
tab fgm [iweight=v005/1000000] if v024==33 | v024==45
|
|
|