- 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;
- Application of unpaired t test for equal or unequal variance by means of the command Data Analysis and interpretation of the test results;
- Application of the independence test (chi-square) through the use of functions: TEST.CHI.QUAD and DISTRIB.CHI.QUAD.DS and interpretation of the test result.