Web Based Analytical Software

Analytical software run from the web is efficient and effective because there is no installation or maintenance, and the software is available from any location with an Internet connection. Further, there is no incremental cost.

This analytical software includes commonly used audit procedures such as identification of duplicates, gaps, Benford's law, outliers, population summaries, data classification and stratification, univariate statistics, cumulative monetary amount sampling, identification of Federal holiday dates and histogram charts.

To use the software, open an Excel workbook, select the data on the sheet to be analyzed and copy the data to the clipboard, by either using edit | copy or else Ctrl-C. Then click on the link below corresponding to the audit test to be performed and "paste" the data into the form, provide any other specification required, and click the "run" button. The results of the analysis will be displayed on a browser page which can then be viewed and the results optionally pasted back into Excel. Each of the software procedures has a link to "help" page with more detailed instructions and screen shot examples.

The topics listed below with a checkmark are available for use now. Those without a check mark are under development. Planned development includes extensive analytical review procedures, designed to save significant time and enhance the audit process.

All of the software here is available at no charge.

Web Based Analytical Software

Command	Help Page	Audit Objective
Statistical Summaries
Histogram	Help	Graphically display a distribution being audited
Means, Data Summarization, Univariate Statistics, Outliers	?	Obtain basic population statistics. Obtain audit totals for numeric variables. List the minimum, maximum, count, average, standard deviation for the audit population. List the sum of all positive, negative. List missing and absolute value. List number of zero items. Obtain quartile, top and bottom five, mode and other statistics. Classify amounts deviating significantly from the norm.
Tools for Fraud Investigation
Benford's Law	?	Audit software to compare expected distributions of Leading and Trailing Digits with actual. Results include the Kolmogorov-Smirnov measure to enable quantification of probability).
Identification of Gaps/ Duplicates	?	Identify missing items in sequences. Isolate duplicate payments or other transactions
Federal holidays	?	Identify dates which are Federal holidays between 1-1-1997 and 12-31-2007
Random Sampling
Sample Size Computations	?	For attribute sampling - compute required sample size and/or evaluate sample results
Cumulative Monetary amount	?	Perform a cumulative monetary amount (cma) sample.
Interval	?	Perform an interval sample
Data Classification
Code Validation	?	Validate a range of cell values using a "lookup" table
Classify / Stratify	?	Classify amounts and numbers as to their frequency. Stratify the data by various tiers.
Linear Regression	?	Audit software to determine if a correlation exists between variables (analytical review)
Analytic Review	?	Compare two balance sheets, income statements etc. to identify the most material item contributing to any difference between them. Express the difference as the D-Statistic in order that it can be measured.
Time Series Analysis	?	Time series analysis for data in either horizontal or vertical format. Examine linear trends over time and assess the strength of correlation by measuring the coefficient of correlation.

	PHP / HTML source code for all the above (zipped - approx 330K size)
	Comments/Questions?

	Web Based Analytical Software
EZ-R Stats	Benford's Law Downloads Site Map