






 | |
Benford's Law Excel 2007 Software
|
This program is only for
users in the USA & Canada. See note at the bottom of the page
|
|
 | DATAS
2009 for Excel 2007 (Benford's Law software
that works with Excel 2007) |
|
These
Benford's Law and number duplication programs
run using Microsoft Excel 2007 on Windows XP or Windows Vista.
The data analyst pastes (as in Copy and Paste) the data in column B on the spreadsheet and then
clicks Run to execute the macros (programs).
There are three programs of which two run Benford's Law on your
data and the third is the number duplication program which is a
follow-on test to Benford's Law.
The three programs are easy to use with output in the form of
tables and graphs. The output can easily be
formatted according to your preference.
The programs can analyze up to 1,048,575 records. For
data sets of less than 100,000 records you should have your results in less than one minute.
One million records might take 5 minutes to process. |

|


|

|
DATAS
2009 for Excel 2007: Click here
to see the documentation for the Excel 2007 Benford's Law software (Word
2007 document).
This program was released on Friday, July 10, 2009.
|
|
|
|
This program is only intended for the USA and Canada. The programs
will not work in any country that does not use the decimal point (.)
because the decimal point is used in my VBA code. It will also
not work in any country where Excel 2007 is in a language other than
English. Please feel free to contact me if you are outside the USA and
Canada, and if (a) you use the decimal point to separate units and tenths,
and (b) Excel 2007 is in English. If neither (a) or (b) apply and
you'd like to develop a local version for me please send me an e-mail
too. |
|
DATAS is the
abbreviation for Digital Analysis Tests and Statistics.
|
|