The text discusses how Benford's Law Testing can test for fraud and anomalies. Review the documents below then import each company’s data into the Benford's Law Excel spreadsheet for review separately. Cut and paste the Data Sets into the Benford's Law Excel spreadsheet to investigate for fraud. Declare if potential fraud exists for Company A and Company B, submit the excel files, and findings can be summarized in dropbox text section.
Use Benford's Law with Excell to improve Business Planning
Import Benford's Law Tests. You must Enable the Macro!! Enter the charts from the data sets or copy and paste the data into the Worksheet.
Data sets:
Company A Invoices
Company B Invoices
Included below is an Excel spreadsheet using Benford's law. The text discusses the value of using this technique to identify fraud. Review the Excel document and the analytical graphs. Then use the attached Excel spreadsheets, by cutting and pasting them into the Benford's Law Excel spreadsheet to determine if potential fraud exists in either. Submit via Dropbox and declare if potential fraud exists.
Benford's Law
Company A
Company B
Sample Solution