Data Analysis Technology for the Audit Community

Home
DataAnalysis Books
Datas Software
Seminars
Benford's Law
Forthcoming Events
Miscellaneous
Personal

 

DATAS Software

 

 

bullet

Prices, What's included, and Order information

 

 
bulletDATAS for Excel (Price reduced October 1, 2005)

 

These programs run using Microsoft Excel (97, 2000, 2002, or 2003) as a platform.  The user pastes the data in column B on the spreadsheet and then clicks Run to execute the programs.  There are 13 programs that do a total of 15 data analysis tests, including the important tests related to Benford's Law.  The programs are easy to use and the output can easily be formatted according to your preference.  The programs can analyze up to 65,535 records.  The programs will all run in less than one minute.

New! March 22, 2004.  Here is a student (or trial) version of the Excel program that does the Data Profile, and Benford's Law First Digit, Second Digit, and First-Two Digits test with output statistics.  The ProfileFirSecFir2 file works with Excel 2000, 2002, or 2003.  Set Security to Medium if prompted.  Enter data in column B starting at B2.  Use Tools/Macro/Macros/Run to run.  If you need a test data set here is a Data Set of 1,000 Census Numbers.

The Student/Trial version will process the first 999 records in your data set correctly (unless you find the line of code where I limit the program to the first 999 records and change it to 65,536 records!)

bulletDATAS ADDRESS (Discontinued October 1, 2005)

DATAS ADDRESS is an address matching program that matches addresses by stripping away all characters from address fields except for the digits in the street address and the zip (or postal) code.  This means that the programs will detect a match even with different spellings of the street name, different indicators for a subunit (suite, apartment, #), and different spellings of the city or state. Program will therefore match 123 N. Main Str., Cincinnati  OH  45201 with 123 North Main Road Cincinnati  Ohio  45201.  The program is used to match employee address and vendor addresses.  There is also a program that looks for matches within one data set and here an analyst can look for multiple vendors at the same address.

 

bulletDATAS for IDEA

DATAS for IDEA is comprehensive data analysis suite of programs running on IDEA as a platform.  The tests include all the tests from Chapter 5 to Chapter 11 in my Using Microsoft Access for Data Analysis and Interrogation book.  Also included is an address matching routine that has the same functionality and uses the same matching logic as DATAS ADDRESS above.

DATAS for IDEA can only be ordered from Audimation Services, Inc. in Houston, Texas hence the link above to Audimation's website.

 

bulletDATAS for SAS (Price reduced on October 1, 2005)

This set of programs runs using any recent version of SAS.  These programs run using the full complement of digital analysis tests described in Digital Analysis Using Benford’s Law.  The advantage of these programs is that the code can be changed by the user if deemed beneficial and SAS can process large data sets very efficiently.

 

bulletDATAS Windows (Free)

This program analyzes the first, second, first-two, and last-two digits of the numbers in a data set.  The program runs on Windows and so no special platform is needed.  Program executes very quickly.  Excel files are included to produce neat graphs.

 

bulletPrices, What's included, and Order information

 

DATAS is the abbreviation for Digital Analysis Tests and Statistics.

 

 For a comprehensive listing of accounting and auditing software see,

 http://www.accountingsoftwaresdirectory.com/

 

Home ] DataAnalysis Books ] [ Datas Software ] Seminars ] Benford's Law ] Forthcoming Events ] Miscellaneous ] Personal ]

Mark J. Nigrini Ph.D.

30 Greenwood Avenue, Essex Junction, Vermont, 05452

Tel: (802) 872-7877  E-mail: mark_nigrini at msn dot com