The course is aimed at realization of the main methods of statistical analysis using a common program such as Microsoft Excel (2010 version). At the end of the course the student will have learned the elements for: Learn how to build a data matrix; Build graphical representations; Analyze the data both from descriptive point of view that analytical; The interpretation of the results.
Teaching Methods
The course is based on taught lessons and practical applications through pc with resolution of statistical problem using excel In particular students will have to attend taught lessons at one of the computerized classroom of the University.
Assessment Methods
Examination will carry out using pc: analysis of a data set and resolving the statistical problems
Texts
Excel & Statistica Medica di S.Villani e P.Borrelli, Ed. MEDEA 2013
Contents
Definition of electronic spreadsheet; Programme and toolbar structure; Creation a data matrix; Introduction to the functions for the main descriptive statistics: Count cells: CONTA (); Sum: SOMMA (); Minimum: MIN (); Maximum: MAX (); Mean: MEDIA (); Mode: MODA (); Median: MEDIANA (); SD: DEV.ST (); Variance: VAR (); Range: MAX () - MIN (); Coefficient of variation: DEV.ST () / MEDIA (); Using the command Data Analysis for the analysis of descriptive statistics; Pivot tables in single and double entry, creation of classes for quantitative variables with data display: Normal; Percentage of the total; Average; Standard deviation; Pivot Charts for qualitative variables (bars and aerogramma) and quantitative (histogram) with an explanation of the design and the layout (title, axes, legend, data labels); Application of the correlation Pearson's test through the Data Analysis command and creation of scatter plot.
