EZ-R Stats, LLC

This page has links to the materials handed out at the joint meeting of the IIA and ISACA in Raleigh, NC on November 11, 2008. Altogether, the material is about 250 MB and was provided on an "AutoRun" CD. The purpose of this page is to make available all (or part) of that hand out material to those who were not able to attend the session. For educational, governmental or not-for-profit use, there is no cost for a software license.

I welcome all comments, questions and suggestions. I can be reached at 919-219-1622 on Fridays 8:00 a.m. to 5:00 p.m. EST and by e-mail at Mike.Blakley@ezrstats.com.

Presentation

Procurement Fraud
Description	Approx Size	Duration	Last Update
PowerPoint presentation	1.8 MB	02:00	11-2008
Detection of fraud patterns using digital analysis	.8 MB	02:00	05-2008
R System
Description	Approx Size	Type	Last Update
Overview	.8 MB	PDF	05-2008
Installation Software	.8 MB	Setup.exe	05-2008
Data Import and Export	.8 MB	PDF	05-2008
The R Language - a short reference card	.8 MB	PDF	05-2008
Installation and Administration	.8 MB	PDF	05-2008
Audit Commander System - Documents
Description	Approx Size	Type	Last Update
Main Menu	4.1MB	PDF	10-2008
Testing data in Excel format	110 K	PDF	10-2008
Testing data in Access databases	< 100K	PDF	10-2008
Testing data in Text Fileformat	< 100K	PDF	10-2008
Testing data in SQLite databases	< 100K	PDF	10-2008
Data extraction - Excel files	< 100K	PDF	10-2008
Data extraction - Access databases	< 100K	PDF	10-2008
Data extraction - SQLite databases	< 100K	PDF	10-2008
Data extraction - text files	< 100K	PDF	10-2008
Linear Regression	< 100K	PDF	10-2008
Stepwise Linear Regression	130 K	PDF	10-2008
Pattern detection with SQLite	< 100K	PDF	10-2008
Plotting data in Excel	< 100K	PDF	10-2008
Data extraction and computation- Excel files	< 100K	PDF	10-2008
Linear Regression - Data in Excel	< 100K	PDF	10-2008
Ageing Data in MS Access	< 100K	PDF	10-2008
Ageing Data in Excel worksheets	< 100K	PDF	10-2008
Audit test on data in MySQL	< 100K	PDF	10-2008
Linear Regression - Data in Access	< 100K	PDF	10-2008
System Log Reports	< 100K	PDF	10-2008
System Configuration	< 100K	PDF	10-2008
Extracting rows with holiday dates from Excel (US and Canada only)	< 100K	PDF	11-2008
Extracting rows with holiday dates from Access (US and Canada only)	< 100K	PDF	11-2008
Reports relating to Benford's Law	< 100K	PDF	11-2008
Audit Commander System - Tutorials
Description	Approx Size	Type	Last Update
Five Minute System Overview	5 minutes	Flash	feedback!
Linear Regression	9 minutes	Flash	feedback!
Excel special commands	13 minutes	Flash	feedback!
Data extract and calculation	5 minutes	Flash	feedback!