Numerical Statistics Report

Number1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Business
B Phillips
Barr & Edwin Co.
Lacrosse Archery
Global Fleet Sales
ALLSTATE ATHLETIC SUPPLY
ELECTROPOWER UTILITY SALES
Bergner’s
BESLEY’S
Dave Ranney & Assoc
RDI Technologies
Rocky MTN HMO – Info. & Sales
Mid-South Sweeper Supply; Inc
WestLake Supply
Old Town Artisans Galleries
Client Services Guy
Bill Reed
Game Fair Ltd
Air Supply Systems; Inc
The Webmaster
First Supply Group; Inc
Comfyco
Telson; Inc
One Plus Two
FlowTech Supply
Brewer Business Supply
King Plaza-Management Lsng
Sales Recruiting Specialist
Lenty Sales; Inc.
Vipbrasil
Empire State Sales Inc
Sunday Sales
Spa City Silver
Cps
WSA Sales Co. Inc
Sun State Sales
KWICK SUPPLY INC
Power Solutions Inc
Reece & Nichols Wyandotte
Harmony Ball
2015
Profit
4436
7452
2564
4547
8028
1313
6843
4280
4721
3603
2701
3119
4308
4550
5267
8973
7366
5905
3701
1180
6980
2117
1219
2817
3142
2533
7021
1654
7713
6244
8838
5777
4504
1990
6541
4541
5662
9286
5414
2016
Profit
8108
9542
2125
5219
6160
5074
7211
7775
9674
4881
7172
8327
6516
2305
8804
4747
2629
7186
9466
7572
930
2414
1108
5635
2651
3784
9522
1841
6069
1063
2851
3058
6606
6252
5904
8953
5125
1158
2769
Two
Two
Year
Year
avg.
Average
change Number
in daily
of
no. of Employe
visits
es
37
82
6
40
85
-7
71
34
40
17
7
12
36
40
46
93
80
54
20
-8
73
4
-8
9
14
6
75
-3
83
57
91
51
39
-2
67
39
50
94
48
100
71
41
56
79
31
97
54
89
37
63
85
43
48
32
86
96
38
44
26
95
66
83
91
44
47
62
21
74
26
26
24
65
65
58
67
71
42
98
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
Eagle Flight Safety Products
Team Vehicle Sales
Papaya Clothing
Daniels & Fry Motor Company
Home Base Solutions
SAFsystems
Robert Rytter & Associates
Arbor Consulting
DEANGELO MACHINERY SALES
JDG Sales And Service
MOSS
Sonya C. Atwell
Sentry Network Service; Inc.
SUMMIT FINANCIAL GROUP
Lenexa Office Supply
Cyberzone
Monarch Rep Sales Inc
Eddiechamberland
EXCEL PRODUCTS
Samco Sales
Lajobi Sales; Inc
ECS Anchor Supply
Tiger Sales
Auto Graphics Sales
Algin Technology LLC
Triple T Sales
Georges Miret Salon
NICHOLSON; WILLIAM
Sears Grand
Active Fitness And Aerobics
Crosstech
Druglaunch
Brian Sullivan Enterprises
PC SALES
Starr Gennett Foundation
KCI Sales
Mapleshade Lane E
Rod Dow
CC Industrial Sales
Southwest Distributing; Inc.
Robert M. Wells
United Sales & Services; Inc
NO. Power Plant
BREWARES INC
Closeouts Attic
AGEE Sales; Inc.
Jason Golden
5505
3444
3703
5009
8229
4800
8424
6488
6287
3844
6730
5695
3579
1737
7001
6699
8868
7114
5239
6541
4484
8655
4278
9678
4440
3687
8906
2991
992
4106
3527
8190
6966
9268
6132
8134
2595
3136
4301
5513
1541
8249
6137
9936
6720
6253
5564
4364
4977
4059
3286
9303
4999
3258
1039
5524
7146
8194
7747
6245
2498
4820
8272
6316
7116
7248
2355
4466
3577
7425
2829
3301
6882
1063
3746
8233
9366
9840
5866
1888
6999
9766
9845
962
5738
9571
7564
2515
4299
5846
5651
8230
8833
5855
49
14
20
44
87
42
89
62
58
25
71
51
17
-3
74
69
92
76
45
67
38
91
32
97
38
19
93
11
-10
29
16
86
72
94
55
85
6
14
36
49
-5
88
55
100
69
57
50
66
50
39
29
50
69
79
30
44
74
72
47
39
57
35
38
21
63
70
49
74
100
39
39
51
89
35
66
57
93
69
58
56
77
62
60
26
95
20
54
83
25
54
32
40
80
94
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
Shepherd Sales
John C Weigand
Discount Silks
Ban-Koe Systems Inc.
Shamrock Computer
Margaret Lucas
Shafer Valve
RTG INDUSTRIAL SUPPLY; INC
American Supply Group
Mr. Spindle
Jones Services Supply Co.
Factory Direct Craft Supply
Metro Sandwiches & Salads
Global Industrial Sales
Fun Yards
Taylor Supply
Facility Robotics; Inc
Tele-Sales Consultants; Inc
Hometown Paintball Supply Inc.
Bales Hay Sales
Zero systems
Agm
Simcha Sales
Pauls Motor Sales And Service
Drillers Supply
Sharper Concepts; Inc
Pat Tomek
Mbh Sales And Service
Howard Sales Co.; Inc
SELECT SALES; INC.
John Garesche
TOP SALES COMPANY; INC
On Angels Wings
WebStar Designs
Lone Pine Sales
Associated Supply Co
John Cody
Barton Mattress Sales
InternetNow
Corrosion Guard
Comet Website Consultants
MCMAHON; JOHN
Alan Warren
ROV Supply CO
Wilrock Sales Corp
Lowe Co Motion Inc.
Daley Plastering
2178
6376
7664
5335
1124
4869
7368
1553
2185
2045
6135
9943
2306
9843
5939
6882
2630
1309
4131
5335
1588
9655
4806
6187
7384
2728
4812
9471
1488
3246
7462
8551
2599
7521
7937
9202
7230
6399
3675
6536
2464
4084
7540
2371
6361
3509
7675
6106
8755
9634
1975
7099
9725
2085
4908
8449
7917
6843
1268
5727
5622
1321
6040
1653
8385
6619
4943
8446
7249
3536
9957
1685
1360
1312
3405
6142
3549
5052
3427
2740
7907
5991
7112
4503
3312
9576
8512
4501
5773
5068
4610
7557
6616
5536
4
60
83
47
-9
43
80
-4
4
1
55
100
4
99
54
72
6
-8
30
48
-3
97
42
56
81
7
43
96
-7
14
82
89
6
82
85
94
79
61
19
63
5
28
83
4
60
16
83
22
32
48
96
95
40
96
64
51
36
79
70
66
32
48
95
63
68
77
39
93
65
71
100
35
80
66
52
23
24
68
67
23
40
50
95
92
71
70
40
26
59
83
49
75
80
86
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
Walter Drake Inc
Philips Business Solutions
Bacik Karpinski Associates Inc
Jeff Munchick Sales
GEO-THERMAL SALES; INC
Sprinkler Supply Company
Rol-Tru Putting Greens
Energy Mgmt Systems
B & D Sales
Tech-Tran Corp.
Judy Rees
Jenskates
Custom Filter Supply; Inc
Fiduciary Trust Co. Intl
The Office Supply Store; Inc.
Char Sakamoto Ishii Lum Ching
Otto Wolff U.S. Sales Corp
Bailey Slipper Shop
Megaidea; Inc
Jeff Branch Motor Sales
Aeropostale Inc
High Tides
Foley’s Department Store
Gornet Technologies
Brinton Vet Supply
The Jones Shop
WOODSTOCK QUILT CO.; INC
KWB SALES
Efficient Lighting Sales Co.
Filene’S
Gemini Technical Sales
Walter Long
Cloutier Property Management
ATMCo
Mark Maggiacoma
Global Granite
NuHS
JTC Express Office Supply
Inductive Technologies; LLC
Florida Villa Vacations Inc
Misty Mountain Sales
Outpost
Dollar All
Clinical Laboratory Standard
AdultPaths.com
Ship Supply Of Florida; Inc.
M Hoffman Enterprises Inc.
8011
8417
7190
5499
6720
7089
8124
8271
9050
6312
1360
2041
2329
9176
9430
8001
8068
6432
6608
6866
5316
5758
6964
9712
9957
2599
8427
4228
7381
3913
5827
900
9566
7180
9973
7608
5337
6751
7701
1917
5012
6640
7879
7546
9627
4039
3068
2665
2808
8807
5077
7404
5822
7440
7978
8048
3887
1123
1606
1866
8072
8961
6363
7261
4169
4956
4998
1953
3857
5252
9608
9965
2740
7816
2742
7066
1176
9978
1584
6887
2327
8707
8684
2539
6204
9342
9450
2294
4570
5010
1229
3445
1385
2896
85
88
77
49
70
60
77
84
91
-5
-60
-50
-50
95
97
61
66
50
50
52
-50
-9
52
98
99
6
89
32
81
27
53
21
97
76
101
83
48
71
83
-2
44
67
83
83
97
27
11
68
88
41
23
99
81
83
85
85
72
61
62
63
86
87
81
83
77
77
77
64
66
78
92
93
23
79
52
37
71
75
97
78
67
79
39
26
81
41
77
29
72
71
20
79
68
45
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
Worldscale Association
Dream Weavers Network
Mr. Trademark Inc.
Jefferson Financial
P J P Sales
Mylon C. Jacobs Supply
Terry Smith
Smith Supply
Complete Police Supply Limited
Design Build Concepts
Bon Voyage Travel
Diverse Technologies Corporation
Magic Dollar
Syracuse Castings Sales
McCormick Sales And Service
Zecharya Sales & Services;Inc
Marinette Co. Abstract & Land
BoKip Sales
Mark’s Sales
Pete Reilly Consultants
9070
9401
3754
3730
7900
2911
1569
3337
2342
8181
8702
9537
3503
8596
6196
9167
6257
4183
7135
4992
7770
7552
4761
5878
6278
4628
2078
5390
5262
7472
3493
3047
2386
4174
2909
1727
3575
1880
6928
5412
94
95
24
21
84
11
-3
14
4
86
91
97
16
91
56
94
57
30
76
43
34
53
90
78
81
86
60
24
94
34
66
59
65
81
49
45
78
85
39
55
Option #1: Business Profits
The research firm LL Research collected data from 200 client businesses. They want
to determine how the businesses compare among four variables:
2015 Profit in millions of dollars
2016 Profit in millions of dollars
2015-2016 Two-Year Change in Daily Average Customer Visits
Two-Year Average Number of Employees
Data collected for the sample of 200 businesses is contained in the file
named Businesses. Be sure to use all 200 data points.
Managerial Report
Prepare a report (see below) using the numerical methods of descriptive statistics
presented in this module to learn how each of the variables contributes to the
success of a client’s business. Be sure to include the following three items in your
report.
1. Compute descriptive sample statistics (mean, median, two quartiles Q1 and Q3
(using QUARTILE.EXC), minimum, maximum, range, interquartile range,
sample standard deviation, and coefficient of variation) for each of the four
variables along with an explanation of what the descriptive statistics tell us
about the client businesses.
•
•
•
•
In this case, which measure of central tendency would be best for this
application? Explain why.
Which measure of variation would be best for this application? Explain why.
How can one use the above descriptive statistics to understand the businesses
better?
Which graphical displays of data would you use to help understand or
complement the above descriptive statistics? Explain how and why.
Note: QUARTILE.EXC works only for Excel 2010 or newer.
2. Compute the percent change in profit from 2015 to 2016 for each business.
•
•
•
•
•
What would the percent change tell us in this application?
Then use the z-score to determine which businesses were outliers with respect
to percent change in profit.
How would identifying outliers be useful in this application?
What advice might you give to businesses that are outliers?
How else would you determine outliers?
3. Compute the sample correlation coefficient, showing the relationship between
percent change in profit and each of the other two variables (2015-2016 TwoYear Change in Daily Average Customer Visits and Two-Year Average
Number of Employees).
•
Explain what the correlation coefficients tell us about the three pairs of
relationships. Use tables, charts, or graphs to support your conclusions.
Write a report that adheres to the formatting and APA expectations outlined in
the CSU Global Writing Center (Links to an external site.). As with all written
assignments at CSU Global, you should have in-text citations and a reference
page.
Submit your Excel file in addition to your report.
Requirements:
1. The paper must be written in third person.
2. Your paper should be four to five pages in length (counting the title page and
references page) and cite and integrate at least one credible outside source.
The CSU Global Library (Links to an external site.) is a great place to find
resources.
3. Include a title page, introduction, body, conclusion, and a reference page.
4. The introduction should describe or summarize the topic or problem. It might
discuss the importance of the topic or how it affects you or society as a whole,
or it might discuss or describe the unique terminology associated with the
topic.
5. The body of your paper should answer the questions posed in the problem.
Explain how you approached and answered the question or solved the
problem, and, for each question, show all steps involved. Be sure the Word
document is in paragraph format, not numbered answers like a homework
assignment.
6. The conclusion should summarize your thoughts about what you have
determined from the data and your analysis, often with a broader personal or
societal perspective in mind. Nothing new should be introduced in the
conclusion that was not previously discussed in the body paragraphs. Your
conclusion should emanate (be aligned with) your findings.
7. Include any tables of data or calculations, calculated values, and/or graphs
associated with this problem in the body of your assignment.
8. Document formatting, citations, and style should conform to the CSU Global
Writing Center (Links to an external site.). A short summary containing
guidelines for paper formatting, citations, and references is contained in
the New Sample APA Paper (Links to an external site.). In addition, information
in the CSU Global Library (Links to an external site.) has many helpful areas
(Writing Center, Writing Tips, Template Examples/Papers Essays, and others).
Option #2: Call Times
Call International oversees the quality of 200 call centers throughout the world. They
want to determine how the centers compare among four variables for the most
recent year:
Shift A Average Call Time (in minutes)
Shift B Average Call Time (in minutes)
Average Customer Satisfaction Level (on a 4-point scale: 1=poor, 2=average,
3=good, 4=excellent)
Average Number of Employees
Data collected for the sample of 200 Call Centers are contained in the file
named Call Centers. Be sure to use all 200 data points.
Managerial Report
Prepare a report (see below) using the numerical methods of descriptive statistics
presented in this module to learn how the variables contribute to the success of a
call center. Be sure to include the following three items in your report.
1. Calculate descriptive sample statistics (mean, median, range, the two quartiles
Q1 and Q3 (using QUARTILE.EXC), minimum, maximum, interquartile range,
sample standard deviation, and coefficient of variation) for each of the four
variables, along with an explanation of what the descriptive statistics tell us
about the call centers.
•
•
•
•
In this case, which measure of central tendency would be best for this
application? Explain why.
Which measure of variation would be best for this application? Explain why.
How can one use the above descriptive statistics to understand the call centers
better?
Which graphical displays of data would you use to help understand or
complement the above descriptive statistics? Explain how and why.
Note: QUARTILE.EXC works only for Excel 2010 or newer.
2. Use the z-score to determine which call centers, if any, should be considered
outliers in each of the four variables.
•
•
•
•
If there are any outliers in any category, please list them and state for which
category they are an outlier.
How would identifying outliers be useful in this application?
What advice might you give to call centers that are outliers?
How else would you determine outliers?
3. Compute the sample correlation coefficient, showing the relationship between
Satisfaction Level and each of the other three variables (Shift A Average Call
time, Shift B Average Call Time, Average Number of Employees).
•
Explain what the correlation coefficients tell us about the three pairs of
relationships. Use tables, charts, or graphs to support your conclusions.
Write a report that adheres to the formatting and APA expectations outlined on
the CSU Global Writing Center (Links to an external site.). As with all written
assignments at CSU Global, you should have in-text citations and a reference page.
Submit your Excel file in addition to your report.
Requirements:
1. The paper must be written in third person.
2. Your paper should be four to five pages in length (counting the title page and
references page) and cite and integrate at least one credible outside source.
The CSU Global Library (Links to an external site.) is a great place to find
resources.
3. Include a title page, introduction, body, conclusion, and a reference page.
4. The introduction should describe or summarize the topic or problem. It might
discuss the importance of the topic or how it affects you or society as a whole,
or it might discuss or describe the unique terminology associated with the
topic.
5. The body of your paper should answer the questions posed in the problem.
Explain how you approached and answered the question or solved the
problem, and, for each question, show all steps involved. Be sure the Word file
is in paragraph format, not numbered answers like a homework assignment.
6. The conclusion should summarize your thoughts about what you have
determined from the data and your analysis, often with a broader personal or
societal perspective in mind. Nothing new should be introduced in the
conclusion that was not previously discussed in the body paragraphs. The
conclusions should emanate (be aligned with) the findings.
7. Include any tables of data or calculations, calculated values, and/or graphs
associated with this problem in the body of your assignment.
8. Document formatting, citations, and style should conform to the CSU Global
Writing Center (Links to an external site.). A short summary containing
guidelines for paper formatting, citations, and references is contained in
the New Sample APA Paper (Links to an external site.). In addition, information
in the CSU Global Library (Links to an external site.)has many helpful areas
(Writing Center, Writing Tips, Template Examples/Papers Essays, and others)
Average
Shift A Shift B
Number
Average Average Average
of
Call
Call Satisfacti Employe
Time
Time on Level
es
Call
Center
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
14
1
53
10
85
18
24
58
33
9
10
6
31
11
3
81
56
63
8
55
38
10
3
7
4
19
74
49
22
49
10
7
39
8
9
39
29
116
17
11
10
29
1
60
25
71
33
40
65
46
19
23
13
44
28
7
70
63
67
16
61
48
26
8
15
11
34
69
57
37
57
22
16
49
17
19
49
43
75
32
28
23
2
1
4
2
4
2
2
4
3
1
2
1
3
2
1
4
4
4
1
4
3
2
1
1
1
2
4
3
2
3
2
1
3
1
2
3
3
4
2
2
2
100
90
80
54
69
54
42
67
30
48
29
26
27
100
47
37
95
84
53
77
49
66
49
94
55
40
74
73
44
46
39
69
84
90
96
68
93
66
96
96
59
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
19
25
2
4
56
61
66
18
98
1
32
1
58
6
61
82
2
31
49
37
26
52
10
28
10
24
3
23
41
32
50
38
14
43
11
38
15
61
57
55
89
10
78
74
6
2
2
34
40
4
11
64
66
67
33
75
3
44
3
64
13
67
71
4
44
55
48
41
59
26
42
26
40
8
40
50
46
58
49
29
51
28
49
30
66
64
62
73
25
69
69
13
4
6
2
2
1
1
4
4
4
2
4
1
3
1
4
1
4
4
1
3
3
3
2
4
2
2
2
2
1
2
3
3
4
3
2
3
2
3
2
4
4
4
4
2
4
4
1
1
1
67
79
98
69
74
67
100
38
72
32
40
57
100
91
60
55
68
31
53
31
49
44
83
96
86
98
62
58
81
91
26
57
34
98
43
33
37
48
94
25
37
28
31
39
26
41
90
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
99
4
47
90
56
20
9
22
53
19
10
47
53
2
5
14
4
39
3
59
63
1
18
4
48
17
46
49
29
2
9
58
10
60
67
87
62
48
16
34
1
44
55
49
7
46
55
75
10
53
74
63
35
19
38
60
35
24
53
60
6
12
29
9
49
8
65
67
1
33
11
54
32
52
56
44
6
19
64
21
66
67
73
67
55
32
48
4
51
62
56
15
52
62
4
1
3
4
4
2
1
2
4
2
2
3
4
1
1
2
1
3
1
4
4
1
2
1
3
2
3
3
3
1
2
4
2
4
4
4
4
3
2
3
1
3
4
3
1
3
4
74
77
81
39
76
54
37
100
42
97
75
76
65
25
52
96
86
32
44
45
58
46
75
100
70
38
48
92
34
46
60
41
78
84
42
78
42
86
92
84
48
90
46
77
59
53
99
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
7
56
4
34
16
2
51
33
14
72
10
18
9
2
48
28
32
20
40
2
49
37
86
9
32
35
50
2
13
86
32
45
31
41
87
20
93
22
26
29
67
55
49
59
52
93
16
14
63
12
47
30
7
59
47
28
68
22
33
20
5
54
43
45
35
50
6
57
48
71
19
46
48
57
4
28
72
46
52
44
50
72
35
74
36
41
43
67
63
56
66
59
74
32
1
4
1
3
2
1
4
3
2
4
2
2
2
1
3
2
3
2
3
1
4
3
4
2
3
3
4
1
2
4
3
3
3
3
4
2
4
2
2
3
4
4
3
4
4
4
2
93
28
47
81
77
50
52
63
28
72
78
52
25
95
26
31
36
73
59
83
84
44
36
59
93
68
63
41
38
50
64
50
72
49
53
32
75
32
26
64
93
71
65
32
63
75
89
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
4
18
13
28
44
118
23
23
57
88
82
7
7
16
37
50
21
1
9
33
28
42
52
19
39
40
64
73
70
16
16
31
48
58
36
2
1
2
2
2
3
2
2
2
4
4
4
1
1
2
3
4
2
1
77
31
54
83
28
96
31
30
63
60
81
64
63
51
93
76
49
42