Javascript Menu by Deluxe-Menu.com

DescriptionValue
Prepared By IMAN Auditor
Date 03-19-2009
Reviewed By G. Audit Supervisor
Review Date 01-31-2009
Audit Step3
Audit ObjectiveObtain total accumulated depreciation
Data Sourcec:\test\data\EWP.xls
Date Run04-18-09 22:30:42
Table/WorkSheetfa$
Columnad
Commandstat - Obtain descriptive population statistics
Parameters Used(none)
First Parameter(none)
Where(none)
Second Parameter(none)
SQL usedselect [ad] from [fa$]
Processing statusNormal process - 4064 rows
Finding (Condition, Cause, Effect)  
Conclusions  
Recommendations  
Discussed with  
Management agrees?  
Management comments  
Auditor comments  
Report Schedule


Population Statistics Report:
N: 4,064
Sum positive: 8,674,981.66
Count positive: 4,061
Sum negative: -985.01
Count negative: 3
Count zero: 0
Mean: 2,134.35
Min: -364.00
Max: 9,321.00
Sum: 8,673,996.65
Stdev: 1,338.39
Median: 2,060.42
Mode: 208.45
Skewness: 0.80034
Kurtosis: 1.83341
Variance: 1,791,288.74
USS: 25,791,347,147.15
CSS: 7,278,006,149.97
SEM: .00
Population Statistics Report:
CV: 0.62707
Pop Std Dev: 1,338.23
Range: 9,685.00
Inter-Quartile Range: 2,052.15
Percentiles:
P 1.0% : 50.09
P 5.0% : 221.57
P 10.0% : 444.09
P 25.0% : 1,067.06
P 50.0% : 2,059.06
P 75.0% : 3,119.21
P 90.0% : 3,717.63
P 95.0% : 3,939.86
P 99.0% : 6,688.00
Inter quartile range: 2,052.15
Histogram Report
BinStartEndCountAmount
1-364.00443.0833-425.77
Population Statistics Report:
2443.081,250.17775350,162.80
31,250.172,057.258141,020,969.54
42,057.252,864.337891,621,300.76
52,864.333,671.427892,264,456.41
63,671.424,478.507682,806,966.25
74,478.505,285.581775,747.09
85,285.586,092.671683,932.21
96,092.676,899.7518109,530.07
106,899.757,706.831497,387.00
117,706.838,513.9224183,341.00
128,513.929,321.00760,629.30
Totals:   4,0648,673,996.65


Lead Work Sheet

Electronic Workpaper index