In: Economics
Find the data for nominal GDP (GDP current US$) and the data of the corresponding deflators (GDP deflator) for Australia, France, Germany, UK, USA and also the data for the countries of origin of each member of the group from 2000 to 2017. Present the data on a table.
a. Present the data on a table
b. Calculate the real GDP for all countries and present the data on a table.
c. Calculate the growth rate of real GDP and present the data on a table.
d. Plot the real GDP growth rate of all the countries on the same graph and compare them by making any comment or observation that you think it worth to mention.
*You can use the following source for downloading the data: http://data.worldbank.org
*The data can be downloaded in an excel format. You have to work on the excel file provided for doing the calculations of the real GDP, the growth, the tables and the graphs and answer on the corresponding worksheets created for each question. You must upload only the excel file
The data for the 5 countries' GDP and GDP deflator and real GDP is given in the table below
The data is represented in the figure below
From the figure above it is evident that US has clearly highest real GDP during the time period and Australia is the one with lowest real GDP.