Conduct Quantitative Analysis

nbroomstqrq
TemplateforWorkforceCompositionAnalysis1.xlsx
Home>Business & Finance homework help>Operations Management homework help>Conduct Quantitative Analysis

DATA

Workforce Profile Analysis
Section 1: Complete all Columns in Data Set
Format for:
Windows User: Format cells in column according to indicated format.
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
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
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
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
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
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+

QR Questions_Responses

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.