Related Experiment Video
Updated: Jun 11, 2025

Using Cholesky Decomposition to Explore Individual Differences in Longitudinal Relations between Reading Skills
Published on: September 17, 2019
Making health inequality analysis accessible: WHO tools and resources using Microsoft Excel
Katherine Kirkby1, Daniel A Antiporta1, Anne Schlotheuber1
1Department of Data and Analytics, Division of Data, Analytics and Delivery for Impact, World Health Organization, 20 Avenue Appia, Geneva 27, CH-1211, Switzerland.
The World Health Organization (WHO) developed accessible Excel-based resources to help non-statisticians analyze health inequality data. These tools aim to strengthen health information systems and improve evidence for policy decisions.
Area of Science:
- Public Health
- Health Systems Strengthening
- Health Equity Research
Background:
- Addressing health inequity is a global priority aligned with Sustainable Development Goals.
- Effective health information systems are crucial for collecting, analyzing, and reporting health inequality data.
- Identifying and addressing health inequalities is vital for improving population health outcomes.
Purpose of the Study:
- To describe three World Health Organization (WHO) resources designed to support non-statistical users in analyzing health inequality data.
- To provide accessible tools for individuals, particularly in low-resource settings, to build analytical capacity.
- To enhance the evidence base for policy and program decision-making regarding health equity.
Main Methods:
- Development of three WHO-created resources utilizing Microsoft Excel.
- An eLearning course for preparing and reporting disaggregated data.
- Two Excel workbooks for step-by-step calculation and automatic computation of 21 summary measures of health inequality.
Main Results:
- The resources facilitate the analysis of health inequality data by users with limited statistical expertise.
- The tools enable the calculation of 21 summary measures of health inequality.
- An empirical example demonstrates the practical utility of these resources.
Conclusions:
- The developed WHO resources effectively support non-statistical users in analyzing health inequality data using accessible software.
- These tools can empower individuals and strengthen health information systems globally.
- Improved analytical capacity can lead to more informed policies and programs to address health inequities.
Related Concept Videos
Overview of Microsoft Excel as a Data Analysis Tool
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Microsoft Excel: Median, Quartile range, and Box Plots
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...
Microsoft Excel: Student's t-Test
To conduct a t-test in Excel, use the T.TEST function or the "Data...
Microsoft Excel: Regression Analysis
To perform regression...
Microsoft Excel: Pearson's Correlation

