Excel Problem Solver: Detect Fraud Using a Spreadsheet and Benford's Law

Рет қаралды 18,087

3 жыл бұрын

This video provides a quick history of a law of random numbers known as Benford's law. The viewer is cautioned that not all data is suitable for analysis using Benford's law. A detailed example of a practical application of Benford's distribution on sample sales transaction data follows. After watching the video, the viewer should have a basic understanding of how to use Benford's distribution to detect fraud in a business enterprise.

Пікірлер: 59

@midlifecrisis920 Жыл бұрын

What a detailed explanation. Loved it!!

@zackone6829 3 жыл бұрын

Hey Geek! I just watched your video, amazing. Very informative and easy to follow. Many thanks.

@thuglifebear5256 3 жыл бұрын

LOL this guy should jump on that Milwaukee/Philadelphia data ASAP, cos the media

@carlosrvillegaschazaro1092 3 жыл бұрын

good video and good music at the end !!

@saurabh_arora

Awesome explanation! 👍 I just want to ask how did you get that +/-(1/2n) in the formula of confidence interval? Does it really matter in case of a large sample size?

@artur50 2 жыл бұрын

Great!

@harumih.3727

I don't think that using "=1" is effective way because every time, you entered "=1" you have to change it to "=2" and "=3" etc. which is much time-consuming. I think that using a reference of the cell is more efficient. For example, when you are calculating the COUNT for the cell with a value of 1, you just simply reference a cell where "1" is entered. Then, for the cell below, simply copy the above formula, changing automatically the above referenced cell the next reference. I tested it myself. Instead of "=1" I entered "E3". Excel formula accordingly search the reference E3 to find the value, for example, and the next formula down the row of 4, Excel searches a value in the cell E4. This way, you wouldn't need to spend time to replace 1 with 2, and with 3, and with 4, and so on.

@rickswineberg

Make the countif criteria dynamic, have it refer to that cell.

@spreadsheetgeek4070 3 жыл бұрын

If I was looking for election fraud I'd focus on precincts that saw a dramatic increase in turnout compared to 2016 and/or a dramatic shift in D/R vote %.

@sachinsharma-de3vj 3 жыл бұрын

can someone explain the upper and lower limit formula?

@Kayne1b 3 жыл бұрын

SIMULATION CONFIRMED

@juggernaut316 3 жыл бұрын

Why won't KZfaq let me like the video?

@marywinter6279 3 жыл бұрын

Wonderful demo - would it be possible for you to share the excel template for educational purpose? Thanks

@jeffgustafson4552 3 жыл бұрын

So would a 300 mile river and a 3,000 mile river be in the same column?

@aditisyal6441 Жыл бұрын

Can Benford's law be assistive in investigating fraud cases where fraudsters misused the Covid relief funds? Is there a pattern observed in cases already investigated?

@sophia212

Hello, I am doing a report on Benford's Law that has to be 12 pages for highschool. Where did you get the trasaction amounts (the 6000 numbers) from? Are those able to be sent to me or is there a place where I can find them? I want to do a similar test to prove that Benford's law works to detect fraud. Thank you!