Spreadsheet: 680845d1591219027-calculating-mean-median-and-mode-temp
Sheet: Sheet1

Year | Value |  |  |  | Count of Value | Column Labels |  |  |  |  |  | Column Labels
2017 | 1 |  |  |  | Row Labels | 2017 | 2018 | 2019 | Grand Total |  |  | 2017 | 2018 | 2019 | Grand Total
2017 | 2 |  |  |  | 0 | 14 | 6 | 11 | 31 |  | Average of Value | 1.118181818181818 | 1.119419642857143 | 1.06140350877193 | 1.099330357142857
2017 | 1.5 |  |  |  | 0.25 | 1 | 5 | 5 | 11
2017 | 1 |  |  |  | 0.5 | 2 | 8 | 4 | 14
2017 | 1 |  |  |  | 0.75 | 6 | 5 | 12 | 23
2017 | 1 |  |  |  | 1 | 102 | 105 | 119 | 326
2017 | 0.5 |  |  |  | 1.25 | 38 | 46 | 42 | 126
2017 | 1 |  |  |  | 1.5 | 45 | 35 | 21 | 101
2017 | 1 |  |  |  | 1.75 | 3 | 5 | 7 | 15
2017 | 1.25 |  |  |  | 2 | 9 | 9 | 6 | 24
2017 | 1 |  |  |  | 2.5 |  |  | 1 | 1
2017 | 0 |  |  |  | Grand Total | 220 | 224 | 228 | 672
2017 | 2
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1
2017 | 0
2017 | 1.5
2017 | 1.25
2017 | 1
2017 | 1
2017 | 0
2017 | 1.75
2017 | 1.5
2017 | 0
2017 | 1.25
2017 | 1
2017 | 2
2017 | 1
2017 | 0.75
2017 | 1
2017 | 1
2017 | 1.5
2017 | 1.25
2017 | 1
2017 | 0.25
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 0
2017 | 1.25
2017 | 2
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 0.75
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1.5
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1.5
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1
2017 | 1.5
2017 | 2
2017 | 1.25
2017 | 1.5
2017 | 1.5
2017 | 1.5
2017 | 1.5
2017 | 1
2017 | 1.5
2017 | 2
2017 | 0
2017 | 1.5
2017 | 1.25
2017 | 1
2017 | 1
2017 | 1.5
2017 | 1.5
2017 | 2
2017 | 1
2017 | 1
2017 | 1.75
2017 | 1.25
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1.25
2017 | 1.25
2017 | 1
2017 | 1.5
2017 | 1.5
2017 | 1.5
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1.5
2017 | 1.5
2017 | 1.25
2017 | 1
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1.5
2017 | 0.5
2017 | 2
2017 | 1.5
2017 | 1
2017 | 1.25
2017 | 0.75
2017 | 1
2017 | 1
2017 | 1.5
2017 | 1.25
2017 | 1.5
2017 | 1.25
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 0.75
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1.25
2017 | 1
2017 | 1
2017 | 1
2017 | 1
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1.5
2017 | 1.5
2017 | 1
2017 | 1.5
2017 | 1
2017 | 1.5
2017 | 1.25
2017 | 1.25
2017 | 2
2017 | 1
2017 | 1.5
2017 | 1.5
2017 | 1
2017 | 1
2017 | 0
2017 | 1
2017 | 1
2017 | 1
2017 | 1.5
2017 | 1.25
2017 | 1
2017 | 1.5
2017 | 1.5
2017 | 1
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1
2017 | 1.25
2017 | 0.75
2017 | 1.25
2017 | 1.5
2017 | 1
2017 | 1.25
2017 | 1.75
2017 | 1
2017 | 1.5
2017 | 1.5
2017 | 1.25
2017 | 0
2017 | 1
2017 | 1.5
2017 | 0.75
2017 | 1.5
2017 | 0
2017 | 0
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1.25
2017 | 1
2017 | 1
2017 | 1.25
2017 | 1.25
2017 | 1
2017 | 0
2017 | 0
2017 | 1
2017 | 0
2017 | 0
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1
2018 | 2
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1
2018 | 0.75
2018 | 1
2018 | 1.25
2018 | 1
2018 | 2
2018 | 1
2018 | 1.25
2018 | 0.75
2018 | 0
2018 | 1.75
2018 | 1.25
2018 | 1
2018 | 0.25
2018 | 1.75
2018 | 1.5
2018 | 0
2018 | 2
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1.5
2018 | 1.25
2018 | 1.25
2018 | 0.25
2018 | 1
2018 | 0.25
2018 | 1
2018 | 1
2018 | 0
2018 | 1
2018 | 2
2018 | 1
2018 | 0.5
2018 | 1
2018 | 0
2018 | 1
2018 | 0.5
2018 | 1
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1.25
2018 | 1.5
2018 | 1.5
2018 | 1.5
2018 | 1
2018 | 1.25
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1
2018 | 1.5
2018 | 0
2018 | 1.25
2018 | 1.25
2018 | 1.25
2018 | 1.25
2018 | 1
2018 | 2
2018 | 1
2018 | 1.5
2018 | 1.5
2018 | 2
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1.5
2018 | 0
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1.5
2018 | 2
2018 | 1
2018 | 1.25
2018 | 1.5
2018 | 1
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1.5
2018 | 1.25
2018 | 1.25
2018 | 1.25
2018 | 1
2018 | 1.5
2018 | 1.5
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1.5
2018 | 1.25
2018 | 1.25
2018 | 1
2018 | 1.25
2018 | 0.25
2018 | 2
2018 | 1
2018 | 2
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1.75
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1.25
2018 | 0.75
2018 | 0.5
2018 | 1
2018 | 0.5
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1.5
2018 | 1
2018 | 1.5
2018 | 1
2018 | 1.5
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1.5
2018 | 0.75
2018 | 1
2018 | 1.5
2018 | 1.25
2018 | 1.5
2018 | 1.5
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1.25
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1
2018 | 1.5
2018 | 0.5
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 0.5
2018 | 1.25
2018 | 1.25
2018 | 1
2018 | 1.25
2018 | 0.5
2018 | 1.75
2018 | 1
2018 | 1.25
2018 | 1.25
2018 | 1
2018 | 1.5
2018 | 1.75
2018 | 1
2018 | 0.75
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1.5
2018 | 0.5
2018 | 1.5
2018 | 1
2018 | 1
2018 | 0.25
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1.5
2018 | 1
2018 | 1
2018 | 1.25
2018 | 1
2018 | 1
2018 | 1
2018 | 1
2019 | 0
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 2
2019 | 1
2019 | 0.75
2019 | 1
2019 | 1
2019 | 0.5
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1
2019 | 0
2019 | 1.75
2019 | 1
2019 | 1
2019 | 0.25
2019 | 1.75
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1
2019 | 0.25
2019 | 1
2019 | 1
2019 | 1
2019 | 0
2019 | 1
2019 | 2
2019 | 1.25
2019 | 0.25
2019 | 1
2019 | 1
2019 | 0.5
2019 | 1
2019 | 1.5
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1.5
2019 | 1.5
2019 | 1
2019 | 1
2019 | 1.75
2019 | 1
2019 | 1.25
2019 | 1.5
2019 | 1
2019 | 1.5
2019 | 1
2019 | 1.25
2019 | 1
2019 | 2
2019 | 1
2019 | 1.5
2019 | 1.5
2019 | 2
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1.5
2019 | 1
2019 | 1.25
2019 | 1.25
2019 | 1
2019 | 0.75
2019 | 1
2019 | 1.5
2019 | 2.5
2019 | 1
2019 | 1.25
2019 | 1.25
2019 | 1.25
2019 | 1.25
2019 | 1.25
2019 | 1
2019 | 1.25
2019 | 0.75
2019 | 1
2019 | 1
2019 | 0.5
2019 | 1.5
2019 | 1.25
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1
2019 | 0.25
2019 | 2
2019 | 1
2019 | 2
2019 | 0.75
2019 | 1.25
2019 | 0
2019 | 1
2019 | 1.75
2019 | 1
2019 | 1
2019 | 1.5
2019 | 1.75
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1
2019 | 0.75
2019 | 1.25
2019 | 1
2019 | 1
2019 | 0
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1.25
2019 | 1.25
2019 | 1
2019 | 1.25
2019 | 1.25
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1.5
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 0.75
2019 | 1.5
2019 | 1.75
2019 | 1.25
2019 | 1.5
2019 | 1.5
2019 | 1.5
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1.5
2019 | 1.25
2019 | 1
2019 | 1
2019 | 0
2019 | 1.75
2019 | 0
2019 | 0.75
2019 | 0.75
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 0.75
2019 | 1.5
2019 | 1.25
2019 | 0.75
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1.5
2019 | 1
2019 | 0.75
2019 | 1.5
2019 | 1.25
2019 | 1.25
2019 | 1.25
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 0
2019 | 1
2019 | 1
2019 | 1
2019 | 0
2019 | 1
2019 | 1
2019 | 1
2019 | 1
2019 | 0.25
2019 | 1
2019 | 1
2019 | 1
2019 | 1.25
2019 | 1.5
2019 | 1
2019 | 0.75
2019 | 1
2019 | 1.25
2019 | 1
2019 | 0
2019 | 1
2019 | 1
2019 | 0.5
2019 | 1
2019 | 1
2019 | 1
2019 | 0