Review and how it works
The function of the utility is to make statistical analysis less complicated, hence the name (Easier Excel). The routine facilitates and comes with option for data analysis by giving numerous software and charts, leveraging the facilities within MS-Excel.EZ-R Excel was tested with Excel 2003 and Windows XP. This routine comes at no charge, and can be used for each purpose, for example personal and commercial.
EZ-R Excel comes as a Windows based menu driven system This facilitates access to the functions without having to remember uncommon key strokes.
The routine has analytical review functions based upon the Kolmogorv-Smirnov test that is able to compare two Balance Sheets or Income Statements at assorted periods and practically 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.
Brief details
Work With Ranges - Basic Statistics
Classify and stratify data.
Benford's Law analysis.
Descriptive Statistics.
Histogram.
Univa riate Statistics.
Obtain Crosstabs.
Try Gaps in Sequence Numbers
Frequency Distributions
Telephone Area Code Validation.
How to install & uninstall EZ-R Excel - system requirements
Needs Windows, Excel 2000, 60 MB of disk space
|
