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 12 countries for your project by checking the check boxes under Country, including USA, China, and Norway.

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

c. Select the most recent year under Time where data required for this exercise 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.

GDP (current US$) Population, total United States 25,439,700,000,000.00 333,287,557.00 Norway 593,348,981,537.66 5,457,127.00 China 17,963, 171,479,205.30 1,412, 175,000.00 Australia 1,692,956,646,855.70 26,005,540.00 Brazil 1,920,095,779,022.73 215,313,498.00 Canada 2, 161,483,369,422.01 38,929,902.00 El Salvador 32,488,720,000.00 6,336,392.00 Germany 4,082,469,490,797.68 83,797,985.00 France 2,779,092,236,505.85 67,971,311.00 Greece 217,581,324,512.06 10,426,919.00 Japan 4,256,410,760,723.75 125, 124,989.00 Italy 2,049,737, 165,407.98 58,940,425.00 Created from: World Development Indicators Time : 2022a. Select 12 countries for your project by checking the check boxes under Country, including USA, China, and Norway. b. Selectthe 2 data series GDP (currentUS$) and Population (Total) under Series. c. Select the most recent year under Time where data required for this exercise is available. Otherwise, you will get zero for this part of the project. d. Choose Layout on the upper leftside 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 recentavailable year for the countries with the equation given in the farright column. Write a short report jn 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. Listthe 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