The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » 2022 DHS FGM Prevalence Question (Calculation regarding combined prevalence of FGM for Kisii and Narok Counties)
2022 DHS FGM Prevalence Question [message #27440] Mon, 14 August 2023 15:41 Go to next message is currently offline
Messages: 1
Registered: August 2023
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 22 times)
Re: 2022 DHS FGM Prevalence Question [message #27472 is a reply to message #27440] Fri, 18 August 2023 08:54 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2862
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
Previous Topic: Language use 2014 Kenya DHS
Goto Forum:

Current Time: Tue Sep 26 15:19:25 Coordinated Universal Time 2023