The aim of the course is to provide students with the statistical tools for a self-sufficient capacity for processing and analyzing data in the field of social research. By privileging the application aspects of statistics, the course intends to learn the conceptual bases and the functioning of the most common techniques of exploratory statistics, both univariate and bivariate.
At the end of the course the student:
- has become familiar with the basic concepts of Social Statistics
- is able to carry out exploratory data analysis and use the main statistical indicators for social sciences.
The objective of the laboratory is the implementation of the main statistical functions of Excel.
At the conclusion of the laboratory the student is able to perform data analysis with the help of Excel.
At the end of the course the student:
- has become familiar with the basic concepts of Social Statistics
- is able to carry out exploratory data analysis and use the main statistical indicators for social sciences.
The objective of the laboratory is the implementation of the main statistical functions of Excel.
At the conclusion of the laboratory the student is able to perform data analysis with the help of Excel.
scheda docente
materiale didattico
Build of pivot tables. Graphical representations: bar graph, pie chart, histogram, box plot.
Statistical functions: mean, median, fashion, quartiles.
Statistical functions: variance, deviation
Pivot tables for pairs of variables. Construction of chi-square index.
Dependence on the mean. Representation of regression spline.
Covariance, correlation. Scatter plot and representation of regression line. Estimation of the parameters of the regression line.
Programma
Introduction to Excel. Main commands. Sum, minimum, maximum, count.se functions.Build of pivot tables. Graphical representations: bar graph, pie chart, histogram, box plot.
Statistical functions: mean, median, fashion, quartiles.
Statistical functions: variance, deviation
Pivot tables for pairs of variables. Construction of chi-square index.
Dependence on the mean. Representation of regression spline.
Covariance, correlation. Scatter plot and representation of regression line. Estimation of the parameters of the regression line.
Testi Adottati
Teaching materials from the teacher.Modalità Frequenza
Once a week in the Laboratory, lasting three hours.Modalità Valutazione
The test consists of carrying out a data analysis starting from a dataset provided by the lecturer. The test will be evaluated in terms of completeness, correctness and appropriateness of the analysis and comments. The test will be considered passed with a passing grade (18 to 22) if major processing is conducted correctly. The test is considered passed with a good grade (23 to 26) if all the elaborations are carried out correctly and the main comments of the results are present. The test is considered passed with a very good/optimum grade (27 to 30/30L) if all the elaborations are corrected and completed with comments of the results that are appropriate to the reference context .