Perhaps one of the most common audit procedures is to "foot" a column of numbers. The "stat" command does this, and much more. It provides a host of information as well as a summary chart.

Auditors can use the "stat" command alone to perform a variety of the most commonly performed audit tests, including quantifying exception amounts, reasonableness testing, etc.

To perform such a test and have the results available in electronic work paper format, the following processing information is explained below:

Description Value Select Specify 'OK' to have this row processed, otherwise it will be skipped Data Source Specify the name of the Excel workbook, including directory or the name of the Access database which has the data to be analyzed Command Name stat Command Description Prepare a report of basic univariate statistics Table Must enter either a sheet name followed by $ or else enter an Access table name Where An optional row selection statement may be made to narrow the analysis to just certain rows Column The name of a numeric column must be specified here Column String This command does not accept group of column names Parm1 This command does not accept a first parameter parm2 This command does not accept a second parameter Theme A theme, such as summer, fall, winter, spring, pink, orange, green etc Title A chart title, if desired, may be specified here Example Chart   Return to electronic work paper home page