SCENARIO (DATA COMPLETED AND ATTACHED)
You recently met with your manager so that he could give you a new assignment. It turns out that your company’s competitors have been closing in on market share. Your manager explains that leadership needs to take a closer look at the composition of the workforce. He wants you to use your quantitative reasoning skills to analyze some important data. He tells you your analysis will contribute to strategic decisions as the leadership considers how best to position the company for expansion, growth, and a more agile response to fluctuating markets. He’ll present this data to the company leaders at their quarterly strategic planning meeting. You know that you will need to use your statistical skills and technical skills to identify and manipulate the data. You’ll also need to draw relevant conclusions based on quantitative reasoning.
QUESTIONS TO BE ADDRESSED IN ESSAY (DATA COMPLETED AND ATTACHED)
Now that you have completed your analysis, think about the patterns you’ve seen in the workforce and how you can connect the formulas you’ve used with what you produced. Answer these questions with short answers.
1. From the created histogram, it appears that a large share of employees have a salary between $31,000—$40,000 or $51,000—$60,000. This may indicate reasonable promotion rate for new employees. Is this distribution unimodal or bimodal? Explain.
2. The line chart, as detailed in your “Graph Charts” Excel spreadsheet, shows sales increasing over the years, after an initial few rocky years from 1999 to 2002. Assuming that the sales are linear, use the Forecast tool to find projected sales for 2019 and 2020. Hint: An easy way to do this is to highlight the sales from the data page and apply the Forecast tool to this data. Your output will be a chart and a new sheet with projected sales for average, upper, and lower range growth.
3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, the more narrow the range will be between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe your standard deviations. What does this tell you about the variables?
4. The company has a keen interest in the educational, race, and gender makeup of its workforce. Its emphasis is on a diverse, dynamic workforce. From your “Graph Charts” spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how you would determine if the company was meeting expectations on these characteristics.
5. The company is conducting an analysis on how many positions to create to keep up with demand. Specifically, it wants to know an estimate of the number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings.
FINAL ESSAY (DATA COMPLETED AND ATTACHED)
Now that you have done all the work with data, write a short three- to four-paragraph summary of your analysis. This is important. While you have done a wonderful job with your analysis, you can never assume that the end user will be able to interpret the data the way it should be understood. Supporting narrative is helpful. Never simply provide a “raw data” dump. Instead, seek to provide information!
a. Write a one-paragraph narrative summary of your findings, describing patterns of interest.
b. Provide an explanation of the potential relevance of such patterns.
c. Provide a description of how you would investigate further to determine if your results are “good or bad” for the company.
Workforce Profile Analysis
Section 1: Complete all Columns in Data Set
Format for:
Number
Emp #
1001
1002
1003
1004
1005
1006
1014
1015
1016
1018
1018
1019
1024
1036
1038
1043
1048
1049
1053
1053
1055
1055
1055
1056
1059
1061
1062
1062
1069
1070
1071
1071
1075
1079
1083
Date
mm/dd/yy
Hire Date
03/15/99
12/15/99
09/07/12
06/13/12
10/25/08
08/05/06
06/03/09
07/08/13
09/23/08
01/15/11
05/03/12
05/21/07
08/17/11
09/25/00
08/21/12
06/18/09
09/19/13
02/23/04
05/31/13
09/08/09
06/15/01
06/04/01
9/30/2001
05/06/07
02/14/12
02/02/09
03/04/13
07/08/09
02/03/11
08/21/09
01/09/05
08/08/05
01/14/10
10/15/03
08/27/09
Text
Role
CEO
Design
Sr Mach
Machine
Machine
Machine
IT Staff
Invent
Machine
Acctg/Fin
Machine
Machine
Machine
Machine
IT Staff
Gen Shop
Shipping
IT Staff
Machine
Machine
Controller
Machine
Machine
Machine
Acctg/Fin
Machine
Acctg/Fin
Flr Supr
Engineering
Machine
Engineering
Engineering
Machine
Invent
Machine
Currency
Currency
General
Number
Salary
$200,210
$79,723
$66,750
$31,924
$42,687
$50,307
$87,818
$31,250
$42,719
$42,836
$32,157
$48,317
$33,005
$57,822
$65,451
$26,168
$31,655
$88,421
$30,241
$35,293
$99,836
$56,663
$57,385
$48,059
$46,589
$39,931
$32,238
$72,803
$79,938
$35,498
$86,238
$87,019
$34,317
$51,459
$35,396
Year Ending Vested Yr
12/31/2014
10
Hrly Rate Yrs of Svc
Ed
$96.25
16
19
$38.33
15
16
$32.09
2
12
$15.35
3
12
$20.52
6
14
$24.19
8
14
$42.22
6
16
$15.02
1
14
$20.54
6
12
$20.59
4
16
$15.46
3
12
$23.23
8
12
$15.87
3
12
$27.80
14
16
$31.47
2
16
$12.58
6
12
$15.22
1
12
$42.51
11
19
$14.54
2
12
$16.97
5
12
$48.00
14
19
$27.24
14
16
$27.59
13
16
$23.11
8
12
$22.40
3
16
$19.20
6
12
$15.50
2
16
$35.00
5
14
$38.43
4
16
$17.07
5
12
$41.46
10
19
$41.84
9
19
$16.50
5
12
$24.74
11
16
$17.02
5
12
Number
General
Number
Number
Number
Text
General
Age
56
45
29
24
35
41
40
26
35
32
24
38
26
51
32
27
20
41
20
30
45
50
50
38
33
34
28
35
35
31
41
51
28
31
31
Vested
YES
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
YES
YES
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
Race
3
3
1
3
3
3
4
3
3
3
3
3
3
2
2
3
1
3
3
1
3
3
1
3
3
1
3
3
2
3
3
3
3
3
3
Gender
1
1
1
1
1
1
2
1
1
2
2
1
1
1
1
1
2
1
1
1
2
1
1
1
2
1
1
1
2
1
1
1
2
1
1
Status
2
2
1
2
1
1
1
2
2
2
1
1
1
1
1
1
2
1
2
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
2
State
PA
PA
IL
NE
PA
IL
IL
PA
NE
PA
NE
NE
IL
NE
PA
IL
IL
PA
PA
IL
PA
PA
IL
IL
NE
NE
IL
PA
IL
NE
NE
IL
NE
PA
PA
Region
Northeast
Northeast
Midwest
C-Plains
Northeast
Midwest
Midwest
Northeast
C-Plains
Northeast
C-Plains
C-Plains
Midwest
C-Plains
Northeast
Midwest
Midwest
Northeast
Northeast
Midwest
Northeast
Northeast
Midwest
Midwest
C-Plains
C-Plains
Midwest
Northeast
Midwest
C-Plains
C-Plains
Midwest
C-Plains
Northeast
Northeast
1
1083
1084
1088
1096
1097
1098
1101
1102
1104
1105
1106
1108
1109
1113
1113
1116
1116
1117
1117
1128
1130
1132
1133
1136
1138
1138
1140
1141
1142
1145
1145
1145
1150
1153
1156
1167
1169
1175
1180
1185
1186
1188
1189
1190
1190
4/30/2000
03/15/99
10/03/11
03/06/06
08/14/05
01/13/14
06/08/02
04/08/00
02/01/05
09/06/12
5/9/2002
06/15/07
02/22/07
05/02/12
09/08/00
12/30/08
04/05/00
05/27/09
08/15/12
06/07/10
03/15/99
07/10/09
02/12/09
12/14/11
10/18/10
4/12/2008
07/10/09
06/18/09
06/17/09
02/16/09
11/05/09
09/15/04
04/26/13
02/05/12
05/21/11
11/15/11
01/22/09
09/25/02
01/24/05
04/16/09
08/14/05
05/16/09
02/12/10
5/9/2002
8/31/1999
Machine
Sales
Sr Flr Mgr
Machine
Machine
Engineering
Invent
IT Staff
Machine
Invent
Machine
Gen Shop
Machine
Machine
Sr Mach
Machine
Quality
Gen Shop
Machine
Flr Supr
Machine
Machine
Sales
Machine
Gen Shop
Machine
Machine
Gen Shop
Machine
Gen Shop
Machine
Machine
Machine
Sr Mach
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Engineering
Sales
Machine
Machine
$58,771
$85,671
$83,974
$50,502
$50,571
$62,245
$55,994
$88,900
$52,450
$32,633
$55,744
$27,403
$49,201
$32,124
$81,695
$42,235
$81,526
$26,360
$31,262
$74,104
$59,438
$35,822
$73,337
$32,523
$24,017
$44,204
$35,934
$25,999
$36,901
$25,131
$34,680
$53,327
$30,808
$66,843
$33,395
$32,766
$40,871
$54,886
$52,469
$37,914
$50,636
$83,198
$70,520
$55,716
$59,147
$28.26
$41.19
$40.37
$24.28
$24.31
$29.93
$26.92
$42.74
$25.22
$15.69
$26.80
$13.17
$23.65
$15.44
$39.28
$20.31
$39.20
$12.67
$15.03
$35.63
$28.58
$17.22
$35.26
$15.64
$11.55
$21.25
$17.28
$12.50
$17.74
$12.08
$16.67
$25.64
$14.81
$32.14
$16.06
$15.75
$19.65
$26.39
$25.23
$18.23
$24.34
$40.00
$33.90
$26.79
$28.44
15
16
3
9
9
1
13
15
10
2
13
8
8
3
14
6
15
6
2
5
16
5
6
3
4
7
5
6
6
6
5
10
2
3
4
3
6
12
10
6
9
6
5
13
15
14
19
16
12
12
16
16
19
12
12
12
12
12
12
14
12
16
12
12
16
16
12
19
12
12
12
12
12
12
12
12
12
12
12
12
12
12
14
12
12
12
19
16
12
14
52
62
35
42
43
25
31
48
44
28
48
29
39
24
50
34
52
27
22
35
53
32
58
24
24
35
32
24
32
24
29
45
21
30
26
24
34
48
45
33
43
38
40
48
53
YES
YES
NO
NO
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
YES
NO
YES
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
YES
YES
3
3
1
3
1
3
1
3
3
3
1
3
3
1
1
3
3
3
2
3
3
3
4
1
4
4
2
3
1
2
1
3
1
3
3
3
3
3
1
1
3
3
2
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
2
1
1
1
2
1
2
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
2
1
1
1
2
1
2
1
2
1
1
1
1
2
1
1
1
1
2
1
1
1
1
1
2
2
1
2
1
2
1
1
1
1
1
1
1
1
1
1
IL
PA
NE
NE
PA
PA
NE
PA
NE
NE
IL
IL
NE
PA
PA
IL
PA
PA
IL
NE
PA
PA
PA
IL
PA
PA
IL
IL
PA
IL
NE
IL
IL
IL
IL
PA
PA
NE
NE
PA
NE
IL
PA
IL
IL
Midwest
Northeast
C-Plains
C-Plains
Northeast
Northeast
C-Plains
Northeast
C-Plains
C-Plains
Midwest
Midwest
C-Plains
Northeast
Northeast
Midwest
Northeast
Northeast
Midwest
C-Plains
Northeast
Northeast
Northeast
Midwest
Northeast
Northeast
Midwest
Midwest
Northeast
Midwest
C-Plains
Midwest
Midwest
Midwest
Midwest
Northeast
Northeast
C-Plains
C-Plains
Northeast
C-Plains
Midwest
Northeast
Midwest
Midwest
2
1196
1198
1201
1202
1210
1215
1216
1218
1220
1220
1224
1226
1227
1227
1232
1233
1237
1246
1248
1254
1255
1257
1257
1258
1261
1261
1265
1265
1267
1269
1272
1276
1279
1280
1285
1288
1289
1289
1292
1295
1296
1296
1296
1297
1299
09/08/09
09/17/10
08/01/08
03/15/99
09/10/06
05/06/07
07/12/06
07/23/09
10/16/02
04/15/00
09/23/13
06/02/07
05/03/00
04/25/06
07/12/10
05/31/13
08/08/07
07/27/00
07/25/09
02/02/09
03/14/09
08/09/09
03/11/10
07/09/03
04/13/13
06/02/09
03/04/13
07/08/11
2/5/2008
03/14/07
09/18/10
05/04/11
10/20/07
08/11/14
04/04/11
03/25/10
09/05/11
10/22/06
05/13/01
07/08/12
05/05/00
09/15/10
09/23/11
06/06/05
04/08/09
Machine
Gen Shop
Machine
Acctg/Fin
Machine
Engineering
Shipping
Design
Machine
Sr Mach
Engineering
Gen Shop
Invent
Machine
Shipping
Machine
Machine
Sr Mach
Gen Shop
Machine
Gen Shop
Engineering
Machine
Sr Mach
Machine
Sr Mach
Acctg/Fin
Engineering
Machine
Design
IT Mgr
IT Staff
Machine
Acctg/Fin
Advertg
Sales
Gen Shop
Machine
Machine
Purch
Gen Shop
Invent
Quality
Sr Mach
Shp Mgr
$35,327
$23,484
$43,003
$85,123
$50,133
$86,673
$52,654
$64,504
$54,368
$83,377
$70,886
$27,435
$65,234
$50,320
$37,456
$30,577
$46,904
$82,315
$26,156
$39,755
$26,621
$85,463
$34,232
$70,234
$30,165
$68,014
$29,632
$85,825
$44,747
$76,577
$100,515
$65,469
$46,057
$29,442
$53,064
$70,708
$17,943
$50,078
$56,815
$45,670
$28,901
$52,765
$53,487
$69,628
$85,286
$16.98
$11.29
$20.67
$40.92
$24.10
$41.67
$25.31
$31.01
$26.14
$40.09
$34.08
$13.19
$31.36
$24.19
$18.01
$14.70
$22.55
$39.57
$12.58
$19.11
$12.80
$41.09
$16.46
$33.77
$14.50
$32.70
$14.25
$41.26
$21.51
$36.82
$48.32
$31.48
$22.14
$14.15
$25.51
$33.99
$8.63
$24.08
$27.31
$21.96
$13.89
$25.37
$25.71
$33.48
$41.00
5
4
6
16
8
8
8
5
12
15
1
8
15
9
4
2
7
14
5
6
6
5
5
11
2
6
2
3
7
8
4
4
7
0
4
5
3
8
14
2
15
4
3
10
6
12
12
12
16
12
19
14
16
12
14
16
12
14
12
12
12
12
12
12
12
12
19
12
12
12
12
16
19
12
16
19
16
12
16
16
16
12
12
14
12
14
12
16
12
16
30
22
35
48
40
43
40
34
48
55
30
29
45
41
28
21
38
54
25
34
27
38
28
46
20
33
24
40
35
39
52
32
37
22
26
41
19
40
50
30
36
29
34
41
47
NO
NO
NO
YES
NO
NO
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
YES
NO
NO
NO
NO
3
1
3
3
3
2
1
1
3
1
2
1
3
3
3
3
1
3
3
2
3
3
3
3
3
1
1
3
2
3
3
3
1
3
3
1
1
1
3
3
3
4
3
3
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
2
1
2
1
2
1
1
1
2
2
1
1
1
1
2
1
2
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
2
1
2
1
1
1
1
2
1
2
1
2
2
2
1
1
2
1
1
1
1
2
2
2
1
1
1
1
1
1
2
1
IL
PA
IL
PA
NE
PA
PA
PA
NE
IL
PA
IL
IL
PA
IL
NE
IL
IL
NE
PA
PA
NE
PA
NE
IL
IL
NE
NE
IL
NE
PA
NE
NE
PA
NE
NE
NE
IL
PA
NE
PA
IL
NE
IL
PA
Midwest
Northeast
Midwest
Northeast
C-Plains
Northeast
Northeast
Northeast
C-Plains
Midwest
Northeast
Midwest
Midwest
Northeast
Midwest
C-Plains
Midwest
Midwest
C-Plains
Northeast
Northeast
C-Plains
Northeast
C-Plains
Midwest
Midwest
C-Plains
C-Plains
Midwest
C-Plains
Northeast
C-Plains
C-Plains
Northeast
C-Plains
C-Plains
C-Plains
Midwest
Northeast
C-Plains
Northeast
Midwest
C-Plains
Midwest
Northeast
3
1300
1300
1308
1308
1308
1314
1315
1315
1317
1320
1320
1320
1323
1325
1329
1332
1339
1341
1343
1343
1346
1350
1356
1357
1357
1364
1364
1373
1373
1378
1379
1381
1387
1387
1387
1391
1393
1394
1400
1402
1403
1404
1405
1411
1417
07/10/09
06/17/09
04/03/10
06/30/01
4/30/2000
1/22/2008
02/15/07
02/07/08
08/12/08
06/18/09
09/01/12
05/07/11
02/05/05
03/15/99
09/20/09
04/12/11
05/01/12
03/07/04
04/15/10
12/18/07
06/12/10
06/21/12
09/19/10
03/15/99
04/08/05
3/16/2008
04/20/05
04/08/09
06/25/07
07/09/10
06/09/07
10/23/10
07/14/09
12/18/07
07/23/05
05/30/09
2/3/2001
04/30/00
06/16/05
08/17/11
12/01/10
10/15/11
08/13/07
03/05/09
04/15/07
Engineering
Machine
Engineering
IT Staff
Machine
Machine
Machine
Sr Mach
Sr Mach
Gen Shop
Machine
Sr Mach
Machine
Sr Mach
Gen Shop
Shipping
Machine
Gen Shop
Gen Shop
Machine
Sr Mach
Admin
Sr Sales Mgr
Advertg
COO
Machine
Machine
Machine
Machine
Machine
Mrktg
Sales
Gen Shop
Machine
Machine
Machine
Machine
Machine
Design
Machine
Sales
Gen Shop
Gen Shop
Design
Sr Mach
$80,637
$36,882
$75,261
$88,698
$58,742
$44,765
$49,672
$68,913
$68,677
$26,351
$31,170
$67,380
$52,235
$83,413
$26,020
$36,789
$31,992
$28,325
$21,897
$44,860
$67,679
$21,387
$84,068
$99,741
$105,779
$44,576
$51,431
$38,873
$47,648
$33,968
$81,191
$72,181
$26,163
$45,130
$50,914
$37,084
$57,643
$58,640
$80,483
$32,812
$71,265
$18,097
$28,537
$61,333
$69,102
$38.77
$17.73
$36.18
$42.64
$28.24
$21.52
$23.88
$33.13
$33.02
$12.67
$14.99
$32.39
$25.11
$40.10
$12.51
$17.69
$15.38
$13.62
$10.53
$21.57
$32.54
$10.28
$40.42
$47.95
$50.86
$21.43
$24.73
$18.69
$22.91
$16.33
$39.03
$34.70
$12.58
$21.70
$24.48
$17.83
$27.71
$28.19
$38.69
$15.78
$34.26
$8.70
$13.72
$29.49
$33.22
5
6
5
14
15
7
8
7
6
6
2
4
10
16
5
4
3
11
5
7
5
3
4
16
10
7
10
6
8
4
8
4
5
7
9
6
14
15
10
3
4
3
7
6
8
16
12
16
19
14
12
12
12
12
14
12
12
12
14
14
12
12
14
12
12
12
12
16
16
19
12
12
12
12
12
16
16
12
12
12
12
12
16
16
12
16
14
14
16
12
36
32
31
43
51
35
39
34
35
27
22
31
44
57
25
24
24
32
22
36
31
23
48
52
39
35
44
33
38
28
36
52
26
36
43
32
51
51
46
26
42
19
34
30
34
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
NO
3
3
3
2
3
1
3
4
3
4
4
1
4
3
1
3
3
3
1
1
3
3
3
3
3
3
1
4
3
3
1
3
1
1
3
3
3
1
3
4
3
3
3
3
4
2
1
1
2
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
2
1
1
2
1
1
1
1
2
2
2
2
1
1
2
2
1
2
1
1
2
1
1
2
1
2
1
1
1
1
1
2
2
1
2
1
1
2
1
1
2
1
2
1
PA
PA
NE
IL
NE
IL
IL
PA
PA
IL
PA
NE
IL
PA
PA
PA
NE
PA
IL
IL
PA
NE
NE
PA
PA
PA
IL
PA
PA
PA
NE
IL
NE
IL
IL
NE
NE
IL
NE
IL
IL
PA
IL
NE
PA
Northeast
Northeast
C-Plains
Midwest
C-Plains
Midwest
Midwest
Northeast
Northeast
Midwest
Northeast
C-Plains
Midwest
Northeast
Northeast
Northeast
C-Plains
Northeast
Midwest
Midwest
Northeast
C-Plains
C-Plains
Northeast
Northeast
Northeast
Midwest
Northeast
Northeast
Northeast
C-Plains
Midwest
C-Plains
Midwest
Midwest
C-Plains
C-Plains
Midwest
C-Plains
Midwest
Midwest
Northeast
Midwest
C-Plains
Northeast
4
1418
1422
1422
1424
1424
1424
1424
1426
1429
1432
1434
1442
1443
1444
1444
1445
1446
1447
1447
1448
1450
1452
1456
1456
1461
1466
1466
1468
1471
1474
1476
1477
1477
1481
1484
1492
1496
1498
1498
1504
1504
1505
1506
1507
1513
07/04/11
05/30/09
09/08/13
03/15/99
01/14/10
02/15/13
03/15/99
10/20/07
06/30/10
10/15/09
01/21/07
01/08/12
09/12/06
06/15/02
08/02/11
08/08/10
12/15/05
10/18/10
09/05/12
05/03/11
01/22/09
11/06/06
06/25/07
05/07/04
10/12/10
03/19/09
05/04/12
7/21/2001
07/10/09
03/25/09
05/23/11
03/15/03
01/15/12
09/06/03
03/04/09
10/25/2001
05/07/13
02/22/11
08/04/13
03/14/05
04/30/10
12/06/10
06/27/04
04/15/14
08/14/03
Quality
Machine
Sales
Flr Supr
Machine
Sales
Sr Mach
Machine
Sr Mach
Design
Machine
Admin
Sr Mach
Mrktg
Sales
Machine
Gen Shop
Gen Shop
Sales
Admin
Machine
Machine
Machine
Sr Mach
Advertg
Machine
Sales
Machine
Machine
Machine
Purch
Purch
Shipping
Machine
Shipping
Machine
Shipping
Machine
Sr Mach
Machine
Shipping
Machine
IT Staff
Gen Shop
Machine
$53,981
$36,918
$52,485
$75,737
$34,512
$55,460
$84,505
$45,934
$67,692
$71,204
$49,797
$22,415
$69,372
$81,221
$64,415
$33,808
$27,574
$23,971
$63,836
$25,456
$40,705
$49,838
$47,522
$69,997
$53,215
$39,634
$64,329
$56,291
$36,729
$39,331
$48,560
$63,388
$33,169
$54,158
$45,622
$55,936
$31,035
$33,574
$65,283
$52,104
$38,455
$33,609
$88,517
$15,182
$54,358
$25.95
$17.75
$25.23
$36.41
$16.59
$26.66
$40.63
$22.08
$32.54
$34.23
$23.94
$10.78
$33.35
$39.05
$30.97
$16.25
$13.26
$11.52
$30.69
$12.24
$19.57
$23.96
$22.85
$33.65
$25.58
$19.05
$30.93
$27.06
$17.66
$18.91
$23.35
$30.48
$15.95
$26.04
$21.93
$26.89
$14.92
$16.14
$31.39
$25.05
$18.49
$16.16
$42.56
$7.30
$26.13
3
6
1
16
5
2
16
7
5
5
8
3
8
13
3
4
9
4
2
4
6
8
8
11
4
6
3
13
5
6
4
12
3
11
6
13
2
4
1
10
5
4
11
1
11
16
12
16
14
12
16
14
12
12
16
12
12
12
16
16
12
14
12
16
14
12
12
12
12
16
12
16
12
12
12
14
16
12
12
14
12
12
12
12
12
12
12
19
12
12
36
32
25
45
29
32
59
37
32
38
39
25
40
42
34
28
30
23
32
31
34
39
38
41
28
34
33
50
32
34
32
44
23
47
35
49
19
27
28
44
28
28
43
18
47
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
NO
YES
NO
YES
NO
YES
NO
NO
NO
NO
NO
NO
YES
NO
YES
3
1
3
3
3
1
3
3
1
3
2
1
3
3
3
3
4
1
3
4
3
3
1
1
3
1
3
1
3
3
3
3
1
3
1
1
1
1
4
1
3
1
1
1
3
1
1
1
2
1
2
1
1
1
1
1
2
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
2
1
1
1
2
1
2
2
1
1
1
1
1
1
1
2
2
1
1
1
1
1
2
1
1
1
1
2
2
1
2
1
1
1
1
2
1
2
2
1
1
1
1
2
1
1
2
2
1
1
1
1
1
1
2
1
IL
IL
NE
PA
NE
PA
PA
IL
IL
PA
NE
IL
PA
IL
IL
NE
PA
PA
NE
PA
NE
IL
NE
PA
IL
NE
IL
NE
PA
NE
IL
PA
PA
NE
PA
IL
NE
IL
NE
PA
PA
IL
NE
IL
PA
Midwest
Midwest
C-Plains
Northeast
C-Plains
Northeast
Northeast
Midwest
Midwest
Northeast
C-Plains
Midwest
Northeast
Midwest
Midwest
C-Plains
Northeast
Northeast
C-Plains
Northeast
C-Plains
Midwest
C-Plains
Northeast
Midwest
C-Plains
Midwest
C-Plains
Northeast
C-Plains
Midwest
Northeast
Northeast
C-Plains
Northeast
Midwest
C-Plains
Midwest
C-Plains
Northeast
Northeast
Midwest
C-Plains
Midwest
Northeast
5
1515
1517
1519
1519
1523
1525
1527
1529
1531
1533
1539
1541
1543
1550
1550
1552
1553
1553
1554
1554
1556
1557
1558
1560
1565
1568
1568
1569
1571
1575
1579
1580
1584
1588
1589
1591
1593
1596
1597
1598
1608
1608
1609
1611
1612
05/01/00
11/12/12
06/04/11
02/15/13
05/21/11
05/09/05
03/15/99
10/16/11
04/07/13
12/28/07
12/15/12
04/09/07
10/06/09
02/19/14
11/14/08
5/30/1999
04/12/09
10/20/07
10/23/13
10/20/06
03/21/09
07/21/04
01/06/05
05/06/12
03/16/07
08/07/12
02/07/10
04/23/10
04/16/09
02/04/09
01/12/05
09/16/10
03/15/99
8/17/2002
04/15/13
7/12/2008
08/15/08
06/12/09
11/20/11
02/15/13
03/15/99
04/15/09
07/20/11
09/23/07
03/06/11
Acctg/Fin
Engineering
Design
Machine
Acctg/Fin
Gen Shop
Machine
Machine
Design
Machine
Gen Shop
Sr Mach
Machine
IT Staff
Sr Mach
Machine
Machine
Machine
Engineering
Machine
Gen Shop
Machine
Machine
Gen Shop
Machine
Shipping
Sr Mach
Quality
Machine
Machine
Machine
Gen Shop
Machine
Machine
Design
Machine
Shipping
CFO
Flr Supr
Machine
Flr Supr
Sales
Machine
Machine
Shipping
$66,230
$62,572
$63,010
$29,819
$50,767
$27,633
$59,872
$32,797
$62,412
$45,283
$18,102
$69,128
$35,002
$55,067
$68,317
$59,316
$38,398
$46,097
$62,458
$50,082
$26,466
$53,537
$52,946
$18,270
$48,712
$32,960
$67,771
$55,254
$37,917
$40,629
$52,580
$23,342
$60,239
$55,566
$51,233
$43,213
$47,891
$131,276
$70,293
$29,661
$75,375
$73,258
$33,266
$46,378
$37,800
$31.84
$30.08
$30.29
$14.34
$24.41
$13.29
$28.78
$15.77
$30.01
$21.77
$8.70
$33.23
$16.83
$26.47
$32.84
$28.52
$18.46
$22.16
$30.03
$24.08
$12.72
$25.74
$25.45
$8.78
$23.42
$15.85
$32.58
$26.56
$18.23
$19.53
$25.28
$11.22
$28.96
$26.71
$24.63
$20.78
$23.02
$63.11
$33.79
$14.26
$36.24
$35.22
$15.99
$22.30
$18.17
15
2
4
2
4
10
16
3
2
7
2
8
5
1
6
16
6
7
1
8
6
10
10
3
8
2
5
5
6
6
10
4
16
12
2
6
6
6
3
2
16
6
3
7
4
16
16
16
12
16
12
12
12
16
12
14
12
12
16
12
14
12
12
16
12
12
12
12
14
12
12
12
16
12
12
12
12
16
12
16
12
12
19
16
12
16
19
12
12
12
36
26
33
19
35
30
54
24
32
36
21
36
30
28
33
53
33
38
26
40
27
46
45
21
38
20
32
42
33
34
45
22
54
48
25
35
38
42
34
19
44
53
26
38
25
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
3
1
3
4
2
3
3
3
3
3
3
3
3
1
3
3
1
3
2
3
4
3
2
3
3
3
1
3
4
3
1
3
1
2
3
3
1
3
3
3
3
3
3
3
2
2
2
1
2
1
1
1
1
1
1
1
1
1
2
1
1
1
1
2
1
1
1
1
1
1
2
1
2
1
1
1
1
1
1
2
1
2
1
1
1
2
1
1
1
1
2
2
2
2
2
2
1
1
2
1
2
1
2
2
1
1
1
1
2
1
2
2
1
2
1
2
2
2
2
1
1
2
2
1
2
1
1
2
1
2
1
1
2
1
1
NE
IL
IL
NE
IL
NE
PA
NE
PA
PA
IL
IL
IL
IL
IL
PA
NE
PA
IL
NE
PA
NE
PA
PA
IL
IL
NE
IL
PA
IL
IL
PA
PA
PA
IL
IL
NE
PA
IL
PA
IL
PA
NE
PA
NE
C-Plains
Midwest
Midwest
C-Plains
Midwest
C-Plains
Northeast
C-Plains
Northeast
Northeast
Midwest
Midwest
Midwest
Midwest
Midwest
Northeast
C-Plains
Northeast
Midwest
C-Plains
Northeast
C-Plains
Northeast
Northeast
Midwest
Midwest
C-Plains
Midwest
Northeast
Midwest
Midwest
Northeast
Northeast
Northeast
Midwest
Midwest
C-Plains
Northeast
Midwest
Northeast
Midwest
Northeast
C-Plains
Northeast
C-Plains
6
1613
1616
1616
1619
1620
1622
1623
1625
1626
1629
1630
1636
1637
1638
1639
1640
1644
1654
1658
1659
1660
1661
1661
1667
1667
1668
1668
1669
1671
1672
1673
1679
1680
1687
1687
1693
1709
1723
1723
1726
1733
1736
1736
1737
1741
05/04/12
09/15/09
08/09/06
11/3/2007
06/07/13
02/06/12
03/04/12
09/12/09
07/08/12
09/04/11
09/12/08
04/17/09
06/07/11
09/01/07
07/30/12
08/13/07
09/05/11
06/07/11
03/22/10
11/02/06
01/14/10
03/18/13
11/18/11
01/15/08
03/14/05
05/01/00
07/10/09
09/05/11
06/13/12
05/04/08
03/07/13
05/18/09
01/06/13
12/15/05
06/02/04
03/15/99
09/20/05
06/02/12
11/10/2007
03/15/99
09/18/13
09/18/07
04/01/09
03/15/99
03/30/09
Machine
Advertg
Engineering
Machine
Gen Shop
Shipping
Engineering
Purch
Gen Shop
Shipping
Shipping
Gen Shop
Sales
Machine
Machine
Design
Gen Shop
Engineering
Admin
Machine
Machine
Sales
Shipping
Engineering
Machine
Advertg
Machine
Design
Machine
Sr Flr Mgr
Mrktg
Acctg/Fin
Design
Gen Shop
Machine
Engineering
Machine
Gen Shop
Machine
Design
Flr Supr
Gen Shop
Machine
Invent
Machine
$32,496
$65,027
$86,818
$45,641
$15,248
$33,047
$64,153
$60,346
$19,141
$35,550
$47,650
$25,671
$64,494
$46,787
$31,567
$77,045
$17,598
$79,709
$32,300
$49,925
$34,420
$52,300
$34,456
$86,096
$51,554
$65,089
$35,688
$61,882
$31,809
$96,546
$67,415
$66,109
$51,226
$27,541
$53,784
$93,678
$50,522
$19,397
$45,495
$81,159
$65,780
$27,221
$39,130
$76,188
$39,191
$15.62
$31.26
$41.74
$21.94
$7.33
$15.89
$30.84
$29.01
$9.20
$17.09
$22.91
$12.34
$31.01
$22.49
$15.18
$37.04
$8.46
$38.32
$15.53
$24.00
$16.55
$25.14
$16.57
$41.39
$24.79
$31.29
$17.16
$29.75
$15.29
$46.42
$32.41
$31.78
$24.63
$13.24
$25.86
$45.04
$24.29
$9.33
$21.87
$39.02
$31.63
$13.09
$18.81
$36.63
$18.84
3
5
8
7
2
3
3
5
2
3
6
6
4
7
2
7
3
4
5
8
5
2
3
7
10
15
5
3
3
7
2
6
2
9
11
16
9
3
7
16
1
7
6
16
6
12
16
19
12
12
12
16
16
14
12
12
12
16
12
12
16
12
16
16
12
12
16
12
16
12
16
12
16
12
12
16
16
16
14
12
19
12
14
12
19
16
12
12
16
12
24
34
48
36
18
21
28
31
21
24
36
24
37
38
23
42
19
35
33
40
28
28
23
40
44
35
32
32
23
38
35
39
24
30
46
54
43
21
36
56
32
28
33
52
34
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
YES
YES
NO
NO
NO
YES
NO
NO
NO
YES
NO
1
3
3
3
1
3
2
3
3
1
3
4
4
3
1
3
3
3
1
1
1
3
1
3
3
3
4
3
3
3
3
3
1
1
3
3
1
3
1
3
1
3
3
3
3
1
2
1
1
2
2
1
1
2
1
1
1
1
1
1
1
1
2
2
1
2
2
2
1
1
1
1
2
1
1
2
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
2
1
1
2
2
1
1
2
1
1
1
1
2
2
1
2
1
2
2
1
1
2
1
1
1
2
1
1
1
1
1
2
1
1
1
1
2
1
1
1
2
2
1
1
PA
PA
NE
NE
NE
PA
IL
IL
NE
IL
IL
NE
PA
IL
PA
PA
PA
NE
PA
NE
PA
IL
NE
PA
PA
IL
PA
PA
IL
IL
IL
PA
IL
NE
IL
PA
IL
PA
PA
PA
PA
PA
IL
PA
IL
Northeast
Northeast
C-Plains
C-Plains
C-Plains
Northeast
Midwest
Midwest
C-Plains
Midwest
Midwest
C-Plains
Northeast
Midwest
Northeast
Northeast
Northeast
C-Plains
Northeast
C-Plains
Northeast
Midwest
C-Plains
Northeast
Northeast
Midwest
Northeast
Northeast
Midwest
Midwest
Midwest
Northeast
Midwest
C-Plains
Midwest
Northeast
Midwest
Northeast
Northeast
Northeast
Northeast
Northeast
Midwest
Northeast
Midwest
7
1744
1744
1744
1745
1748
1749
1750
1750
1754
1756
1756
1757
1760
1760
1764
1767
1770
1771
1773
1774
1776
1776
1779
1779
1782
1785
1785
1785
1787
1789
1793
1793
1793
1794
1796
1797
1800
1800
1802
1803
1804
1809
1812
1813
1814
06/15/11
Eng Mgr
08/16/06
Gen Shop
11/12/2007
Machine
06/10/10
Machine
08/25/10
Mrktg
08/14/00
Sr Mach
06/22/10
Gen Shop
08/13/09
Machine
05/06/03
Sr Mach
05/13/01
Machine
07/01/09
Sr Flr Mgr
2/16/2002
Machine
02/04/11
Design
09/15/12
Machine
6/17/2001
Machine
05/20/05
Machine
03/06/04
Engineering
03/14/05
Machine
06/07/05
Purch
10/25/13
Flr Supr
11/13/09
Design
03/15/99
Machine
09/07/10
Machine
06/01/05
Machine
03/04/04
Machine
07/06/06
Engineering
09/21/09
Gen Shop
02/08/10
Shipping
07/21/07
Acctg/Fin
09/23/08
Machine
03/15/99
Design
09/07/07
Shipping
09/08/08 Sr Sales Mgr
01/14/14
Engineering
03/14/10
Sales Mgr
02/08/03
Sr Mach
05/14/09
Machine
03/15/99
Machine
5/31/2008
Machine
09/30/00
Mrktg
08/19/09
Quality
10/16/2001
Machine
04/06/05
Gen Shop
01/15/03
Machine
08/19/11 Sr Sales Mgr
$110,233
$28,486
$45,317
$34,196
$68,352
$82,777
$21,828
$35,536
$70,507
$56,888
$93,478
$55,840
$60,348
$31,049
$57,530
$51,360
$86,972
$51,899
$60,999
$68,455
$61,441
$60,198
$33,631
$51,084
$53,903
$86,972
$26,096
$42,456
$66,261
$42,802
$81,077
$50,788
$90,822
$60,323
$101,275
$70,084
$36,918
$59,647
$43,498
$81,282
$64,510
$56,946
$27,781
$53,922
$87,102
$53.00
$13.70
$21.79
$16.44
$32.86
$39.80
$10.49
$17.08
$33.90
$27.35
$44.94
$26.85
$29.01
$14.93
$27.66
$24.69
$41.81
$24.95
$29.33
$32.91
$29.54
$28.94
$16.17
$24.56
$25.91
$41.81
$12.55
$20.41
$31.86
$20.58
$38.98
$24.42
$43.66
$29.00
$48.69
$33.69
$17.75
$28.68
$20.91
$39.08
$31.01
$27.38
$13.36
$25.92
$41.88
4
8
7
5
4
14
5
5
12
14
6
13
4
2
14
10
11
10
10
1
5
16
4
10
11
8
5
5
7
6
16
7
6
1
5
12
6
16
7
14
5
13
10
12
3
19
12
12
12
16
12
14
12
12
12
16
12
16
12
12
12
16
12
16
16
16
12
12
12
12
16
14
12
16
12
19
14
19
16
19
12
12
14
12
16
16
12
12
12
16
45
32
36
28
35
56
22
31
48
50
42
49
28
22
50
44
48
44
42
33
30
54
28
43
46
50
25
32
45
35
54
40
50
24
43
44
32
54
35
45
46
50
30
47
53
NO
NO
NO
NO
NO
YES
NO
NO
YES
YES
NO
YES
NO
NO
YES
NO
YES
NO
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
3
1
3
4
3
1
3
1
1
3
3
3
2
3
3
3
3
3
3
3
3
3
3
3
1
3
4
3
3
3
1
3
3
3
3
2
1
3
4
3
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
2
1
1
1
2
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
2
2
2
1
1
1
2
1
2
1
1
1
1
1
2
1
1
1
1
1
2
2
1
1
1
1
1
1
1
1
1
2
1
PA
NE
NE
PA
PA
NE
NE
IL
PA
PA
PA
PA
PA
IL
IL
IL
NE
PA
PA
NE
IL
PA
NE
IL
NE
IL
IL
PA
IL
PA
IL
IL
IL
PA
PA
NE
PA
PA
NE
PA
PA
NE
PA
IL
PA
Northeast
C-Plains
C-Plains
Northeast
Northeast
C-Plains
C-Plains
Midwest
Northeast
Northeast
Northeast
Northeast
Northeast
Midwest
Midwest
Midwest
C-Plains
Northeast
Northeast
C-Plains
Midwest
Northeast
C-Plains
Midwest
C-Plains
Midwest
Midwest
Northeast
Midwest
Northeast
Midwest
Midwest
Midwest
Northeast
Northeast
C-Plains
Northeast
Northeast
C-Plains
Northeast
Northeast
C-Plains
Northeast
Midwest
Northeast
8
1815
1816
1819
1820
1821
1822
1824
1829
1830
1831
1835
1836
1840
1841
1841
1846
1846
1846
1848
1848
1850
1850
08/17/11
04/16/09
10/06/09
08/06/09
09/13/06
05/02/07
04/13/13
03/01/07
1/15/2000
08/16/12
06/07/13
08/12/06
2/16/2000
06/07/07
08/05/13
04/23/09
03/05/13
08/30/04
12/15/09
06/05/04
11/20/10
08/05/07
Machine
Machine
Machine
Shipping
Machine
Engineering
Machine
Machine
Machine
Sr Mach
Sr Mach
Machine
Machine
Design
Sr Mach
Design
Engineering
Machine
Design
Gen Shop
Gen Shop
Invent
$33,244
$37,144
$34,804
$44,236
$50,130
$81,691
$30,089
$48,826
$58,928
$65,938
$65,556
$50,199
$58,792
$79,865
$65,117
$80,113
$60,324
$53,369
$80,722
$28,344
$24,060
$58,068
$15.98
$17.86
$16.73
$21.27
$24.10
$39.27
$14.47
$23.47
$28.33
$31.70
$31.52
$24.13
$28.27
$38.40
$31.31
$38.52
$29.00
$25.66
$38.81
$13.63
$11.57
$27.92
3
6
5
5
8
8
2
8
15
2
2
8
15
8
1
6
2
10
5
11
4
7
12
12
12
12
12
16
12
12
14
12
12
12
12
16
12
19
16
12
19
12
12
12
26
33
30
32
40
36
20
39
52
29
29
41
52
45
28
46
24
46
52
32
24
30
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
YES
NO
NO
African-Am
Asian
Caucasian
Hispanic
#
96
24
227
25
372
%
25.81%
6.45%
61.02%
6.72%
100.00%
Male
Female
#
300
72
372
%
80.65%
19.35%
100.00%
#
215
37
93
%
57.80%
9.95%
25.00%
3
3
2
3
3
3
1
1
3
1
4
1
3
2
3
3
3
2
3
3
3
3
1
1
1
1
1
1
2
1
1
2
1
1
1
1
1
2
1
1
1
1
1
2
1
1
1
1
1
1
2
1
1
1
1
1
1
2
1
2
1
1
1
1
2
1
NE
NE
IL
NE
PA
NE
NE
PA
IL
PA
NE
NE
IL
PA
PA
PA
IL
PA
PA
PA
PA
IL
C-Plains
C-Plains
Midwest
C-Plains
Northeast
C-Plains
C-Plains
Northeast
Midwest
Northeast
C-Plains
C-Plains
Midwest
Northeast
Northeast
Northeast
Midwest
Northeast
Northeast
Northeast
Northeast
Midwest
Section 2: Complete Summary Tables for Graphing
Roles
Key Emp
Acctg/Fin
Admin
Advertg
CEO
CFO
Controller
COO
Design
Engineering
Eng Mgr
Flr Supr
Gen Shop
Invent
IT Staff
IT Mgr
Machine
Race
0
10
4
5
1
1
1
1
19
23
1
7
40
8
8
1
159
1
2
3
4
Gender
1
2
Education Level
12
HS
14
AA
16
BA/BS
Sales Summary (Provided)
Yr
Sales
1999
($527,000)
2000
$1,215,000
2001
($257,000)
2002
$985,000
2003
$1,274,000
2004
$1,578,000
2005
$2,061,000
2006
$1,987,000
2007
$2,057,000
2008
$2,565,000
2009
$2,467,000
2010
$3,846,000
2011
$3,252,000
2012
$4,226,000
2013
$4,844,000
2014
$4,922,000
2015
$3,702,000
9
Mrktg
Purch
Quality
Sales
Sales Mgr
Shipping
Shp Mgr
Sr Flr Mgr
Sr Mach
Sr Sales Mgr
5
5
5
14
1
18
1
3
28
3
372
19
Masters
27
372
7.26%
100.00%
Marital Status
1
Married
2
Single
#
254
118
372
%
68.28%
31.72%
100.00%
#
148
123
101
372
%
39.78%
33.06%
27.15%
100.00%
Region Key
State
Region
PA
Northeast
IL
Midwest
NE
C-Plains
Section 3: Complete Descriptive Statistics
Descriptive Statistics
Mean
Median
Mode
Std Deviation
Variance
Kurtosis
Skewness
Max Min =
Range
Sum
Count
Salary
$53,115
$51,297
$36,918
21711.92675
471407763
4.921273461
1.194918571
$200,210
$15,182
$185,028
$19,758,742
372
Hrly Rate
$26
$25
$18
10.43843
108.9607
4.921273
1.194919
$96
$7
$89
$9,499
372
Yrs of Svc
Ed
Age
7
14
36
6
12
35
16
12
32
4.07921907 2.248127 9.698093
16.6400282 5.054075 94.05301
-0.3933865 -0.2802021 -0.71449
0.7304027 0.9675352 0.310279
16
19
62
0
12
18
15
7
44
2563.14722
5099
13330
372
372
372
Frequency Table by Salary Ranges
Bin
Range/Up
per Limit
20000
30000
40000
50000
60000
70000
80000
90000
100000
110000
120000
130000
140000
150000
160000
170000
180000
190000
200000
210000
Labels
0 – 20
21-30
31-40
41-50
51-60
61-70
71-80
81-90
91-100
101-110
111-120
121-130
131-140
141-150
151-160
161-170
171-180
181-190
191-200
200+
Graph on next Tab
10
Salary
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Confidence Level(95.0%)
Hrly Rate
53114.8978
1125.71096
51296.5
36918
21711.9267
471407763
4.92127346
1.19491857
185028
15182
200210
19758742
372
2213.57417
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Confidence Level(95.0%)
Yrs of Svc
25.53600858
0.541207193
24.66177885
17.74903846
10.43842632
108.960744
4.921273461
1.194918571
88.95576923
7.299038462
96.25480769
9499.395192
372
1.064218353
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Confidence Level(95.0%)
Yrs of Svc
6.8901807
0.21149766
5.73055556
15.7944444
4.07921907
16.6400282
-0.39338654
0.7304027
15.4055556
0.38888889
15.7944444
2563.14722
372
0.41588451
Ed
Age
Mean
13.7069892
Standard Error
0.11655996
Median
12
Mode
12
Standard Deviation
2.248127
Sample Variance
5.05407501
Kurtosis
-0.28020206
Skewness
0.96753517
Range
7
Minimum
12
Maximum
19
Sum
5099
Count
372
Confidence Level(95.0%) 0.22920103
Mean
35.8333333
Standard Error
0.5028227
Median
35
Mode
32
Standard Deviation
9.69809311
Sample Variance
94.0530099
Kurtosis
-0.71449414
Skewness
0.31027907
Range
44
Minimum
18
Maximum
62
Sum
13330
Count
372
Confidence Level(95.0%) 0.98873991
Employee % by Gender
Female
19%
Male
Female
Male
81%
96
Employee % by Education Level
African-Am
Masters, 7%
HS
Masters
NE
BA/BS
C-Plains
IL
BA/BS, 25%
Midwest
PA
AA
Northeast
HS, 58%
AA, 10%
0
Employee % by Marital Status
1 Married
$6,000,000
2 Single
32%
$5,000,000
2 Single
1 Married
68%
$4,000,000
$3,000,000
$2,000,000
$2,000,000
$1,000,000
$0
($1,000,000)
# Employees by Race
227
96
24
African-Am
25
Asian
Caucasian
Hispanic
# of Employees per State
C-Plains
101
Midwest
123
Northeast
148
0
20
40
60
80
100
Sales Summary by Year
120
140
160
20000
30000
40000
50000
60000
70000
80000
90000
100000
110000
120000
130000
140000
150000
160000
170000
180000
190000
200000
More
Frequency
9
38
76
46
75
54
24
38
6
3
1
0
1
0
0
0
0
0
0
1
# of Employees by Salary Range Histogra
80
70
60
Frequency
bin
50
40
30
20
10
0
Salary ($)
ry Range Histogram
Salary
Range by
$10,000
0 – 20
21-30
31-40
41-50
51-60
61-70
71-80
81-90
91-100
101-110
111-120
121-130
131-140
141-150
151-160
161-170
171-180
181-190
191-200
200+
Frequency
9
38
76
46
75
54
24
38
6
3
1
0
1
0
0
0
0
0
0
1
Workforce Profile Analysis
Section 1: Complete all Columns in Data Set
Format for:
Number
Emp #
1059
1265
1515
1350
1285
1269
1400
1411
1071
1257
1265
1308
1616
1654
1770
1822
1128
1774
1248
1289
1387
1525
1620
1626
1636
1687
1744
1750
1101
1105
1276
Date
mm/dd/yy
Hire Date
02/14/12
03/04/13
05/01/00
06/21/12
04/04/11
03/14/07
06/16/05
03/05/09
01/09/05
08/09/09
07/08/11
04/03/10
08/09/06
06/07/11
03/06/04
05/02/07
06/07/10
10/25/13
07/25/09
09/05/11
07/14/09
05/09/05
06/07/13
07/08/12
04/17/09
12/15/05
08/16/06
06/22/10
06/08/02
09/06/12
05/04/11
Text
Role
Acctg/Fin
Acctg/Fin
Acctg/Fin
Admin
Advertg
Design
Design
Design
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Flr Supr
Flr Supr
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Invent
Invent
IT Staff
Currency
Currency
General
Number
Salary
$46,589
$29,632
$66,230
$21,387
$53,064
$76,577
$80,483
$61,333
$86,238
$85,463
$85,825
$75,261
$86,818
$79,709
$86,972
$81,691
$74,104
$68,455
$26,156
$17,943
$26,163
$27,633
$15,248
$19,141
$25,671
$27,541
$28,486
$21,828
$55,994
$32,633
$65,469
Year Ending Vested Yr
12/31/2014
10
Hrly Rate Yrs of Svc
Ed
$22.40
3
16
$14.25
2
16
$31.84
15
16
$10.28
3
12
$25.51
4
16
$36.82
8
16
$38.69
10
16
$29.49
6
16
$41.46
10
19
$41.09
5
19
$41.26
3
19
$36.18
5
16
$41.74
8
19
$38.32
4
16
$41.81
11
16
$39.27
8
16
$35.63
5
16
$32.91
1
16
$12.58
5
12
$8.63
3
12
$12.58
5
12
$13.29
10
12
$7.33
2
12
$9.20
2
14
$12.34
6
12
$13.24
9
14
$13.70
8
12
$10.49
5
14
$26.92
13
16
$15.69
2
12
$31.48
4
16
Number
General
Number
Number
Number
Text
General
Age
33
24
36
23
26
39
46
30
41
38
40
31
48
35
48
36
35
33
25
19
26
30
18
21
24
30
32
22
31
28
32
Vested
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
Race
3
1
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
1
1
3
1
3
4
1
1
3
1
3
3
Gender
2
1
2
2
2
2
1
1
1
1
2
1
1
2
1
1
2
2
1
1
1
1
2
2
1
1
1
1
1
1
1
Status
1
2
2
2
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
1
1
1
2
1
2
1
State
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
Region
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
19
Workforce Profile Analysis
1506
06/27/04
1004
06/13/12
1016
09/23/08
1018
05/03/12
1019
05/21/07
1036
09/25/00
1061
02/02/09
1070
08/21/09
1075
01/14/10
1096
03/06/06
1104
02/01/05
1109
02/22/07
1145
11/05/09
1175
09/25/02
1180
01/24/05
1186
08/14/05
1210
09/10/06
1220
10/16/02
1233
05/31/13
1279
10/20/07
1308
4/30/2000
1339
05/01/12
1391
05/30/09
1393
2/3/2001
1424
01/14/10
1434
01/21/07
1445
08/08/10
1450
01/22/09
1456
06/25/07
1466
03/19/09
1468
7/21/2001
1474
03/25/09
1481
09/06/03
1519
02/15/13
1529
10/16/11
1553
04/12/09
1554
10/20/06
1557
07/21/04
1609
07/20/11
1619
11/3/2007
IT Staff
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
$88,517
$31,924
$42,719
$32,157
$48,317
$57,822
$39,931
$35,498
$34,317
$50,502
$52,450
$49,201
$34,680
$54,886
$52,469
$50,636
$50,133
$54,368
$30,577
$46,057
$58,742
$31,992
$37,084
$57,643
$34,512
$49,797
$33,808
$40,705
$47,522
$39,634
$56,291
$39,331
$54,158
$29,819
$32,797
$38,398
$50,082
$53,537
$33,266
$45,641
$42.56
$15.35
$20.54
$15.46
$23.23
$27.80
$19.20
$17.07
$16.50
$24.28
$25.22
$23.65
$16.67
$26.39
$25.23
$24.34
$24.10
$26.14
$14.70
$22.14
$28.24
$15.38
$17.83
$27.71
$16.59
$23.94
$16.25
$19.57
$22.85
$19.05
$27.06
$18.91
$26.04
$14.34
$15.77
$18.46
$24.08
$25.74
$15.99
$21.94
11
3
6
3
8
14
6
5
5
9
10
8
5
12
10
9
8
12
2
7
15
3
6
14
5
8
4
6
8
6
13
6
11
2
3
6
8
10
3
7
19
12
12
12
12
16
12
12
12
12
12
12
12
14
12
12
12
12
12
12
14
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
43
24
35
24
38
51
34
31
28
42
44
39
29
48
45
43
40
48
21
37
51
24
32
51
29
39
28
34
38
34
50
34
47
19
24
33
40
46
26
36
YES
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
YES
NO
NO
YES
NO
NO
NO
NO
NO
NO
YES
NO
YES
NO
NO
NO
NO
YES
NO
NO
1
3
3
3
3
2
1
3
3
3
3
3
1
3
1
3
3
3
3
1
3
3
3
3
3
2
3
3
1
1
1
3
3
4
3
1
3
3
3
3
1
1
1
2
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
2
1
2
2
2
1
2
1
1
1
1
1
2
1
1
2
1
1
1
2
2
1
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
20
Workforce Profile Analysis
1659
11/02/06
Machine
1744
11/12/2007
Machine
1779
09/07/10
Machine
1782
03/04/04
Machine
1802
5/31/2008
Machine
1809
10/16/2001
Machine
1815
08/17/11
Machine
1816
04/16/09
Machine
1824
04/13/13
Machine
1836
08/12/06
Machine
1379
06/09/07
Mrktg
1295
07/08/12
Purch
1296
09/23/11
Quality
1288
03/25/10
Sales
1422
09/08/13
Sales
1447
09/05/12
Sales
1496
05/07/13
Shipping
1593
08/15/08
Shipping
1612
03/06/11
Shipping
1661
11/18/11
Shipping
1820
08/06/09
Shipping
1088
10/03/11
Sr Flr Mgr
1258
07/09/03
Sr Mach
1320
05/07/11
Sr Mach
1498
08/04/13
Sr Mach
1568
02/07/10
Sr Mach
1749
08/14/00
Sr Mach
1797
02/08/03
Sr Mach
1835
06/07/13
Sr Mach
1356
09/19/10 Sr Sales Mgr
1062
1523
1787
1442
1461
1668
1519
1589
1680
03/04/13
05/21/11
07/21/07
01/08/12
10/12/10
05/01/00
06/04/11
04/15/13
01/06/13
Acctg/Fin
Acctg/Fin
Acctg/Fin
Admin
Advertg
Advertg
Design
Design
Design
$49,925
$45,317
$33,631
$53,903
$43,498
$56,946
$33,244
$37,144
$30,089
$50,199
$81,191
$45,670
$53,487
$70,708
$52,485
$63,836
$31,035
$47,891
$37,800
$34,456
$44,236
$83,974
$70,234
$67,380
$65,283
$67,771
$82,777
$70,084
$65,556
$84,068
$5,091,475
$32,238
$50,767
$66,261
$22,415
$53,215
$65,089
$63,010
$51,233
$51,226
$24.00
$21.79
$16.17
$25.91
$20.91
$27.38
$15.98
$17.86
$14.47
$24.13
$39.03
$21.96
$25.71
$33.99
$25.23
$30.69
$14.92
$23.02
$18.17
$16.57
$21.27
$40.37
$33.77
$32.39
$31.39
$32.58
$39.80
$33.69
$31.52
$40.42
8
7
4
11
7
13
3
6
2
8
8
2
3
5
1
2
2
6
4
3
5
3
11
4
1
5
14
12
2
4
12
12
12
12
12
12
12
12
12
12
16
12
16
16
16
16
12
12
12
12
12
16
12
12
12
12
12
12
12
16
40
36
28
46
35
50
26
33
20
41
36
30
34
41
25
32
19
38
25
23
32
35
46
31
28
32
56
44
29
48
NO
NO
NO
YES
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
YES
NO
NO
1
3
3
1
4
1
3
3
1
1
1
3
3
1
3
3
1
1
2
1
3
1
3
1
4
1
1
2
4
3
1
1
1
1
1
1
1
1
2
1
1
2
1
1
1
1
1
2
1
2
1
2
1
1
2
1
1
1
1
2
2
1
1
1
1
1
1
1
2
1
1
1
1
2
1
1
2
1
1
2
1
1
1
2
1
2
2
1
1
1
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
NE
$15.50
$24.41
$31.86
$10.78
$25.58
$31.29
$30.29
$24.63
$24.63
2
4
7
3
4
15
4
2
2
16
16
16
12
16
16
16
16
16
28
35
45
25
28
35
33
25
24
NO
NO
NO
NO
NO
YES
NO
NO
NO
3
2
3
1
3
3
3
3
1
1
1
1
2
1
1
1
2
1
2
2
1
2
2
1
2
2
2
IL
IL
IL
IL
IL
IL
IL
IL
IL
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains
C-Plains Total
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
21
Workforce Profile Analysis
1776
11/13/09
1793
03/15/99
1069
02/03/11
1071
08/08/05
1188
05/16/09
1517
11/12/12
1554
10/23/13
1623
03/04/12
1785
07/06/06
1846
03/05/13
1597
11/20/11
1608
03/15/99
1043
06/18/09
1108
06/15/07
1141
06/18/09
1145
02/16/09
1226
06/02/07
1320
06/18/09
1343
04/15/10
1405
08/13/07
1507
04/15/14
1539
12/15/12
1785
09/21/09
1227
05/03/00
1296
09/15/10
1850
08/05/07
1014
06/03/09
1308
06/30/01
1550
02/19/14
1006
08/05/06
1024
08/17/11
1053
09/08/09
1055
9/30/2001
1056
05/06/07
1083
4/30/2000
1106
5/9/2002
1116
12/30/08
1117
08/15/12
1136
12/14/11
1140
07/10/09
Design
Design
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Flr Supr
Flr Supr
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Invent
Invent
Invent
IT Staff
IT Staff
IT Staff
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
$61,441
$81,077
$79,938
$87,019
$83,198
$62,572
$62,458
$64,153
$86,972
$60,324
$70,293
$75,375
$26,168
$27,403
$25,999
$25,131
$27,435
$26,351
$21,897
$28,537
$15,182
$18,102
$26,096
$65,234
$52,765
$58,068
$87,818
$88,698
$55,067
$50,307
$33,005
$35,293
$57,385
$48,059
$58,771
$55,744
$42,235
$31,262
$32,523
$35,934
$29.54
$38.98
$38.43
$41.84
$40.00
$30.08
$30.03
$30.84
$41.81
$29.00
$33.79
$36.24
$12.58
$13.17
$12.50
$12.08
$13.19
$12.67
$10.53
$13.72
$7.30
$8.70
$12.55
$31.36
$25.37
$27.92
$42.22
$42.64
$26.47
$24.19
$15.87
$16.97
$27.59
$23.11
$28.26
$26.80
$20.31
$15.03
$15.64
$17.28
5
16
4
9
6
2
1
3
8
2
3
16
6
8
6
6
8
6
5
7
1
2
5
15
4
7
6
14
1
8
3
5
13
8
15
13
6
2
3
5
16
19
16
19
19
16
16
16
16
16
16
16
12
12
12
12
12
14
12
14
12
14
14
14
12
12
16
19
16
14
12
12
16
12
14
12
12
12
12
12
30
54
35
51
38
26
26
28
50
24
34
44
27
29
24
24
29
27
22
34
18
21
25
45
29
30
40
43
28
41
26
30
50
38
52
48
34
22
24
32
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
YES
YES
NO
NO
NO
NO
3
1
2
3
3
1
2
2
3
3
3
3
3
3
3
2
1
4
1
3
1
3
4
3
4
3
4
2
1
3
3
1
1
3
3
1
3
2
1
2
2
1
2
1
1
2
2
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
2
2
1
1
1
1
1
1
2
1
2
1
2
2
1
2
2
2
1
1
1
1
1
2
1
1
1
1
1
1
1
1
2
2
1
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
22
Workforce Profile Analysis
1145
09/15/04
1150
04/26/13
1156
05/21/11
1190
5/9/2002
1190
8/31/1999
1196
09/08/09
1201
08/01/08
1237
08/08/07
1261
04/13/13
1267
2/5/2008
1289
10/22/06
1314
1/22/2008
1315
02/15/07
1323
02/05/05
1343
12/18/07
1364
04/20/05
1387
12/18/07
1387
07/23/05
1394
04/30/00
1402
08/17/11
1422
05/30/09
1426
10/20/07
1452
11/06/06
1492
10/25/2001
1498
02/22/11
1505
12/06/10
1543
10/06/09
1565
03/16/07
1575
02/04/09
1579
01/12/05
1591
7/12/2008
1638
09/01/07
1671
06/13/12
1687
06/02/04
1709
09/20/05
1736
04/01/09
1741
03/30/09
1750
08/13/09
1760
09/15/12
1764
6/17/2001
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
$53,327
$30,808
$33,395
$55,716
$59,147
$35,327
$43,003
$46,904
$30,165
$44,747
$50,078
$44,765
$49,672
$52,235
$44,860
$51,431
$45,130
$50,914
$58,640
$32,812
$36,918
$45,934
$49,838
$55,936
$33,574
$33,609
$35,002
$48,712
$40,629
$52,580
$43,213
$46,787
$31,809
$53,784
$50,522
$39,130
$39,191
$35,536
$31,049
$57,530
$25.64
$14.81
$16.06
$26.79
$28.44
$16.98
$20.67
$22.55
$14.50
$21.51
$24.08
$21.52
$23.88
$25.11
$21.57
$24.73
$21.70
$24.48
$28.19
$15.78
$17.75
$22.08
$23.96
$26.89
$16.14
$16.16
$16.83
$23.42
$19.53
$25.28
$20.78
$22.49
$15.29
$25.86
$24.29
$18.81
$18.84
$17.08
$14.93
$27.66
10
2
4
13
15
5
6
7
2
7
8
7
8
10
7
10
7
9
15
3
6
7
8
13
4
4
5
8
6
10
6
7
3
11
9
6
6
5
2
14
12
12
12
12
14
12
12
12
12
12
12
12
12
12
12
12
12
12
16
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
45
21
26
48
53
30
35
38
20
35
40
35
39
44
36
44
36
43
51
26
32
37
39
49
27
28
30
38
34
45
35
38
23
46
43
33
34
31
22
50
YES
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
YES
3
1
3
1
1
3
3
1
3
2
1
1
3
4
1
1
1
3
1
4
1
3
3
1
1
1
3
3
3
1
3
3
3
3
1
3
3
1
3
3
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
2
1
1
1
1
2
1
2
2
1
1
1
1
1
1
2
1
1
2
1
1
1
1
2
1
1
1
2
1
1
2
2
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
23
Workforce Profile Analysis
1767
05/20/05
1779
06/01/05
1813
01/15/03
1819
10/06/09
1830
1/15/2000
1840
2/16/2000
1444
06/15/02
1673
03/07/13
1476
05/23/11
1625
09/12/09
1418
07/04/11
1569
04/23/10
1381
10/23/10
1403
12/01/10
1444
08/02/11
1466
05/04/12
1661
03/18/13
1048
09/19/13
1232
07/12/10
1568
08/07/12
1629
09/04/11
1630
09/12/08
1793
09/07/07
1672
05/04/08
1003
09/07/12
1153
02/05/12
1220
04/15/00
1246
07/27/00
1261
06/02/09
1297
06/06/05
1429
06/30/10
1541
04/09/07
1550
11/14/08
1793
09/08/08
1018
1202
1280
1679
1448
01/15/11
03/15/99
08/11/14
05/18/09
05/03/11
Machine
Machine
Machine
Machine
Machine
Machine
Mrktg
Mrktg
Purch
Purch
Quality
Quality
Sales
Sales
Sales
Sales
Sales
Shipping
Shipping
Shipping
Shipping
Shipping
Shipping
Sr Flr Mgr
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Sales Mgr
Acctg/Fin
Acctg/Fin
Acctg/Fin
Acctg/Fin
Admin
$51,360
$51,084
$53,922
$34,804
$58,928
$58,792
$81,221
$67,415
$48,560
$60,346
$53,981
$55,254
$72,181
$71,265
$64,415
$64,329
$52,300
$31,655
$37,456
$32,960
$35,550
$47,650
$50,788
$96,546
$66,750
$66,843
$83,377
$82,315
$68,014
$69,628
$67,692
$69,128
$68,317
$90,822
$6,326,750
$42,836
$85,123
$29,442
$66,109
$25,456
$24.69
$24.56
$25.92
$16.73
$28.33
$28.27
$39.05
$32.41
$23.35
$29.01
$25.95
$26.56
$34.70
$34.26
$30.97
$30.93
$25.14
$15.22
$18.01
$15.85
$17.09
$22.91
$24.42
$46.42
$32.09
$32.14
$40.09
$39.57
$32.70
$33.48
$32.54
$33.23
$32.84
$43.66
10
10
12
5
15
15
13
2
4
5
3
5
4
4
3
3
2
1
4
2
3
6
7
7
2
3
15
14
6
10
5
8
6
6
12
12
12
12
14
12
16
16
14
16
16
16
16
16
16
16
16
12
12
12
12
12
14
12
12
12
14
12
12
12
12
12
12
19
44
43
47
30
52
52
42
35
32
31
36
42
52
42
34
33
28
20
28
20
24
36
40
38
29
30
55
54
33
41
32
36
33
50
NO
NO
YES
NO
YES
YES
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
3
3
1
2
3
3
3
3
3
3
3
3
3
3
3
3
3
1
3
3
1
3
3
3
1
3
1
3
1
3
1
3
3
3
1
1
1
1
1
1
2
2
2
1
1
2
1
2
1
1
2
2
1
2
1
1
2
1
1
1
2
2
2
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
2
1
1
1
2
1
2
1
2
1
1
1
1
1
1
1
1
2
2
1
1
1
2
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
IL
$20.59
$40.92
$14.15
$31.78
$12.24
4
16
0
6
4
16
16
16
16
14
32
48
22
39
31
NO
YES
NO
NO
NO
3
3
3
3
4
2
1
2
1
1
2
1
1
1
2
PA
PA
PA
PA
PA
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest
Midwest Total
Northeast
Northeast
Northeast
Northeast
Northeast
24
Workforce Profile Analysis
1658
03/22/10
1357
03/15/99
1616
09/15/09
1001
03/15/99
1596
06/12/09
1055
06/15/01
1357
04/08/05
1002
12/15/99
1218
07/23/09
1432
10/15/09
1531
04/07/13
1640
08/13/07
1669
09/05/11
1726
03/15/99
1760
02/04/11
1841
06/07/07
1846
04/23/09
1848
12/15/09
1744
06/15/11
1098
01/13/14
1215
05/06/07
1224
09/23/13
1300
07/10/09
1667
01/15/08
1693
03/15/99
1794
01/14/14
1062
07/08/09
1424
03/15/99
1733
09/18/13
1117
05/27/09
1138
10/18/10
1198
09/17/10
1255
03/14/09
1296
05/05/00
1329
09/20/09
1341
03/07/04
1404
10/15/11
1446
12/15/05
1447
10/18/10
1556
03/21/09
Admin
Advertg
Advertg
CEO
CFO
Controller
COO
Design
Design
Design
Design
Design
Design
Design
Design
Design
Design
Design
Eng Mgr
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Flr Supr
Flr Supr
Flr Supr
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
$32,300
$99,741
$65,027
$200,210
$131,276
$99,836
$105,779
$79,723
$64,504
$71,204
$62,412
$77,045
$61,882
$81,159
$60,348
$79,865
$80,113
$80,722
$110,233
$62,245
$86,673
$70,886
$80,637
$86,096
$93,678
$60,323
$72,803
$75,737
$65,780
$26,360
$24,017
$23,484
$26,621
$28,901
$26,020
$28,325
$18,097
$27,574
$23,971
$26,466
$15.53
$47.95
$31.26
$96.25
$63.11
$48.00
$50.86
$38.33
$31.01
$34.23
$30.01
$37.04
$29.75
$39.02
$29.01
$38.40
$38.52
$38.81
$53.00
$29.93
$41.67
$34.08
$38.77
$41.39
$45.04
$29.00
$35.00
$36.41
$31.63
$12.67
$11.55
$11.29
$12.80
$13.89
$12.51
$13.62
$8.70
$13.26
$11.52
$12.72
5
16
5
16
6
14
10
15
5
5
2
7
3
16
4
8
6
5
4
1
8
1
5
7
16
1
5
16
1
6
4
4
6
15
5
11
3
9
4
6
16
16
16
19
19
19
19
16
16
16
16
16
16
19
16
16
19
19
19
16
19
16
16
16
19
16
14
14
16
12
12
12
12
14
14
14
14
14
12
12
33
52
34
56
42
45
39
45
34
38
32
42
32
56
28
45
46
52
45
25
43
30
36
40
54
24
35
45
32
27
24
22
27
36
25
32
19
30
23
27
NO
YES
NO
YES
NO
YES
NO
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
NO
NO
YES
NO
YES
NO
NO
NO
NO
1
3
3
3
3
3
3
3
1
3
3
3
3
3
2
2
3
3
3
3
2
2
3
3
3
3
3
3
1
3
4
1
3
3
1
3
3
4
1
4
2
1
2
1
1
2
1
1
1
1
1
1
2
1
1
1
2
1
1
1
1
1
2
1
1
1
1
2
2
2
2
1
1
1
1
1
1
1
1
1
2
1
2
2
2
1
2
2
2
1
2
1
1
1
2
2
2
1
1
2
1
1
1
1
1
2
1
1
1
1
1
1
2
1
1
1
2
2
2
2
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
25
Workforce Profile Analysis
1560
05/06/12
1580
09/16/10
1644
09/05/11
1723
06/02/12
1736
09/18/07
1812
04/06/05
1848
06/05/04
1850
11/20/10
1015
07/08/13
1079
10/15/03
1737
03/15/99
1272
09/18/10
1038
08/21/12
1049
02/23/04
1102
04/08/00
1005
10/25/08
1053
05/31/13
1055
06/04/01
1083
08/27/09
1097
08/14/05
1113
05/02/12
1130
03/15/99
1132
07/10/09
1138
4/12/2008
1142
06/17/09
1167
11/15/11
1169
01/22/09
1185
04/16/09
1227
04/25/06
1254
02/02/09
1257
03/11/10
1292
05/13/01
1300
06/17/09
1320
09/01/12
1364
3/16/2008
1373
04/08/09
1373
06/25/07
1378
07/09/10
1471
07/10/09
1504
03/14/05
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Gen Shop
Invent
Invent
Invent
IT Mgr
IT Staff
IT Staff
IT Staff
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
$18,270
$23,342
$17,598
$19,397
$27,221
$27,781
$28,344
$24,060
$31,250
$51,459
$76,188
$100,515
$65,451
$88,421
$88,900
$42,687
$30,241
$56,663
$35,396
$50,571
$32,124
$59,438
$35,822
$44,204
$36,901
$32,766
$40,871
$37,914
$50,320
$39,755
$34,232
$56,815
$36,882
$31,170
$44,576
$38,873
$47,648
$33,968
$36,729
$52,104
$8.78
$11.22
$8.46
$9.33
$13.09
$13.36
$13.63
$11.57
$15.02
$24.74
$36.63
$48.32
$31.47
$42.51
$42.74
$20.52
$14.54
$27.24
$17.02
$24.31
$15.44
$28.58
$17.22
$21.25
$17.74
$15.75
$19.65
$18.23
$24.19
$19.11
$16.46
$27.31
$17.73
$14.99
$21.43
$18.69
$22.91
$16.33
$17.66
$25.05
3
4
3
3
7
10
11
4
1
11
16
4
2
11
15
6
2
14
5
9
3
16
5
7
6
3
6
6
9
6
5
14
6
2
7
6
8
4
5
10
14
12
12
14
12
12
12
12
14
16
16
19
16
19
19
14
12
16
12
12
12
16
12
12
12
12
12
12
12
12
12
14
12
12
12
12
12
12
12
12
21
22
19
21
28
30
32
24
26
31
52
52
32
41
48
35
20
50
31
43
24
53
32
35
32
24
34
33
41
34
28
50
32
22
35
33
38
28
32
44
NO
NO
NO
NO
NO
NO
YES
NO
NO
YES
YES
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
3
3
3
3
3
1
3
3
3
3
3
3
2
3
3
3
3
3
3
1
1
3
3
4
1
3
3
1
3
2
3
3
3
4
3
4
3
3
3
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
2
2
2
2
2
1
1
2
2
1
1
1
1
1
1
1
2
1
2
1
2
1
1
1
1
1
1
1
2
1
2
1
2
2
1
1
1
1
1
1
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
26
Workforce Profile Analysis
1513
08/14/03
1527
03/15/99
1533
12/28/07
1552
5/30/1999
1553
10/20/07
1558
01/06/05
1571
04/16/09
1584
03/15/99
1588
8/17/2002
1598
02/15/13
1611
09/23/07
1613
05/04/12
1639
07/30/12
1660
01/14/10
1667
03/14/05
1668
07/10/09
1723
11/10/2007
1745
06/10/10
1756
05/13/01
1757
2/16/2002
1771
03/14/05
1776
03/15/99
1789
09/23/08
1800
05/14/09
1800
03/15/99
1821
09/13/06
1829
03/01/07
1846
08/30/04
1748
08/25/10
1803
09/30/00
1477
03/15/03
1773
06/07/05
1116
04/05/00
1804
08/19/09
1084
03/15/99
1133
02/12/09
1189
02/12/10
1424
02/15/13
1608
04/15/09
1637
06/07/11
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Machine
Mrktg
Mrktg
Purch
Purch
Quality
Quality
Sales
Sales
Sales
Sales
Sales
Sales
$54,358
$59,872
$45,283
$59,316
$46,097
$52,946
$37,917
$60,239
$55,566
$29,661
$46,378
$32,496
$31,567
$34,420
$51,554
$35,688
$45,495
$34,196
$56,888
$55,840
$51,899
$60,198
$42,802
$36,918
$59,647
$50,130
$48,826
$53,369
$68,352
$81,282
$63,388
$60,999
$81,526
$64,510
$85,671
$73,337
$70,520
$55,460
$73,258
$64,494
$26.13
$28.78
$21.77
$28.52
$22.16
$25.45
$18.23
$28.96
$26.71
$14.26
$22.30
$15.62
$15.18
$16.55
$24.79
$17.16
$21.87
$16.44
$27.35
$26.85
$24.95
$28.94
$20.58
$17.75
$28.68
$24.10
$23.47
$25.66
$32.86
$39.08
$30.48
$29.33
$39.20
$31.01
$41.19
$35.26
$33.90
$26.66
$35.22
$31.01
11
16
7
16
7
10
6
16
12
2
7
3
2
5
10
5
7
5
14
13
10
16
6
6
16
8
8
10
4
14
12
10
15
5
16
6
5
2
6
4
12
12
12
14
12
12
12
16
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
14
12
12
12
16
16
16
16
16
16
19
19
16
16
19
16
47
54
36
53
38
45
33
54
48
19
38
24
23
28
44
32
36
28
50
49
44
54
35
32
54
40
39
46
35
45
44
42
52
46
62
58
40
32
53
37
YES
YES
NO
YES
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
YES
NO
YES
NO
NO
YES
NO
NO
YES
NO
YES
YES
NO
YES
NO
YES
NO
NO
NO
NO
NO
3
3
3
3
3
2
4
1
2
3
3
1
1
1
3
4
1
4
3
3
3
3
3
1
3
3
1
2
3
3
3
3
3
1
3
4
2
1
3
4
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
2
1
1
2
1
1
2
2
1
1
1
1
1
1
1
1
2
2
1
2
1
1
2
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
2
1
1
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
27
Workforce Profile Analysis
1796
03/14/10
1216
07/12/06
1332
04/12/11
1477
01/15/12
1484
03/04/09
1504
04/30/10
1622
02/06/12
1785
02/08/10
1299
04/08/09
1756
07/01/09
1113
09/08/00
1315
02/07/08
1317
08/12/08
1325
03/15/99
1346
06/12/10
1417
04/15/07
1424
03/15/99
1443
09/12/06
1456
05/07/04
1754
05/06/03
1831
08/16/12
1841
08/05/13
1814
08/19/11
Sales Mgr
Shipping
Shipping
Shipping
Shipping
Shipping
Shipping
Shipping
Shp Mgr
Sr Flr Mgr
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Mach
Sr Sales Mgr
$101,275
$52,654
$36,789
$33,169
$45,622
$38,455
$33,047
$42,456
$85,286
$93,478
$81,695
$68,913
$68,677
$83,413
$67,679
$69,102
$84,505
$69,372
$69,997
$70,507
$65,938
$65,117
$87,102
$8,340,517
$19,758,742
$48.69
$25.31
$17.69
$15.95
$21.93
$18.49
$15.89
$20.41
$41.00
$44.94
$39.28
$33.13
$33.02
$40.10
$32.54
$33.22
$40.63
$33.35
$33.65
$33.90
$31.70
$31.31
$41.88
5
8
4
3
6
5
3
5
6
6
14
7
6
16
5
8
16
8
11
12
2
1
3
19
14
12
12
14
12
12
12
16
16
14
12
12
14
12
12
14
12
12
12
12
12
16
43
40
24
23
35
28
21
32
47
42
50
34
35
57
31
34
59
40
41
48
29
28
53
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
YES
NO
NO
YES
NO
YES
YES
NO
NO
NO
State
PA
IL
NE
Region
Northeast
Midwest
C-Plains
#
148
123
101
372
%
39.78%
33.06%
27.15%
100.00%
3
1
3
1
1
3
3
3
1
3
1
4
3
3
3
4
3
3
1
1
1
3
1
1
1
1
1
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
2
2
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast
Northeast Total
Company Grand Total
Section 2: Complete Summary Tables for Graphing
Section 3: Complete Descriptive Statistics
28
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Dissertation Writing Service Works
First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download