Calculating the Indices

Calculating the Indices using Excel is a tool that helps you learn how the composite human development indices - the human development index (HDI), the inequality-adjusted HDI (IHDI) the gender inequality index (GII) and the gender human development index (GDI) can be calculated using EXCEL, based on the current methodologies described in the technical notes.

Each worksheet contains a set of sample calculations for one country for a specific index, with built-in EXCEL formula. It also includes sample data and results.

To replicate a specific step, you may copy the formula in the sample cell and adjust for the relevant cell(s) you are working on.

Using this tool, you could also input your own data and calculate the relevant human development indices for real applications.

In the case of the MPI which uses micro survey data, the STATA do files for each country are available at http://hdr.undp.org.

This tool could be used for practice and verifying your results. To replicate a specific step, you may copy the formula in the sample cell and adjust for the relevant cell(s) you are working on.

For more detailed explanations about the composite indices, please refer to Technical notes: Calculating the human development indices which can be found on the HDR website.

Download the tool