February 20, 2007 by Mike.Blakley.

If you select random samples from Excel, you may be interested in an approach that takes the data directly from Excel, using the “copy” command, and then “pasting” in onto a web form. Currently, two types of sampling are supported: interval sampling (attribute sampling) and cumulative monetary amount sampling. Both procedures return a sample and a sample reconciliation report. These can be selected, copied and pasted back into Excel. Ofcourse it is necessary to determine the sampling parameters required prior to selecting the sample. In the case of interval sampling, a sample size calculator and evaluator is available.

Posted in Audit sampling | No Comments »

February 16, 2007 by Mike.Blakley.

For some of the audit analysis routines that can be run directly from the web (for example Benford’s law, and histograms), I have added an on-line “quiz” to test understanding of key topics. These quizzes were generated directly from questions and answers in an Excel workbook. Details on the Excel workbook are available for download.

Posted in Audit Software | No Comments »