Summarizing data over several Google Sheets - an exercise in stats and formulas
November 28, 2019
In my current job, as Head of Quality and Curriculum at </salt>, my thirst for being data-driven is frequently useful. In particular when it comes to test results for the developers in our courses. We test the developers every weekend (for 10/13 weeks) and we have now run 4 courses using the same tests… A gold mine of knowledge if you can mine it.
To help each developer and us, understand how they are doing we produce a diagram that compares their results to the result of their class (ca 30 people) but also compared to all classes (to date 4 x 30 people).
In the end we want to produce charts that looks like these:


But getting there has been quite tricky but oh so rewarding. At the end of this blog post,...