Loading...

Question

DATA EXERCISE #3

DATA EXERCISE #3

Due at the end of week 7

Format of the Project:

The Data Exercise must be posted to the LEO Student Assignments as a Attachments are limited to a maximum two files in doc, docx., xls. xlsx., or rtf. formats. OTHER FORMATS ARE NOT ACCEPTABLE, will not be reviewed or graded.

Please note that hand-written and scanned works, pdf. files, jpg. files, as well as files posted in google drive, will not be accepted or graded.

Please note that starting from the Fall 2020 semester the UMGC moved to the 7th Edition of the APA Style. The links to the 7th Edition of the APA Style methodology are posted in Content – Course Resources – Writing Resources.

No more than 20% of the text of the project should be made up of quotes.

Please note that Use of the 7th Edition APA Citation Methodology is required for all parts of the assignment

Written projects:

1.Must be typed, double-spaced, in 12-point Times New Roman or Arial font, with one-inch margins

2. Must have the title page in APA-7th style

3.Must have in-text citations in APA-7th edition style

4.Must have reference list in APA-7th edition style. Please note that you must reference the data you are using for the project

5.Must be prepared using word processing software (Microsoft Word preferred)

Data exercise #3 Assignment

Consists of two parts.  

Part 1: GDP in Different Countries (weight 45% of the assignment grade)

Complete the following exercise:

Go to World Development Indicators database:

https://databank.worldbank.org/home.aspx

Click on World Development Indicators.

a.Select 20 countries for your project by checking the check boxes under Country, including USA and China.

b.Select the 2 data series GDP (current US$) and Population (Total) under Series. 

c.Select the most recent year under Time. Please use the last year when the data is available. Otherwise you will get zero for this part of the project.

d.Choose Layout on the upper left side of the screen. Under Orientation choose “Page” for Time, “Column” for Series, “Row” for Country.

e. Retrieve data. You can now retrieve data by clicking on the options on the right upper side of the window.  Clicking “Table” will allow you to see data.  Click “Download options” and choose “Data on this page only – formatted”. This option will allow you to download the data in Excel, which can then be copied into your report file. Or you can simply type the required data into the table below. Fill in the table below.

f.Present the table in your project.

g. Calculate the per capita GDP for the most recent available year for the countries with the equation given in the far right column.

Country

   GDP

Population

   Per Capita GDP

      1

       2

        3

        4 = 2/3

 

 

 

 

 Write a short report in your own words (2 pages, double-spaced), which contains the analysis of the results you received. In this report consider, but do not be limited to the following:

1. List the countries by highest per capita GDP to lowest.

2. Does the order remain the same for total GDP as for per capita GDP?]

3.If not, explain why is it different?

4.Please analyze and discuss the significance of this data that you received for this Data exercise.

5. Please reflect on what you have learned from this assignment.

Part 2: Index of Economic Freedom (weight 45% of the assignment grade)

Log onto the Heritage Foundation's website at https://www.heritage.org/index/

Today, we live in the most prosperous time in human history. Poverty, sicknesses, and ignorance are receding throughout the world, due in large part to the advance of economic freedom. In 2021, the principles of economic freedom that have fueled this monumental progress are once again measured in the Index of Economic Freedom, an annual guide published by The Heritage Foundation, Washington's No. 1 think tank.

For twenty-seven years the Index has delivered thoughtful analysis in a clear, friendly, and straight-forward format. With new resources for users and a website tailored for research and education, the Index of Economic Freedom is poised to help readers track over two decades of the advancement in economic freedom, prosperity, and opportunity and promote these ideas in their homes, schools, and communities.

The Index covers 12 freedoms – from property rights to financial freedom – in 184 countries.”

(https://www.heritage.org/index/)

 lick on COUNTRY RANKING to find the Rank and the Overall Score of economic freedom.

Click on EXPLORE THE DATA to find the Rank of business, trade, financial freedom, and property rights.

1. Find the Rank and Overall Score in economic freedom (overall) of the countries that you were using in part I of the assignment. Present this information as table(s) in your project.

2.Find the scores in business, trade, financial freedom, and property rights of the countries that you were using in part I of the assignment. Present this information as table(s) in your project.

3. Compare the Rank in economic freedom (overall) and other indicators with the order of the countries using the per capita GDP in the table in part I of the assignment. 

4. Write a report in your own words (2 pages, double-spaced), which contains the analysis of the results that you received. Discuss the significance of the data and what you feel is the relevance of rankings. Please reflect on what you have learned from this assignment.

 Presentation of the data exercise and use of apa citation methodology (10%) of the project grade):

·        Organization, format, and presentation of paper including the title page, introduction, body, and summary. Begin each section with a subheading; use the subheadings described in the assignment (3% of the project grade).

·        Use of tables, figures, and other graphics to summarize and support analysis presented in the paper. All tables and charts should have the numbering system: “Table 1”, a substantive title, and a reference to the source of the information. (3% of the project grade).  Research sources and significance of research information and data, and use of APA citation methodology (4% of the project grade).

Expert Solution

[WDI_Ctry].[List].[Country Name].[MEMBER_CAPTION]

GDP (current US$)

Population, total

United Arab Emirates

 

9,991,083.00

South Sudan

 

11,381,377.00

Afghanistan

 

39,835,428.00

United States

22,996,100,000,000.00

331,893,745.00

China

17,734,062,645,371.40

1,412,360,000.00

United Kingdom

3,186,859,739,185.02

67,326,569.00

India

3,173,397,590,816.91

1,393,409,033.00

Italy

2,099,880,198,258.88

59,066,225.00

Canada

1,990,761,609,665.23

38,246,108.00

Russian Federation

1,775,799,919,352.98

143,446,060.00

Australia

1,542,659,899,992.54

25,739,256.00

Saudi Arabia

833,541,236,569.32

35,340,680.00

Nigeria

440,776,971,536.02

211,400,704.00

South Africa

419,946,428,126.01

60,041,996.00

Egypt, Arab Rep.

404,142,766,093.05

104,258,327.00

Ukraine

200,085,537,744.35

43,814,581.00

Kenya

110,347,079,517.36

54,985,702.00

Dominican Republic

94,243,453,937.45

10,953,714.00

Tanzania

67,775,101,794.35

61,498,438.00

The Central African Republic

2,516,498,299.01

4,919,987.00

 

Economic Assessment of States

The economic assessment of nations is a potent measure of how a country is performing. This data report indicates the assessment through GDP, GDP per capita and selected qualitative measures from heritage.com. The selected countries will be used as a sample to explain the economic state of the nations. Therefore, the first part indicates the use of GDP and GDP per capita whereas the second part is useful for the analysis through qualitative measures of trade, property rights, financial freedom and business.

Table 1 : GDP rankng

[WDI_Ctry].[List].[Country Name].[MEMBER_CAPTION]

GDP (current US$)

GDP per capita

Population, total

Afghanistan

 

#VALUE!

39,835,428.00

South Sudan

 

#VALUE!

11,381,377.00

United Arab Emirates

 

#VALUE!

9,991,083.00

United States

22,996,100,000,000.00

69,287.54

331,893,745.00

Australia

1,542,659,899,992.54

59,934.13

25,739,256.00

Canada

1,990,761,609,665.23

52,051.35

38,246,108.00

United Kingdom

3,186,859,739,185.02

47,334.36

67,326,569.00

Italy

2,099,880,198,258.88

35,551.28

59,066,225.00

Saudi Arabia

833,541,236,569.32

23,585.89

35,340,680.00

China

17,734,062,645,371.40

12,556.33

1,412,360,000.00

Russian Federation

1,775,799,919,352.98

12,379.57

143,446,060.00

Dominican Republic

94,243,453,937.45

8,603.79

10,953,714.00

South Africa

419,946,428,126.01

6,994.21

60,041,996.00

Ukraine

200,085,537,744.35

4,566.64

43,814,581.00

Egypt, Arab Rep.

404,142,766,093.05

3,876.36

104,258,327.00

India

3,173,397,590,816.91

2,277.43

1,393,409,033.00

Nigeria

440,776,971,536.02

2,085.03

211,400,704.00

Kenya

110,347,079,517.36

2,006.83

54,985,702.00

Tanzania

67,775,101,794.35

1,102.06

61,498,438.00

The central African Republic

2,516,498,299.01

511.48

4,919,987.00

 Table 2: GDP per capita Ranking

The listing above is the country ordered by GDP and the GDP per capita. The order is not the same indicating the disparity in aggregate output versus output per individual within the country. The United States has the highest GDP which is expected given the strength of the dollar, the superiority of its financial and banking institutions as well their dominion in the tech sector which is the most influential and most lucrative sector on the planet at the moment (Abel et al., 2018). China follows close behind as the country has a large population indicating a high gross domestic product for the country in the long run. United Kingdom, Canada, Russia, and Italy have a gross domestic product higher than a billion dollars (The World Bank, 2020). However, approaching the setup from the angle of GDP per capita, there is a palpable variation in the order of the countries. The first is the United States with the highest GDP per capita followed by Australia, Canada, the United Kingdom, Italy Saudi Arabia, and then finally China. This indicates that qualitatively, the countries with the highest GDP per capita have a better quality of life amidst production. Therefore, the two scenarios indicate the variation in the estimation of country output through aggregation and per capita.The entire exercise has indicated that the GDP per capita is a better estimator of national output. Aggregated output in a big population indicates a lower dimensional level of production. China, therefore, has a big GDP VALUE because of its more than a billion people. However, the quality of production is lower than in other countries with less than half the Chinese population. This indicates that the latter countries have a superior level of production whereby the higher quality in processes and production leads to a higher GDP (The World Bank, 2020). The aggregation of all the sectors of production will lead to the comprehensive output which is the GDP. Developed nations are distinguishable from their higher GDP per capita as opposed to the less developed nations. The dataset indicates the Central African Republic is the lowest, followed by Tanzania, Kenya, Nigeria, and then India. These countries are the less developed countries in the dataset Therefore, the GDP per capita is an appropriate indicator of the development levels in the country.

[WDI_Ctry].[List].[Country Name].[MEMBER_CAPTION]

overall score

Afghanistan

 53

South Sudan

 40

United Arab Emirates

 60

United States

74.80

Australia

72.10

Canada

68.70

United Kingdom

65.30

Italy

61.90

Saudi Arabia

58.50

China

55.10

Russian Federation

51.70

Dominican Republic

48.30

South Africa

44.90

Ukraine

41.50

Egypt, Arab Rep.

38.10

India

34.70

Nigeria

31.30

Kenya

27.90

Tanzania

24.50

The central African Republic

21.10

Table 3: Overall Score

[WDI_Ctry].[List].[Country Name].[MEMBER_CAPTION]

business

trade

financial freedom

property rights

Afghanistan

53.90

68.60

80.80

30.30

United States

82.50

80.40

81.80

79.70

Australia

87.40

89.80

86.70

81.50

Canada

81.40

88.80

76.10

84.50

United Kingdom

94.40

84.00

81.00

87.60

Italy

91.80

81.40

78.40

85.00

Saudi Arabia

89.20

78.80

75.80

82.40

China

86.60

76.20

73.20

79.80

Russian Federation

84.00

73.60

70.60

77.20

Dominican Republic

81.40

71.00

68.00

74.60

South Africa

78.80

68.40

65.40

72.00

Ukraine

76.20

65.80

62.80

69.40

Egypt, Arab Rep.

73.60

63.20

60.20

66.80

India

71.00

60.60

57.60

64.20

Nigeria

68.40

58.00

55.00

61.60

Kenya

65.80

55.40

52.40

59.00

Tanzania

63.20

52.80

49.80

56.40

The Central African Republic

60.60

50.20

47.20

53.80

Table 4: Trade, Business, Financial Freedom, property rights

The ecnomic freedom overall rank has been portrayed in the first table whereas the second table indicates four components of the overall score. The business score is a measure of the ease of conducting business dealings within the country in question. The level of economic activity in every country is a function of how easy it is to start and run a business enterprise. The wide range of forms of business units inclusive of a sole proprietorship, partnerships, cooperative societies, and limited liability companies in both the public and private forms are various business forms (Heritage, 2022). However, the level of capital required varies and increases business complexity which further increases the impact of the business on the organization. Therefore, the business score is a reliable metric of the impact of the business within the country in question.Moreover, trade indicates the exchange of commodities within and without the country. Imports and exports are reliable components of the gross domestic product and the value of net exports affects the magnitude of the output within the nation. Furthermore, if the export is significantly high it could theoretically lead to a higher GDP per capita (Heritage, 2022). This indicates that the trade score indicates the level of efficiency in maintaining positive net exports as well as a favorable balance of payment as an ideal economic indicator. Moreover, the level of financial freedom is a measure of indication of the quality of lifestyle amongst the population of the selected nation. Therefore, financial freedom is significantly correlated with a favorable GDP per capita given in the first section. The level of financial freedom of the nation is therefore a potent economic indicator of how the nation progresses forward (Heritage, 2022). Finally, the property rights score indicates how convenient it is for individuals and organizations to be owners of the property. Given the fact that land is a very pertinent factor of production, the level of property rights of the nation is a significant economic indicator of how far the nation can go as far as production is concerned (Heritage, 2022). Thus, property rights scores are also significantly correlated with GDP per capita. Therefore, trade, financial freedom, property rights, and business levels are proper economic indicators of the economic performance of a particular nation

The contrast between these four indicators and the quantitative outlook of the gross domestic product is palpable. The latter assumes a qualitative approach. Furthermore, the gross domestic product is an aggregation and is assumptive and the assumptions might not sufficiently cover the nuances within a complex economy. The latter score accommodates numerous dimensions with a significant contribution to the economic state of the nation. The latter scores are therefore more descriptive of the true economic state of the nation at the time t. This renders them superior to GDP for comprehension and explanation purposes. However, GDP and GDP are superior for the estimation and ranking of the countries in an objective manner as it is an unbiased, consistent, complete, and sufficient estimators of the economic output of the nation. Therefore, both avenues are a sufficient metric for the economic rankings of countries.

References

Abel, A. B., Bernanke, B., & Kneebone, R. D. (2018). Macroeconomics. Pearson.

Heritage. (2022). Economic Data and Statistics on World Economy and Economic Freedom. Www.heritage.org. https://www.heritage.org/index/explore?view=by-region-country-year?&countryIds=175®ionIds=&yearIds=27

The World Bank. (2020). World Development Indicators | DataBank. Worldbank.org. https://databank.worldbank.org/source/world-development-indicators#

Please enter your email address to h

  • 100% Plagiarism-free
  • 100% Human-written
Blurred answer