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 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 Text Role CEO Design Sr Mach Machine Machine Machine IT Staf Invent Machine Acctg/Fin Machine Machine Machine Machine IT Staf Gen Shop Shipping IT Staf Machine Machine Controller Machine Machine Machine Acctg/Fin Format cells in column according to indicated format. Currency Currency Number Text 2080 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 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 Number Number Number Number Number Text 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 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 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 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 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 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 1061 1062 1062 1069 1070 1071 1071 1075 1079 1083 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 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 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 Machine Acctg/Fin Flr Supr Engineering Machine Engineering Engineering Machine Invent Machine Machine Sales Sr Flr Mgr Machine Machine Engineering Invent IT Staf Machine Invent Machine Gen Shop Machine Machine Sr Mach Machine Quality Gen Shop Machine Flr Supr Machine Machine Sales Machine Gen Shop Machine $39,931 $32,238 $72,803 $79,938 $35,498 $86,238 $87,019 $34,317 $51,459 $35,396 $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 $19.20 $15.50 $35.00 $38.43 $17.07 $41.46 $41.84 $16.50 $24.74 $17.02 $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 6 2 5 4 5 10 9 5 11 5 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 12 16 14 16 12 19 19 12 16 12 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 34 28 35 35 31 41 51 28 31 31 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 No No No No No No No No Yes No 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 1 3 3 2 3 3 3 3 3 3 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 1 1 1 2 1 1 1 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 2 1 1 1 1 1 1 1 2 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 NE IL PA IL NE NE IL NE PA PA 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 1140 1141 1142 1145 1145 1145 1150 1153 1156 1167 1169 1175 1180 1185 1186 1188 1189 1190 1190 1196 1198 1201 1202 1210 1215 1216 1218 1220 1220 1224 1226 1227 1227 1232 1233 1237 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 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 Machine Gen Shop Machine Gen Shop Machine Machine Machine Sr Mach Machine Machine Machine Machine Machine Machine Machine Engineering Sales Machine Machine Machine Gen Shop Machine Acctg/Fin Machine Engineering Shipping Design Machine Sr Mach Engineering Gen Shop Invent Machine Shipping Machine Machine $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 $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 $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 $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 5 6 6 6 5 10 2 3 4 3 6 12 10 6 9 6 5 13 15 5 4 6 16 8 8 8 5 12 15 1 8 15 9 4 2 7 12 12 12 12 12 12 12 12 12 12 12 14 12 12 12 19 16 12 14 12 12 12 16 12 19 14 16 12 14 16 12 14 12 12 12 12 32 24 32 24 29 45 21 30 26 24 34 48 45 33 43 38 40 48 53 30 22 35 48 40 43 40 34 48 55 30 29 45 41 28 21 38 No No No No No Yes No No No No No Yes No No No No No Yes Yes No No No Yes No No No No Yes Yes No No Yes No No No No 2 3 1 2 1 3 1 3 3 3 3 3 1 1 3 3 2 1 1 3 1 3 3 3 2 1 1 3 1 2 1 3 3 3 3 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 2 1 1 1 1 1 1 1 1 1 1 2 2 1 2 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 2 1 2 1 IL IL PA IL NE IL IL IL IL PA PA NE NE PA NE IL PA IL IL IL PA IL PA NE PA PA PA NE IL PA IL IL PA IL NE IL 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 1300 1300 1308 1308 1308 1314 1315 1315 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 07/10/09 06/17/09 04/03/10 06/30/01 4/30/2000 1/22/2008 02/15/07 02/07/08 Sr Mach Gen Shop Machine Gen Shop Engineering Machine Sr Mach Machine Sr Mach Acctg/Fin Engineering Machine Design IT Mgr IT Staf Machine Acctg/Fin Advertg Sales Gen Shop Machine Machine Purch Gen Shop Invent Quality Sr Mach Shp Mgr Engineering Machine Engineering IT Staf Machine Machine Machine Sr Mach $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 $80,637 $36,882 $75,261 $88,698 $58,742 $44,765 $49,672 $68,913 $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 $38.77 $17.73 $36.18 $42.64 $28.24 $21.52 $23.88 $33.13 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 5 6 5 14 15 7 8 7 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 16 12 16 19 14 12 12 12 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 36 32 31 43 51 35 39 34 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 No No No Yes Yes No No No 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 3 3 3 2 3 1 3 4 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 2 1 1 2 1 1 1 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 1 2 1 1 2 1 1 1 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 PA PA NE IL NE IL IL PA 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 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 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 $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 $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 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 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 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 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 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 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 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 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 1417 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 04/15/07 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 Sr Mach 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 $69,102 $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 $33.22 $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 8 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 12 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 34 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 No 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 4 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 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 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 PA 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 1492 1496 1498 1498 1504 1504 1505 1506 1507 1513 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 10/25/2001 Machine 05/07/13 Shipping 02/22/11 Machine 08/04/13 Sr Mach 03/14/05 Machine 04/30/10 Shipping 12/06/10 Machine 06/27/04 IT Staf 04/15/14 Gen Shop 08/14/03 Machine 05/01/00 Acctg/Fin 11/12/12 Engineering 06/04/11 Design 02/15/13 Machine 05/21/11 Acctg/Fin 05/09/05 Gen Shop 03/15/99 Machine 10/16/11 Machine 04/07/13 Design 12/28/07 Machine 12/15/12 Gen Shop 04/09/07 Sr Mach 10/06/09 Machine 02/19/14 IT Staf 11/14/08 Sr Mach 5/30/1999 Machine 04/12/09 Machine 10/20/07 Machine 10/23/13 Engineering 10/20/06 Machine 03/21/09 Gen Shop 07/21/04 Machine 01/06/05 Machine 05/06/12 Gen Shop 03/16/07 Machine 08/07/12 Shipping $55,936 $31,035 $33,574 $65,283 $52,104 $38,455 $33,609 $88,517 $15,182 $54,358 $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 $26.89 $14.92 $16.14 $31.39 $25.05 $18.49 $16.16 $42.56 $7.30 $26.13 $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 13 2 4 1 10 5 4 11 1 11 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 12 12 12 12 12 12 12 19 12 12 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 49 19 27 28 44 28 28 43 18 47 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 Yes No No No No No No Yes No Yes 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 1 1 1 4 1 3 1 1 1 3 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 1 1 2 1 2 2 1 1 1 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 2 2 1 1 1 1 1 1 2 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 IL NE IL NE PA PA IL NE IL PA 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 1568 1569 1571 1575 1579 1580 1584 1588 1589 1591 1593 1596 1597 1598 1608 1608 1609 1611 1612 1613 1616 1616 1619 1620 1622 1623 1625 1626 1629 1630 1636 1637 1638 1639 1640 1644 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 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 Sr Mach Quality Machine Machine Machine Gen Shop Machine Machine Design Machine Shipping CFO Flr Supr Machine Flr Supr Sales Machine Machine Shipping Machine Advertg Engineering Machine Gen Shop Shipping Engineering Purch Gen Shop Shipping Shipping Gen Shop Sales Machine Machine Design Gen Shop $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 $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 $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.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 5 5 6 6 10 4 16 12 2 6 6 6 3 2 16 6 3 7 4 3 5 8 7 2 3 3 5 2 3 6 6 4 7 2 7 3 12 16 12 12 12 12 16 12 16 12 12 19 16 12 16 19 12 12 12 12 16 19 12 12 12 16 16 14 12 12 12 16 12 12 16 12 32 42 33 34 45 22 54 48 25 35 38 42 34 19 44 53 26 38 25 24 34 48 36 18 21 28 31 21 24 36 24 37 38 23 42 19 No No No No No No Yes Yes No No No No No No Yes No No No No No No No No No No No No No No No No No No No No No 1 3 4 3 1 3 1 2 3 3 1 3 3 3 3 3 3 3 2 1 3 3 3 1 3 2 3 3 1 3 4 4 3 1 3 3 1 2 1 1 1 1 1 1 2 1 2 1 1 1 2 1 1 1 1 1 2 1 1 2 2 1 1 2 1 1 1 1 1 1 1 1 2 2 2 1 1 2 2 1 2 1 1 2 1 2 1 1 2 1 1 1 2 1 1 2 2 1 1 2 1 1 1 1 2 2 1 2 NE IL PA IL IL PA PA PA IL IL NE PA IL PA IL PA NE PA NE PA PA NE NE NE PA IL IL NE IL IL NE PA IL PA PA PA 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 1744 1744 1744 1745 1748 1749 1750 1750 06/07/11 Engineering 03/22/10 Admin 11/02/06 Machine 01/14/10 Machine 03/18/13 Sales 11/18/11 Shipping 01/15/08 Engineering 03/14/05 Machine 05/01/00 Advertg 07/10/09 Machine 09/05/11 Design 06/13/12 Machine 05/04/08 Sr Flr Mgr 03/07/13 Mrktg 05/18/09 Acctg/Fin 01/06/13 Design 12/15/05 Gen Shop 06/02/04 Machine 03/15/99 Engineering 09/20/05 Machine 06/02/12 Gen Shop 11/10/2007 Machine 03/15/99 Design 09/18/13 Flr Supr 09/18/07 Gen Shop 04/01/09 Machine 03/15/99 Invent 03/30/09 Machine 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 $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 $110,233 $28,486 $45,317 $34,196 $68,352 $82,777 $21,828 $35,536 $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 $53.00 $13.70 $21.79 $16.44 $32.86 $39.80 $10.49 $17.08 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 4 8 7 5 4 14 5 5 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 19 12 12 12 16 12 14 12 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 45 32 36 28 35 56 22 31 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 No No No No No Yes No No 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 3 1 3 4 3 1 3 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 1 1 1 2 1 1 1 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 1 1 1 1 1 2 2 1 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 PA NE NE PA PA NE NE IL 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 05/06/03 05/13/01 07/01/09 2/16/2002 02/04/11 09/15/12 6/17/2001 05/20/05 03/06/04 03/14/05 06/07/05 10/25/13 11/13/09 03/15/99 09/07/10 06/01/05 03/04/04 07/06/06 09/21/09 02/08/10 07/21/07 09/23/08 03/15/99 09/07/07 09/08/08 01/14/14 03/14/10 02/08/03 05/14/09 03/15/99 5/31/2008 09/30/00 08/19/09 10/16/2001 04/06/05 01/15/03 Sr Mach Machine Sr Flr Mgr Machine Design Machine Machine Machine Engineering Machine Purch Flr Supr Design Machine Machine Machine Machine Engineering Gen Shop Shipping Acctg/Fin Machine Design Shipping Sr Sales Mgr Engineering Sales Mgr Sr Mach Machine Machine Machine Mrktg Quality Machine Gen Shop Machine $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 $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 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 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 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 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 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 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 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 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 1814 1815 1816 1819 1820 1821 1822 1824 1829 1830 1831 1835 1836 1840 1841 1841 1846 1846 1846 1848 1848 1850 1850 08/19/11 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 Sr Sales Mgr 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 $87,102 $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 $41.88 $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 3 6 5 5 8 8 2 8 15 2 2 8 15 8 1 6 2 10 5 11 4 7 16 12 12 12 12 12 16 12 12 14 12 12 12 12 16 12 19 16 12 19 12 12 12 53 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 No Yes No No No Yes No No No No Yes No Yes No No 1 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 1 2 1 1 2 1 1 1 1 1 2 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 1 2 1 2 1 1 1 1 2 1 Section 2: Complete Summary Tables for Graphing Roles Key Emp Acctg/Fin Admin Advertg CEO CFO Race 0 10 4 5 1 1 1 2 3 4 African-Am Asian Caucasian Hispanic # 96 24 227 25 372 % 26% 6% 61% 7% 100% 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 PA NE NE IL NE PA NE NE PA IL PA NE NE IL PA PA PA IL PA PA PA PA IL Controller COO Design Engineering Eng Mgr Flr Supr Gen Shop Invent IT Staf IT Mgr Machine Mrktg Purch Quality Sales Sales Mgr Shipping Shp Mgr Sr Flr Mgr Sr Mach Sr Sales Mgr 1 1 19 23 1 7 40 8 8 1 159 5 5 5 14 1 18 1 3 28 3 372 Gender 1 2 # 300 72 372 % 81% 19% 100% Education Level 12 HS 14 AA 16 BA/BS 19 Masters # 215 37 93 27 372 % 58% 10% 25% 7% 100% Marital Status 1 Married 2 Single # 254 118 372 % 68% 32% 100% # 148 123 101 372 % 40% 33% 27% 100% Male Female Region Key State Region PA Northeast IL Midwest NE C-Plains 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 $2,061,000 $1,987,000 $2,057,000 $2,565,000 $2,467,000 $3,846,000 $3,252,000 $4,226,000 $4,844,000 $4,922,000 $3,702,000 Section 3: Complete Descriptive Statistics Descriptive Statistics Mean Median Mode Salary $53,115 $51,297 $36,918 Hrly Rate $26 $25 $18 Yrs of Svc 7 6 16 Ed 14 12 12 Age Frequency Table by Salary Ranges 36 35 32 Bin Range/Up per Limit 20000 30000 Labels Up to 20Graph on next Tab 21-30 Std Deviation Variance Kurtosis Skewness Max Min = Range Sum Count $21,712 $10 4 2 10 $470,140,538 $109 17 5 94 4.9212734614 4.9212735 -0.39338654 -0.2802021 -0.714494 1.1949185713 1.1949186 0.7304027 0.96753517 0.310279 $200,210 $96 16 19 62 $15,182 $7 0 12 18 $185,028 $89 15 7 44 $19,758,742 $9,499 2563 5099 13330 372 372 372 372 372 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 150000 160000 170000 180000 190000 200000 210000 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+ Text 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 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 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 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 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 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 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 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 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 next Tab Quantitative Reasoning in Action Now that you have completed your analysis, think about the patterns you've seen in the workforce. Write a short 3-4 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 (I call this, never simply providing a \"raw data\" dump - strive to provide information!). The paper sections include - one paragraph narrative summary of your findings; describing patterns of interest - explanation of their potential relevance of such patterns - describe how you will further investigate to determine if your results are \"good or bad\" for the company Prepare your response in this workbook. Place it at the front on completion. Gender Ed Female; 19% Ma BA/BS; 25% Male; 81% AA; 10 Marital Status 250 Single; 32% 200 150 Married; 68% 100 96 50 Number of Employees by State 160 148 140 123 120 101 100 80 60 40 20 0 PA IL NE 0 N 80 60 40 20 0 PA IL Sales Summary $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 ($1,000,000) Sales Summary NE Education Masters; 7% BA/BS; 25% HS; 58% AA; 10% 250 227 200 150 100 50 96 24 0 Number of employees by Race 25