Correlation vs. Causation [Charting Chatter]

Share

Facebook
Twitter
LinkedIn

Here is a trap that is easy to fall in to. Confusing correlation as causation. As analysts, it is our job to see the data as it is rather than imply causation that doesn’t exist.

Let’s sample a chart, recently featured in Economist’s graphic detail under the title Measuring well-being.

correlation-causation-confusion

At the end of the article they show the above chart and say, (emphasis mine)

BCG also compared financial inclusion (the percentage of individuals aged 15 or over with a bank account) against each country’s SEDA score, revealing a clear relationship.The report’s authors found that countries with higher financial inclusion generally had higher well-being than their peers at a similar income level.

Now, it is easy to misunderstand above chart and come to a conclusion that if you provide bank accounts to everyone in a country, then the country’s SEDA score (well-being) would improve.

But this would be wrong.

As an analyst leaning towards awesomeness, you want to ask questions like,

  • Is it a coincidence that countries with higher well-being naturally have bank accounts for everyone?
  • How does having a bank account impact a person’s well being?
  • What other factors can contribute to well being? What about access to education, healthcare and information?

So there you go. Next time you see data  or visual analysis that exhibits correlations, do not confuse them as causation. Question the factors first.

More charting principles and guidelines for you

Do you often confuse correlation with causation?

Have you seen such misinterpretation of data in your work life? What was it like? Please share your thoughts in the comments section.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

One Response to “Loan Amortization Schedule in Excel – FREE Template”

  1. Ag says:

    The balance formula as given doesnt seem to work on my excel

Leave a Reply