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.

Screen Shot 2016-06-10 at 9.53.11 AM.png

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:

Screen Shot 2016-06-10 at 9.57.58 AM

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.


Disclaimer: The data and graphics used on this site are simulated re-creations intended to protect the privacy of the original data sources.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.