Digital Analysis is a tool that looks for the abnormal occurrences digits that violate Benford's Law, which predicts statistically how these digits should be present in your transactional data.

Column To Analyze

Specify the amount column to analyze.

Include Stratified Analysis

If checked then a stratification will be included in the resulting worksheet. Click on the Bands button to specify the stratum ranges. See the Strata command for more information on stratification.

Chart Results

If this option is checked then a chart will be included for each of the digital tests selected.

Condense Output

Digital Tests

Please see Wikipedia: Benford's Law for a discussion of the digital tests.

Group (Subset Tests)

If this option is checked then a separate analysis will be produced for each of the groups specified.

Digital Analysis Using Benford's Law

The following online resource contains explanations and many useful references to Benford's Law:

Example

  • Open ActiveData's Sample Workbook
  • Select the Invoices sheet
  • Select Digital Analysis from the ActiveData Menu
  • Select Amount as the column to analyze
  • Check the First Digit and First Two Digits tests in the Digital Tests section.
  • Click Finished.
 
 
 
Joomla 1.5 Templates by Joomlashack