Data Analysis Technology for the Audit Community

Home
Forensic Analytics
Benford's Law Software
Seminars
Benford's Law
Forthcoming Events
Miscellaneous
Personal

 

Benford's Law Excel 2007 Software

 

 

bullet

Prices, What's included, and Order information

     This program is only for users in the USA & Canada. See note at the bottom of the page

 

 
bulletDATAS 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.

 

Home ] Forensic Analytics ] [ Benford's Law Software ] Seminars ] Benford's Law ] Forthcoming Events ] Miscellaneous ] Personal ]

Mark J. Nigrini Ph.D.

55 Heath Court, Pennington, New Jersey, 08534

Tel: (609) 303-0533  E-mail: mark_nigrini at msn dot com