Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Note that I have attached the Fraud Buster Excel Spread sheet and the 1978 Taxable incomes. The problem requires you to use the Fraud Buster

Note that I have attached the Fraud Buster Excel Spread sheet and the 1978 Taxable incomes. The problem requires you to use the Fraud Buster spreadsheet (which incorporates the Benford's Law calculations) to help you ascertain if there is probable fraud in the taxes filed with the . The instructions in the problem require you to focus on the incomes of the first 6,000 people or entities. As instructed in the problem, you should delete the only the data or values that already exist in the first tab or worksheet labelled "Enter Data" of your Fraud Buster excel file. Then run Fraud Buster by clicking where it states "Fraud Busterin that first tab or worksheet. The tables and graphs in the next three tabs or worksheets will be updated, automatically. You must submit answers to Part 2 of the problemand you must attach the printouts of your results of your first digit second digit, and third digit tests. I do not need the data (first tab or worksheet).
image text in transcribed
9-90. 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 distri- bution? Are there any digits you might investigate further? 9-90. 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 distri- bution? Are there any digits you might investigate further

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey Of Accounting

Authors: James D. Stice, W. Steve Albrecht, Earl Kay Stice, K. Fred Skousen

1st Edition

0538846178, 978-0538846172

More Books

Students also viewed these Accounting questions

Question

Solve the indicated equations analytically. cos 3x cos x = 0

Answered: 1 week ago