Guide to Country Indicators

The spreadsheet builds on the indicators included in the country profiles in Hague and Harrop (2010 edition). The spreadsheet contains indicators for countries with a population of at least one million. Blanks indicate missing data. This document describes the indicators, provides links to sources and outlines some EXCEL tools that can be used to interrogate the data.

Country rating

This is the overall rating produced by Freedom House for 2009, scored as follows:

1 Free
2 Partly free
3 Not free

Freedom House defines these categories as follows:

Free Open political competition; respect for civil liberties; an independent civic life; independent media.

Partly free Limited political rights and civil liberties. Often: corruption, weak rule of law, civil strife, a dominant party.

Not free Basic political rights are lacking and civil liberties are widely and systematically denied. Especially at the extremes, Freedom House’s classification produces similar results to our own classification of regimes as liberal democracies, illiberal democracies and authoritarian.

Political rights

Political rights in 2009 are scored by Freedom House on a scale from 1 (most rights) to 7 (fewest rights). A score of one indicates that ‘those who are elected rule; that there are competitive parties or other political groupings; and that the opposition plays an important role and has actual power. Minority groups have reasonable self-government or can participate in the government through informal consensus.’

Civil liberties

Civil liberties in 2009 are scored by Freedom House on a scale from 1 (most liberties) to 7 (fewest liberties). A score of one indicates that a country ‘comes closest to ensuring the freedoms expressed in the civil liberties checklist, including freedom of expression, assembly, association, education, and religion. Such countries are distinguished by an established and generally equitable system of rule of law, enjoy free economic activity and tend to strive for equality of opportunity.’

Freedom of the press

Freedom of the press (i.e. the media generally) in 2008 is scored by Freedom House on a scale from 0 (most freedom) to 100 (least freedom). The score is based on detailed consideration of the legal, political and economic environments within which the media operate. The nature of these environments shapes the media’s vulnerability to pressure.

Human development index

The human development index in 2007, produced by the United Nations Development Programme, is scored on a scale from 0 (least developed) to 1 (most developed). The index measures average achievement within a country on three dimensions of human development: a long and healthy life (life expectancy), knowledge (literacy, enrolment in education), and living standards (gross domestic product per head).

Population

As reported for 2009 by the CIA in The World Factbook. The CIA itself draws on estimates by the US Bureau of the Census.

Gross national income, gross national income per head

As estimated by the World Bank for 2008. The Bank uses the Atlas method, based on a three year average of the exchange rate to the US dollar. This technique reduces the impact on the estimates of short-term fluctuations in exchange rates.

Ease of doing business

As estimated by the World Bank for the period between June 2008 and May 2009. Units are ranked from 1 – 183, with a rank of one indicating that the regulatory environment is most conducive to the operation of business. The index averages the country's percentile rankings on 10 equally weighted topics. These indicators cover the degree of regulation; regulatory outcomes such as the time and cost to enforce a contract; the extent of legal protection of property; the flexibility of employment regulation; and the tax burden on businesses. The ranking in our spreadsheet for ease of doing business is based on all units analyzed by the World Bank, not just the countries in our spreadsheet.

Perceived transparency

As estimated by Transparency International, the Corruption Perceptions Index measures perceived levels of public sector transparency based on 13 different expert and business surveys conducted in 2008 and 2009. Scores range between 1 (most corrupt – least transparent) and 10 (least corrupt – most transparent).

Globalization

The KOF Index of Globalization, based on 2007 data, is an overall index based on three dimensions: first, economic variables (e.g. trade as a proportion of gross domestic product); second, social variables (e.g. international letters per head); third, political variables (e.g. membership of international organizations). Scores range between 1 (least global) and 100 (most global).

Analyzing the data

The following EXCEL functions, each with an example, may be helpful. Enter your formula into a cell where you would like the result to appear. Ensure that this cell is outside the range on which you are basing the calculation. Begin each formula with = and include no blanks in your formula. Note that a range of cells can be referenced using a colon: thus A1:A3 refers to A1, A2 and A3. For more information on a particular function, enter the function into the help facility in the EXCEL program. Some understanding of statistical techniques is useful with some of these functions; Hague and Harrop (2010 edn, pp. 51-3) offers some help but any statistics text will provide more.

AVERAGE

To obtain average gross national income per head:

=AVERAGE(I4:I153)

STANDARD DEVIATION

To obtain the standard deviation of national income per head:

=STDEV(I4:I153)

MEDIAN

To obtain the median freedom of the press score:

=MEDIAN(E4:E153)

MINIMUM AND MAXIMUM

To obtain the highest and lowest score on the human development index:

=MIN(F4:F153)

=MAX(F4:F153)

PERCENTILE

To obtain the national income per head that ten per cent of the countries are higher than:

=PERCENTILE(I4:I153,0.9)

RANK

To obtain Canada’s rank in national income:

=RANK(I27,I$4:I$153,0)

Note that we have used $ signs here to indicate absolute (constant) row references.

Note also that the 0 at the end of the formula is used to indicate descending order.

CORRELATION

To correlate political rights with national income per head:

=CORREL(C4:C153,I4:I153)

SCATTER CHART

To plot human development scores against national income per head, use INSERT, CHART

AVERAGES WITHIN GROUPS

To find average national income per head within free countries only:

We first copy national income per head for free countries only to a new column. We do this using the IF command whose general form is:

=IF(logical test,value if true, value if false)

=IF(B4=1,I4,"")

Note that “” is used to indicate blank if false

Then use EDIT, FILL DOWN to complete this new column

Delete any stray zeros in the new column, then calculate the average for this column as shown above.

REDUCING NUMBERS TO CATEGORIES

To produce a new column containing 1 if the country has an national income per head above the median and 0 otherwise:

=IF(I4>3640,1,0)

The use EDIT, FILL DOWN to complete the new column