Building a database

Opened: Понедельник, 22 февраля 2021, 00:00
Due: Понедельник, 1 марта 2021, 06:00

Database: COVID impact

Your task is to build a dataset containing (i) GDP growth predicitions of the European Commision (EC) for the EU countries (including the UK) for 2020 and 2021 as issued just before the COVID (Feb ´20), (ii) current estimates of the actual GDP growth in 2020 and predictions for 2021 (EC - Feb ´21). Add to this dataset the pre-covid values for three marco-economic indicators: (a) GDP per capita (constant), (b) (total) GDP, (c) Gross Governmental Debt (for 2019). Find the data for the macroeconomic indicators in IMF WEO database (use April 2020 edition).

Calculate the Covid related GDP loss - as % (2019 = 100) for 2020 and 2021. For this task lets assume that the pre-COVID predictions would have been perfect (if there was not COVID). 

Try to plot all the variables, It is possible that some have extremely skewed distribution - in that case, use log or any other appropriate transformation.

Hand in as a single excel document (dont forget to include a fine codebook sheet)