The DHS Program User Forum: Kenya » Issues with Education Data in DHS Dataset for Kenya (2022 and 2014)

Home » Countries » Kenya » Issues with Education Data in DHS Dataset for Kenya (2022 and 2014)

Show: Today's Messages :: Show Polls :: Message Navigator

Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29862]

Wed, 14 August 2024 09:45

n.borgmann
Messages: 10
Registered: August 2024

Member

Dear DHS Team,

I am reaching out with a question regarding the DHS dataset for Kenya, specifically about the variables V107 (years of schooling) and V106 (education level) for the years 2022 and 2014.

In the 2022 dataset, there seem to be only a very small number of individuals with more than 8 years of schooling--just 7 individuals. Considering that Kenya's education system typically includes both primary and secondary schooling, which should exceed 8 years, I am puzzled by this finding.

I have seen discussions in the forum suggesting that there were issues with this variable in previous datasets and that the revised dataset will be released by the end of this week. However, the dataset for 2014 was referenced as being accurate. Upon reviewing the 2014 data, I found that the maximum value for years of schooling is also 8 years. This seems inconsistent with the data for variable V106, where many individuals fall into the third category, which is supposed to be higher than secondary education.

Could you please provide an explanation for these results? Is there a specific reason for this discrepancy, or could the data potentially be incorrect? Understanding this would be crucial for my work.

Thank you very much for your time and assistance. I greatly appreciate your help.

Best regards,

Nils

[Updated on: Wed, 14 August 2024 09:45]

Report message to a moderator

Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29871 is a reply to message #29862]

Thu, 15 August 2024 10:07

Bridgette-DHS
Messages: 3229
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

You may be misinterpreting v107. That variable gives the number of years WITHIN the reported level, v106. The total number of years is v133, "education in single years". It is constructed by combining v106 and v107. In the Kenya 2014 survey, the following table has v106 for columns, v107 for rows, and v133 for cell values (ignore the Total row and column).
/index.php?t=getfile&id=2384&private=0

In the Kenya 2022 survey there was an error in the construction of the education variables. New versions of the files for that survey were put on the website just a few days ago and you should use them in place of the old files.

I can't account for illegal values, such as the 7 cases you found (if indeed they are illegal) in the KE 2022 survey. DHS files have remarkably few such values, but there are some. You may be able to find out whether and how they were altered by comparing with the new versions of the data files. (I can't do that because the internal data folder I use has not been updated yet).

Let us know if you have other questions.

Attachment: v107-v106.png
(Size: 17.00KB, Downloaded 142 times)

Report message to a moderator

Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29873 is a reply to message #29862]

Thu, 15 August 2024 10:12

n.borgmann
Messages: 10
Registered: August 2024

Member

Thank you very much for your detailed explanation. This clarifies everything, and I probably wouldn't have figured it out on my own. I greatly appreciate your help.

Report message to a moderator

Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29880 is a reply to message #29871]

Fri, 16 August 2024 04:06

n.borgmann
Messages: 10
Registered: August 2024

Member

Thank you very much for the detailed response.

As I mentioned in another post, there was a mix-up on my end regarding the variable names.

Thank you so much for the help, my calculations make sense now!

Report message to a moderator

Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #30594 is a reply to message #29862]

Fri, 03 January 2025 09:27

pkaburi
Messages: 11
Registered: February 2014
Location: Nairobi

Member

Dear DHS Users,

I have observed the trend of the Median years of education completed for both men and women over the last previous KDHS surveys. In the last two KDHS surveys, the median years of education completed among the high wealth quintile declined for both men (from 11.4 in 2014 to 10 in 2022) and women (from 11.2 in 2014 to 9.8 in 2022). This appears significant and I wonder what could be the explanation. Trends in the other wealth quintile show a positive trend. My analysis is based on statcompiler.

Attachment: Median years of education completed [Men].pdf
(Size: 202.02KB, Downloaded 11 times)
Attachment: Median years of education completed [Women].pdf
(Size: 203.03KB, Downloaded 13 times)

Report message to a moderator

Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #30603 is a reply to message #30594]

Mon, 06 January 2025 09:45

Bridgette-DHS
Messages: 3229
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

This is a very interesting observation, but before trying to understand it, I first need to know how you got the estimates of the medians.

Did you use hv108 in the PR file? If so, did you have lower or upper cutoff ages? Tables 2.13.1-2 in the final report on the 2014 survey, for example, include ages 6+, with no upper age cutoff. Or did you use v133 in the IR file, which would apply to age 15-49 (for women) and mv133 in the MR file, which would apply to age 15-54 (for men)? Did you modify the upper age limit for men to match that of women?

I can suggest a strategy to understand this pattern, which I agree is unexpected, if you will clarify how you got the numbers.

[Updated on: Mon, 06 January 2025 09:46]

Report message to a moderator

Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #30604 is a reply to message #30603]

Mon, 06 January 2025 10:13

pkaburi
Messages: 11
Registered: February 2014
Location: Nairobi

Member

Many thanks for your response. As reported in the database, I got the figures directly from the DHS stat compiler. I did not do any extra analysis but did a trend analysis over time for all previous KDHS.

Regards

Report message to a moderator

Previous Topic:

Codebook/Value Meaning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jan 23 14:48:20 Coordinated Universal Time 2025