Abstract all the data from the table using excel formula (cannot do it manually), form a new table that only contain the countries (refer to the question) , 2015 year and Corruption Perception Index - Transparency International (2018).

The country and year for that country is sorted.

The data set for Corruption Perception Index scores and Human Development Index is available in Corruption VS HDI xls. i) Construct a diagram for the Corruption Perception Index scores for the year 2015 for Denmark, New Zealand, Finland, Singapore, Sweden, Somalia, Syria, South Sudan, Yemen, and North Korea.