Detailed program
1 – Introduction to Data Analysis and Business and financial reporting
General features of Excel and R
2 – Data description, summary and interpretation
Use of Excel e R for:
- constructing databases; micro data, macro data, meta data; creation of variables and data frames; data conversion; data import/export; data standardization
- constructing and interpreting tables and graphs
- computing and interpreting statistical indices (position, variability, form)
- descriptive statistical analysis
Business cases and applications
3 – Study and interpretation of the relationships among two (or more) variables
Use of Excel e R for:
- constructing and analysing crosstabs
- association, correlation, and regression analyses
- time series (graphical analysis, moving averages)
Business cases and applications
4 –Representation and communication of results
Use of Excel, R and Word for constructing a graphical and statistical report