Two reasons journalists should learn to love Excel

I love Microsoft Excel, I really do. It’s currently the second highest item in my Start Menu, that’s how frequently I use it (now that I think about it, I should just pin it). I use it for all kinds of things – calculations, cleaning up data, and yes, generating graphs. It’s a really versatile tool, and it’s really easy to use (especially the latest version).

I often talk about changes I’d like to see in the mainstream media, and two important ones are context and presentation. There are so many stories that seem like they’re written in a vacuum. A story about housing starts is a good example, like this one from the Edmonton Journal yesterday. There’s 560 words there, words about numbers. Is that the best way to present that information? And even if you think it is, where’s the context? How do the housing starts this month relate to averages and historical numbers?

That’s the first reason that journalists should learn to love Excel – it can make providing context and better presentation easy. Here are three simple graphs, created with Excel, that tell you about housing starts in Edmonton.

This data comes from a PDF provided by the City of Edmonton. It shows annual housing starts since 1970. Copy and paste into Excel and you’re done!

This graph shows monthly housing starts from October 2008 until now. It uses data from the CMHC’s Reports & Publications section. Took maybe 10 minutes of copying and pasting.

This graph compares housing starts for this time of year from 2006 until now. Also comes from the CMHC.

Imagine if the article included graphs like these. The journalist could then focus on telling a more interesting story.

So, what’s the second reason journalists should learn to love Excel? Well, it can help them get their story right. Here’s what the Journal article starts with:

Despite a strong spring, the slowing trend in new-home construction became clear in October with housing starts dropping to their lowest level since June 2009 in the Edmonton region.

As you can see from the second graph above, that’s just not true. Is there a slowing trend? Maybe, if you just look from the spring to now. Was October the lowest level since June 2009? No. There were just 690 starts in August 2010. In fact, there were six months with lower housing starts since June 2009. I’m not sure what data the Journal was looking at, but it doesn’t appear to be CMHC data.

Add Excel to your toolkit. You won’t regret it.

UPDATE: Here’s the Journal story on August housing starts. Maybe if finding archived stories was easier, Dave Cooper, who wrote the story on October housing starts, could have consulted previous Journal articles to see that the lowest level was much more recent than June 2009.