Javascript Menu by Deluxe-Menu.com

DescriptionValue
Prepared By IMAN Auditor
Date 01-15-2009
Reviewed By G. Audit Supervisor
Review Date 01-29-2009
Audit Step4
Audit ObjectivePrepare a box plot of dailt sales amounts
Data Sourcec:\test\data\EWP.xls
Date Run04-12-09 11:30:41
Table/WorkSheetRevenue Data$
Columnamount
Commandboxplot - Plot basic statistics
Parameters Used(none)
Where(none)
Second Parameter(none)
Finding (Condition, Cause, Effect)  
Conclusions  
Recommendations  
Discussed with  
Management agrees?  
Management comments  
Auditor comments  
Report Schedule


Population Statistics Report:
N: 1,509
Sum positive: 668,485.23
Count positive: 1,377
Sum negative: -15,488.93
Count negative: 78
Count zero: 54
Mean: 432.73
Min: -1,715.58
Max: 3,668.57
Sum: 652,996.30
Stdev: 605.07
Median: 225.08
Mode: .00
Skewness: 2.04036
Kurtosis: 5.46749
Variance: 366,114.56
USS: 834,674,763.32
CSS: 552,100,762.11
SEM: .00
Population Statistics Report:
CV: 1.39826
Pop Std Dev: 604.87
Range: 5,384.15
Inter-Quartile Range: 478.41
Percentiles:
P 1.0% : -286.21
P 5.0% : -2.81
P 10.0% : 7.16
P 25.0% : 58.62
P 50.0% : 225.08
P 75.0% : 537.03
P 90.0% : 1,201.12
P 95.0% : 1,820.10
P 99.0% : 2,616.65
Inter quartile range: 478.41
Histogram Report
BinStartEndCountAmount
1-1,715.58-1,226.111-1,715.58
Population Statistics Report:
2-1,226.11-736.645-5,718.86
3-736.64-247.182-1,536.54
4-247.18242.2967-6,514.45
5242.29731.761,026178,855.46
6731.761,221.23214152,189.21
71,221.231,710.706980,793.62
81,710.702,200.1762104,173.97
92,200.172,689.634699,140.71
102,689.633,179.10615,877.99
113,179.103,668.571137,450.77
Totals:   1,509652,996.30


Lead Work Sheet

Electronic Workpaper index