Javascript Menu by Deluxe-Menu.com

DescriptionValue
Prepared By IMAN Auditor
Date 04-17-2009
Reviewed By G. Audit Supervisor
Review Date 02-01-2009
Audit Step4
Audit ObjectiveTotal the file for net book value
Data Sourcec:\test\data\EWP.xls
Date Run04-18-09 22:30:43
Table/WorkSheetfa$
Column(cost - ad)
Commandstat - Obtain descriptive population statistics
Parameters Used(none)
First Parameter(none)
Where(none)
Second Parameter(none)
SQL usedselect (cost - 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: 11,794,810.28
Count positive: 4,032
Sum negative: -80,022.65
Count negative: 29
Count zero: 3
Mean: 2,882.58
Min: -9,313.06
Max: 8,442.00
Sum: 11,714,787.63
Stdev: 1,798.72
Median: 2,847.13
Mode: .00
Skewness: -0.26820
Kurtosis: 0.57302
Variance: 3,235,380.83
USS: 46,914,114,450.38
CSS: 13,145,352,316.33
SEM: .00
Population Statistics Report:
CV: 0.62400
Pop Std Dev: 1,798.50
Range: 17,755.06
Inter-Quartile Range: 3,031.62
Percentiles:
P 1.0% : 9.60
P 5.0% : 264.00
P 10.0% : 548.44
P 25.0% : 1,403.09
P 50.0% : 2,846.51
P 75.0% : 4,434.71
P 90.0% : 5,326.45
P 95.0% : 5,633.74
P 99.0% : 5,881.55
Inter quartile range: 3,031.62
Histogram Report
BinStartEndCountAmount
1-9,313.06-7,833.481-9,313.06
Population Statistics Report:
2-7,833.48-6,353.892-16,386.00
3-6,353.89-4,874.302-12,890.00
4-4,874.30-3,394.713-14,238.00
5-3,394.71-1,915.122-5,695.00
6-1,915.12-435.538-15,786.44
7-435.531,044.0622127,630.70
81,044.062,523.651,0521,103,466.01
92,523.654,003.231,0212,558,133.04
104,003.235,482.829583,846,641.46
115,482.826,962.417904,222,469.93
126,962.418,442.00430,755.00
Totals:   4,06411,714,787.63


Lead Work Sheet

Electronic Workpaper index