Portale di Ateneo - En.Unibs.it

Use of Excel and R, with business cases and applications, for data analysis and business and financial reporting

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