• EZ-R Stats for Excel 1.2

• Author Company: EZ-R Stats, LLC

• Excel addin for data analysis, utility functions, Benford's Law

• 
  Click to enlarge
• Price: Free
• File Size: 4.37 M   Requirements: Windows, Excel 2003, 20 MB of disk space
• Update Time: 3/9/2007 2:32:10 AM   Release Date: Sunday, October 22, 2006
• Language: English
• OS: Win95/Win98/WinNT 4.x/Windows2000/WindowsXP
• License: Freeware  Limitations: no expiration
• Support Phone: (none)
• Download Now

Excel addin to provide statistical analysis. The routine facilitates and supports data analysis by providing numerous tools and charts, leveraging the facilities within MS-Excel.EZ-R Excel has been tested with Excel 2003 and Windows XP. This routine is available at no charge, and may be used for any purpose, including personal and commercial.

EZ-R Excel is a Windows based menu driven system This facilitates access to the functions without having to remember special key strokes.

A variety of analytical tools are offered, classified as follows:

Work With Ranges - Basic Statistcis
Classify and stratify data
Benford's Law analysis
Descriptive Statistics
Histogram
Univariate Statistics
Obtain Crosstabs
Check for Gaps in Sequence Numbers
Frequency Distributions
Telephone Area Code Validation

The routine also provides analytical review functions based upon the Kolmogorv-Smirnov test which can compare two Balance Sheets or Income Statements at different periods and easily identify the most material item contributing to the difference and the extent of that difference. This assists the auditor in deciding which accounts should be reviewed further.