Data analysis task

Data analysis task 50% (max 25 points),
Macroeconomics, summer semester 2020/2021, Judyta Lubacha, PhD
Early bird submission 11.04.2021, 23.59 Central European Time – extra 10% from gained points
Deadline 18.04.2021, 23.59 Central European Time – no extra points
Work in groups (2-3 person), upload .doc or .pdf file with the report 2-4 pages
name the file only with SURNAMES of the authors
Each author has to upload the file on PEGAZ
EUROPE 2020 targets analysis
Europe faces a moment of transformation. The crisis has wiped out years of economic and social progress
and exposed structural weaknesses in Europe’s economy. In the meantime, the world is moving fast and
long-term challenges – globalisation, pressure on resources, ageing – intensify. The EU must now take charge
of its future.
Europe can succeed if it acts collectively, as a Union. We need a strategy to help us come out stronger from
the crisis and turn the EU into a smart, sustainable and inclusive economy delivering high levels of
employment, productivity and social cohesion. Europe 2020 sets out a vision of Europe’s social market
economy for the 21st century.
Europe 2020 puts forward three mutually reinforcing priorities:
– Smart growth: developing an economy based on knowledge and innovation.
– Sustainable growth: promoting a more resource efficient, greener and more competitive economy.
– Inclusive growth: fostering a high-employment economy delivering social and territorial cohesion.
The EU needs to define where it wants to be by 2020. To this end, the Commission proposes the following
EU headline targets:
– 75 % of the population aged 20-64 should be employed.
– 3% of the EU’s GDP should be invested in R&D.
– The “20/20/20” climate/energy targets should be met (including an increase to 30% of emissions reduction
if the conditions are right).
– The share of early school leavers should be under 10% and at least 40% of the younger generation should
have a tertiary degree.
– 20 million less people should be at risk of poverty.
(EUROPE 2020 A strategy for smart, sustainable and inclusive growth)1. Choose one country and 4 of 11 EUROPE 2020 indicators:
List of indicators
Europe 2020 indicators
• Employment rate by sex, age group 20-64 (t2020_10)
• Gross domestic expenditure on R&D (GERD) (t2020_20)
• Greenhouse gas emissions, base year 1990 (t2020_30)
• Share of renewable energy in gross final energy consumption (t2020_31)
• Primary energy consumption (t2020_33)
• Final energy consumption (t2020_34)
• Early leavers from education and training by sex (t2020_40)
• Tertiary educational attainment by sex, age group 30-34 (t2020_41)
• People living in households with very low work intensity (t2020_51)
• People at risk of poverty after social transfers (t2020_52)
• Severely materially deprived people (t2020_53)
2. Prepare graphs (10 points):
1) Use data for years 2007- 2018/2019
2) show data for a chosen country and UE average/ the target at the same graph
3) add a proper title to the graph, the title should include following information what? where?
when? in which unit? (eg. Expenditures on R&D in Poland in 2005 in million euros)
4) add axis labels
5) always give a source below the graph
6) use any type of graph – choose the one fitting the best to presented data
(useful tips

Designing Charts and Graphs: How to Choose the Right Data Visualization Types
3. Describe your data (10 points):
1) what is a difference between a chosen country and the UE average?
2) how did it change in the analysed period? – please use calculated growth rates and absolute
changes in your descriptions, eg. „Governmental expenditures on R&D increased 3% in from
2005 to 2010.” or „Average salary increased significantly from 2008 to 2009 (by 200PLN)”
3) Describe if the country has met the targets of the Europe 2020 strategy.
4) try to put your own assumptions, questions, opinions why is a chosen country performing in
a given way
4. Verify your opinions, assumptions with the scientific literature, reports, analysis trying to explain the
performance of a chosen country (5 points)
Remember to use proper quotation – citation rules belowCitation rules – In-text citation
1. Indirect quotation – used most common, in this situation you paraphrase words or author or
summarise main message of a text in 1-2 sentences in your own words.
Example from: Dettmann et al. (2015)
Another explanation for the spatial concentration of technological activities is associated with the nature
of knowledge. While information is fairly simple to codify, this is not the case with knowledge, owing to
its tacit dimension (COWAN et al., 2000). According to POLANYI (1966), creative acts, and in particular
acts of discovery, depend crucially on personal feelings and commitment. VON HIPPEL (1994) argues that
‘sticky knowledge’ cannot be transferred at insignificant cost.
Give a SURNAME OF AN AUTHOR in brackets with date of publication, or
Give a SURNAME OF AN AUTHOR directly in text with date of publication in brackets
If there is more than 3 authors, please write a “SURNAME OF THE FIRST AUTHOR et al.”
2. Direct quotation – it is used in scientific text very rare, mostly when we want to introduce some
Example from: Działek (2014)
Thus, from all the proposed definitions, the one put forth by Trigilia (2001, p. 430), an Italian researcher
in economic sociology, seems particularly appealing, as it considers social capital as: “a set of social
relations of which a single subject … or a collective subject … can make use at any given moment. Through
the availability of this capital of relations, cognitive resources, such as information, or normative
resources, such as trust, allow actors to realize objectives which would not otherwise be realized…”.
Give a SURNAME OF AN AUTHOR in the brackets with date of publication, or
Give a SURNAME OF AN AUTHOR directly in text with date of publication in brackets
Use “quotation marks”
Add page number after year of publication
3. Secondary referencing – if you cite someone, who cites someone, avoid that and always try to read
an original source
Source of the example:
A process project might consist of a number of stages including experimentation and production
(Rondinelli 1983, cited in Potts 2002, p. 37).
Give a SURNAME OF AN AUTHOR of a book you have not read, year of publication, cited in SURNAME
OF AN AUTHOR of a book which you actually read, year of publication
Add page number after year of publication
In your reference list you should list the book you have actually read, it means Potts 2002 Sources of sources – How to use better side of internet?
• Books
• Access to online journals
• http://www.sciencedirect.c
• http://www.oxfordjournals
• http://onlinelibrary.wiley.c
• http://www.emeraldinsigh
• WorldBank
g/data/home.aspx or
• Eurostat
use databases, and work with this
data to make your own graphs
(don’t use googled graphs)
s/publications/transitionreport/ebrd-transitionreport-201516.htmlInformation/ Data searching
1. Searching strategies:
1. Library/ online journals catalogues:– use “keywords” in search option instead whole sentences. Scientific articles always have “keywords”
included. Eg. ( Sometimes it is better to use “advanced search” option (
3. Google searching – also try to use “keywords” instead full sentences. Pay attention for results with surnames, bellow result link, and with
link to online journals. Eg
Order Now

Calculate a fair price for your paper

Such a cheap price for your free time and healthy sleep

1650 words
Place an order within a couple of minutes.
Get guaranteed assistance and 100% confidentiality.
Total price: $78
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?