Idowu Makinde’s Updates

Survey Analyst Assignment

Makinde_Dataset_28.xlsx
Makinde_dataset_27.xlsx

I used EXCEL for the data cleaning. The following was done on the data set

1: Duplicate, missing, or conflicting data

Data set was checked for duplicate entries or forms that were not entered and values of Stratum ID, Cluster ID, HH ID, and Child ID were checked to ensure that they were complete

2. Implausible responses

Values that were plausible, and any logical relation were checked to be sure the relation holds. Like having the child’s vaccination date falls between that child’s birth date and the date of the interview.

Values of Stratum ID, Cluster ID, HH ID, and Child ID were checked to ensure that they were complete.

Discrepancy between data of birth from History and Immunization card