Data Analysis
A.Y. 2024/2025
Learning objectives
The course employs an empirical approach and aims to provide students with the ability to process data from external sources or collected from experiments using the main functionalities of Excel. Students will acquire the ability to use key statistical tools to extract useful information about the studied phenomena, identify hidden patterns, and understand the implications of the obtained results.
Expected learning outcomes
Students will learn to use statistical tools through Excel to process data and obtain information and knowledge applicable in various professional and research contexts.
Lesson period: Second semester
Assessment methods: Esame
Assessment result: voto verbalizzato in trentesimi
Single course
This course can be attended as a single course.
Course syllabus and organization
Single session
Responsible
Lesson period
Second semester
Course syllabus
Introduction to using Excel for data analysis
The graphical representation of the data
Measures of central tendency (mean, median, mode)
Measurements of dispersion or variation
Bivariate data analysis and pivot tables
Main databases for cultural heritage and database management
Notes on the concept of probability
The normal probability distribution
Confidence intervals
Hypothesis testing
Regression analysis
Analysis of Variance
The graphical representation of the data
Measures of central tendency (mean, median, mode)
Measurements of dispersion or variation
Bivariate data analysis and pivot tables
Main databases for cultural heritage and database management
Notes on the concept of probability
The normal probability distribution
Confidence intervals
Hypothesis testing
Regression analysis
Analysis of Variance
Prerequisites for admission
Interest in the quantitative approach to the study of phenomena
Teaching methods
There will be theoretical lessons and also laboratory exercises using Excel.
Teaching Resources
- Material provided by the teacher on the Mylab website
- Textbook: Pelosi, M., Sandifer, T., Cerchiello, P., & Giudici, P. S. (2009). Introduction to statistics. McGraw Hill.
- Textbook: Pelosi, M., Sandifer, T., Cerchiello, P., & Giudici, P. S. (2009). Introduction to statistics. McGraw Hill.
Assessment methods and Criteria
The exam is written and will take place in the computer laboratory using Excel. It includes exercises to be carried out using data provided by the teacher. The vote is out of thirty
Professor(s)
Reception:
on appointment
Via Celoria 2, Milan, Italy, 3rd floor (or by Skype/Teams/Zoom)