Forensic Analytics (Second Edition, 2020)
Ancillary materials
End-of-Chapter Tests and Cases with a Note to Students
Data files and other files for the end-of-chapter cases
Instructor’s Manual with instructor materials (instructors contact me for complete document)
PowerPoint slides for complete book and for each chapter (instructors contact me for complete set)
Purchasing card data used in the introduction and in chapters 2, 4, 5, 6, 7, 8, 9, 10, and 11.
Nigrini Cycle Excel file used in chapters 2, 3, 4, 5, and 6.
Corporate journal entries used in chapters 3, 4, and 6 (sample of 246,811 amounts).
Excel workbook for Figure 4.9 (corporate journal entries, N=493,621)
Grocery store sales data used in the introduction and in chapters 9 and 11.
Affidavit of Special Agent in the Lynn Scheuffler fraud case. This fraud case used threshold numbers.
Indictment of Ryan King. This fraud case used duplicate numbers.
Chapter Reviews (YouTube)
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
Guidance for Cases (YouTube)
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 4.1, Benford’s Law advanced tests
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 12.1, scoring forensic units for fraud risk
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
Guidance for IDEA Cases (Search for title on YouTube)
Forensic Analytics Second Edition, IDEA 1, calculations, summarization, field stats, & Benford’s Law
Forensic Analytics Second Edition, IDEA 2, import, sample, top records, Benford & calculated field
Forensic Analytics Second Edition, IDEA 3, duplicates, calculated fields and joins
Forensic Analytics Second Edition, IDEA 4, summarization, date calculations, search and joins