BENFORD ANALYSIS TEMPLATE
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."
Click here to download the Benford Analysis (first digit, single digit) zip file
Click here to download the Analysis Template (first, second, and first two digits) Excel file