Visualize This: Class Size and Quality of Education. Your Turn

Posted to Visualize This  |  Nathan Yau
classroom
Photo by Night Owl City

Last week I posted some parallel coordinate plots that related SAT scores and class size. Now it's your turn to take a crack.

You can find the data that I used (and more) from the National Center of Education Statistics. There's a link to download the data as an Excel file. You can find pupil/teacher ratios here.

The two best entries each win a copy of David McCandless' The Visual Miscellaneum: A Colorful Guide to the World's Most Consequential Trivia as well as eternal glory on FlowingData. Yes. Eternal.

Different Views and Other Factors

There were a lot of great comments on alternative ways to view the dataset and other factors that play into average SAT scores and education quality. Obviously class size isn't the only thing.

For example, the percentage of graduates who take the SAT in each state plays a big part in the story that wasn't in my original graphic. Eighty-seven percent of Maine graduates took the test while only 3% in Iowa. There's going to be a higher average if the only people who take the test in your state are the ones who want to go to college.

Some also suggested a scatterplot with some line-fitting to tell a more complete story while others wanted some actual numbers to see what was up. Both good ideas.

How to Enter

For those new to Visualize This, here's how it works.

  1. Take your best crack at visualizing the data
  2. Submit your entry to this thread in the FlowingData forums

If you haven't registered in the forums yet (it's free), you'll want to do that first.

A few of you posted alternatives in the comments of the original post. You're welcome to submit those as your entry. Just make sure you post it to the forum thread.

Finally, you're welcome (and encouraged) to bring in other data if you feel it tells a better story.

Get your entries in by November 24, 2009, 11:59pm EST. One entry per person please.

The Prize

visual miscellaneum bookLike I said, the two best entries will each win a copy of The Visual Miscellaneum. If you're international, you'll just have to cover shipping. Entries will be judged based on appropriate interpretation of the data, design, aesthetics, and how well you tell the story of class size and quality of education (not just SAT).

Good luck, everyone. I'm looking forward to what you all come up with.

Favorites

Graphical perception – learn the fundamentals first

Before you dive into the advanced stuff – like just about everything in your life – you have to learn the fundamentals before you know when you can break the rules.

19 Maps That Will Blow Your Mind and Change the Way You See the World. Top All-time. You Won’t Believe Your Eyes. Watch.

Many lists of maps promise to change the way you see the world, but this one actually does.

The Most Unisex Names in US History

Moving on from the most trendy names in US history, let’s look at the most unisex ones. Some names have …

Reviving the Statistical Atlas of the United States with New Data

Due to budget cuts, there is no plan for an updated atlas. So I recreated the original 1870 Atlas using today’s publicly available data.