Inequality Analysis Using Excel: Disaggregated Data (WHO)

Disaggregated data refer to data that are broken down by population subgroups, defined by demographic, socioeconomic or geographic criteria. These subgroups serve as the basis of comparison for health inequality analysis. Disaggregated data offer important insights into the health experience of subgroups that are often masked by national (or overall) averages. These data can come from a range of sources, including household surveys and administrative data. Statistical software programs are useful to facilitate the preparation, analysis and reporting of disaggregated data.

This course aims to provide learners with a practical guide to the preparation of disaggregated datasets using Microsoft Excel. These datasets can then be analysed using the WHO Health Equity Assessment Toolkit (HEAT Plus) software application. The course introduces learners to a set of formulas and processes in Excel for disaggregated data preparation and reporting, demonstrated through examples using sample datasets. The target audience is monitoring and evaluation officers, data analysts and other technical officers with an interest in data analysis. The course may also be of interest to students and researchers.

Course duration: Approximately 2 hours

Certificates: A Certificate of Achievement will be available to participants who score at least 80% of the total points available in the final assessment. Participants who receive a Certificate of Achievement can also download an Open Badge for this course. Click here to learn how.