

This tool could be used for practice and verifying your results. In the case of the MPI which uses micro survey data, the STATA do files for several countries are available.

Using this tool, you could also input your own data and calculate the relevant human development indices for real applications. 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. It also includes sample data and results. Please contact us via email at Ĭalculating 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.Įach worksheet contains a set of sample calculations for one country for a specific index, with built-in EXCEL formula. Throughout the year, when updates are made to the database, the API data may also be updated manually by the database/website manager. This is due to the fact that the data is recalculated retroactively each year, in light of new methodologies and updated data. When this happens, the data present in the API (MySQL) database is wiped and replaced with the new data. This happens at least once a year upon the publication of the global Human Development Report, which coincides with the release of the data. For the API, the data is manually extracted from SQL Server and copied into a separate MySQL database. The data is entered into a SQL Server database by the statistics unit and stored and archived there. HDRO produces a small dataset each year which consists over 150 indicators by country and year. The options selection is by default set to: Data Structure: structure = ciy. The resource selection can be done using single or multiple strings, as follows: country_code = 'AFG' indicator_id = '72206' year = '1980, 1990, 2019'. Users should query the API using the GET method. Upon successful registration, the user will be navigated to a page with information on using the API. The user has to register at in order to access the HDRO API. The data can be queried by indicator id(s), year(s) and country code(s) and group by any order. The Human Development Report Office (HDRO) offers this REST API for the developers to query human development related data in JSON format.
