BENFORD ANALYSIS TEMPLATE
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