Click here to download the Benford Analysis zip file

The template has two pages.  The first page is for your use, and the second is a sample with data already included, if you want to watch the macro operate.  When it is completed, you can graph the results (the table) using chart wizard (a line chart works very well).  Remember NOT to save the sheet, just print the results.

To apply the Benford analysis to a population, open the data file into Excel as a delimited file (you will  have to set the column widths).  Highlight, copy and paste the amounts into the template and follow the instructions."

Home ] History ] President ] Message ] Services ] 2021 Catalog ] Fraud ] [ Benford ] Tips ] Others ]