Assignment details

Question 1

Data collection, presentation and analysis

The economic crisis in Greece has been in the news lately, as it looked likely to default on its debt. For this part of the assignment you will be collecting, presenting and analysing economic data for Australia, Germany, Greece and an Asian country of your choice.

Using The World Bank website (under Data), collect and present annual data showing: GDP per capita (in constant 2005 US$); the GDP annual percentage growth rate; the annual percentage inflation rate (using the GDP deflator figures); and the total unemployment rate, for each of the four countries, for the years 2005 —2016 (for some countries data may only be available up to 2013, in which case data from 2005 — 2013 is acceptable).

Present the data initially in tables. You may decide how many tables to use, and which variables/countries to include in each table. Each table must be numbered and have a clear heading/title indicating its contents, and a reference for the source of the data under the table.

Use the data to construct the following graphs, using the graphing tool (line graphs) in Excel. Indicate under each graph which table/s the data came from. Make sure you also label each axis and each variable, and give your graph a title.

Figure 1: GDP per capita for all four countries

Figures 2, 3, 4 and 5: One figure for each country, with the GDP growth, inflation and unemployment rates for that country.

Figure 6: GDP growth and unemployment rates for all four countries.

Note: Please do not attach the excel file with your assignment. You need to use copy/paste functions to transfer your graphs to the word document containing your assignment.

                                                                                                                                        (15 points)