Workbook and Analysis
iikotu
untitled.pdf
Workforce Profile Analysis Section 1: Complete all Columns in Data Set Format for:
Number Date Text Currency Currency Number Text Number Number Number Number Number Text Text mm/dd/yy Year Ending Vested Yr 12/31/14 10
Emp # Hire Date Role Salary Hrly Rate Yrs of Svc Ed Age Vested Race Gender Status State Region 1001 03/15/99 CEO $200,210 19 56 3 1 2 PA 1002 12/15/99 Design $79,723 16 45 3 1 2 PA 1003 09/07/12 Sr Mach $66,750 12 29 1 1 1 IL 1004 06/13/12 Machine $31,924 12 24 3 1 2 NE 1005 10/25/08 Machine $42,687 14 35 3 1 1 PA 1006 08/05/06 Machine $50,307 14 41 3 1 1 IL 1014 06/03/09 IT Staff $87,818 16 40 4 2 1 IL 1015 07/08/13 Invent $31,250 14 26 3 1 2 PA 1016 09/23/08 Machine $42,719 12 35 3 1 2 NE 1018 01/15/11 Acctg/Fin $42,836 16 32 3 2 2 PA 1018 05/03/12 Machine $32,157 12 24 3 2 1 NE 1019 05/21/07 Machine $48,317 12 38 3 1 1 NE 1024 08/17/11 Machine $33,005 12 26 3 1 1 IL 1036 09/25/00 Machine $57,822 16 51 2 1 1 NE 1038 08/21/12 IT Staff $65,451 16 32 2 1 1 PA 1043 06/18/09 Gen Shop $26,168 12 27 3 1 1 IL 1048 09/19/13 Shipping $31,655 12 20 1 2 2 IL 1049 02/23/04 IT Staff $88,421 19 41 3 1 1 PA 1053 05/31/13 Machine $30,241 12 20 3 1 2 PA 1053 09/08/09 Machine $35,293 12 30 1 1 1 IL 1055 06/15/01 Controller $99,836 19 45 3 2 1 PA 1055 06/04/01 Machine $56,663 16 50 3 1 1 PA 1055 9/30/01 Machine $57,385 16 50 1 1 1 IL 1056 05/06/07 Machine $48,059 12 38 3 1 1 IL 1059 02/14/12 Acctg/Fin $46,589 16 33 3 2 1 NE 1061 02/02/09 Machine $39,931 12 34 1 1 1 NE 1062 03/04/13 Acctg/Fin $32,238 16 28 3 1 2 IL 1062 07/08/09 Flr Supr $72,803 14 35 3 1 1 PA 1069 02/03/11 Engineering $79,938 16 35 2 2 1 IL 1070 08/21/09 Machine $35,498 12 31 3 1 1 NE 1071 01/09/05 Engineering $86,238 19 41 3 1 1 NE 1071 08/08/05 Engineering $87,019 19 51 3 1 1 IL 1075 01/14/10 Machine $34,317 12 28 3 2 1 NE 1079 10/15/03 Invent $51,459 16 31 3 1 1 PA 1083 08/27/09 Machine $35,396 12 31 3 1 2 PA 1083 4/30/00 Machine $58,771 14 52 3 1 1 IL 1084 03/15/99 Sales $85,671 19 62 3 1 1 PA 1088 10/03/11 Sr Flr Mgr $83,974 16 35 1 2 1 NE 1096 03/06/06 Machine $50,502 12 42 3 1 1 NE 1097 08/14/05 Machine $50,571 12 43 1 1 1 PA 1098 01/13/14 Engineering $62,245 16 25 3 1 2 PA 1101 06/08/02 Invent $55,994 16 31 1 1 1 NE 1102 04/08/00 IT Staff $88,900 19 48 3 1 1 PA 1104 02/01/05 Machine $52,450 12 44 3 1 1 NE 1105 09/06/12 Invent $32,633 12 28 3 1 2 NE 1106 5/9/02 Machine $55,744 12 48 1 1 1 IL 1108 06/15/07 Gen Shop $27,403 12 29 3 1 2 IL 1109 02/22/07 Machine $49,201 12 39 3 1 1 NE 1113 05/02/12 Machine $32,124 12 24 1 2 2 PA 1113 09/08/00 Sr Mach $81,695 14 50 1 1 1 PA 1116 12/30/08 Machine $42,235 12 34 3 1 1 IL 1116 04/05/00 Quality $81,526 16 52 3 1 1 PA 1117 05/27/09 Gen Shop $26,360 12 27 3 2 1 PA 1117 08/15/12 Machine $31,262 12 22 2 1 2 IL 1128 06/07/10 Flr Supr $74,104 16 35 3 2 1 NE 1130 03/15/99 Machine $59,438 16 53 3 1 1 PA 1132 07/10/09 Machine $35,822 12 32 3 1 1 PA 1133 02/12/09 Sales $73,337 19 58 4 1 1 PA 1136 12/14/11 Machine $32,523 12 24 1 1 2 IL 1138 10/18/10 Gen Shop $24,017 12 24 4 2 1 PA 1138 4/12/08 Machine $44,204 12 35 4 1 1 PA 1140 07/10/09 Machine $35,934 12 32 2 1 1 IL 1141 06/18/09 Gen Shop $25,999 12 24 3 1 1 IL 1142 06/17/09 Machine $36,901 12 32 1 1 1 PA 1145 02/16/09 Gen Shop $25,131 12 24 2 1 2 IL 1145 11/05/09 Machine $34,680 12 29 1 1 2 NE 1145 09/15/04 Machine $53,327 12 45 3 1 1 IL
Format cells in column according to indicated format.
QR Questions_ResponsesDATA
https://umuc.equella.ecollege.com/file/bf300325-e42d-47a7-b…5a543df1fae3/1/TemplateforWorkforceCompositionAnalysis.xlsx 10/26/16, 11J22 AM Page 1 of 6
1145 09/15/04 Machine $53,327 12 45 3 1 1 IL 1150 04/26/13 Machine $30,808 12 21 1 1 2 IL 1153 02/05/12 Sr Mach $66,843 12 30 3 1 1 IL 1156 05/21/11 Machine $33,395 12 26 3 1 2 IL 1167 11/15/11 Machine $32,766 12 24 3 1 1 PA 1169 01/22/09 Machine $40,871 12 34 3 1 1 PA 1175 09/25/02 Machine $54,886 14 48 3 1 1 NE 1180 01/24/05 Machine $52,469 12 45 1 1 1 NE 1185 04/16/09 Machine $37,914 12 33 1 1 1 PA 1186 08/14/05 Machine $50,636 12 43 3 1 1 NE 1188 05/16/09 Engineering $83,198 19 38 3 1 1 IL 1189 02/12/10 Sales $70,520 16 40 2 2 1 PA 1190 5/9/02 Machine $55,716 12 48 1 1 1 IL 1190 8/31/99 Machine $59,147 14 53 1 1 1 IL 1196 09/08/09 Machine $35,327 12 30 3 1 1 IL 1198 09/17/10 Gen Shop $23,484 12 22 1 1 1 PA 1201 08/01/08 Machine $43,003 12 35 3 1 1 IL 1202 03/15/99 Acctg/Fin $85,123 16 48 3 1 1 PA 1210 09/10/06 Machine $50,133 12 40 3 1 1 NE 1215 05/06/07 Engineering $86,673 19 43 2 1 1 PA 1216 07/12/06 Shipping $52,654 14 40 1 1 1 PA 1218 07/23/09 Design $64,504 16 34 1 1 2 PA 1220 10/16/02 Machine $54,368 12 48 3 1 1 NE 1220 04/15/00 Sr Mach $83,377 14 55 1 2 1 IL 1224 09/23/13 Engineering $70,886 16 30 2 1 1 PA 1226 06/02/07 Gen Shop $27,435 12 29 1 1 1 IL 1227 05/03/00 Invent $65,234 14 45 3 1 1 IL 1227 04/25/06 Machine $50,320 12 41 3 1 2 PA 1232 07/12/10 Shipping $37,456 12 28 3 1 1 IL 1233 05/31/13 Machine $30,577 12 21 3 1 2 NE 1237 08/08/07 Machine $46,904 12 38 1 1 1 IL 1246 07/27/00 Sr Mach $82,315 12 54 3 2 1 IL 1248 07/25/09 Gen Shop $26,156 12 25 3 1 1 NE 1254 02/02/09 Machine $39,755 12 34 2 1 1 PA 1255 03/14/09 Gen Shop $26,621 12 27 3 1 2 PA 1257 08/09/09 Engineering $85,463 19 38 3 1 1 NE 1257 03/11/10 Machine $34,232 12 28 3 1 2 PA 1258 07/09/03 Sr Mach $70,234 12 46 3 1 1 NE 1261 04/13/13 Machine $30,165 12 20 3 1 2 IL 1261 06/02/09 Sr Mach $68,014 12 33 1 2 2 IL 1265 03/04/13 Acctg/Fin $29,632 16 24 1 1 2 NE 1265 07/08/11 Engineering $85,825 19 40 3 2 1 NE 1267 2/5/08 Machine $44,747 12 35 2 1 1 IL 1269 03/14/07 Design $76,577 16 39 3 2 2 NE 1272 09/18/10 IT Mgr $100,515 19 52 3 1 1 PA 1276 05/04/11 IT Staff $65,469 16 32 3 1 1 NE 1279 10/20/07 Machine $46,057 12 37 1 1 1 NE 1280 08/11/14 Acctg/Fin $29,442 16 22 3 2 1 PA 1285 04/04/11 Advertg $53,064 16 26 3 2 2 NE 1288 03/25/10 Sales $70,708 16 41 1 1 2 NE 1289 09/05/11 Gen Shop $17,943 12 19 1 1 2 NE 1289 10/22/06 Machine $50,078 12 40 1 1 1 IL 1292 05/13/01 Machine $56,815 14 50 3 1 1 PA 1295 07/08/12 Purch $45,670 12 30 3 2 1 NE 1296 05/05/00 Gen Shop $28,901 14 36 3 1 1 PA 1296 09/15/10 Invent $52,765 12 29 4 2 1 IL 1296 09/23/11 Quality $53,487 16 34 3 1 1 NE 1297 06/06/05 Sr Mach $69,628 12 41 3 1 2 IL 1299 04/08/09 Shp Mgr $85,286 16 47 1 1 1 PA 1300 07/10/09 Engineering $80,637 16 36 3 2 1 PA 1300 06/17/09 Machine $36,882 12 32 3 1 2 PA 1308 04/03/10 Engineering $75,261 16 31 3 1 1 NE 1308 06/30/01 IT Staff $88,698 19 43 2 2 1 IL 1308 4/30/00 Machine $58,742 14 51 3 1 2 NE 1314 1/22/08 Machine $44,765 12 35 1 1 1 IL 1315 02/15/07 Machine $49,672 12 39 3 1 1 IL 1315 02/07/08 Sr Mach $68,913 12 34 4 1 1 PA 1317 08/12/08 Sr Mach $68,677 12 35 3 1 1 PA 1320 06/18/09 Gen Shop $26,351 14 27 4 1 2 IL 1320 09/01/12 Machine $31,170 12 22 4 2 2 PA 1320 05/07/11 Sr Mach $67,380 12 31 1 1 2 NE 1323 02/05/05 Machine $52,235 12 44 4 1 2 IL 1325 03/15/99 Sr Mach $83,413 14 57 3 1 1 PA 1329 09/20/09 Gen Shop $26,020 14 25 1 1 1 PA 1332 04/12/11 Shipping $36,789 12 24 3 1 2 PA 1339 05/01/12 Machine $31,992 12 24 3 1 2 NE 1341 03/07/04 Gen Shop $28,325 14 32 3 1 1 PA 1343 04/15/10 Gen Shop $21,897 12 22 1 1 2 IL 1343 12/18/07 Machine $44,860 12 36 1 1 1 IL 1346 06/12/10 Sr Mach $67,679 12 31 3 1 1 PA 1350 06/21/12 Admin $21,387 12 23 3 2 2 NE 1356 09/19/10 Sr Sales Mgr $84,068 16 48 3 2 1 NE 1357 03/15/99 Advertg $99,741 16 52 3 1 1 PA
https://umuc.equella.ecollege.com/file/bf300325-e42d-47a7-b…5a543df1fae3/1/TemplateforWorkforceCompositionAnalysis.xlsx 10/26/16, 11J22 AM Page 2 of 6
1357 03/15/99 Advertg $99,741 16 52 3 1 1 PA 1357 04/08/05 COO $105,779 19 39 3 1 2 PA 1364 3/16/08 Machine $44,576 12 35 3 1 1 PA 1364 04/20/05 Machine $51,431 12 44 1 1 2 IL 1373 04/08/09 Machine $38,873 12 33 4 1 1 PA 1373 06/25/07 Machine $47,648 12 38 3 1 1 PA 1378 07/09/10 Machine $33,968 12 28 3 1 1 PA 1379 06/09/07 Mrktg $81,191 16 36 1 1 1 NE 1381 10/23/10 Sales $72,181 16 52 3 1 1 IL 1387 07/14/09 Gen Shop $26,163 12 26 1 1 2 NE 1387 12/18/07 Machine $45,130 12 36 1 1 2 IL 1387 07/23/05 Machine $50,914 12 43 3 1 1 IL 1391 05/30/09 Machine $37,084 12 32 3 1 2 NE 1393 2/3/01 Machine $57,643 12 51 3 1 1 NE 1394 04/30/00 Machine $58,640 16 51 1 1 1 IL 1400 06/16/05 Design $80,483 16 46 3 1 2 NE 1402 08/17/11 Machine $32,812 12 26 4 1 1 IL 1403 12/01/10 Sales $71,265 16 42 3 2 1 IL 1404 10/15/11 Gen Shop $18,097 14 19 3 1 2 PA 1405 08/13/07 Gen Shop $28,537 14 34 3 1 1 IL 1411 03/05/09 Design $61,333 16 30 3 1 2 NE 1417 04/15/07 Sr Mach $69,102 12 34 4 1 1 PA 1418 07/04/11 Quality $53,981 16 36 3 1 1 IL 1422 05/30/09 Machine $36,918 12 32 1 1 1 IL 1422 09/08/13 Sales $52,485 16 25 3 1 1 NE 1424 03/15/99 Flr Supr $75,737 14 45 3 2 1 PA 1424 01/14/10 Machine $34,512 12 29 3 1 2 NE 1424 02/15/13 Sales $55,460 16 32 1 2 2 PA 1424 03/15/99 Sr Mach $84,505 14 59 3 1 1 PA 1426 10/20/07 Machine $45,934 12 37 3 1 1 IL 1429 06/30/10 Sr Mach $67,692 12 32 1 1 1 IL 1432 10/15/09 Design $71,204 16 38 3 1 1 PA 1434 01/21/07 Machine $49,797 12 39 2 1 1 NE 1442 01/08/12 Admin $22,415 12 25 1 2 2 IL 1443 09/12/06 Sr Mach $69,372 12 40 3 1 1 PA 1444 06/15/02 Mrktg $81,221 16 42 3 2 1 IL 1444 08/02/11 Sales $64,415 16 34 3 1 1 IL 1445 08/08/10 Machine $33,808 12 28 3 1 1 NE 1446 12/15/05 Gen Shop $27,574 14 30 4 1 2 PA 1447 10/18/10 Gen Shop $23,971 12 23 1 1 2 PA 1447 09/05/12 Sales $63,836 16 32 3 1 1 NE 1448 05/03/11 Admin $25,456 14 31 4 1 2 PA 1450 01/22/09 Machine $40,705 12 34 3 1 1 NE 1452 11/06/06 Machine $49,838 12 39 3 1 1 IL 1456 06/25/07 Machine $47,522 12 38 1 1 1 NE 1456 05/07/04 Sr Mach $69,997 12 41 1 1 1 PA 1461 10/12/10 Advertg $53,215 16 28 3 1 2 IL 1466 03/19/09 Machine $39,634 12 34 1 1 1 NE 1466 05/04/12 Sales $64,329 16 33 3 1 2 IL 1468 7/21/01 Machine $56,291 12 50 1 1 2 NE 1471 07/10/09 Machine $36,729 12 32 3 1 1 PA 1474 03/25/09 Machine $39,331 12 34 3 1 1 NE 1476 05/23/11 Purch $48,560 14 32 3 2 1 IL 1477 03/15/03 Purch $63,388 16 44 3 2 1 PA 1477 01/15/12 Shipping $33,169 12 23 1 1 2 PA 1481 09/06/03 Machine $54,158 12 47 3 1 1 NE 1484 03/04/09 Shipping $45,622 14 35 1 2 1 PA 1492 10/25/01 Machine $55,936 12 49 1 1 2 IL 1496 05/07/13 Shipping $31,035 12 19 1 1 2 NE 1498 02/22/11 Machine $33,574 12 27 1 1 1 IL 1498 08/04/13 Sr Mach $65,283 12 28 4 2 1 NE 1504 03/14/05 Machine $52,104 12 44 1 1 1 PA 1504 04/30/10 Shipping $38,455 12 28 3 2 1 PA 1505 12/06/10 Machine $33,609 12 28 1 2 1 IL 1506 06/27/04 IT Staff $88,517 19 43 1 1 1 NE 1507 04/15/14 Gen Shop $15,182 12 18 1 1 2 IL 1513 08/14/03 Machine $54,358 12 47 3 1 1 PA 1515 05/01/00 Acctg/Fin $66,230 16 36 3 2 2 NE 1517 11/12/12 Engineering $62,572 16 26 1 2 2 IL 1519 06/04/11 Design $63,010 16 33 3 1 2 IL 1519 02/15/13 Machine $29,819 12 19 4 2 2 NE 1523 05/21/11 Acctg/Fin $50,767 16 35 2 1 2 IL 1525 05/09/05 Gen Shop $27,633 12 30 3 1 2 NE 1527 03/15/99 Machine $59,872 12 54 3 1 1 PA 1529 10/16/11 Machine $32,797 12 24 3 1 1 NE 1531 04/07/13 Design $62,412 16 32 3 1 2 PA 1533 12/28/07 Machine $45,283 12 36 3 1 1 PA 1539 12/15/12 Gen Shop $18,102 14 21 3 1 2 IL 1541 04/09/07 Sr Mach $69,128 12 36 3 1 1 IL 1543 10/06/09 Machine $35,002 12 30 3 1 2 IL 1550 02/19/14 IT Staff $55,067 16 28 1 2 2 IL 1550 11/14/08 Sr Mach $68,317 12 33 3 1 1 IL
https://umuc.equella.ecollege.com/file/bf300325-e42d-47a7-b…5a543df1fae3/1/TemplateforWorkforceCompositionAnalysis.xlsx 10/26/16, 11J22 AM Page 3 of 6
1552 5/30/99 Machine $59,316 14 53 3 1 1 PA 1553 04/12/09 Machine $38,398 12 33 1 1 1 NE 1553 10/20/07 Machine $46,097 12 38 3 1 1 PA 1554 10/23/13 Engineering $62,458 16 26 2 2 2 IL 1554 10/20/06 Machine $50,082 12 40 3 1 1 NE 1556 03/21/09 Gen Shop $26,466 12 27 4 1 2 PA 1557 07/21/04 Machine $53,537 12 46 3 1 2 NE 1558 01/06/05 Machine $52,946 12 45 2 1 1 PA 1560 05/06/12 Gen Shop $18,270 14 21 3 1 2 PA 1565 03/16/07 Machine $48,712 12 38 3 1 1 IL 1568 08/07/12 Shipping $32,960 12 20 3 2 2 IL 1568 02/07/10 Sr Mach $67,771 12 32 1 1 2 NE 1569 04/23/10 Quality $55,254 16 42 3 2 2 IL 1571 04/16/09 Machine $37,917 12 33 4 1 2 PA 1575 02/04/09 Machine $40,629 12 34 3 1 1 IL 1579 01/12/05 Machine $52,580 12 45 1 1 1 IL 1580 09/16/10 Gen Shop $23,342 12 22 3 1 2 PA 1584 03/15/99 Machine $60,239 16 54 1 1 2 PA 1588 8/17/02 Machine $55,566 12 48 2 1 1 PA 1589 04/15/13 Design $51,233 16 25 3 2 2 IL 1591 7/12/08 Machine $43,213 12 35 3 1 1 IL 1593 08/15/08 Shipping $47,891 12 38 1 2 1 NE 1596 06/12/09 CFO $131,276 19 42 3 1 2 PA 1597 11/20/11 Flr Supr $70,293 16 34 3 1 1 IL 1598 02/15/13 Machine $29,661 12 19 3 1 2 PA 1608 03/15/99 Flr Supr $75,375 16 44 3 2 1 IL 1608 04/15/09 Sales $73,258 19 53 3 1 1 PA 1609 07/20/11 Machine $33,266 12 26 3 1 2 NE 1611 09/23/07 Machine $46,378 12 38 3 1 1 PA 1612 03/06/11 Shipping $37,800 12 25 2 1 1 NE 1613 05/04/12 Machine $32,496 12 24 1 1 1 PA 1616 09/15/09 Advertg $65,027 16 34 3 2 2 PA 1616 08/09/06 Engineering $86,818 19 48 3 1 1 NE 1619 11/3/07 Machine $45,641 12 36 3 1 1 NE 1620 06/07/13 Gen Shop $15,248 12 18 1 2 2 NE 1622 02/06/12 Shipping $33,047 12 21 3 2 2 PA 1623 03/04/12 Engineering $64,153 16 28 2 1 1 IL 1625 09/12/09 Purch $60,346 16 31 3 1 1 IL 1626 07/08/12 Gen Shop $19,141 14 21 3 2 2 NE 1629 09/04/11 Shipping $35,550 12 24 1 1 1 IL 1630 09/12/08 Shipping $47,650 12 36 3 1 1 IL 1636 04/17/09 Gen Shop $25,671 12 24 4 1 1 NE 1637 06/07/11 Sales $64,494 16 37 4 1 1 PA 1638 09/01/07 Machine $46,787 12 38 3 1 2 IL 1639 07/30/12 Machine $31,567 12 23 1 1 2 PA 1640 08/13/07 Design $77,045 16 42 3 1 1 PA 1644 09/05/11 Gen Shop $17,598 12 19 3 1 2 PA 1654 06/07/11 Engineering $79,709 16 35 3 2 1 NE 1658 03/22/10 Admin $32,300 16 33 1 2 2 PA 1659 11/02/06 Machine $49,925 12 40 1 1 2 NE 1660 01/14/10 Machine $34,420 12 28 1 2 1 PA 1661 03/18/13 Sales $52,300 16 28 3 2 1 IL 1661 11/18/11 Shipping $34,456 12 23 1 2 2 NE 1667 01/15/08 Engineering $86,096 16 40 3 1 1 PA 1667 03/14/05 Machine $51,554 12 44 3 1 1 PA 1668 05/01/00 Advertg $65,089 16 35 3 1 1 IL 1668 07/10/09 Machine $35,688 12 32 4 1 2 PA 1669 09/05/11 Design $61,882 16 32 3 2 1 PA 1671 06/13/12 Machine $31,809 12 23 3 1 1 IL 1672 05/04/08 Sr Flr Mgr $96,546 12 38 3 1 1 IL 1673 03/07/13 Mrktg $67,415 16 35 3 2 1 IL 1679 05/18/09 Acctg/Fin $66,109 16 39 3 1 1 PA 1680 01/06/13 Design $51,226 16 24 1 1 2 IL 1687 12/15/05 Gen Shop $27,541 14 30 1 1 1 NE 1687 06/02/04 Machine $53,784 12 46 3 1 1 IL 1693 03/15/99 Engineering $93,678 19 54 3 1 1 PA 1709 09/20/05 Machine $50,522 12 43 1 1 1 IL 1723 06/02/12 Gen Shop $19,397 14 21 3 1 2 PA 1723 11/10/07 Machine $45,495 12 36 1 1 1 PA 1726 03/15/99 Design $81,159 19 56 3 1 1 PA 1733 09/18/13 Flr Supr $65,780 16 32 1 2 1 PA 1736 09/18/07 Gen Shop $27,221 12 28 3 2 2 PA 1736 04/01/09 Machine $39,130 12 33 3 1 2 IL 1737 03/15/99 Invent $76,188 16 52 3 1 1 PA 1741 03/30/09 Machine $39,191 12 34 3 1 1 IL 1744 06/15/11 Eng Mgr $110,233 19 45 3 1 1 PA 1744 08/16/06 Gen Shop $28,486 12 32 1 1 1 NE 1744 11/12/07 Machine $45,317 12 36 3 1 1 NE 1745 06/10/10 Machine $34,196 12 28 4 1 1 PA 1748 08/25/10 Mrktg $68,352 16 35 3 2 1 PA 1749 08/14/00 Sr Mach $82,777 12 56 1 1 2 NE 1750 06/22/10 Gen Shop $21,828 14 22 3 1 2 NE
https://umuc.equella.ecollege.com/file/bf300325-e42d-47a7-b…5a543df1fae3/1/TemplateforWorkforceCompositionAnalysis.xlsx 10/26/16, 11J22 AM Page 4 of 6
1750 06/22/10 Gen Shop $21,828 14 22 3 1 2 NE 1750 08/13/09 Machine $35,536 12 31 1 1 1 IL 1754 05/06/03 Sr Mach $70,507 12 48 1 1 1 PA 1756 05/13/01 Machine $56,888 12 50 3 1 1 PA 1756 07/01/09 Sr Flr Mgr $93,478 16 42 3 1 1 PA 1757 2/16/02 Machine $55,840 12 49 3 1 1 PA 1760 02/04/11 Design $60,348 16 28 2 1 2 PA 1760 09/15/12 Machine $31,049 12 22 3 1 2 IL 1764 6/17/01 Machine $57,530 12 50 3 1 2 IL 1767 05/20/05 Machine $51,360 12 44 3 1 1 IL 1770 03/06/04 Engineering $86,972 16 48 3 1 1 NE 1771 03/14/05 Machine $51,899 12 44 3 1 1 PA 1773 06/07/05 Purch $60,999 16 42 3 1 2 PA 1774 10/25/13 Flr Supr $68,455 16 33 3 2 1 NE 1776 11/13/09 Design $61,441 16 30 3 2 2 IL 1776 03/15/99 Machine $60,198 12 54 3 1 1 PA 1779 09/07/10 Machine $33,631 12 28 3 1 1 NE 1779 06/01/05 Machine $51,084 12 43 3 1 1 IL 1782 03/04/04 Machine $53,903 12 46 1 1 1 NE 1785 07/06/06 Engineering $86,972 16 50 3 1 1 IL 1785 09/21/09 Gen Shop $26,096 14 25 4 1 2 IL 1785 02/08/10 Shipping $42,456 12 32 3 2 1 PA 1787 07/21/07 Acctg/Fin $66,261 16 45 3 1 1 IL 1789 09/23/08 Machine $42,802 12 35 3 1 1 PA 1793 03/15/99 Design $81,077 19 54 1 1 1 IL 1793 09/07/07 Shipping $50,788 14 40 3 2 1 IL 1793 09/08/08 Sr Sales Mgr $90,822 19 50 3 1 2 IL 1794 01/14/14 Engineering $60,323 16 24 3 1 2 PA 1796 03/14/10 Sales Mgr $101,275 19 43 3 1 1 PA 1797 02/08/03 Sr Mach $70,084 12 44 2 1 1 NE 1800 05/14/09 Machine $36,918 12 32 1 1 1 PA 1800 03/15/99 Machine $59,647 14 54 3 1 1 PA 1802 5/31/08 Machine $43,498 12 35 4 1 1 NE 1803 09/30/00 Mrktg $81,282 16 45 3 1 1 PA 1804 08/19/09 Quality $64,510 16 46 1 2 1 PA 1809 10/16/01 Machine $56,946 12 50 1 1 1 NE 1812 04/06/05 Gen Shop $27,781 12 30 1 1 1 PA 1813 01/15/03 Machine $53,922 12 47 1 1 2 IL 1814 08/19/11 Sr Sales Mgr $87,102 16 53 1 1 1 PA 1815 08/17/11 Machine $33,244 12 26 3 1 1 NE 1816 04/16/09 Machine $37,144 12 33 3 1 1 NE 1819 10/06/09 Machine $34,804 12 30 2 1 1 IL 1820 08/06/09 Shipping $44,236 12 32 3 1 1 NE 1821 09/13/06 Machine $50,130 12 40 3 1 1 PA 1822 05/02/07 Engineering $81,691 16 36 3 1 1 NE 1824 04/13/13 Machine $30,089 12 20 1 2 2 NE 1829 03/01/07 Machine $48,826 12 39 1 1 1 PA 1830 1/15/00 Machine $58,928 14 52 3 1 1 IL 1831 08/16/12 Sr Mach $65,938 12 29 1 2 1 PA 1835 06/07/13 Sr Mach $65,556 12 29 4 1 1 NE 1836 08/12/06 Machine $50,199 12 41 1 1 1 NE 1840 2/16/00 Machine $58,792 12 52 3 1 1 IL 1841 06/07/07 Design $79,865 16 45 2 1 2 PA 1841 08/05/13 Sr Mach $65,117 12 28 3 1 1 PA 1846 04/23/09 Design $80,113 19 46 3 2 2 PA 1846 03/05/13 Engineering $60,324 16 24 3 1 1 IL 1846 08/30/04 Machine $53,369 12 46 2 1 1 PA 1848 12/15/09 Design $80,722 19 52 3 1 1 PA 1848 06/05/04 Gen Shop $28,344 12 32 3 1 1 PA 1850 11/20/10 Gen Shop $24,060 12 24 3 1 2 PA 1850 08/05/07 Invent $58,068 12 30 3 2 1 IL
Section 2: Complete Summary Tables for Graphing Sales Summary (Provided)
Roles Race # % Yr Sales Key Emp 1 African-Am 1999 ($527,000) Acctg/Fin 2 Asian 2000 $1,215,000 Admin 3 Caucasian 2001 ($257,000) Advertg 4 Hispanic 2002 $985,000 CEO 2003 $1,274,000 CFO 2004 $1,578,000 Controller 2005 $2,061,000 COO Gender # % 2006 $1,987,000 Design 1 Male 2007 $2,057,000 Engineering 2 Female 2008 $2,565,000 Eng Mgr 2009 $2,467,000 Flr Supr 2010 $3,846,000 Gen Shop 2011 $3,252,000 Invent Education Level # % 2012 $4,226,000 IT Staff 12 HS 2013 $4,844,000
https://umuc.equella.ecollege.com/file/bf300325-e42d-47a7-b…5a543df1fae3/1/TemplateforWorkforceCompositionAnalysis.xlsx 10/26/16, 11J22 AM Page 5 of 6
IT Staff 12 HS 2013 $4,844,000 IT Mgr 14 AA 2014 $4,922,000 Machine 16 BA/BS 2015 $3,702,000 Mrktg 19 Masters Purch Quality Sales Sales Mgr Marital Status # % Shipping 1 Married Shp Mgr 2 Single Sr Flr Mgr Sr Mach Sr Sales Mgr Region Key State Region # % PA Northeast IL Midwest NE C-Plains
Section 3: Complete Descriptive Statistics
Descriptive Statistics Salary Hrly Rate Yrs of Svc Ed Age Frequency Table by Salary Ranges
Mean Bin
Range/Upper Limit
Labels
Median 20000 Up to 20 Graph on next Tab Mode 30000 21-30 Std Deviation 40000 31-40 Variance 50000 41-50 Kurtosis 60000 51-60 Skewness 70000 61-70 Max - 80000 71-80 Min = 90000 81-90 Range 100000 91-100 Sum 110000 101-110 Count 120000 111-120
130000 121-130 140000 131-140 150000 141-150 160000 151-160 170000 161-170 180000 171-180 190000 181-190 200000 191-200 210000 200+
https://umuc.equella.ecollege.com/file/bf300325-e42d-47a7-b…5a543df1fae3/1/TemplateforWorkforceCompositionAnalysis.xlsx 10/26/16, 11J22 AM Page 6 of 6
