Keep up to date with every new upload!

Join free & follow Chandoo.org Podcast - Become A
Share
  • 4 years ago
CP030: Detecting fraud in data using Excel – 5 techniques for you

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

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

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

Comments