About this course
Covers the steps between collecting data and reporting findings. Delegates design codebooks, code and clean survey and interview data, handle missing values, and run descriptive statistics, cross-tabulations and basic tests in Excel and a statistical package such as SPSS. Qualitative coding of interview and open-ended responses into themes is also practised, along with presenting results in tables and charts.
Why this course
Survey and administrative data are expensive to collect, yet results are often delayed or unreliable because coding is inconsistent and cleaning is skipped. Staff who can code, check and analyse data properly produce findings that management, auditors and policy-makers can trust, and reduce dependence on outside consultants.
What delegates will be able to do
By the end of the course, delegates will be able to
- Develop a codebook and apply consistent codes to survey and interview data
- Clean a dataset by checking for errors, outliers, duplicates and missing values
- Run descriptive statistics, cross-tabulations and simple significance tests
- Code open-ended responses into themes and count how often they occur
- Present analysis results in clear tables and charts with short interpretations
Who should attend
Research officers, statisticians, monitoring and evaluation staff, economists and analysts in central banks, ministries, statistics offices and public entities who handle survey or administrative data. Basic Excel skills are assumed.
How it is delivered
Hands-on computer sessions in Excel and a statistical package, working through sample datasets and, where possible, delegates' own data. It is available as a public course, in-house at your premises, or as live virtual sessions. Duration and dates are confirmed in your quote, and in-house groups can have the examples and exercises fitted to their organisation.