The Relationship Between Gross Domestic Product and Human Development Index in 41 Countries
Essay Preview: The Relationship Between Gross Domestic Product and Human Development Index in 41 Countries
Report this essay
MANAGERIAL DATA ANALYSIS – CASE STUDY
SUBJECT ANALYSED: THE RELATIONSHIP BETWEEN GROSS DOMESTIC PRODUCT AND HUMAN DEVELOPMENT INDEX in 41 COUNTRIES
MIHAILA MIOARA 25%
PETRE ALEXANDRA 25%
SIMION LAURENTIU 25%
TARIUC MONICA 25%
MANAGEMENT of INTERNATIONAL PROJECTS
ASE 2009
Case Study
Record 40 – 60 data for two statistical variables (X and Y) at your choice.
I. For each of the two variables:
a) Calculate and interpret the average, standard deviation and the coefficient of variation for row data. Interpret the results. Is the data series homogenous?

b) Summarize the data in an appropriate number of classes. Construct the frequency distribution.
c) Calculate and interpret for the frequency distribution the average, standard deviation and coefficient of variance. Compare with the results from point a). Explain the differences.

d) Construct a histogram and describe the shape of the distribution based on the histogram.
e) In which interval is expected that about 95% of the data will fall? Is this assumption true for this data?
II. Using the “Pivot Table Wizard” in EXCEL, build a pivot table on your spreadsheet (using also the second variable). You may have to change the order of the rows (You should define the intervals first using VLookup function.

III. Calculate the regression line and interpret and test the regression coefficients, coefficient of determination and coefficient of correlation. Interpret the results.

Introduction:
We chose for analysis a sample of 41 countries, considering the relationship between the following two variables: the Human Development Index(HDI) and the Gross Product per Capita (GDP)[1]. The values are extracted from a report provided by the World Bank in 2008.

The gross domestic product (GDP) or gross domestic income (GDI) is a basic measure of a countrys economic performance and is the market value of all final goods and services made within the borders of a country in a year. It is a fundamental measurement of production and is very often positively correlated with the standard of living, though its use as a stand-in for measuring progress in increasing the standard of living has come under increasing criticism and many countries are actively exploring alternative measures. GDP can be defined in three ways, all of which are conceptually identical. First, it is equal to the total expenditures for all final goods and services produced within the country in a stipulated period of time (usually a 365-day year). Second, it is equal to the sum of the value added at every stage of production (the intermediate stages) by all the industries within a country, plus taxes less subsidies on products, in the period. Third, it is equal to the sum of the income generated by production in the country in the period–that is, compensation of employees, taxes on production and imports less subsidies, and gross operating surplus (or profits).

The Human Development Index (HDI) is an index used to rank countries by level of “human development”, which usually also implies whether a country is developed, developing, or underdeveloped.

The HDI combines normalized measures of life expectancy, educational attainment, and GDP per capita for countries worldwide. It is claimed as a standard means of measuring human development–a concept that, according to the United Nations Development Program (UNDP), refers to the process of widening the options of persons, giving them greater opportunities for education, health care, income, employment, etc. The HDI attempts to measure a countrys development.

The HDI combines three dimensions:
* Life expectancy at birth, as an index of population health and longevity
* Knowledge and education, as measured by the adult literacy rate (with two-thirds weighting) and the combined primary, secondary, and tertiary gross enrollment ratio (with one-third weighting).

* Standard of living, as measured by the natural logarithm of gross domestic product per capita at purchasing power parity.
I. a)
| |HDI |GDP per capita |
|average |0,93414634 |44448 |
|standard deviation |0,0384113 |13170,96478 |
|coeficient of variation |0,04111915 |0,296320237 |
Interpretation for HDI
The average of the HDI data is 0.934146. Looking at the values from HDI column, we can see that there are few extreme values, therefore the average did not suffer any distortions. The coefficient of variation is 4% (less than 30%), so the series of data collected is homogeneous. Regarding the standard deviation, this is 3.8, so the HDI individual values deviate with +/- 3.8 units from the average.

Interpretation for GDP
The computed average for the GDP data is 44448. The coefficient of variation is 29.63% , which is smaller than 30%, showing that the data series is homogeneous. Regarding the standard deviation, this is 13170.96478, so the GDP deviates with +/- 13170 from the average.

I. b)
In order to group the data into classes, the range was first calculated. For the GDP values, the range was 53735 units, with a minimum of 20945 and a maximum of 74680. Having in mind that for a set of data with less than 50 recordings, the number of classes should be between 5 and 7, we considered to group the data into six classes, each class having a range of 10000 units.

Frequency distribution:
| | | |Countries(fi) | | | |
|30000 |40000 |30000-40000 |11 |35000 |385000 |1423296875 |
|40000 |50000 |40000-50000 |12 |45000 |540000 |22687500 |
|50000 |60000 |50000-60000 |7 |55000 |385000 |520734375 |
|60000 |70000 |60000-70000 |3 |65000 |195000 |1040671875 |
|70000

Get Your Essay

Cite this page

Human Development Index And Pivot Table Wizard. (July 14, 2021). Retrieved from https://www.freeessays.education/human-development-index-and-pivot-table-wizard-essay/