EZ-R Stats, LLC

Three reports are produced:

1. Basic statistics
2. Histogram data
3. Percentile report

Once the Excel data has been copied to the clipboard, pasted into the Audit Commander Worksheet form and analyzed, the form appears as follows:

Next any empty area in the workbook can be selected, and the reports "pasted" in resulting in the following:

Basic Statistics

Histogram Data

Percentile Report

The most common audit uses for this information are as follows:

• sum positive and count positive provide information as to the file totals for debits, which can then be tied to the trial balance or general ledger (if applicable)
• sum negative and count negative provide similar information for credits
• count of zero items can be an indicator of a problem, if the auditor is not expecting to find zero amount transactions
• Sum is the net total for the population tested
• Minimum and maximum values can be used to determine if the data is reasonable and also to identify and large (or small) amounts which may need further testing. (Note there is a separate test for identifying the "top 10" and "bottom 10".
• the standard deviation can be used as part of sample planning and is an indicator as to how much the data varies
• the mode is the value which occurs the most frequently
• the median is the 50th percentile or the value where half the population is less than and half the population is more than the amount specified
• the skewness indicates the degree to which the data differs from that expected with a normal ("bell curve") distribution. Positive values indicate that the data is skewed to the right, negative values indicate that the data is skewed to the left.
• the kurtosis indicates how "peaked" or "flattened" the data is compared with a normal ("bell curve") distribution. Positive values indicate that the data is "peaked" and negative values indicate that the data is "flattened".
• Range - The difference between the largest and smallest values

 

Example charts are shown below (produced using the Audit Commander)

Sample precision computations are charted below.