Spreadsheet: 680811d1591200764-calculating-mean-median-and-mode-temp
Sheet: Sheet3

2017 | 2018 | 2019
1 | 1.5 | 0
2 | 1 | 1
1.5 | 1 | 1
1 | 1 | 1 |  |  |  |  | 2017 | 2018 | 2019
1 | 2 | 1 |  |  |  | Mean
1 | 1.5 | 2 |  |  |  | Median
0.5 | 1 | 1 |  |  |  | Mode
1 | 1 | 0.75
1 | 1 | 1
1.25 | 0.75 | 1
1 | 1 | 0.5
0 | 1.25 | 1
2 | 1 | 1.25 |  |  |  | Row Labels | Count of 2017 | Count of 2018 | Count of 2019
1 | 2 | 1 |  |  |  | 0 | 14 | 14 | 14
1 | 1 | 1 |  |  |  | 0.25 | 1 | 1 | 1
1.25 | 1.25 | 0 |  |  |  | 0.5 | 2 | 2 | 2
1 | 0.75 | 1.75 |  |  |  | 0.75 | 6 | 6 | 6
0 | 0 | 1 |  |  |  | 1 | 102 | 102 | 102
1.5 | 1.75 | 1 |  |  |  | 1.25 | 38 | 38 | 38
1.25 | 1.25 | 0.25 |  |  |  | 1.5 | 45 | 45 | 45
1 | 1 | 1.75 |  |  |  | 1.75 | 3 | 3 | 3
1 | 0.25 | 1.25 |  |  |  | 2 | 9 | 9 | 9
0 | 1.75 | 1 |  |  |  | Grand Total | 220 | 220 | 220
1.75 | 1.5 | 1
1.5 | 0 | 1
0 | 2 | 1.25
1.25 | 1.5 | 1
1 | 1 | 0.25 |  |  |  | Row Labels | Average of 2017
2 | 1 | 1 |  |  |  | 0 | 0
1 | 1.5 | 1 |  |  |  | 0.25 | 0.25
0.75 | 1.25 | 1 |  |  |  | 0.5 | 0.5
1 | 1.25 | 0 |  |  |  | 0.75 | 0.75
1 | 0.25 | 1 |  |  |  | 1 | 1
1.5 | 1 | 2 |  |  |  | 1.25 | 1.25
1.25 | 0.25 | 1.25 |  |  |  | 1.5 | 1.5
1 | 1 | 0.25 |  |  |  | 1.75 | 1.75
0.25 | 1 | 1 |  |  |  | 2 | 2
1 | 0 | 1 |  |  |  | Grand Total | 1.118181818181818
1 | 1 | 0.5
1 | 2 | 1
1 | 1 | 1.5
0 | 0.5 | 1
1.25 | 1 | 1
2 | 0 | 1
1.5 | 1 | 1
1 | 0.5 | 1.25
1 | 1 | 1
1 | 1.5 | 1.5
1 | 1 | 1.5
1 | 1 | 1
0.75 | 1.25 | 1
1.5 | 1 | 1.75
1 | 1.25 | 1
1 | 1.5 | 1.25
1.25 | 1.5 | 1.5
1 | 1.5 | 1
1 | 1 | 1.5
1 | 1.25 | 1
1 | 1.5 | 1.25
1.25 | 1 | 1
1.5 | 1 | 2
1 | 1 | 1
1.25 | 1.5 | 1.5
1 | 0 | 1.5
1.5 | 1.25 | 2
1 | 1.25 | 1
1.25 | 1.25 | 1
1 | 1.25 | 1.25
1.5 | 1 | 1.5
1 | 2 | 1
1 | 1 | 1.25
1.25 | 1.5 | 1.25
1 | 1.5 | 1
1 | 2 | 0.75
1.5 | 1 | 1
2 | 1 | 1.5
1.25 | 1.25 | 2.5
1.5 | 1.5 | 1
1.5 | 0 | 1.25
1.5 | 1.25 | 1.25
1.5 | 1 | 1.25
1 | 1 | 1.25
1.5 | 1 | 1.25
2 | 1 | 1
0 | 1.5 | 1.25
1.5 | 2 | 0.75
1.25 | 1 | 1
1 | 1.25 | 1
1 | 1.5 | 0.5
1.5 | 1 | 1.5
1.5 | 1.5 | 1.25
2 | 1 | 1.25
1 | 1 | 1
1 | 1.5 | 1
1.75 | 1 | 1
1.25 | 1 | 1.25
1.5 | 1.25 | 1.25
1 | 1 | 1
1 | 1.5 | 1
1.25 | 1.25 | 1.25
1 | 1.25 | 1
1.25 | 1.25 | 1
1.25 | 1 | 1
1 | 1.5 | 1.25
1.5 | 1.5 | 1
1.5 | 1.25 | 1
1.5 | 1 | 0.25
1 | 1 | 2
1.25 | 1 | 1
1 | 1.25 | 2
1.5 | 1 | 0.75
1.5 | 1.5 | 1.25
1.25 | 1.25 | 0
1 | 1.25 | 1
1.5 | 1 | 1.75
1 | 1.25 | 1
1 | 0.25 | 1
1 | 2 | 1.5
1 | 1 | 1.75
1.5 | 2 | 1.25
1 | 1.25 | 1
1 | 1 | 1
1.25 | 1 | 1
1.5 | 1 | 0.75
0.5 | 1 | 1.25
2 | 1 | 1
1.5 | 1.25 | 1
1 | 1.75 | 0
1.25 | 1.25 | 1
0.75 | 1 | 1
1 | 1 | 1
1 | 1 | 1
1.5 | 1 | 1
1.25 | 1.25 | 1
1.5 | 0.75 | 1.25
1.25 | 0.5 | 1.25
1 | 1 | 1.25
1 | 0.5 | 1
1 | 1 | 1.25
1 | 1 | 1.25
1 | 1 | 1
1 | 1 | 1.25
1 | 1 | 1
0.75 | 1 | 1.5
1 | 1 | 1
1 | 1.25 | 1.25
1 | 1 | 1
1 | 1 | 1
1.25 | 1.25 | 1
1.25 | 1 | 1
1 | 1 | 0.75
1 | 1.5 | 1.5
1 | 1 | 1.75
1 | 1.5 | 1.25
1.5 | 1 | 1.5
1 | 1.5 | 1.5
1 | 1 | 1.5
1.25 | 1.25 | 1
1 | 1 | 1
1.5 | 1.5 | 1
1.5 | 0.75 | 1
1 | 1 | 1.5
1.5 | 1.5 | 1.25
1 | 1.25 | 1
1.5 | 1.5 | 1
1.25 | 1.5 | 0
1.25 | 1.5 | 1.75
2 | 1 | 0
1 | 1 | 0.75
1.5 | 1 | 0.75
1.5 | 1.25 | 1
1 | 1.25 | 1
1 | 1.25 | 1
0 | 1 | 1
1 | 1 | 1
1 | 1 | 0.75
1 | 1.5 | 1.5
1.5 | 0.5 | 1.25
1.25 | 1 | 0.75
1 | 1 | 1
1.5 | 1.25 | 1.25
1.5 | 1 | 1
1 | 1 | 1
1 | 1 | 1.25
1 | 1 | 1
1.25 | 1 | 1
1 | 1.25 | 1.5
1 | 1 | 1
1.25 | 0.5 | 0.75
0.75 | 1.25 | 1.5
1.25 | 1.25 | 1.25
1.5 | 1 | 1.25
1 | 1.25 | 1.25
1.25 | 0.5 | 1
1.75 | 1.75 | 1
1 | 1 | 1
1.5 | 1.25 | 1
1.5 | 1.25 | 1
1.25 | 1 | 1
0 | 1.5 | 1
1 | 1.75 | 0
1.5 | 1 | 1
0.75 | 0.75 | 1
1.5 | 1.25 | 1
0 | 1 | 0
0 | 1 | 1
1 | 1.25 | 1
1.25 | 1.5 | 1
1 | 0.5 | 1
1.25 | 1.5 | 0.25
1 | 1 | 1
1 | 1 | 1
1.25 | 0.25 | 1
1.25 | 1.25 | 1.25
1 | 1 | 1.5
0 | 1 | 1
0 | 1.5 | 0.75
1 | 1 | 1
0 | 1 | 1.25
0 | 1.25 | 1
 | 1 | 0
 | 1 | 1
 | 1 | 1
 | 1 | 0.5
 |  | 1
 |  | 1
 |  | 1
 |  | 0