The AICPA provides a free Excel spreadsheet pro-gram that can be used to test data for consistency

Question:

The AICPA provides a free Excel spreadsheet pro-gram that can be used to test data for consistency with Benford’s Law. A link to this spreadsheet is available at www.pearsonhighered.com/rufus. Download the spreadsheet and study its structure as well as the manner in which it presents the results of the first- digit and second- digit tests.

1. Once you understand the spreadsheet, perform the following:

a. Obtain the Excel data file for 1978 taxable income in the Chapter 8 materials via a link at www.pearsonhighered.com/rufus, which will take you to a web site hosted by Dr. Mark Nigrini.

b. Copy and paste the first 6,000 observations into the data entry tab (Column A) of the Fraud Buster spreadsheet. Remember to clear all existing data prior to performing this step. c. Run Fraud Buster.

2. How do the results of the first- digit and second-digit tests compare to Benford’s predicted distribution? Are there any digits you might investigate further?


Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Forensic Accounting

ISBN: 978-0133050479

1st Edition

Authors: Robert Rufus, Laura Miller, William Hahn

Question Posted: