Task
Create a spreadsheet that calculates a set of summary statistics.
Description
Statistics is a calculation-intensive branch of Mathematics. Spreadsheets are particularly well-suited to working out the statistics of data sets. Not only can spreadsheets make thousands of calculations convenient to set up, most spreadsheet applications have a range of in-built statistics functions.
Instructions
(a) Create a new spreadsheet, called "Statistics.xlsx".
(b) Designate an area of a sheet for calculations, and an area for data.
(c) In the data area, copy in Data Set 1, below.
(d) In the calculation area, calculate the following statistics:
- Lowest, First Quartile, Median, Third Quartile and Highest;
- Mean and Standard Deviation;
- Mode and Midrange;
- Range and Interquartile Range.
(e) Copy your calculations to a second sheet, and copy Data Set 2 into the data area.
(f) Copy your calculations to a third sheet, and copy Data Set 3 into the data area.
Data Set 1
| 8 | 2 | 5 | 7 | 0 | 0 | 5 | 6 | 6 | 7 |
| 6 | 8 | 5 | 3 | 8 | 6 | 7 | 6 | 5 | 1 |
| 5 | 9 | 2 | 4 | 5 | 5 | 7 | 5 | 5 | 3 |
| 1 | 5 | 2 | 7 | 4 | 7 | 1 | 4 | 2 | 5 |
| 5 | 4 | 5 | 5 | 2 | 1 | 0 | 7 | 3 | 8 |
Data Set 2
| 71 | 22 | 99 | 54 | 58 | 11 | 22 | 3 | 58 | 82 |
| 25 | 23 | 50 | 80 | 77 | 51 | 56 | 82 | 85 | 13 |
| 57 | 62 | 48 | 3 | 31 | 85 | 9 | 77 | 54 | 71 |
| 98 | 26 | 1 | 59 | 46 | 82 | 45 | 13 | 33 | 79 |
| 46 | 5 | 15 | 41 | 27 | 87 | 86 | 79 | 99 | 35 |
Data Set 3
| 57.5 | 16.9 | 33 | 32.8 | 55 | 74.4 | 30.6 | 67.3 | 11 | 40.5 | 99.5 | 8.8 |
| 81.1 | 47.2 | 79.9 | 36.8 | 21.7 | 95 | 51.5 | 6.1 | 0.3 | 59.3 | 95.2 | 53.6 |
| 57.1 | 6.6 | 69 | 56.3 | 64.1 | 78.2 | 98.1 | 71.5 | 87.2 | 14.2 | 4 | 45.1 |
| 48.9 | 53.7 | 5.6 | 69.5 | 28.8 | 64.9 | 25.9 | 57.2 | 2.9 | 88.9 | 42.6 | 9.5 |
| 83 | 58.8 | 62.2 | 22.4 | 28.8 | 16.1 | 76.1 | 71.3 | 51.9 | 66.6 | 81.8 | 30.9 |
| 27.5 | 66.3 | 73.8 | 84.5 | 48.9 | 39.1 | 62.1 | 62.1 | 16.5 | 30.6 | 77.9 | 22.2 |
