A.Y. 2019/2020
Overall hours
Learning objectives
The course aims to:
- - To introduce the main tools that allow you to make statistical inference based on sample surveys;
- - Explain how to use a widely used spreadsheet (Excel, Microsoft) for the synthetic and graphic representation of data;
- - Implement, within a widely spread spreadsheet (Excel, Microsoft), the statistical inference tools useful for comparing two or more samples.
Expected learning outcomes
Addressing and solving statistical problems and graphically reporting the numerical results obtained with health surveys, using the Microsoft Excel program
Course syllabus and organization

Single session

Course syllabus
1) Introduction to the procedures based on hypothesis testing for quantitative or interval variables
2) Description of the sample using the sample mean and the sample variance
3) Description of the sample through the distribution and calculation of percentiles
4) Hypothesis test for the assessment of differences between groups: F-test
5) Homoscedasticity test
6) Hypothesis test for the evaluation of the differences between two groups: t-test for unpaired data
7) Use of the t-test to isolate differences between groups in multiple comparison problems
8) Hypothesis test for repeated measures: t-test for paired data
9) Hypothesis test based on the rank sum: the Mann-Whitney test
10) Introduction to the procedures based on the hypothesis test for two mutually exclusive nominal variables
11) Description of the sample by the frequency of the two categories
12) Construction of the contingency table
13) Hypothesis test to evaluate the differences between groups: χ2 tests
14) Use of the χ2 test to isolate differences between groups in multiple comparison problems
15) Hypothesis test for repeated measures: McNemar test
Prerequisites for admission
Teaching methods
The course is done in a classroom using computers using the Excel program (Microsoft). Each lesson has the structure of a practical training session: in each lesson one or more problems related to the various topics of the course are solved on the computer. Each practical training session is preceded by the projection of PowerPoint slides related to the theoretical topic of the session.
Teaching Resources
- Slides of the lessons and exercises will be distributed during the course.
- S.A. Glantz, Primer on Bio-Statistics, McGraw-Hill. 1997.
- Microsfot Excel Tutorial, Microsoft.
Assessment methods and Criteria
Resolution of a computer exercise using the Excel program (Microsoft). Each correct question is worth about 3 points. The sum of the points corresponds to the final outcome of the test. The test is passed if the sum of the points is greater than or equal to 18.
INF/01 - INFORMATICS - University credits: 3
Lessons: 24 hours
Professor: Porta Alberto
by appointment to be agreed via e-mail
San Donato Milanese - via R. Morandi 30