It doesn’t take a data scientist to draw conclusions about longitudinal data. One of my colleagues decided to simply grab MAP averages of specific graduating classes (which he called “cohorts”) and track them over time.
Simple but effective.
This table allows us to look vertically, so see the change in a cohort; and horizontally, to compare cohorts when they are in specific grade levels.
With a simple rearrangement and renaming, he also showed the data by year:
Sometimes, us data folk like to go for the visually appealing – html/css styled graphs. We like to use our powers of statistics to add weight to our conclusions.
But these two charts show us that it’s not always necessary and that it doesn’t always take a mathematician. We had a great conversation around this work, without all the flashiness.