Conduct quantitative reasoning using data in a data set to produce an analysis in context
Apply Quantitative Reasoning Now that you have completed your analysis, think about the patterns you have seen in the workforce. In this final section, you will answ five questions and write a short essay. 1. From the created histogram, it appears that a large share of employees have a salary between $61,000-$140,000 or $141,000-$190, This may indicate a reasonable promotion rate for new employees. Is this distribution unimodal or bimodal? Please explain. 2. The line chart, as detailed in your "Graph Charts" Excel spreadsheet, shows sales generally increasing over the years, although sales the first two years were notably lower. Assuming that the sales are linear, please use the Forecast tool to find projected sales for 2019 a 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 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 na the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe y 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 ho 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 findin FINAL ESSAY: Now that you have done all the work with data, you will write a short three- to four-paragraph summary of your analysis. This is importan 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 wa should be understood. Supporting narrative is helpful. Never simply provide a "raw data" dump. Instead, seek to provide information! Structure your essay like this: Write a one-paragraph narrative summary of your findings, describing patterns of interest. Provide an explanation of the potential relevance of such patterns. Provide a description of how you would investigate further to determine if your results are "good or bad" for the company. Prepare your response in this workbook. (Simply expand this text box to accommodate your essay and other answers.) Structure your essay like this: Write a one-paragraph narrative summary of your findings, describing patterns of interest. Provide an explanation of the potential relevance of such patterns. Provide a description of how you would investigate further to determine if your results are "good or bad" for the company. Prepare your response in this workbook. (Simply expand this text box to accommodate your essay and other answers.) you will answer 41,000-$190,000. . though sales in les for 2019 and ur output will be a , the more narrow cs, describe your se, dynamic e. Describe how know an be your findings. s is important. e data the way it ormation! answers.) answers.) Workforce Profile Analysis Format cells in column according to indicated format. Section 1: Complete all Columns in Data Set Format for: Number Date mm/dd/yy Text Currency Currency Number General Year Ending Vested Yr 10 Ed 19 19 19 16 16 19 16 14 14 16 14 16 14 16 16 16 12 16 14 14 19 16 16 12/31/2014 Emp # 1001 1002 1003 1004 1005 1006 1014 1015 1016 1018 1019 1020 1024 1036 1038 1043 1048 1049 1053 1054 1055 1056 1057 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 Role CEO CIO Sr Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staf Investigator Cyber Analyst Acctg/Fin Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staf Forensics Analyst Physical Security IT Staf Cyber Analyst Cyber Analyst Controller Cyber Analyst Cyber Analyst Salary $290,210 $279,723 $166,750 $131,924 $142,687 $150,307 $98,818 $81,250 $92,719 $72,836 $82,157 $98,317 $83,005 $107,822 $85,451 $76,168 $61,655 $88,421 $80,241 $85,293 $149,836 $106,663 $107,385 Hrly Rate Yrs of Svc 1058 1059 1060 1061 1062 1069 1070 1071 1072 1075 1079 1083 1084 1085 1088 1096 1097 1098 1101 1102 1104 1105 1106 1108 1109 1113 1114 1116 1117 1118 1119 1128 1130 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 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 Cyber Analyst Acctg/Fin Cyber Analyst Acctg/Fin Cyber Mgr Cyber Software Engineer Cyber Analyst Cyber Software Engineer Cyber Software Engineer Cyber Analyst Investigator Cyber Analyst Cyber Analyst Public and Business Office Team Sr Forensics Mgr Cyber Analyst Cyber Analyst Cyber Software Engineer Investigator IT Staf Cyber Analyst Investigator Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Quality Assurance Forensics Analyst Cyber Analyst Cyber Mgr Cyber Analyst $98,059 $126,589 $99,931 $112,238 $162,803 $179,938 $95,498 $166,238 $167,019 $84,317 $71,459 $85,396 $108,771 $135,671 $173,974 $100,502 $110,571 $162,245 $125,994 $88,900 $112,450 $92,633 $115,744 $127,403 $99,201 $82,124 $151,695 $112,235 $111,526 $136,360 $121,262 $174,104 $79,438 14 16 14 16 16 16 14 19 19 16 16 14 14 19 19 14 16 16 16 19 16 12 14 16 14 14 16 16 16 19 16 19 14 1132 1133 1136 1138 1139 1140 1141 1142 1145 1146 1147 1150 1153 1156 1167 1169 1175 1180 1185 1186 1188 1189 1190 1191 1196 1198 1201 1202 1210 1215 1216 1218 1220 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 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 Cyber Analyst Public and Business Office Team Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Public and Business Office Team Cyber Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Acctg/Fin Cyber Analyst Cyber Software Engineer Physical Security Malware reverse engineer Cyber Analyst $85,822 $93,337 $82,523 $124,017 $94,204 $85,934 $75,999 $86,901 $75,131 $74,680 $103,327 $80,808 $154,843 $83,395 $82,766 $90,871 $104,886 $102,469 $87,914 $100,636 $143,198 $110,520 $105,716 $59,147 $135,327 $123,484 $143,003 $125,123 $120,133 $166,673 $72,654 $164,504 $114,368 14 19 14 16 16 14 14 14 14 14 16 16 19 16 14 14 16 16 14 16 19 16 14 14 16 16 16 16 16 19 14 16 16 1220 1224 1226 1227 1228 1232 1233 1237 1246 1248 1254 1255 1257 1258 1259 1261 1262 1265 1266 1267 1269 1272 1276 1279 1280 1285 1288 1289 1290 1292 1295 1296 1297 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 Sr Cyber Investigator Cyber Software Engineer Forensics Analyst Investigator Cyber Analyst Physical Security Cyber Analyst Cyber Analyst Sr Cyber Investigator Forensics Analyst Cyber Analyst Forensics Analyst Cyber Software Engineer Cyber Analyst Sr Cyber Investigator Cyber Analyst Sr Cyber Investigator Acctg/Fin Cyber Software Engineer Cyber Analyst Malware reverse engineer IT Mgr IT Staf Cyber Analyst Acctg/Fin Advertising Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst Logistics Forensics Analyst Investigator $143,377 $150,886 $127,435 $85,234 $120,320 $67,456 $80,577 $86,904 $142,315 $76,156 $79,755 $96,621 $135,463 $74,232 $130,234 $80,165 $148,014 $109,632 $115,825 $94,747 $176,577 $120,515 $85,469 $96,057 $79,442 $103,064 $120,708 $97,943 $100,078 $106,815 $85,670 $138,901 $112,765 16 16 16 14 16 12 14 14 19 14 14 16 16 14 16 14 19 16 16 14 19 16 14 16 14 16 16 14 16 14 12 16 14 1298 1299 1300 1301 1302 1303 1304 1308 1314 1315 1316 1317 1318 1319 1320 1323 1325 1329 1332 1339 1341 1343 1343 1346 1350 1356 1357 1358 1364 1365 1373 1374 1378 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 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 Quality Assurance Sr Cyber Investigator Logistics Mgr Cyber Software Engineer Cyber Analyst Cyber Software Engineer IT Staf Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Sr Cyber Investigator Forensics Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Sr Cyber Investigator Forensics Analyst Physical Security Cyber Analyst Forensics Analyst Forensics Analyst Cyber Analyst Sr Cyber Investigator Admin Sr Public and Business Office Team Mgr Advertising COO Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst $123,487 $169,628 $175,286 $80,637 $86,882 $115,261 $88,698 $78,742 $84,765 $89,672 $128,913 $138,677 $86,351 $81,170 $147,380 $102,235 $143,413 $96,020 $76,789 $81,992 $78,325 $71,897 $104,860 $147,679 $61,387 $164,068 $99,741 $235,779 $94,576 $101,431 $88,873 $97,648 $103,968 16 16 16 14 14 16 14 14 14 14 16 16 14 14 19 14 16 16 14 16 14 16 16 14 12 19 16 19 14 14 14 14 16 1379 1381 1387 1388 1389 1391 1393 1394 1400 1402 1403 1404 1405 1411 1417 1418 1422 1423 1424 1425 1426 1427 1428 1429 1432 1434 1442 1443 1444 1445 1446 1447 1448 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 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 Marketing Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineer Cyber Analyst Public and Business Office Team Forensics Analyst Forensics Analyst Malware Reverse Engineer Sr Cyber Investigator Quality Assurance Cyber Analyst Public and Business Office Team Cyber Mgr Cyber Analyst Public and Business Office Team Sr Cyber Investigator Cyber Analyst Sr Cyber Investigator Malware Reverse Engineer Cyber Analyst Admin Sr Cyber Investigator Marketing Public and Business Office Team Cyber Analyst Forensics Analyst Forensics Analyst $121,191 $132,181 $126,163 $145,130 $100,914 $87,084 $107,643 $118,640 $180,483 $82,812 $121,265 $118,097 $128,537 $161,333 $169,102 $133,981 $86,918 $112,485 $145,737 $84,512 $105,460 $144,505 $95,934 $127,692 $174,904 $99,797 $72,415 $149,372 $121,221 $104,415 $113,808 $127,574 $123,971 16 16 14 16 16 14 14 16 16 16 16 16 16 16 16 16 14 16 16 14 16 14 14 16 19 14 12 16 16 16 16 16 16 1449 1450 1451 1452 1456 1456 1461 1467 1466 1468 1471 1474 1476 1477 1478 1481 1484 1492 1496 1498 1499 1504 1505 1506 1507 1508 1513 1515 1517 1519 1519 1523 1525 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 05/01/00 11/12/12 06/04/11 02/15/13 05/21/11 05/09/05 Public and Business Office Team Admin Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Advertising Cyber Analyst Public and Business Office Team Cyber Analyst Cyber Analyst Cyber Analyst Logistics Logistics Physical Security Cyber Analyst Physical Security Cyber Analyst Physical Security Cyber Analyst Sr Cyber Investigator Cyber Analyst Physical Security Cyber Analyst IT Staf Forensics Analyst Cyber Analyst Acctg/Fin Cyber Software Engineer Malware Reverse Engineer Cyber Analyst Acctg/Fin Forensics Analyst $123,836 $75,456 $90,705 $99,838 $97,522 $119,997 $83,215 $99,634 $114,329 $126,291 $86,729 $89,331 $98,560 $113,388 $83,169 $104,158 $75,622 $105,936 $71,035 $93,574 $125,283 $72,104 $68,455 $83,609 $88,517 $115,182 $104,358 $106,230 $122,572 $163,010 $79,819 $60,767 $127,633 16 14 14 14 14 16 16 14 16 16 14 14 14 16 12 16 14 16 12 14 16 12 12 14 14 16 14 14 16 16 14 14 16 1527 1529 1531 1533 1539 1541 1543 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1565 1567 1568 1569 1571 1575 1579 1580 1584 1588 1589 1591 1593 1596 1597 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 Cyber Analyst Cyber Analyst Malware Reverse Engineer Cyber Analyst Forensics Analyst Sr Cyber Investigator Cyber Analyst IT Staf Sr Cyber Investigator Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Physical Security Sr Cyber Investigator Quality Assurance Cyber Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineer Cyber Analyst Physical Security CFO Cyber Mgr $99,872 $92,797 $162,412 $95,283 $78,102 $139,128 $85,002 $75,067 $128,317 $79,316 $88,398 $96,097 $142,458 $110,082 $96,466 $93,537 $92,946 $88,270 $88,712 $62,960 $137,771 $95,254 $87,917 $90,629 $102,580 $93,342 $110,239 $105,566 $101,233 $93,213 $77,891 $231,276 $170,293 14 14 16 14 14 16 14 14 16 14 14 14 16 16 14 14 14 14 14 12 16 16 14 14 16 16 16 16 16 14 12 19 19 1598 1607 1608 1609 1611 1612 1613 1616 1617 1619 1620 1622 1623 1625 1626 1629 1630 1636 1637 1638 1639 1640 1644 1654 1658 1659 1660 1661 1661 1665 1666 1667 1668 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 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 Cyber Analyst Cyber Mgr Public and Business Office Team Cyber Analyst Cyber Analyst Physical Security Cyber Analyst Advertising Cyber Software Engineer Cyber Analyst Forensics Analyst Physical Security Cyber Software Engineer Logistics Forensics Analyst Physical Security Physical Security Forensics Analyst Public and Business Office Team Cyber Analyst Cyber Analyst Malware Reverse Engineer Forensics Analyst Cyber Software Engineer Admin Cyber Analyst Cyber Analyst Public and Business Office Team Physical Security Cyber Software Engineer Cyber Analyst Advertising Cyber Analyst $89,661 $175,375 $133,258 $83,266 $96,378 $67,800 $82,496 $115,027 $166,818 $95,641 $85,248 $73,047 $114,153 $90,346 $99,141 $65,550 $77,650 $85,671 $114,494 $96,787 $81,567 $137,045 $77,598 $129,709 $72,300 $99,925 $84,420 $102,300 $64,456 $86,096 $101,554 $105,089 $95,688 12 19 16 14 14 12 14 16 19 14 14 12 16 16 16 12 12 16 16 14 16 16 16 16 16 14 14 16 12 14 16 16 14 1669 1671 1672 1673 1679 1680 1687 1688 1693 1709 1723 1724 1726 1733 1735 1736 1737 1741 1742 1743 1744 1745 1748 1749 1750 1751 1754 1755 1756 1757 1760 1761 1764 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 06/15/11 08/16/06 11/12/2007 06/10/10 08/25/10 08/14/00 06/22/10 08/13/09 05/06/03 05/13/01 07/01/09 2/16/2002 02/04/11 09/15/12 6/17/2001 Malware Reverse Engineer Cyber Analyst Sr Forensics Mgr Marketing Acctg/Fin Malware Reverse Engineer Forensics Analyst Cyber Analyst Cyber Software Engineer Cyber Analyst Forensics Analyst Cyber Analyst Malware Reverse Engineer Cyber Mgr Forensics Analyst Cyber Analyst Investigator Cyber Analyst Eng Mgr Forensics Analyst Cyber Analyst Cyber Analyst Marketing Sr Cyber Investigator Forensics Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Sr Forensics Mgr Cyber Analyst Malware Reverse Engineer Cyber Analyst Cyber Analyst $161,882 $81,809 $146,546 $117,415 $116,109 $151,226 $97,541 $103,784 $143,678 $110,522 $99,397 $95,495 $161,159 $165,780 $97,221 $109,130 $116,188 $89,191 $160,233 $98,486 $115,317 $114,196 $98,352 $142,777 $91,828 $115,536 $70,507 $106,888 $153,478 $105,840 $160,348 $81,049 $117,530 16 16 16 16 16 16 14 16 19 16 16 16 19 19 16 16 16 14 16 14 16 16 16 14 16 16 14 16 19 16 16 16 14 1767 1770 1771 1773 1774 1775 1776 1777 1779 1782 1783 1784 1785 1787 1789 1790 1791 1793 1794 1796 1797 1798 1799 1802 1803 1804 1809 1812 1813 1814 1815 1816 1819 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 08/19/11 08/17/11 04/16/09 10/06/09 Cyber Analyst Cyber Software Engineer Cyber Analyst Logistics Cyber Mgr Malware Reverse Engineer Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Forensics Analyst Physical Security Acctg/Fin Cyber Analyst Malware Reverse Engineer Physical Security Sr Public and Business Office Team Mgr Cyber Software Engineer Public and Business Office Team Mgr Sr Cyber Investigator Cyber Analyst Cyber Analyst Cyber Analyst Marketing Quality Assurance Cyber Analyst Forensics Analyst Cyber Analyst Sr Public and Business Office Team Mgr Cyber Analyst Cyber Analyst Cyber Analyst $111,360 $138,697 $101,899 $110,999 $148,455 $161,441 $110,198 $113,631 $121,084 $123,903 $156,972 $96,096 $82,456 $116,261 $92,802 $161,077 $70,788 $140,822 $110,323 $151,275 $150,084 $86,918 $109,647 $93,498 $111,282 $124,510 $106,946 $97,781 $103,922 $147,102 $83,244 $87,144 $84,804 16 16 16 16 16 14 19 16 16 16 19 16 12 16 14 19 12 19 16 19 19 14 16 16 16 16 16 14 16 16 14 14 14 1820 1821 1822 1824 1829 1830 1831 1835 1836 1840 1841 1842 1843 1844 1846 1848 1849 1850 1851 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 Physical Security Cyber Analyst Cyber Software Engineer Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Sr Cyber Investigator Cyber Analyst Cyber Analyst Malware Reverse Engineer Sr Cyber Investigator Malware Reverse Engineer Cyber Software Engineer Cyber Analyst Malware Reverse Engineer Forensics Analyst Forensics Analyst Investigator $84,236 $100,130 $151,691 $80,089 $98,826 $108,928 $135,938 $135,556 $100,199 $108,792 $179,865 $165,117 $180,113 $140,324 $103,369 $170,722 $98,344 $94,060 $118,068 12 14 16 16 14 14 16 16 14 14 19 19 19 16 16 19 14 14 16 Section 2: Complete Summary Tables for Graphing Roles Acctg/Fin Admin Advertising CEO CFO CIO Controller COO # Race 1 2 3 4 Gender African-Am Asian Caucasian Hispanic TOTAL Cyber Analyst Cyber Mgr Cyber Software Engineer Eng Mgr Forensics Analyst Investigator IT Mgr IT Staf Logistics Logistics Mgr Malware Reverse Engineer Marketing Physical Security Public and Business Office Team Public and Business Office Team Mgr Quality Assurance Sr Cyber Analyst Sr Cyber Investigator Sr Forensics Mgr Sr Public and Business Office Team Mgr TOTAL 1 2 Male Female TOTAL Education Level 12 HS 14 AA 16 BA/BS 19 Masters+ TOTAL Marital Status 1 Married 2 Single TOTAL Region Key State Region PA Northeast IL Midwest NE C-Plains TOTAL Section 3: Complete Descriptive Statistics Descriptive Statistics Mean Salary Hrly Rate Yrs of Svc Ed Median Mode Std Deviation Variance Kurtosis Skewness Max Min = Range Sum Count 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 Vested Race 3 3 1 3 3 3 4 3 3 3 3 3 3 2 2 3 1 3 3 1 3 3 1 Gender 1 1 1 1 1 1 2 1 1 2 2 1 1 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 State PA PA IL NE PA IL IL PA NE PA NE NE IL NE PA IL IL PA PA IL PA PA IL Region 38 33 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 3 3 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 1 2 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 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 IL NE 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 32 58 24 24 35 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 3 4 1 4 4 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 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 1 1 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 1 1 1 1 1 1 1 2 1 PA PA IL PA PA 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 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 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 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 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 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 34 41 47 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 3 3 1 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 1 1 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 2 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 NE IL PA 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 36 52 26 36 43 32 51 51 46 26 42 19 34 30 34 36 32 25 45 29 32 59 37 32 38 39 25 40 42 34 28 30 23 1 3 1 1 3 3 3 1 3 4 3 3 3 3 4 3 1 3 3 3 1 3 3 1 3 2 1 3 3 3 3 4 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 2 1 1 1 1 1 2 1 2 1 1 1 1 1 1 2 2 1 2 1 1 2 1 1 2 1 2 1 1 1 1 1 2 2 1 1 1 1 1 2 1 1 1 1 2 2 NE IL NE IL IL NE NE IL NE IL IL PA IL NE PA IL IL NE PA NE PA PA IL IL PA NE IL PA IL IL NE PA PA 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 36 26 33 19 35 30 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 3 1 3 4 2 3 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 2 2 1 2 1 1 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 2 2 2 2 2 2 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 NE IL IL NE IL NE 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 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 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 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 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 19 44 53 26 38 25 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 3 3 3 3 3 2 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 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 1 2 2 2 1 1 1 1 2 1 1 2 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 PA IL PA NE PA NE 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 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 48 50 42 49 28 22 50 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 1 3 3 3 2 3 3 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 1 1 1 1 1 1 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 1 1 1 1 2 2 2 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 PA PA PA PA PA IL IL 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 26 33 30 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 3 3 2 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 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 1 1 1 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 NE NE IL 32 40 36 20 39 52 29 29 41 52 45 28 46 24 46 52 32 24 30 3 3 3 1 1 3 1 4 1 3 2 3 3 3 2 3 3 3 3 # % # % 1 1 1 2 1 1 2 1 1 1 1 1 2 1 1 1 1 1 2 1 1 1 2 1 1 1 1 1 1 2 1 2 1 1 1 1 2 1 Sales Summary (Provided) Yr Sales 1999 $527,000 2000 $15,367,000 2001 $26,481,000 2002 $41,485,000 2003 $46,274,000 2004 $46,578,000 2005 $48,061,000 2006 $47,987,000 NE PA NE NE PA IL PA NE NE IL PA PA PA IL PA PA PA PA IL # % # % # % Age 2007 2008 2009 2010 2011 2012 2013 2014 2015 $48,057,000 $48,565,000 $48,467,000 $49,846,000 $49,252,000 $50,226,000 $50,844,000 $51,850,000 $51,702,000 Frequency Table by Salary Ranges Bin Range / Upper Limit Labels 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 150000 160000 170000 180000 190000 200000 210000 Up to 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 210+ Graph on next Tab
