My YouTube channel is Mark Nigrini. On the channel I post videos related to Benford’s Law, my book “Forensic Analytics Second Edition,” and a few miscellaneous videos mostly from my car’s dashcam. Scroll down for details and links.
My YouTube channel (Mark Nigrini)
Benford's Law videos
Forensic Analytics Second Edition, Benford’s Law discussion and free Excel software
Benford’s Law presentation, 1995 Long Island University, New York
Benford’s Law, Part 2 (Excel) (Updated March, 2020)
Benford’s Law, Part 1 (Theory)
Benford’s Law, Part 3 (Analysis in R, no packages), updated code June 2020
Benford’s Law, Part 3 (Calculations in R) [see the June 2020 video with updated improved code]
Benford’s Law, Part 1 of 4 (April 2008)
Benford’s Law, Part 2 of 4 (April, 2008)
Forensic Analytics Second Edition, chapter reviews
Review of the entire book and the supplements
Review of the Introduction chapter
Review of the Excel chapter, 1
Review of high-level overview and the Benford’s Law chapters, 2, 3, 4, and 5
Review of the drill-down chapters, outliers and duplications, 6, 7, and 8
Review of the prior and current period comparison chapters, 9, 10, and 11
Review of scoring forensic units for fraud risk, 12
Review of the chapter-length case studies, 13 and 14
Review of the financial statement fraud chapter, 15
Review of the Access and R chapter, 16
Review of the concluding notes chapter, 17
Forensic Analytics Second Edition, guidance for cases
Case 1.1, using Excel’s VLOOKUP function for a histogram
Case 2.1, high-level overview tests in Excel
Case 3.1, Benford’s Law in Excel and Access
Case 5.1, Number duplications & last-two digits in Excel and Access
Case 6.1, largest subsets and largest subsets growth test in Excel
Case 7.1, relative size factor test in Excel with interpretation
Case 8.1, abnormal duplications in Excel
Case 13.1, analysis of Harriette Walters fraud data in Excel with interpretation
Case 13.2, analysis of Harriette Walters fraud data in Excel with interpretation
Forensic Analytics Second Edition, guidance for IDEA cases
IDEA Case 1, calculations, summarization, field statistics, and Benford’s Law
IDEA Case 2, import, calculations, sample, top records, and Benford’s Law
IDEA Case 3, calculations, duplicates, and joins
IDEA Case 4, summarization, date calculations, and joins
Review of the Hands-on Session at the 2020 IDEA User Conference. The forensic analytics tests are run on City of Somerville payments data for 2013 to 2016. The data file, the requirements, my notes, and PowerPoint slides discussing the mean of a sample can be found in this Dropbox folder.
Data analytics
The patterns of the numbers used in fraud schemes (Ottawa, Ontario, December 2019)