Benford's Law | using Excel | Video 2/6
In this video we will use Microsoft Excel and test Benford's Law on a Data set.
Dataset :
https://opendata.dc.gov/datasets/purc...
Search terms in web browser :
Open Data DC Purchase Card Transactions
TIMESTAMPS
00:00 Overview of Benford's Law
00:25 Using web browser, search using keywords
00:40 About the data (Purchase Card Transactions csv file)
02:05 Open the csv file using Excel
02:35 Step by Step process of creating Leading Digit column .
06:04 Create pivot table
06:12 Using this Pivot table create additional steps that are needed to apply Benford's theory
09:48 Insert a clustered column chart and compare the distributions : Observed vs Benford
10:43 Recap and conclusion