Spreadsheet: 779641d1651928020-average-formula-solution-problem-using-lists-test-cohort-tracking
Sheet: Sheet1

Name | Group | Year | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Score 6 |  | Group | Year | Score | Average |  |  |  |  | Group | Year | Score
Student 1 | 1 | 2016-2017 | 0.42 | 0.94 | 2.58 | 2.63 | 1.05 | 2.15 |  | 1 | 2016-2017 | 1 |  |  |  |  |  | 1 | 2016-2017 | 1
Student 2 | 2 | 2016-2017 | 2.61 | 3.07 | 3.47 | 2.88 | 2.15 | 2.22 |  | 1 | 2017-2018 | 2 |  |  |  |  |  | 2 | 2017-2018 | 2
Student 3 | 3 | 2016-2017 | -0.74 | -0.51 | 3.62 | 2.61 | 2.87 | 4.21 |  | 1 | 2018-2019 | 3 |  |  |  |  |  | 3 | 2018-2019 | 3
Student 4 | 4 | 2016-2017 | 3.15 | 2.45 | 3.74 | 2.84 | 1.2 | 2.54 |  | 1 | 2019-2020 | 4 |  |  |  |  |  | 4 | 2019-2020 | 4
Student 5 | 5 | 2016-2017 | -0.22 | 0.48 | 2.35 | 2.26 | 1.46 | 1.78 |  | 1 | 2020-2021 | 5 |  |  |  |  |  | 5 | 2020-2021 | 5
Student 6 | 6 | 2016-2017 | 2.4 | 2.83 | 1.73 | 1.77 | -0.21 | -0.68 |  | 1 | 2021-2022 | 6 |  |  |  |  |  | 6 | 2021-2022 | 6
Student 7 | 1 | 2016-2017 | 1.43 | 1.26 | 1.42 | 1.37 | 0.2 | 0.8
Student 8 | 2 | 2016-2017 | 2.43 | 2.52 | 2.27 | 3.37 | 2.91 | 4.43
Student 9 | 3 | 2016-2017 | 0.62 | 1.28 | -0.25 | -0.53 | -0.84 | 0.58
Student 10 | 4 | 2016-2017 | 0.19 | -0.08 | 3.05 | 3.24 | 2.73 | 2.3
Student 11 | 5 | 2016-2017 | 3.83 | 3.71 | 1.09 | 0.99 | -0.33 | 0.67
Student 12 | 6 | 2016-2017 | 2.55 | 2.61 | 1.73 | 0.89 | 1.41 | 1.11
Student 13 | 1 | 2017-2018 | 2.37 | 1.56 | 1.02 | 1.63 | 0.33 | -0.88
Student 14 | 2 | 2017-2018 | 1.49 | 1.48 | 0.66 | 2.25 | -0.9 | -0.99
Student 15 | 3 | 2017-2018 | 2.27 | 3.02 | 2.29 | 2.36 | 4.38 | 4.58
Student 16 | 4 | 2017-2018 | 1.93 | 2.29 | 3.76 | 2.13 | 2.58 | 2.5
Student 17 | 5 | 2017-2018 | 1.7 | 1.12 | 3.17 | 1.78 | 2.22 | 0.81
Student 18 | 6 | 2017-2018 | 4.3 | 3.34 | 2.85 | 2.51 | 2.41 | 3.34
Student 19 | 1 | 2018-2019 | 1.77 | 1.82 | 0.88 | 2.51 | 0.97 | 2.03
Student 20 | 2 | 2018-2019 | 1.01 | 2.04 | 2.96 | 2.83 | 1.92 | 1.67
Student 21 | 3 | 2018-2019 | 3.95 | 4.5 | 0.76 | 1.73 | 1.9 | 3.74
Student 22 | 4 | 2018-2019 | 1.01 | 1.61 | 2.31 | 2.07 | 1.57 | 2.8
Student 23 | 5 | 2018-2019 | 3.2 | 2.05 | 1.2 | 1.09 | 0.96 | 1.62
Student 24 | 6 | 2018-2019 | -2.3 | -1.25 | 3.14 | 2.29 | 3.5 | 4.71
Student 25 | 1 | 2019-2020 | -0.3 | -0.49 | -1.8 | 0.15 | -1.22 | -0.89
Student 26 | 2 | 2019-2020 | -0.58 | -0.27 | 3.51 | 3.23 | 2.36 | 2.97
Student 27 | 3 | 2019-2020 | -0.51 | -0.69 | -1.43 | 1.36 | 0.07 | 0.92
Student 28 | 4 | 2019-2020 | 0.62 | 1.28 | 2.24 | 3.46 | 1.89 | 3.48
Student 29 | 5 | 2019-2020 | 2.09 | 2.2 | 1.4 | 1.14 | 1.35 | 2.21
Student 30 | 6 | 2019-2020 | 2.22 | 2.72 | 2.54 | 2.25 | 2.76 | 4.05
Student 31 | 1 | 2020-2021 | 2.51 | 3.7 | 5.13 | 3.46 | 3.33 | 2.85
Student 32 | 2 | 2020-2021 | 1.77 | 1.82 | 0.34 | 1.41 | 0.72 | 2.01
Student 33 | 3 | 2020-2021 | 2.03 | 2.28 | 4.45 | 5.2 | 3.71 | 5.58
Student 34 | 4 | 2020-2021 | -1.17 | -1.47 | 0.4 | 0.68 | 2.61 | 3.6
Student 35 | 5 | 2020-2021 | -0.25 | -0.25 | 2.23 | 1.72 | 1.56 | 3.79
Student 36 | 6 | 2020-2021 | 1.23 | 2.36 | 3.17 | 3.92 | 1.48 | 1.85
Student 37 | 1 | 2021-2022 | 2.26 | 2.22 | 2.91 | 2.39 | 3.02 | 2.31
Student 38 | 2 | 2021-2022 | 3.1 | 1.83 | 3.5 | 2.62 | 2.29 | 2.32
Student 39 | 3 | 2021-2022 | 3.08 | 3.05 | 1.72 | 2.01 | 1.12 | 2.16
Student 40 | 4 | 2021-2022 | 2.9 | 3.29 | 1.39 | 1.98 | 1.01 | 1.94
Student 41 | 5 | 2021-2022 | 1.27 | 1.33 | 4.4 | 4.41 | 4.21 | 4.71
Student 42 | 6 | 2021-2022 | 2.57 | 1.58 | 3.48 | 5.32 | 3.48 | 2.72