All articles with 'correlation' Tag

Correlation vs. Causation [Charting Chatter]

Published on Aug 3, 2016 in Charts and Graphs
Correlation vs. Causation [Charting Chatter]

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.

Continue »

CP030: Detecting fraud in data using Excel – 5 techniques for you

Published on Feb 19, 2015 in Analytics, Podcast Sessions

In the 30th session of podcast, let’s learn how to uncover fraud in data.

How to detect fraud in data - 5 techniques for you - CP030 - podcast

What is in this session?

In the wake of hedge fund scams, accounting frauds and globalization, We, analysts are constantly second guessing every source of data. So how do you answer a simple question like, “am I being lied to?” while looking at a set of numbers your supplier has sent you.

That is our topic for this podcast session.

In this podcast, you will learn

  • Quick announcements about 50 ways & 200k BRM
  • Introduction to fraud detection
  • 5 techniques for detecting fraud
    • Benford’s law
    • Auto correlation
    • Discontinuity at zero
    • Analysis of distribution
    • Learning systems & decision trees
  • Implementing these techniques in Excel
  • A word of caution
Continue »