Spreadsheets have procedures for automatically describing data, such as the 'Data Analysis' tool in Excel (if this is missing you have to load the Analysis ToolPac as an add-in). An option in this is 'Descriptive Statistics' which automatically finds 13 measures for a set of data (illustrated in Figure). Explore the analyses done by theseprocedures.

Transcribed Image Text:

4 1 Data description Data description Data 45 35 3 Mean tandard error Median Mode Standard deviation Sample variance Kurtosis Skewness Range Minimum Maximum Sum Count 45.41 3.92 45.00 45.00 16.15 260.76 -0.75 -0.21 53.00 19.00 72.00 772 17 21 34 45 10 12 13 72 54 15 20 17 51 39 18 2057