Data Processing
 

Training for Manual Editing Staff          

The then Federal Office of Statistics organised training for the Questionnaire Editors.  Forty experienced officers were trained.

Training for Data Entry Staff

Thirty officers were trained on computer data entry and editing.

Data Analysis Preparation                      

The then FOS worked with the World Bank Mission to undertake system development for data analysis.  This involved data dictionary development, data entry procedure and data editing.

Computer Edits

There were five levels of computer edits before analysis took place.  This was critical to ensuring the quality and acceptability of the data.

Level 1:           Control Edits:          These were to ensure the sample integrity.  The total households captured must match with master sample list.

 

Level 2:           Inter-Questionnaire Structure:    These were required in order to compute the Standard of Living (SOL), quintile distribution or compute per capita value.  Mismatches and duplicates were reconciled.

 

Level 3:           Intra-Questionnaire:           This was required for sectoral analysis.  Information from the roster (age and sex) was matched with respective sections in the questionnaire.  Since the household roster was the primary source for computing the universe of subsequent sections, these had to be consistent.  Mismatches and duplicates of household members’ identification were rectified.

 

Level  4:          Edits: These checks monitor the intra-record consistency.  It was important that logical responses and skip patterns were followed.

 

Level 5:           General Edits:     This checked for outliers and corrections were made through static or dynamic imputation

Data Analysis

The  Staff of Computer Management and Information Services (CMIS) of the NBS carried out the data entry of the edited  questionnaire and ran programmes to further detect inconsistencies and other related errors as part of the final editing.  Tables were then generated from the analyses.                

Also at the request of the then Federal Office of Statistics, under the British Council Economic Management Capacity Building (EMCAP) Project, a DFID Consultant came to Nigeria to provide technical assistance in the evaluation of dataset.

The consultancy covered the following areas:  Computer Edits, Tabulations and Capacity Building.  Generally, IMPS was used for data entry, IMPS and CSPro for data editing and SPSS for data analysis and tabulations.