second-order test – any data set summation test – large numbers analysis of journal entries...
TRANSCRIPT
![Page 1: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/1.jpg)
CHAPTER 7
Second-order test – any data set
Summation test – large numbers
Analysis of journal entries
Access and Excel
Prepared by:Mark J. Nigrini
Copyright © 2012 by Mark J. Nigrini. All rights reserved.
![Page 2: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/2.jpg)
CONFORMITY TO BENFORD
Digits of the differences between the records of a geometric sequence conform to Benford’s Law
Digits of the differences between the records from almost all other distributions are almost Benford
If the digits of the differences are not close to Benford it indicates that some anomaly is present
![Page 3: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/3.jpg)
SIMULATED DATA
![Page 4: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/4.jpg)
DIGITS OF THE DIFFERENCES
![Page 5: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/5.jpg)
USING EXCEL
![Page 6: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/6.jpg)
INVOICE DATA RESULTS
![Page 7: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/7.jpg)
JOURNAL ENTRIES
![Page 8: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/8.jpg)
SUMMATION TEST
![Page 9: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/9.jpg)
SUMMATION SIMULATION
![Page 10: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/10.jpg)
SUMMATION IN ACCESS
![Page 11: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/11.jpg)
INVOICES DATA: SUMMATION
![Page 12: Second-order test – any data set Summation test – large numbers Analysis of journal entries Access and Excel Prepared by: Mark J. Nigrini Copyright © 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649dbe5503460f94ab1c75/html5/thumbnails/12.jpg)
SUMMARY Simulations showed that the digits of the
differences were almost Benford For currency or integer data we will usually get
spikes on the prime digits Second-order test showed anomalies in journal
entries Summation test is based on the sums of the
numbers with the same FT digits Summation test shows abnormally large numbers
or groups of moderately large numbers with the same FT digits
Summation test showed spikes for invoices data