Javascript Menu by Deluxe-Menu.com

DescriptionValue
Prepared By IMAN Auditor
Date 01-14-2009
Reviewed By G. Audit Supervisor
Review Date 03-14-2009
Audit Step10
Audit ObjectiveTotal posted invoices for the year
Data Sourcec:\test\data\EWP.xls
Date Run04-19-09 17:12:52
Table/WorkSheetTrans$
Columninvoice amount
Commandstat - Obtain descriptive population statistics
Parameters Used(none)
First Parameter(none)
Where(none)
Second Parameter(none)
SQL usedselect [invoice amount] from [Trans$]
Processing statusNormal process - 5032 rows
Finding (Condition, Cause, Effect)  
Conclusions  
Recommendations  
Discussed with  
Management agrees?  
Management comments  
Auditor comments  
Report Schedule


Population Statistics Report:
N: 5,032
Sum positive: 24,812,426.96
Count positive: 4,493
Sum negative: -3,060,977.99
Count negative: 539
Count zero: 0
Mean: 4,322.62
Min: -11,000.00
Max: 10,497.28
Sum: 21,751,448.97
Stdev: 4,495.96
Median: 4,906.82
Mode: -6,000.00
Skewness: -1.15336
Kurtosis: 1.35081
Variance: 20,213,614.40
USS: 195,718,051,028.56
CSS: 101,694,694,054.29
SEM: .00
Population Statistics Report:
CV: 1.04010
Pop Std Dev: 4,495.51
Range: 21,497.28
Inter-Quartile Range: 5,496.80
Percentiles:
P 1.0% : -9,791.54
P 5.0% : -6,000.00
P 10.0% : -1,523.22
P 25.0% : 2,195.30
P 50.0% : 4,906.72
P 75.0% : 7,692.10
P 90.0% : 9,405.05
P 95.0% : 9,973.96
P 99.0% : 10,379.49
Inter quartile range: 5,496.80
Histogram Report
BinStartEndCountAmount
1-11,000.00-9,208.5617-180,423.82
Population Statistics Report:
2-9,208.56-7,417.1298-918,182.56
3-7,417.12-5,625.68104-780,919.49
4-5,625.68-3,834.24101-574,485.99
5-3,834.24-2,042.80107-402,767.14
6-2,042.80-251.3690-184,002.65
7-251.361,540.087912,098.35
81,540.083,331.527651,173,434.52
93,331.525,122.968412,791,672.62
105,122.966,914.408074,109,976.15
116,914.408,705.848085,575,336.98
128,705.8410,497.281,21511,129,712.00
Totals:   5,03221,751,448.97


Lead Work Sheet

Electronic Workpaper index