LAB OF DATA ANALYSIS FOR ECONOMICS AND POLITICAL SCIENCES
LAB OF DATA ANALYSIS FOR ECONOMICS AND POLITICAL SCIENCES
Marco Iecher, Francesca Sica
Instructional goals
The main aim is to endow students with the following abilities: ability to collect and process data, ability to interpret findings and to communicate results useful not only to formulate critical judgments on the economic, social and political issues behind the working of a real economic system; but also to communicate information, ideas, problems and solutions to both specialists and non-specialists audiences. These abilities match the Dublin Descriptors especially no. 3 independent ability of judging: to gather and interpret relevant data usually within their field of study to inform judgments that include reflection on relevant social, scientific or ethical issues; no. 4 communicative skills: to communicate information, ideas, problems and solutions to both specialist and non-specialist audiences.
At the end of the course, the students will be able to apply basic statistical tools to analyze real-world economic data, also by means of statistical software and advanced spreadsheet (EXCEL, GRETL, .).
The course also develops digital competences as of EU DIGCOMP 2.1 (Competence area 1: Information and data literacy; Competence area 2: Communication and collaboration; Competence area 3: Digital content creation). Moreover, midway through the academic year, students take an advanced Excel test based on the AICA “Advanced Spreadsheets” syllabus, which leads to the awarding of a badge.
Intended learning outcomes
Knowledge and understanding: knowledge of data sources, data types and related univariate analysis techniques (cycle-trend decomposition, graphical representations, measures of dispersion), linear regression model.
Applied knowledge and understanding: ability to select appropriate measures of data synthesis and analysis of the relationship between variables in economics, finance and business.
Making judgments: ability to collect, process and critically interpret quantitative and qualitative data related to economic, financial and business phenomena.
Communication skills: ability to effectively communicate data analysis.
ability to present data in an effective way to different kinds of audience
actively handling the most important tools available for data presentation of results, such as tables, charts in a static and dynamic web-based environment, data warehouses, advanced visual graphics, etc.
Learning skills: ability to learn autonomously data analysis techniques, in professional activities or subsequent studies.
Course Contents
Empirical lectures
The teaching method is interactive because implies the simultaneous use of a pc by the teacher and students to manage data in excel and in other statistical/econometrics packages. The lesson scheme foresees an input that is to say an assertion about an economic phenomenon inspired by the topical economic issues drawn from a media, tv and radio broadcasting, newspaper or on line official press release from any organization committed to provide statistics. The range of themes covered by the course aims at explaining: the way in which the whole economic system functions through the analysis of all economic operators (households, enterprises, government, private institutions) and their corresponding functions (consumption, production of goods and services, investment, international trade).
The lesson scheme foresees also an output consisting of the following steps: 1st step – problem formulation for the phenomenon of interest; 2nd step – data searching; 3rd step – data gathering through access to databases; 4th step – data extraction; 5th step – data analysis and depiction with tables/graphs; 6th step – interpretation and description of the results. The teacher and the students carry out jointly each step and in case of difficulty the teacher will assist the student until he/she will be able to manage the task independently.
Practices are designed to develop the students’ ability in collecting and analyzing real data in economics and in analyzing them also by means of statistical software (EXCEL, GRET; ability in using functions such as those associated with logical, statistical, financial and mathematical operations; ability in creating charts and apply advanced chart formatting features; filter and sort data; ability in enhancing productivity by working with named cell ranges, macros and pivot tables.
The methodological approach consists of empirical analysis based on real data at a national (regional and provincial) and international level, drawn from official databases (ISTAT, EUROSTAT, OECD, IMF, WTO, World Bank, etc.) and processed in order to carry out both spatial benchmarking and time series analysis.
Reference Books
RAPPORTO ANNUALE 2020 - LA SITUAZIONE DEL PAESE
https://www.istat.it/it/archivio/245216
RAPPORTO SULLA COMPETITIVITÀ DEI SETTORI PRODUTTIVI - EDIZIONE 2021 https://www.istat.it/it/archivio/255558
Istat http://dati.istat.it/
Eurostat
https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Beginners:Statistics_4_beginners
http://ec.europa.eu/eurostat/data/database
Commissione europea https://ec.europa.eu/info/business-economy-euro/indicators-statistics/economic-databases/business-and-consumer-surveys/download-business-and-consumer-survey-data/time-series_en
OCSE http://stats.oecd.org/
FMI http://www.imf.org/en/data
Banca Mondiale http://data.worldbank.org/
Teaching Methods
Lectures
Interactive visualization
Exercises
Empirical exercises with EXCEL/GRETL
Analysis on real data
Data from official statistical sources
Assessment Method
Practical test with tasks to be performed individually by each student on a PC in order to check the acquisition of knowledge and understanding, applied knowledge and understanding, making judgments.
The students are requested: 1. to gather data; 2. to process data using statistical or logical functions; 3. to represent the findings of the elaboration by means of charts and tables; 4. to interpret and comment the main findings.
2. Project Work. Report on the statistical analysis of empirical data to be carried out in groups of a maximum of three students with the aid of the advanced spreadsheet (EXCEL) and GRETL.
Verification of the acquisition of Making judgments, Communication Skills, Learning Skills. Digital skills (1, 2, 3), working in groups, time management, developing new solutions to problems.
The final report in word and the workbook in excel containing the raw data, the elaborations and the results have to be sent to the teacher by e-mail. The deadline for the final report is one week before the exam session chosen.
The system sends a communication with the results to the students enrolled in the call.
To be admitted to the final exam, students must have previously passed the Excel Advanced test administered midway through the course. Students who have not passed the test will be required to take it on the day of the final exam as a condition for admission to the examination.
Thesis assignment criteria
The final dissertation concerns applications of statistical methods in business and economics. The topic is agreed with the lecturer.
Week 1
Week 1
Introduction to the course and to Microsoft Excel. Worksheets and workbooks structure. Cells and basic arithmetic formulas. Introductory concepts of quantitative data analysis. Applied exercises on data entry and average calculation.
Week 2
Basic Excel functions. Relative and absolute references. Data organization using tables. Introduction to table formatting and conditional formatting for descriptive data analysis. Applied exercises on basic functions, table formatting, and conditional formatting to highlight data patterns.
Week 2
Week 3
Logical and conditional functions (IF). Conditional counting and summing functions (COUNTIF, SUMIF). Simple, custom, and advanced filters for selective data analysis. Applied exercises on structured datasets.
Week 4
Advanced conditional formatting. Date and time functions. Rounding and numerical precision management. Custom cell formats. Applied exercises on time series and formatted data.
Week 3
Week 5
3D references across worksheets. Introduction to descriptive statistical functions. Text functions for data cleaning, transformation, and standardization. Applied exercises on multidimensional data.
Week 6
Pivot tables: structure, logic, and use for exploratory data analysis. Data aggregation, comparison, and summarization. Applied exercises on real datasets.
Week 4
Week 7
Mock exam covering all topics addressed so far. Review and consolidation of data analysis skills using Excel.
Week 8
Charts: main types, selection criteria, and customization. Lookup and reference functions. Applied exercises on data visualization and data querying.
Week 5
Week 9
Subtotals and automatic summaries. Data validation. Scenario analysis. Introduction to financial functions. Applied exercises on economic and financial simulations.
Week 10
Mock exam 2 concerning new topics. Formula auditing and error checking. Comments and named ranges. Database functions for structured data analysis.
Week 6
Week 11
File linking and data import. Worksheet and workbook protection. Introduction to macros for automating repetitive tasks. Applied exercises.
Settimana 12
Recap and final test preparation. Mock Exam 3.
Week 7
Week 13
Session (1)
1.Population: demography, projections migration and the economic impact
Population structure by age
Demographic indicators: dependency ratio by age, old and youth dependency ratio, ageing index, working age population per pension age, generational turnover, birth rate, fertility rate, life expectancy at birth marriage rate, etc.
Foreign population: migration flows, total immigrants (stock), acquisitions of citizenship
Natural population growth rate: time series and projections
The demographic decline
- The reduction of the population of working age from the unification of Italy to today
Labor market - characteristic ratios:
employment, unemployment, youth unemployment, long-term unemployment, inactivity, potential additional labor force (inactive and discouraged persons)
regional and provincial comparisons and international benchmarking
Time series of labor market indicators
Session (2)
-consultation of national and international databases
download data from official sources
database construction
creation of pivot tables
Week 14
Session (1):
Focus on the labor market key indicators
How to build a database including:
Young people, gender gap, foreigners (employment and unemployment rate)
Young people not in employment, education or training: the NEET
Irregular workers and correlation with GDP
Educational attainment (ISCED) and labor market indicators: the Italy’s anomalies
Session (2):
Empirical exercises by using statistical calculation programs and advanced spreadsheet (EXCEL, GRETL).
Consumer confidence index
pie and pie of pie to represent graphically the consumption expenditure by purpose (COICOP)
how to calculate the propensity to consume and save
how to calculate the consumption expenditures deflator and household purchasing power
Week 8
Week 15
Session (1)
Macroeconomics: what is GDP?
Calculating GDP
The output approach: from added value to GDP
The expenditure approach: domestic and foreign demand
The macroeconomic indicators: openness to trade, accumulation rate, etc.
Comparing GDP
GDP per capita and international benchmarking using Purchasing Power Parities (PPPs)
Labor productivity
Session (2)
Empirical exercises also using statistical calculation programs and advanced spreadsheet (EXCEL,GRETL):
how to measure the percentage variation of GDP
potential GDP and Okun’s law: an empirical estimation for Italy
inflation calculation: the basket of goods and services and weighting composition
consumer price indices (NIC, HICP, FOI, core inflation)
the Phillips curve: an empirical estimation for Italy
Week 16
Session (1)
Short-term analysis (monthly and quarterly)
Quarterly national accounts from ISTAT, Eurostat, OECD
Industrial production, turnover and orders
Business and consumer confidence; general economic confidence
Production in the construction sector
Turnover in services and retail trade
Business cycle leading indicators:
ESI (European Commission);
CLI (OECD);
PMI (HIS Markit)
ESI
Composition by sectors
Correlation ESI-GDP
Business cycle clock
https://ec.europa.eu/eurostat/cache/bcc/bcc.html
Session (2)
Empirical exercises also using statistical calculation programs and advanced spreadsheet (EXCEL,GRETL) on:
The relevance of the public sector in the economy
General government expenditures: expenditure by function (COFOG)
General government expenditures: interests payable, bond yelds and spread
Revenues, taxation and fiscal pressure
Fiscal balances
https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Beginners:Government_finance_statistics
Week 9
Week 17
Session (1) on campus
Social protection expenditure of which: old age (pension expenditure)
Public supply of childcare and female employment rate
GDP per capita losses attributable to gender gaps in the labour market have
The unbalanced sharing of caring responsibilities between women and men
Session (2) on line
Empirical exercises also using statistical calculation programs and advanced spreadsheet (EXCEL,GRETL) on:
Public educational expenditure by ISCED classification
Human capital intensity: mean years of schooling, and graduates-to-population ratio and graduated-to-employed ratio
Quality of education: proficiency levels of students aged 16-64 years in the PISA test
Human capital and economic growth
Session (1) on campus
Productive structure, specialization model, entrepreneurship indicators:
Business density in terms of population or employment
Characteristics and specializations by ATECO/NACE/ISIC classification and by technology intensity (high-tech, medium-tech, low-tech)
Self employed to total employment ratio
Business demography: birth rate, death rate and survival rate
Innovative Start-up
Business confidence survey
Week 18
Session (1)
Productive structure, specialization model, entrepreneurship indicators:
Business density in terms of population or employment
Characteristics and specializations by ATECO/NACE/ISIC classification and by technology intensity (high-tech, medium-tech, low-tech)
Self employed to total employment ratio
Business demography: birth rate, death rate and survival rate
Innovative Start-up
Business confidence survey
Session (2)
Empirical exercises also using statistical calculation programs and advanced spreadsheet (EXCEL,GRETL) on:
Export, import e trade balance
Sectoral export propensity and specialization index
Export by country destination
World market share and Revealed Comparative Advantage RCA
Week 10
Week 19
Session (1)
Agriculture:
The relevance of the agriculture sector within the economy: added value, GDP, employment, enterprises, export, etc.)
Quality agro-food products (PDO, PGI and TSI quality products) Agritourism farms
Session (2)
Theoretical and empirical exercises also using statistical calculation programs and advanced spreadsheet (EXCEL,GRETL) on:
Research and innovation
Human Resources in Science and Technology (HRST)
High-skill jobs by ISCO classification
Innovative enterprises, ICT investments
R&D expenditure (absolute values and % of GDP), researchers and R&D personnel (% of population and % of total employment)
Patents: patents-to-population ratio and world share
Citizens and the ICTs
Week 20
Session (1)
Environment and exploitation of natural resources
Energy consumption and foreign dependence (on foreign energy sources)
Electricity generation and renewable sources
Pollution and environmental protection (greenhouse gas emissions, recycling, etc.)
Circular economy
The green economy
Green jobs
The European Green Deal
Eco-Innovation
Session (2)
Empirical exercises also using statistical calculation programs and advanced spreadsheet (EXCEL,GRETL) on:
Environmental protection investment by industry
Regulation and economic development
Week 11
Week 21
Session (1)
Cultural heritage and tourism
UNESCO world heritage sites
Enterprises in cultural sector and cultural employment
Public expenditure on culture
Private expenditure on cultural goods and services in PPS and in relation to the total household consumption
Cultural participation: reading books and newspapers (also e-books) e-magazines; music; photos, videos including films and TV programmes; going to cinema, going to theatres and concerts and visiting cultural sites.
Session (2)
Empirical exercises also using statistical calculation programs and advanced spreadsheet (EXCEL,GRETL) on:
Tourism demand: trips of residents; tourism supply: tourism accommodation establishments, top world destinations
Tourism expenditure: final consumption expenditure of non-resident households on the economic territory and final consumption expenditure of resident households in the rest of the world.
Week 22
Session (1)
Input-output tables (IOTs)and economic impact evaluation
Leontief matrix structure
Input-coefficients: what they are and how they are measured
Calculation of the Leontief inverse matrix in order to identify the direct, indirect (inter-industry) and induced (by household expenditures) effects
Week 12
Week 23
Session (1) on campus
Construction of synthetic indicators: enterprises, sectors and households
For the enterprises: the two dimensions of the competitiveness (labor productivity and labor cost)
For the sectors: the four dimensions of the competitiveness (cost competitiveness, profitability, export propensity and innovation)
For the households: the twelve dimensions of the Equitable and Sustainable Well-being BES (health, education and training, work and life balance, economic well-being, social relationship, politics and institutions, security, subjective well-being, landscape and cultural heritage, environment, research and innovation, quality of services)
Week 24
Session (1)
Construction of synthetic indicators of the territorial attractiveness
The twelve dimensions of the territorial attractiveness (institutions, macroeconomic stability, infrastructures, health, quantity and quality of human capital of primary and secondary education, tertiary and post-tertiary and life-long learning, labor market efficiency, market size, technological readiness, business sophistication, innovation)
National comparison at a regional and a provincial level
International comparison at European level (NUTS2)