Obtain the Fraud Buster spreadsheet described in problem 9-90. In the data entry column, use the Excel

Question:

Obtain the Fraud Buster spreadsheet described in problem 9-90. In the data entry column, use the Excel Rand function to generate random numbers between 1 and 999. Use the formula = RAND()*( 1000- 1)+ 1 for this purpose. Once you have the first random number in cell A1, copy the formula so that you have a data set of 1,000 randomly generated observations. Then run the first- digit test in Fraud Buster.

1. What do the results of the first- digit test indicate?

2. Expand the random number list to 25,000 observations by copying the formula. Run the first- digit test for this new set of observations and compare the results to those you obtained for the set of 1,000 observations. Explain the differences.


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: