CBR 600 Quantitative Analysis Project Your manager, Pat Williams, invites you to meet again to discuss another project. It turns out that Cybertech's competitors have been closing in on market share. Pat asks you to analyze data about the company's workforce and to prepare an analysis of its current composition. The report is due in two weeks. Your quantitative analysis will be used to advise the company's management on the cost of doing business, and how to achieve success and income revenues, as well as make recommendations on the allocation of salaries across the company. Pat explains more about the requirements. Pat asks that your report must consider personnel by organizational roles, salaries, length of service, level of education, age, race, gender, marital status, and region. Pat explains that your analysis will be reviewed to determine how the company's employee demographics compare with industry peers and competitors. You learn that you will present your report to leadership at their quarterly strategic planning meeting. You know that you'll need to use your statistical skills and technical skills to identify and manipulate the data. You'll also need to draw relevant conclusions based on quantitative reasoning. First, sketch out a plan to review your skills in math, statistics, and Excel. Second, you'll need to work through the data to produce supporting charts and graphs. Third, you'll need to complete the analysis well before the due date. Time to get busy. This project will help you advise your company’s management on the cost of doing business, how to achieve success in income revenues, and make recommendations on the allocation of salaries across the company. Management will be able to use your analysis to fairly adjust salary anomalies, and also show profitability which might be used for further investments, hiring additional staff, or even employee incentive pay. During this project, you will use mathematical operations and data analysis to solve problems and inform decision making. Your final assignment will be the creation of a comprehensive Excel workbook with supporting charts and graphs and a short analysis of the data. This project will enable you to refresh and refine your skills in math and statistics before you tackle a real-world data set using Excel to analyze and display the data. Quantitative reasoning uses a process similar to the qualitative research process in that you will first identify an issue or problem and then use mathematical formulas or an analytic tool to derive a solution. You will construct graphs, charts, and tables to display data and inform analysis and interpretation. You will evaluate the results of the information, draw analyses and validate them by applying them to the issue or problem. This project will enable you to see the connection between data and how the use of quantitative analysis of that data informs solutions to practical problems with potential impact on your organization or industry. Here are the steps to completing this project. Step 1: Set Up Your Spreadsheet First download the Excel template attached to this email and use it to set up your spreadsheet. This step has you set up your basic view in preparation for the use of several tools. After you’ve formatted and set up your basic view and saved it with your name (Safea Musa), you’re ready to move to the next step and add data. Step 2: Add Data With your spreadsheet set up and saved with your last name, you're ready to add data. In Section 1 on the Data page, complete each column of the spreadsheet to arrive at the desired calculations. When you're ready, move on to the next step, where you will use functions to summarize the data. Step 3: Use Functions to Summarize the Data With your data built, you are now ready to start using some tools to summarize the data, using Countif and the Sum function to do the math. In this step, you'll begin to see patterns in the data and the story of the workforce. With this step complete, you’re ready to begin your analysis. Step 4: Analyze the Workforce You've summarized the data, and next, you will employ descriptive or summary statistics to analyze the workforce. Your summary table described "how many." Now you will calculate mean, median, and mode for the categories of data, and derive the deviation, variance, and dispersion, and distribution. This is where it gets interesting! Your data set in Tab 1 should now be built. Next, you’ll create Tab 2: Excel Summary Stats. Step 5: Use the Analysis Toolpak With your data set built, you will now use the Analysis Toolpak to do those same functions. This is a handy feature to know. Remember that there may be some minor differences in the answers depending on the version. You should now have Tab 2 complete: Excel Summary Stats. Next, you’ll create charts and a histogram for Tabs 3 and 4. Step 6: Create Charts and a Histogram Where would we be without the ability to view data in charts? It is sometimes easier to grasp context of data if we can see it captured in an image. In this step, you will work with data to create charts, adding a tab for charts, and another for a histogram. In this step, you will build Tab 3: Graphs— Charts and Tab 4: Histogram. After you complete these tabs, you’ll be ready to sort the data. Step 7: Copy and Sort the Data You’ve accomplished a lot with your data set, summary stats, charts, and histograms. Another skill you’ll need to be able to do is sort data in an Excel worksheet for reporting purposes. You’ll copy the data so that you can learn how to sort it. This is a good skill that applies to any Excel application. In this step, you will create Tab 5: Sorted Data. When you’re finished, you’ll be ready to conduct your quantitative analysis. See below for example of sorted spreadsheet. Step 8: Conduct Quantitative Analysis In this step, your hard work bears fruit. What does it all mean? Think back to your boss's reasons for tasking you with this project. Bring your powers of analysis to bear to determine what the data may be telling you. Apply your quantitative reasoning skills by answering the questions provided in the resource and writing a short essay. After you answer the questions, your short essay include: • • • a one-paragraph narrative summary of your findings, describing patterns of interest an explanation of the potential relevance of such patterns a description of how you would investigate further to determine if your results could be perceived as good or bad for the company. Prepare your response in this workbook. Create a tab for Quantitative Analysis, create a text box, and paste your answers to above questions and your essay in it. Move the tab to the first tab position. 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 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 Text Role CEO CIO Sr Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staff Investigator Cyber Analyst Acctg/Fin Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staff Forensics Analyst Physical Security IT Staff Cyber Analyst Cyber Analyst Controller Cyber Analyst Cyber Analyst Cyber Analyst Currency 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 $98,059 Currency Number Year Ending 12/31/2014 Hrly Rate Yrs of Svc 1059 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 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 07/10/09 02/12/09 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 Staff 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 Cyber Analyst Public and Business Office Team $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 $85,822 $93,337 1136 1138 1138 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 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 04/15/00 09/23/13 06/02/07 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 Engineers Cyber Analyst Sr Cyber Investigator Cyber Software Engineer Forensics Analyst $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 $143,377 $150,886 $127,435 1227 1227 1232 1233 1237 1246 1248 1254 1255 1257 1257 1258 1261 1261 1265 1265 1267 1269 1272 1276 1279 1280 1285 1288 1289 1289 1292 1295 1296 1296 1296 1297 1299 1300 05/03/00 04/25/06 07/12/10 05/31/13 08/08/07 07/27/00 07/25/09 02/02/09 03/14/09 08/09/09 03/11/10 07/09/03 04/13/13 06/02/09 03/04/13 07/08/11 2/5/2008 03/14/07 09/18/10 05/04/11 10/20/07 08/11/14 04/04/11 03/25/10 09/05/11 10/22/06 05/13/01 07/08/12 05/05/00 09/15/10 09/23/11 06/06/05 04/08/09 07/10/09 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 Engineers IT Mgr IT Staff Cyber Analyst Acctg/Fin Advertising Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst Logistics Forensics Analyst Investigator Quality Assurance Sr Cyber Investigator Logistics Mgr Cyber Software Engineer $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 $123,487 $169,628 $175,286 $80,637 1300 1308 1308 1308 1314 1315 1315 1317 1320 1320 1320 1323 1325 1329 1332 1339 1341 1343 1343 1346 1350 1356 1357 1357 1364 1364 1373 1373 1378 1379 1381 1387 1387 1387 06/17/09 04/03/10 06/30/01 4/30/2000 1/22/2008 02/15/07 02/07/08 08/12/08 06/18/09 09/01/12 05/07/11 02/05/05 03/15/99 09/20/09 04/12/11 05/01/12 03/07/04 04/15/10 12/18/07 06/12/10 06/21/12 09/19/10 03/15/99 04/08/05 3/16/2008 04/20/05 04/08/09 06/25/07 07/09/10 06/09/07 10/23/10 07/14/09 12/18/07 07/23/05 Cyber Analyst Cyber Software Engineer IT Staff 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 Marketing Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst $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 $121,191 $132,181 $126,163 $145,130 $100,914 1391 1393 1394 1400 1402 1403 1404 1405 1411 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 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 09/05/12 05/03/11 01/22/09 11/06/06 06/25/07 05/07/04 Cyber Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineers Cyber Analyst Public and Business Office Team Forensics Analyst Forensics Analyst Malware Reverse Engineers 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 Engineers Cyber Analyst Admin Sr Cyber Investigator Marketing Public and Business Office Team Cyber Analyst Forensics Analyst Forensics Analyst Public and Business Office Team Admin Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator $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 $123,836 $75,456 $90,705 $99,838 $97,522 $119,997 1461 1466 1466 1468 1471 1474 1476 1477 1477 1481 1484 1492 1496 1498 1498 1504 1504 1505 1506 1507 1513 1515 1517 1519 1519 1523 1525 1527 1529 1531 1533 1539 1541 1543 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 03/15/99 10/16/11 04/07/13 12/28/07 12/15/12 04/09/07 10/06/09 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 Staff Forensics Analyst Cyber Analyst Acctg/Fin Cyber Software Engineer Malware Reverse Engineers Cyber Analyst Acctg/Fin Forensics Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineers Cyber Analyst Forensics Analyst Sr Cyber Investigator Cyber Analyst $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 $99,872 $92,797 $162,412 $95,283 $78,102 $139,128 $85,002 1550 1550 1552 1553 1553 1554 1554 1556 1557 1558 1560 1565 1568 1568 1569 1571 1575 1579 1580 1584 1588 1589 1591 1593 1596 1597 1598 1608 1608 1609 1611 1612 1613 1616 02/19/14 11/14/08 5/30/1999 04/12/09 10/20/07 10/23/13 10/20/06 03/21/09 07/21/04 01/06/05 05/06/12 03/16/07 08/07/12 02/07/10 04/23/10 04/16/09 02/04/09 01/12/05 09/16/10 03/15/99 8/17/2002 04/15/13 7/12/2008 08/15/08 06/12/09 11/20/11 02/15/13 03/15/99 04/15/09 07/20/11 09/23/07 03/06/11 05/04/12 09/15/09 IT Staff 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 Engineers Cyber Analyst Physical Security CFO Cyber Mgr Cyber Analyst Cyber Mgr Public and Business Office Team Cyber Analyst Cyber Analyst Physical Security Cyber Analyst Advertising $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 $89,661 $175,375 $133,258 $83,266 $96,378 $67,800 $82,496 $115,027 1616 1619 1620 1622 1623 1625 1626 1629 1630 1636 1637 1638 1639 1640 1644 1654 1658 1659 1660 1661 1661 1667 1667 1668 1668 1669 1671 1672 1673 1679 1680 1687 1687 1693 08/09/06 11/3/2007 06/07/13 02/06/12 03/04/12 09/12/09 07/08/12 09/04/11 09/12/08 04/17/09 06/07/11 09/01/07 07/30/12 08/13/07 09/05/11 06/07/11 03/22/10 11/02/06 01/14/10 03/18/13 11/18/11 01/15/08 03/14/05 05/01/00 07/10/09 09/05/11 06/13/12 05/04/08 03/07/13 05/18/09 01/06/13 12/15/05 06/02/04 03/15/99 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 Engineers 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 Malware Reverse Engineers Cyber Analyst Sr Forensics Mgr Marketing Acctg/Fin Malware Reverse Engineers Forensics Analyst Cyber Analyst Cyber Software Engineer $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 $161,882 $81,809 $146,546 $117,415 $116,109 $151,226 $97,541 $103,784 $143,678 1709 1723 1723 1726 1733 1736 1736 1737 1741 1744 1744 1744 1745 1748 1749 1750 1750 1754 1756 1756 1757 1760 1760 1764 1767 1770 1771 1773 1774 1776 1776 1779 1779 1782 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 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 Cyber Analyst Forensics Analyst Cyber Analyst Malware Reverse Engineers 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 Engineers Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Cyber Analyst Logistics Cyber Mgr Malware Reverse Engineers Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst $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 $111,360 $138,697 $101,899 $110,999 $148,455 $161,441 $110,198 $113,631 $121,084 $123,903 1785 1785 1785 1787 1789 1793 1793 1793 1794 1796 1797 1800 1800 1802 1803 1804 1809 1812 1813 1814 1815 1816 1819 1820 1821 1822 1824 1829 1830 1831 1835 1836 1840 1841 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 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 Cyber Software Engineer Forensics Analyst Physical Security Acctg/Fin Cyber Analyst Malware Reverse Engineers 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 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 Engineers $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 $84,236 $100,130 $151,691 $80,089 $98,826 $108,928 $135,938 $135,556 $100,199 $108,792 $179,865 1841 1846 1846 1846 1848 1848 1850 1850 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 Cyber Investigator Malware Reverse Engineers Cyber Software Engineer Cyber Analyst Malware Reverse Engineers Forensics Analyst Forensics Analyst Investigator $165,117 $180,113 $140,324 $103,369 $170,722 $98,344 $94,060 $118,068 $41,433,167 Section 2: Complete Summary Tables for Graphing Roles Race Acctg/Fin Admin Advertising CEO CFO CIO Controller COO Cyber Analyst Cyber Mgr Cyber Software Engineer Eng Mgr Forensics Analyst Investigator IT Mgr IT Staff Logistics Logistics Mgr Malware Reverse Engineers Marketing 1 2 3 4 Gender 1 2 Education Level 12 14 16 19 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 Marital Status 1 2 Region Key State PA IL NE Section 3: Complete Descriptive Statistics Descriptive Statistics Mean Median Mode Std Deviation Variance Kurtosis Skewness Max Min = Range Sum Count Salary Hrly Rate Yrs of Svc Text Number Number Number Number Number Text Text Vested Yr 10 Ed 20 19 17 17 14 14 16 14 15 16 15 16 14 16 16 16 12 19 14 14 19 16 16 14 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 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 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 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 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 Region 16 14 16 16 16 14 19 19 16 16 14 14 19 16 14 16 16 16 19 16 12 14 16 14 16 16 16 16 18 17 18 16 14 19 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 32 58 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 3 4 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 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 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 PA PA 16 14 16 14 16 14 14 14 16 16 20 16 16 14 16 14 14 14 19 16 14 14 16 16 16 16 16 19 14 17 16 14 16 16 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 55 30 29 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 2 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 2 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 1 1 1 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 IL PA IL 16 14 12 16 14 14 16 14 16 14 19 18 16 16 16 19 14 16 19 16 14 16 16 16 14 17 14 12 16 12 16 16 16 14 45 41 28 21 38 54 25 34 27 38 28 46 20 33 24 40 35 39 52 32 37 22 26 41 19 40 50 30 36 29 34 41 47 36 3 3 3 3 1 3 3 2 3 3 3 3 3 1 1 3 2 3 3 3 1 3 3 1 1 1 3 3 3 4 3 3 1 3 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 2 1 2 1 2 1 1 1 1 2 1 2 1 2 2 2 1 1 2 1 1 1 1 2 2 2 1 1 1 1 1 1 2 1 1 IL PA IL NE IL IL NE PA PA NE PA NE IL IL NE NE IL NE PA NE NE PA NE NE NE IL PA NE PA IL NE IL PA PA 16 14 16 19 14 14 16 15 16 16 16 14 14 16 12 16 14 16 16 14 12 19 16 19 14 14 14 14 17 16 16 14 16 16 32 31 43 51 35 39 34 35 27 22 31 44 57 25 24 24 32 22 36 31 23 48 52 39 35 44 33 38 28 36 52 26 36 43 3 3 2 3 1 3 4 3 4 4 1 4 3 1 3 3 3 1 1 3 3 3 3 3 3 1 4 3 3 1 3 1 1 3 1 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 2 2 2 2 1 1 2 2 1 2 1 1 2 1 1 2 1 2 1 1 1 1 1 2 2 1 PA NE IL NE IL IL PA PA IL PA NE IL PA PA PA NE PA IL IL PA NE NE PA PA PA IL PA PA PA NE IL NE IL IL 14 14 16 18 16 16 16 16 16 17 16 14 16 16 20 16 14 14 16 16 14 12 16 16 16 17 16 16 16 14 14 12 14 16 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 32 31 34 39 38 41 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 3 4 3 3 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 1 1 1 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 1 2 1 1 1 1 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 NE PA NE IL NE PA 16 14 16 16 14 14 14 16 12 14 14 14 12 14 12 12 12 16 19 18 14 16 16 16 17 16 16 12 16 16 14 17 16 14 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 54 24 32 36 21 36 30 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 3 3 3 3 3 3 3 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 1 1 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 1 1 2 1 2 1 2 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 PA NE PA PA IL IL IL 16 16 14 14 14 16 16 16 12 12 17 14 12 16 16 14 14 14 16 16 14 16 14 12 19 16 16 19 14 16 14 12 16 16 28 33 53 33 38 26 40 27 46 45 21 38 20 32 42 33 34 45 22 54 48 25 35 38 42 34 19 44 53 26 38 25 24 34 1 3 3 1 3 2 3 4 3 2 3 3 3 1 3 4 3 1 3 1 2 3 3 1 3 3 3 3 3 3 3 2 1 3 2 1 1 1 1 2 1 1 1 1 1 1 2 1 2 1 1 1 1 1 1 2 1 2 1 1 1 2 1 1 1 1 1 2 2 1 1 1 1 2 1 2 2 1 2 1 2 2 2 2 1 1 2 2 1 2 1 1 2 1 2 1 1 2 1 1 1 2 IL IL PA NE PA IL NE PA NE PA PA IL IL NE IL PA IL IL PA PA PA IL IL NE PA IL PA IL PA NE PA NE PA PA 19 14 17 12 16 16 17 12 12 16 16 14 16 16 17 16 16 12 16 12 16 14 16 16 14 18 16 16 16 16 17 14 12 19 48 36 18 21 28 31 21 24 36 24 37 38 23 42 19 35 33 40 28 28 23 40 44 35 32 32 23 38 35 39 24 30 46 54 3 3 1 3 2 3 3 1 3 4 4 3 1 3 3 3 1 1 1 3 1 3 3 3 4 3 3 3 3 3 1 1 3 3 1 1 2 2 1 1 2 1 1 1 1 1 1 1 1 2 2 1 2 2 2 1 1 1 1 2 1 1 2 1 1 1 1 1 1 1 2 2 1 1 2 1 1 1 1 2 2 1 2 1 2 2 1 1 2 1 1 1 2 1 1 1 1 1 2 1 1 1 NE NE NE PA IL IL NE IL IL NE PA IL PA PA PA NE PA NE PA IL NE PA PA IL PA PA IL IL IL PA IL NE IL PA 16 14 17 19 20 17 16 16 14 16 19 16 17 16 14 16 16 14 14 16 14 16 17 14 16 16 14 16 17 14 19 17 16 16 43 21 36 56 32 28 33 52 34 45 32 36 28 35 56 22 31 48 50 42 49 28 22 50 44 48 44 42 33 30 54 28 43 46 1 3 1 3 1 3 3 3 3 3 1 3 4 3 1 3 1 1 3 3 3 2 3 3 3 3 3 3 3 3 3 3 3 1 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 2 2 1 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 1 1 1 2 1 2 1 1 1 1 IL PA PA PA PA PA IL PA IL PA NE NE PA PA NE NE IL PA PA PA PA PA IL IL IL NE PA PA NE IL PA NE IL NE 16 16 12 16 14 19 14 19 16 19 14 14 14 14 16 16 14 14 14 16 16 14 14 12 14 16 16 14 14 17 18 14 14 16 50 25 32 45 35 54 40 50 24 43 44 32 54 35 45 46 50 30 47 53 26 33 30 32 40 36 20 39 52 29 29 41 52 45 3 4 3 3 3 1 3 3 3 3 2 1 3 4 3 1 1 1 1 1 3 3 2 3 3 3 1 1 3 1 4 1 3 2 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 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 1 1 1 2 1 1 1 1 1 1 2 IL IL PA IL PA IL IL IL PA PA NE PA PA NE PA PA NE PA IL PA NE NE IL NE PA NE NE PA IL PA NE NE IL PA 18 14 16 19 14 19 16 12 28 46 24 46 52 32 24 30 3 3 3 2 3 3 3 3 # % # % # % African-Am Asian Caucasian Hispanic Male Female n Level HS AA BA/BS Masters+ 1 2 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 2007 $48,057,000 2008 $48,565,000 2009 $48,467,000 2010 $49,846,000 2011 $49,252,000 2012 $50,226,000 2013 $50,844,000 2014 $51,850,000 2015 $51,702,000 PA PA IL PA PA PA PA IL Status Married Single Region Northeast Midwest C-Plains Ed # % # % Age Frequency Table by Salary Ranges Bin Range/Up per Limit 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 Labels 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 Graph on next Tab 150000 160000 170000 180000 190000 200000 210000 141-150 151-160 161-170 171-180 181-190 191-200 210+ 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. 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 w 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 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, from 1 have been steady since the first years, but investors want to know what the projected sales will be in 2017. One method for determining this value is to calculate the average percentage growth, based on historical trends. For example, if Year 1 and grew to $5,000 in Year 5, the average percentage growth between these years was 600% as shown below: This represents a growth of $5,000-$200 = $4,800 in a time of 4 years (from Year 1 to Year 5), ie an average growth in sales of $4,800/4 = $1,200 per year. Expressed as a percentage = (1200/200 )* 100% = 600% (note the initial year of sales is used as a denominator to determine percent Figure it like this: ((5000-200)/4*200)*100 = 600% i.e., ((Final year sales figure - Initial year sales figure) / Number of year * Sale in initial year figure) *100%. Projected Sale for next year = Sale for this year + expected sales growth. Projected Sale for next year = Sale for this year + (Average percentage growth * Sales of this year). Using this info and the data in Section 3, calculate the average percentage growth for 1999–2015 and projected sales for 2016 and 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe you 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, d From your "Graph Charts" spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how the company was meeting expectations on these characteristics. 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 number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings. 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 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 understood. Supporting narrative is helpful. Never simply provide a "raw data" dump. Instead, seek to provide information! Structure your essay like this: a. b. c. 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 n, you will answer five 141,000–$190,000. This m 1999 to 2014. Sales ple, if sales were $200 in mine percentage growth) 016 and 2017. the more narrow the describe your standard erse, dynamic workforce. ow you would determine if o know an estimate of the his is important. While you e way it should be any. answers.) 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 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 Text Role CEO CIO Sr Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staff Investigator Cyber Analyst Acctg/Fin Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staff Forensics Analyst Physical Security IT Staff Cyber Analyst Cyber Analyst Controller Cyber Analyst Cyber Analyst Cyber Analyst Currency 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 $98.059 Currency Number Year Ending 12/31/2014 Hrly Rate Yrs of Svc 1059 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 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 07/10/09 02/12/09 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 Staff 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 Cyber Analyst Public and Business Office Team $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 $85.822 $93.337 1136 1138 1138 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 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 04/15/00 09/23/13 06/02/07 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 Engineers Cyber Analyst Sr Cyber Investigator Cyber Software Engineer Forensics Analyst $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 $143.377 $150.886 $127.435 1227 1227 1232 1233 1237 1246 1248 1254 1255 1257 1257 1258 1261 1261 1265 1265 1267 1269 1272 1276 1279 1280 1285 1288 1289 1289 1292 1295 1296 1296 1296 1297 1299 1300 05/03/00 04/25/06 07/12/10 05/31/13 08/08/07 07/27/00 07/25/09 02/02/09 03/14/09 08/09/09 03/11/10 07/09/03 04/13/13 06/02/09 03/04/13 07/08/11 2/5/2008 03/14/07 09/18/10 05/04/11 10/20/07 08/11/14 04/04/11 03/25/10 09/05/11 10/22/06 05/13/01 07/08/12 05/05/00 09/15/10 09/23/11 06/06/05 04/08/09 07/10/09 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 Engineers IT Mgr IT Staff Cyber Analyst Acctg/Fin Advertising Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst Logistics Forensics Analyst Investigator Quality Assurance Sr Cyber Investigator Logistics Mgr Cyber Software Engineer $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 $123.487 $169.628 $175.286 $80.637 1300 1308 1308 1308 1314 1315 1315 1317 1320 1320 1320 1323 1325 1329 1332 1339 1341 1343 1343 1346 1350 1356 1357 1357 1364 1364 1373 1373 1378 1379 1381 1387 1387 1387 06/17/09 04/03/10 06/30/01 4/30/2000 1/22/2008 02/15/07 02/07/08 08/12/08 06/18/09 09/01/12 05/07/11 02/05/05 03/15/99 09/20/09 04/12/11 05/01/12 03/07/04 04/15/10 12/18/07 06/12/10 06/21/12 09/19/10 03/15/99 04/08/05 3/16/2008 04/20/05 04/08/09 06/25/07 07/09/10 06/09/07 10/23/10 07/14/09 12/18/07 07/23/05 Cyber Analyst Cyber Software Engineer IT Staff 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 Marketing Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst $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 $121.191 $132.181 $126.163 $145.130 $100.914 1391 1393 1394 1400 1402 1403 1404 1405 1411 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 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 09/05/12 05/03/11 01/22/09 11/06/06 06/25/07 05/07/04 Cyber Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineers Cyber Analyst Public and Business Office Team Forensics Analyst Forensics Analyst Malware Reverse Engineers 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 Engineers Cyber Analyst Admin Sr Cyber Investigator Marketing Public and Business Office Team Cyber Analyst Forensics Analyst Forensics Analyst Public and Business Office Team Admin Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator $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 $123.836 $75.456 $90.705 $99.838 $97.522 $119.997 1461 1466 1466 1468 1471 1474 1476 1477 1477 1481 1484 1492 1496 1498 1498 1504 1504 1505 1506 1507 1513 1515 1517 1519 1519 1523 1525 1527 1529 1531 1533 1539 1541 1543 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 03/15/99 10/16/11 04/07/13 12/28/07 12/15/12 04/09/07 10/06/09 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 Staff Forensics Analyst Cyber Analyst Acctg/Fin Cyber Software Engineer Malware Reverse Engineers Cyber Analyst Acctg/Fin Forensics Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineers Cyber Analyst Forensics Analyst Sr Cyber Investigator Cyber Analyst $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 $99.872 $92.797 $162.412 $95.283 $78.102 $139.128 $85.002 1550 1550 1552 1553 1553 1554 1554 1556 1557 1558 1560 1565 1568 1568 1569 1571 1575 1579 1580 1584 1588 1589 1591 1593 1596 1597 1598 1608 1608 1609 1611 1612 1613 1616 02/19/14 11/14/08 5/30/1999 04/12/09 10/20/07 10/23/13 10/20/06 03/21/09 07/21/04 01/06/05 05/06/12 03/16/07 08/07/12 02/07/10 04/23/10 04/16/09 02/04/09 01/12/05 09/16/10 03/15/99 8/17/2002 04/15/13 7/12/2008 08/15/08 06/12/09 11/20/11 02/15/13 03/15/99 04/15/09 07/20/11 09/23/07 03/06/11 05/04/12 09/15/09 IT Staff 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 Engineers Cyber Analyst Physical Security CFO Cyber Mgr Cyber Analyst Cyber Mgr Public and Business Office Team Cyber Analyst Cyber Analyst Physical Security Cyber Analyst Advertising $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 $89.661 $175.375 $133.258 $83.266 $96.378 $67.800 $82.496 $115.027 1616 1619 1620 1622 1623 1625 1626 1629 1630 1636 1637 1638 1639 1640 1644 1654 1658 1659 1660 1661 1661 1667 1667 1668 1668 1669 1671 1672 1673 1679 1680 1687 1687 1693 08/09/06 11/3/2007 06/07/13 02/06/12 03/04/12 09/12/09 07/08/12 09/04/11 09/12/08 04/17/09 06/07/11 09/01/07 07/30/12 08/13/07 09/05/11 06/07/11 03/22/10 11/02/06 01/14/10 03/18/13 11/18/11 01/15/08 03/14/05 05/01/00 07/10/09 09/05/11 06/13/12 05/04/08 03/07/13 05/18/09 01/06/13 12/15/05 06/02/04 03/15/99 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 Engineers 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 Malware Reverse Engineers Cyber Analyst Sr Forensics Mgr Marketing Acctg/Fin Malware Reverse Engineers Forensics Analyst Cyber Analyst Cyber Software Engineer $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 $161.882 $81.809 $146.546 $117.415 $116.109 $151.226 $97.541 $103.784 $143.678 1709 1723 1723 1726 1733 1736 1736 1737 1741 1744 1744 1744 1745 1748 1749 1750 1750 1754 1756 1756 1757 1760 1760 1764 1767 1770 1771 1773 1774 1776 1776 1779 1779 1782 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 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 Cyber Analyst Forensics Analyst Cyber Analyst Malware Reverse Engineers 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 Engineers Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Cyber Analyst Logistics Cyber Mgr Malware Reverse Engineers Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst $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 $111.360 $138.697 $101.899 $110.999 $148.455 $161.441 $110.198 $113.631 $121.084 $123.903 1785 1785 1785 1787 1789 1793 1793 1793 1794 1796 1797 1800 1800 1802 1803 1804 1809 1812 1813 1814 1815 1816 1819 1820 1821 1822 1824 1829 1830 1831 1835 1836 1840 1841 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 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 Cyber Software Engineer Forensics Analyst Physical Security Acctg/Fin Cyber Analyst Malware Reverse Engineers 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 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 $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 $84.236 $100.130 $151.691 $80.089 $98.826 $108.928 $135.938 $135.556 $100.199 $108.792 $179.865 1841 1846 1846 1846 1848 1848 1850 1850 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 Cyber Investigator Malware Reverse Engineer Cyber Software Engineer Cyber Analyst Malware Reverse Engineer Forensics Analyst Forensics Analyst Investigator $165.117 $180.113 $140.324 $103.369 $170.722 $98.344 $94.060 $118.068 Section 2: Complete Summary Tables for Graphing Roles Acctg/Fin Admin Advertising CEO CFO CIO Controller COO Cyber Analyst Cyber Mgr Cyber Software Engineer Eng Mgr Forensics Analyst Investigator IT Mgr IT Staff Logistics Logistics Mgr Malware Reverse Engineers Marketing # Race 1 2 3 4 Gender 1 2 Education Level 12 14 16 19 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 Marital Status 1 2 Region Key State PA IL NE Section 3: Complete Descriptive Statistics Descriptive Statistics Mean Median Mode Std Deviation Variance Kurtosis Skewness Max Min = Range Sum Count Salary Hrly Rate Yrs of Svc General Number General Number Number Number Text General 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 14 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 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 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 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 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 Region 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 14 19 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 32 58 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 3 4 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 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 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 PA PA 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 16 16 16 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 55 30 29 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 2 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 2 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 1 1 1 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 IL PA IL 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 16 16 16 14 45 41 28 21 38 54 25 34 27 38 28 46 20 33 24 40 35 39 52 32 37 22 26 41 19 40 50 30 36 29 34 41 47 36 3 3 3 3 1 3 3 2 3 3 3 3 3 1 1 3 2 3 3 3 1 3 3 1 1 1 3 3 3 4 3 3 1 3 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 2 1 2 1 2 1 1 1 1 2 1 2 1 2 2 2 1 1 2 1 1 1 1 2 2 2 1 1 1 1 1 1 2 1 1 IL PA IL NE IL IL NE PA PA NE PA NE IL IL NE NE IL NE PA NE NE PA NE NE NE IL PA NE PA IL NE IL PA PA 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 116 16 16 14 16 16 32 31 43 51 35 39 34 35 27 22 31 44 57 25 24 24 32 22 36 31 23 48 52 39 35 44 33 38 28 36 52 26 36 43 3 3 2 3 1 3 4 3 4 4 1 4 3 1 3 3 3 1 1 3 3 3 3 3 3 1 4 3 3 1 3 1 1 3 1 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 2 2 2 2 1 1 2 2 1 2 1 1 2 1 1 2 1 2 1 1 1 1 1 2 2 1 PA NE IL NE IL IL PA PA IL PA NE IL PA PA PA NE PA IL IL PA NE NE PA PA PA IL PA PA PA NE IL NE IL IL 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 16 14 14 14 14 16 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 32 31 34 39 38 41 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 3 4 3 3 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 1 1 1 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 1 2 1 1 1 1 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 NE PA NE IL NE PA 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 14 14 16 14 14 16 14 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 54 24 32 36 21 36 30 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 3 3 3 3 3 3 3 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 1 1 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 1 1 2 1 2 1 2 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 PA NE PA PA IL IL IL 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 12 19 16 14 14 12 14 16 28 33 53 33 38 26 40 27 46 45 21 38 20 32 42 33 34 45 22 54 48 25 35 38 42 34 19 44 53 26 38 25 24 34 1 3 3 1 3 2 3 4 3 2 3 3 3 1 3 4 3 1 3 1 2 3 3 1 3 3 3 3 3 3 3 2 1 3 2 1 1 1 1 2 1 1 1 1 1 1 2 1 2 1 1 1 1 1 1 2 1 2 1 1 1 2 1 1 1 1 1 2 2 1 1 1 1 2 1 2 2 1 2 1 2 2 2 2 1 1 2 2 1 2 1 1 2 1 2 1 1 2 1 1 1 2 IL IL PA NE PA IL NE PA NE PA PA IL IL NE IL PA IL IL PA PA PA IL IL NE PA IL PA IL PA NE PA NE PA PA 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 16 16 16 16 16 16 14 16 19 48 36 18 21 28 31 21 24 36 24 37 38 23 42 19 35 33 40 28 28 23 40 44 35 32 32 23 38 35 39 24 30 46 54 3 3 1 3 2 3 3 1 3 4 4 3 1 3 3 3 1 1 1 3 1 3 3 3 4 3 3 3 3 3 1 1 3 3 1 1 2 2 1 1 2 1 1 1 1 1 1 1 1 2 2 1 2 2 2 1 1 1 1 2 1 1 2 1 1 1 1 1 1 1 2 2 1 1 2 1 1 1 1 2 2 1 2 1 2 2 1 1 2 1 1 1 2 1 1 1 1 1 2 1 1 1 NE NE NE PA IL IL NE IL IL NE PA IL PA PA PA NE PA NE PA IL NE PA PA IL PA PA IL IL IL PA IL NE IL PA 16 16 16 19 19 16 16 16 14 16 14 16 16 16 14 16 16 14 16 19 16 16 16 14 16 16 16 16 16 14 19 16 16 16 43 21 36 56 32 28 33 52 34 45 32 36 28 35 56 22 31 48 50 42 49 28 22 50 44 48 44 42 33 30 54 28 43 46 1 3 1 3 1 3 3 3 3 3 1 3 4 3 1 3 1 1 3 3 3 2 3 3 3 3 3 3 3 3 3 3 3 1 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 2 2 1 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 1 1 1 2 1 2 1 1 1 1 IL PA PA PA PA PA IL PA IL PA NE NE PA PA NE NE IL PA PA PA PA PA IL IL IL NE PA PA NE IL PA NE IL NE 19 16 12 16 14 19 12 19 16 19 19 14 16 16 16 16 16 14 16 16 14 14 14 12 14 16 16 14 14 16 16 14 14 19 50 25 32 45 35 54 40 50 24 43 44 32 54 35 45 46 50 30 47 53 26 33 30 32 40 36 20 39 52 29 29 41 52 45 3 4 3 3 3 1 3 3 3 3 2 1 3 4 3 1 1 1 1 1 3 3 2 3 3 3 1 1 3 1 4 1 3 2 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 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 1 1 1 2 1 1 1 1 1 1 2 IL IL PA IL PA IL IL IL PA PA NE PA PA NE PA PA NE PA IL PA NE NE IL NE PA NE NE PA IL PA NE NE IL PA 19 19 16 16 19 14 14 16 28 46 24 46 52 32 24 30 3 3 3 2 3 3 3 3 # % # % # % African-Am Asian Caucasian Hispanic TOTAL Male Female TOTAL n Level HS AA BA/BS Masters+ TOTAL 1 2 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 2007 $48.057.000 2008 $48.565.000 2009 $48.467.000 2010 $49.846.000 2011 $49.252.000 2012 $50.226.000 2013 $50.844.000 2014 $51.850.000 2015 $51.702.000 PA PA IL PA PA PA PA IL Status Married Single TOTAL # % Region Northeast Midwest C-Plains TOTAL # % Ed Age Frequency Table by Salary Ranges Bin Range / Upper Limit 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 Labels 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 Graph on next Tab 150000 160000 170000 180000 190000 200000 210000 141-150 151-160 161-170 171-180 181-190 191-200 210+
Purchase answer to see full attachment