What is it?
Data analysis software / analytical audit software -
- identification of duplicates, gaps, outliers, population summaries, data classification and stratification, univariate statistics, sample size computations, percentiles/quartiles, Federal holiday dates, histograms and other....
- perform procedures such as test Benford's law, cumulative monetary amount sampling, interval sampling,
- perform tests such as Chi Square, credit card number checking (Luhn-10)
Why use it?
- Save audit time doing certain types of data mining / analytical tasks, which would otherwise be tedious or error-prone.
- Empower auditors who wouldn't otherwise have the time/resources to perform the required analysis.
- Minimize software installation and support requirements
- Ensure consistency and standardization of audit procedures performed
- Save time using online tutorials
- Handle large files (up to operating system limits)
- Efficiently perform certain types of computations/extracts, otherwise difficult/tedious. Can be done on server, but requires scripting knowledge.
- Work in a familiar environment, Excel®
- Cost - no license cost.
| Item |
Description |
| Command Language Help |
| Help |
Shows list of help links in the current workbook |
|
Commands of just two letters for a selected range on a single worksheet |
|
Population statistics (univariate, stratify, population, duplicates) |
|
Sampling procedures (cma, interval, sample size calculation, precision calculation) |
|
Fraud investigation tools (test Benford's Law, duplicates) |
|
Cash Recovery procedures ("Near miss" invoices, split invoices) |
|
Other Commands (ageing, gaps, credit card validation, analytic review procedures, dates on federal holidays, etc.) |
| Ideas? |
Other commands |
If you have ideas for other commands that would be of general interest and useful for analysis, let me know and I'll implement it if I can. |
|
Benford's Law 
Site Map 
