week 5
jkceaqc312
TemplateforWorkforceCompositionAnalysis.xlsxQR Questions_Responses
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 answer 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–$110,000 or $131,000–$170,000. This may indicate a reasonable promotion rate for new and seasoned 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 in the first two years were notably lower. Assuming that the sales are linear, please use the Forecast tool to find projected sales for 2020 thru 2024. Hint: An easy way to do this is to highlight the sales from the data page and apply the Forecast tool to this data or use the forecast function in excel. You will generate a chart on a new sheet with projected sales; rename this sheet "Projected Sales". 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, in general, the more narrow the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe your standard deviations of Salary, Hryly Rate, Yrs Worked, Education, and Age. 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 how 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 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 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. Never simply provide a "raw data" dump. Instead, seek to provide information! Structure your essay like this: a. Write a one-paragraph narrative summary of your findings, describing patterns of interest. b. Provide an explanation of the potential relevance of such patterns. c. 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, or you can copy and paste from another document.)
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 | General | Currency | Currency | Number | General | Number | General | Number | Number | Number | Text | General |
| mm/dd/yy | |||||||||||||
| Year Ending | Vested Yr | ||||||||||||
| 12/31/19 | 10 | ||||||||||||
| Emp # | Hire Date | Role | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Vested | Race | Gender | Status | State | Region |
| 4000 | 4/23/15 | Sr Cyber Investigator | $92,267 | 19 | 35 | 3 | 1 | 1 | IL | ||||
| 4004 | 7/13/02 | Cyber Analyst | $111,801 | 16 | 60 | 3 | 1 | 1 | IL | ||||
| 4010 | 11/25/18 | Forensics Analyst | $90,688 | 16 | 23 | 1 | 2 | 2 | PA | ||||
| 4012 | 1/26/10 | Cyber Analyst | $95,985 | 14 | 43 | 1 | 1 | 1 | NE | ||||
| 4013 | 12/29/11 | Cyber Analyst | $100,520 | 19 | 44 | 3 | 1 | 1 | IL | ||||
| 4014 | 10/2/11 | Forensics Analyst | $125,156 | 19 | 31 | 1 | 1 | 1 | IL | ||||
| 4015 | 1/1/12 | Cyber Analyst | $78,475 | 16 | 40 | 3 | 1 | 2 | PA | ||||
| 4020 | 5/9/11 | Cyber Analyst | $93,518 | 14 | 39 | 1 | 1 | 1 | PA | ||||
| 4022 | 5/27/04 | Cyber Analyst | $69,529 | 16 | 53 | 3 | 1 | 1 | PA | ||||
| 4023 | 2/6/14 | Advertising | $128,384 | 16 | 28 | 1 | 2 | 2 | NE | ||||
| 4025 | 12/12/14 | Cyber Mgr | $151,174 | 16 | 38 | 3 | 1 | 1 | PA | ||||
| 4027 | 8/19/06 | Sr Cyber Investigator | $71,914 | 16 | 51 | 1 | 1 | 1 | NE | ||||
| 4029 | 6/5/11 | Cyber Analyst | $152,446 | 14 | 36 | 4 | 1 | 2 | IL | ||||
| 4030 | 7/10/11 | IT Staff | $57,727 | 16 | 51 | 3 | 1 | 1 | IL | ||||
| 4031 | 10/20/13 | Cyber Software Engineer | $78,869 | 16 | 39 | 3 | 1 | 1 | PA | ||||
| 4034 | 5/21/06 | IT Staff | $90,930 | 19 | 45 | 3 | 1 | 1 | PA | ||||
| 4037 | 9/13/13 | Forensics Analyst | $67,866 | 14 | 25 | 3 | 1 | 2 | PA | ||||
| 4038 | 4/14/12 | Cyber Analyst | $64,580 | 16 | 40 | 1 | 1 | 1 | PA | ||||
| 4039 | 5/30/13 | Cyber Analyst | $91,771 | 16 | 30 | 3 | 1 | 2 | PA | ||||
| 4044 | 12/3/15 | Cyber Analyst | $59,219 | 14 | 35 | 3 | 1 | 2 | NE | ||||
| 4045 | 6/7/16 | Physical Security | $32,367 | 12 | 25 | 3 | 2 | 2 | NE | ||||
| 4046 | 9/4/06 | Cyber Analyst | $115,974 | 16 | 54 | 1 | 1 | 1 | PA | ||||
| 4055 | 6/17/18 | IT Staff | $99,786 | 14 | 31 | 1 | 2 | 2 | PA | ||||
| 4060 | 2/1/12 | Sr Cyber Investigator | $73,650 | 19 | 42 | 3 | 1 | 1 | IL | ||||
| 4061 | 2/28/12 | Cyber Analyst | $154,933 | 16 | 34 | 3 | 1 | 2 | PA | ||||
| 4064 | 1/18/16 | Cyber Analyst | $144,571 | 16 | 36 | 4 | 1 | 2 | PA | ||||
| 4067 | 10/29/12 | Malware Reverse Engineer | $124,996 | 16 | 49 | 2 | 1 | 2 | PA | ||||
| 4068 | 7/15/03 | Cyber Analyst | $145,776 | 16 | 59 | 3 | 1 | 1 | IL | ||||
| 4070 | 4/4/17 | Forensics Analyst | $80,191 | 16 | 28 | 1 | 1 | 1 | PA | ||||
| 4075 | 10/2/16 | Forensics Analyst | $75,053 | 14 | 25 | 3 | 1 | 2 | IL | ||||
| 4078 | 7/15/09 | Cyber Analyst | $83,851 | 16 | 51 | 1 | 1 | 1 | PA | ||||
| 4082 | 7/2/15 | Cyber Analyst | $82,411 | 16 | 37 | 3 | 1 | 1 | IL | ||||
| 4086 | 9/18/07 | Cyber Analyst | $114,721 | 14 | 51 | 3 | 1 | 1 | PA | ||||
| 4088 | 7/18/17 | Public and Business Office Team | $108,342 | 16 | 34 | 3 | 2 | 1 | IL | ||||
| 4089 | 10/16/16 | Cyber Software Engineer | $81,050 | 16 | 36 | 3 | 1 | 1 | PA | ||||
| 4090 | 11/15/15 | Cyber Analyst | $87,641 | 14 | 33 | 4 | 1 | 2 | IL | ||||
| 4092 | 7/7/08 | Forensics Analyst | $98,943 | 16 | 36 | 3 | 1 | 1 | PA | ||||
| 4093 | 8/25/10 | Cyber Analyst | $93,936 | 19 | 47 | 3 | 1 | 2 | NE | ||||
| 4095 | 12/31/04 | Cyber Analyst | $133,678 | 16 | 52 | 3 | 1 | 1 | PA | ||||
| 4097 | 2/26/07 | Cyber Analyst | $162,731 | 16 | 53 | 1 | 1 | 2 | IL | ||||
| 4104 | 7/21/08 | Logistics | $71,690 | 16 | 51 | 3 | 2 | 1 | PA | ||||
| 4106 | 5/7/17 | Public and Business Office Team | $150,263 | 16 | 57 | 3 | 1 | 1 | IL | ||||
| 4107 | 11/5/13 | Cyber Analyst | $78,334 | 19 | 34 | 3 | 1 | 1 | PA | ||||
| 4118 | 8/13/17 | IT Mgr | $154,933 | 16 | 24 | 3 | 1 | 1 | IL | ||||
| 4119 | 8/31/16 | Cyber Analyst | $86,384 | 16 | 26 | 3 | 1 | 2 | IL | ||||
| 4120 | 8/30/13 | Sr Cyber Investigator | $127,190 | 16 | 34 | 3 | 1 | 1 | IL | ||||
| 4121 | 8/31/11 | Cyber Analyst | $148,111 | 16 | 36 | 2 | 1 | 1 | NE | ||||
| 4122 | 8/4/14 | Cyber Analyst | $86,147 | 16 | 39 | 2 | 1 | 1 | IL | ||||
| 4126 | 12/24/16 | Cyber Analyst | $60,641 | 16 | 34 | 4 | 1 | 1 | NE | ||||
| 4128 | 5/16/03 | Cyber Analyst | $126,426 | 14 | 56 | 3 | 1 | 1 | PA | ||||
| 4133 | 5/29/12 | Forensics Analyst | $119,165 | 16 | 31 | 4 | 1 | 1 | PA | ||||
| 4134 | 6/30/17 | Acctg/Fin | $98,007 | 19 | 28 | 1 | 1 | 2 | PA | ||||
| 4135 | 2/24/16 | Forensics Analyst | $76,956 | 16 | 26 | 3 | 1 | 2 | NE | ||||
| 4137 | 1/14/09 | Cyber Analyst | $98,634 | 16 | 52 | 3 | 1 | 1 | NE | ||||
| 4139 | 2/20/14 | Cyber Analyst | $87,056 | 16 | 41 | 3 | 1 | 1 | IL | ||||
| 4144 | 12/4/17 | Sr Cyber Investigator | $96,062 | 16 | 31 | 4 | 2 | 1 | IL | ||||
| 4146 | 12/4/11 | Cyber Analyst | $104,961 | 16 | 41 | 1 | 1 | 1 | PA | ||||
| 4147 | 9/30/17 | Cyber Analyst | $122,352 | 16 | 28 | 3 | 2 | 2 | IL | ||||
| 4150 | 9/6/17 | Physical Security | $33,367 | 12 | 22 | 1 | 1 | 1 | IL | ||||
| 4152 | 7/19/12 | Cyber Analyst | $151,523 | 16 | 41 | 1 | 1 | 1 | NE | ||||
| 4155 | 7/16/01 | Public and Business Office Team | $89,522 | 19 | 68 | 3 | 1 | 1 | NE | ||||
| 4163 | 9/11/14 | Cyber Analyst | $74,419 | 14 | 38 | 1 | 1 | 1 | IL | ||||
| 4167 | 8/26/05 | Cyber Analyst | $111,536 | 16 | 51 | 1 | 1 | 1 | NE | ||||
| 4169 | 3/14/14 | Acctg/Fin | $65,100 | 14 | 40 | 3 | 2 | 1 | PA | ||||
| 4175 | 11/29/11 | Cyber Software Engineer | $162,731 | 16 | 54 | 3 | 1 | 1 | NE | ||||
| 4176 | 11/23/17 | Cyber Analyst | $135,533 | 14 | 28 | 3 | 1 | 1 | IL | ||||
| 4177 | 3/26/12 | Sr Cyber Investigator | $82,515 | 16 | 39 | 1 | 1 | 2 | PA | ||||
| 4181 | 7/15/03 | Cyber Analyst | $123,391 | 12 | 59 | 3 | 1 | 1 | IL | ||||
| 4183 | 10/29/14 | IT Staff | $65,126 | 16 | 38 | 1 | 1 | 1 | NE | ||||
| 4186 | 3/9/18 | Sr Public and Business Office Team Mgr | $172,291 | 16 | 57 | 1 | 1 | 1 | IL | ||||
| 4189 | 4/24/11 | Physical Security | $53,669 | 14 | 42 | 1 | 2 | 1 | PA | ||||
| 4191 | 7/11/04 | Acctg/Fin | $71,026 | 16 | 49 | 3 | 1 | 2 | NE | ||||
| 4193 | 10/27/15 | Sr Cyber Investigator | $125,004 | 16 | 32 | 1 | 2 | 1 | PA | ||||
| 4198 | 6/5/17 | Forensics Analyst | $73,447 | 14 | 27 | 3 | 1 | 2 | IL | ||||
| 4199 | 7/16/12 | Cyber Analyst | $151,174 | 16 | 38 | 3 | 1 | 1 | NE | ||||
| 4204 | 12/14/13 | Cyber Analyst | $61,212 | 14 | 43 | 1 | 1 | 1 | IL | ||||
| 4205 | 11/26/14 | Cyber Analyst | $106,640 | 14 | 40 | 4 | 2 | 1 | IL | ||||
| 4207 | 6/22/14 | Cyber Analyst | $91,205 | 14 | 37 | 3 | 1 | 1 | NE | ||||
| 4208 | 2/15/16 | IT Staff | $61,383 | 14 | 26 | 3 | 1 | 1 | IL | ||||
| 4212 | 4/4/19 | Public and Business Office Team | $61,068 | 16 | 37 | 3 | 1 | 1 | NE | ||||
| 4214 | 5/9/13 | Advertising | $145,776 | 19 | 30 | 3 | 2 | 2 | IL | ||||
| 4218 | 11/30/06 | Cyber Analyst | $99,130 | 14 | 50 | 3 | 1 | 1 | IL | ||||
| 4220 | 9/17/06 | Cyber Analyst | $164,033 | 16 | 54 | 3 | 1 | 1 | PA | ||||
| 4221 | 7/10/11 | Malware reverse engineer | $74,000 | 19 | 40 | 3 | 2 | 2 | IL | ||||
| 4225 | 8/1/04 | Quality Assurance | $63,125 | 16 | 54 | 3 | 1 | 1 | PA | ||||
| 4232 | 4/9/13 | Cyber Analyst | $86,787 | 16 | 34 | 1 | 2 | 1 | IL | ||||
| 4237 | 11/2/14 | IT Staff | $95,957 | 16 | 41 | 3 | 2 | 1 | IL | ||||
| 4238 | 6/24/18 | Malware Reverse Engineer | $101,386 | 16 | 27 | 1 | 1 | 2 | PA | ||||
| 4239 | 1/6/17 | Investigator | $78,985 | 16 | 33 | 3 | 1 | 2 | IL | ||||
| 4247 | 11/23/19 | Forensics Analyst | $105,069 | 16 | 21 | 1 | 1 | 2 | IL | ||||
| 4249 | 8/17/07 | Sr Cyber Investigator | $107,496 | 16 | 43 | 1 | 1 | 1 | PA | ||||
| 4252 | 3/23/16 | Forensics Analyst | $97,885 | 16 | 28 | 1 | 1 | 1 | PA | ||||
| 4253 | 11/18/13 | Malware reverse engineer | $86,377 | 14 | 40 | 1 | 1 | 2 | IL | ||||
| 4257 | 7/11/03 | Cyber Mgr | $104,220 | 19 | 51 | 3 | 2 | 1 | PA | ||||
| 4258 | 1/24/13 | Cyber Analyst | $58,540 | 14 | 44 | 1 | 1 | 1 | IL | ||||
| 4259 | 9/4/04 | Forensics Analyst | $106,267 | 16 | 40 | 3 | 1 | 1 | PA | ||||
| 4260 | 9/19/15 | Cyber Analyst | $88,743 | 14 | 27 | 3 | 1 | 2 | IL | ||||
| 4265 | 6/24/13 | Cyber Analyst | $81,042 | 16 | 30 | 3 | 1 | 2 | NE | ||||
| 4271 | 8/5/11 | Sr Cyber Investigator | $72,213 | 16 | 41 | 3 | 1 | 1 | PA | ||||
| 4272 | 7/18/14 | Admin | $78,873 | 12 | 36 | 1 | 2 | 2 | PA | ||||
| 4274 | 12/8/14 | Cyber Analyst | $87,092 | 16 | 30 | 3 | 1 | 1 | NE | ||||
| 4278 | 9/6/10 | Cyber Analyst | $90,153 | 14 | 40 | 4 | 1 | 1 | NE | ||||
| 4279 | 11/3/17 | Investigator | $95,220 | 19 | 31 | 2 | 1 | 1 | IL | ||||
| 4284 | 12/16/10 | Forensics Analyst | $143,063 | 14 | 36 | 1 | 1 | 1 | PA | ||||
| 4285 | 3/30/11 | Cyber Analyst | $80,909 | 16 | 40 | 1 | 1 | 1 | IL | ||||
| 4287 | 2/5/14 | Cyber Analyst | $63,777 | 14 | 35 | 3 | 1 | 2 | PA | ||||
| 4291 | 12/25/15 | Cyber Analyst | $66,938 | 16 | 39 | 3 | 1 | 1 | IL | ||||
| 4296 | 12/9/07 | Cyber Analyst | $150,868 | 16 | 53 | 2 | 1 | 1 | NE | ||||
| 4298 | 8/28/07 | Logistics | $83,294 | 16 | 49 | 3 | 1 | 2 | PA | ||||
| 4299 | 6/1/11 | Cyber Analyst | $76,158 | 16 | 38 | 4 | 1 | 1 | NE | ||||
| 4300 | 7/10/18 | Cyber Analyst | $108,866 | 16 | 27 | 1 | 2 | 1 | PA | ||||
| 4301 | 11/7/13 | Sr Forensics Mgr | $96,582 | 19 | 40 | 1 | 1 | 1 | NE | ||||
| 4302 | 3/8/17 | Marketing | $87,519 | 16 | 37 | 3 | 2 | 1 | IL | ||||
| 4303 | 1/19/18 | Cyber Software Engineer | $113,246 | 19 | 34 | 2 | 1 | 1 | PA | ||||
| 4304 | 6/1/06 | Cyber Software Engineer | $81,779 | 16 | 51 | 3 | 1 | 1 | NE | ||||
| 4305 | 7/27/16 | Cyber Analyst | $78,015 | 16 | 31 | 3 | 1 | 1 | PA | ||||
| 4307 | 8/27/07 | Sr Cyber Investigator | $73,807 | 16 | 46 | 3 | 1 | 2 | IL | ||||
| 4310 | 1/21/11 | Cyber Analyst | $108,326 | 19 | 41 | 3 | 1 | 1 | PA | ||||
| 4311 | 12/13/15 | Cyber Analyst | $92,847 | 16 | 31 | 3 | 1 | 1 | IL | ||||
| 4313 | 11/11/10 | Physical Security | $39,808 | 16 | 46 | 1 | 1 | 1 | PA | ||||
| 4314 | 12/28/05 | Cyber Analyst | $98,771 | 19 | 59 | 1 | 1 | 1 | IL | ||||
| 4316 | 10/7/17 | Sr Cyber Analyst | $149,466 | 16 | 31 | 4 | 1 | 1 | IL | ||||
| 4319 | 12/3/13 | Forensics Analyst | $63,933 | 19 | 34 | 3 | 1 | 2 | IL | ||||
| 4324 | 6/4/11 | Public and Business Office Team | $87,409 | 14 | 58 | 4 | 1 | 1 | IL | ||||
| 4326 | 5/3/12 | Cyber Analyst | $65,955 | 14 | 39 | 3 | 1 | 1 | NE | ||||
| 4327 | 1/29/12 | Malware Reverse Engineer | $68,226 | 16 | 54 | 3 | 1 | 1 | PA | ||||
| 4329 | 6/21/10 | Cyber Analyst | $119,537 | 19 | 47 | 4 | 1 | 2 | PA | ||||
| 4330 | 10/14/15 | Cyber Analyst | $94,038 | 16 | 30 | 1 | 1 | 2 | NE | ||||
| 4332 | 9/28/04 | Cyber Analyst | $91,507 | 19 | 53 | 3 | 1 | 1 | PA | ||||
| 4334 | 12/28/10 | Cyber Software Engineer | $103,736 | 19 | 56 | 3 | 1 | 1 | PA | ||||
| 4337 | 10/11/15 | Logistics Mgr | $64,200 | 16 | 53 | 1 | 1 | 1 | IL | ||||
| 4342 | 7/13/11 | Cyber Analyst | $156,750 | 16 | 38 | 4 | 1 | 1 | PA | ||||
| 4343 | 12/29/17 | Public and Business Office Team | $96,327 | 16 | 40 | 4 | 1 | 1 | NE | ||||
| 4345 | 7/4/13 | Forensics Analyst | $87,480 | 16 | 26 | 1 | 1 | 1 | NE | ||||
| 4346 | 9/4/06 | Investigator | $100,314 | 16 | 51 | 3 | 1 | 1 | NE | ||||
| 4352 | 7/4/16 | Cyber Software Engineer | $50,377 | 12 | 31 | 2 | 1 | 1 | PA | ||||
| 4354 | 7/17/02 | Acctg/Fin | $68,056 | 14 | 62 | 1 | 1 | 1 | NE | ||||
| 4355 | 4/1/07 | Cyber Analyst | $150,263 | 12 | 53 | 2 | 1 | 1 | NE | ||||
| 4359 | 11/26/06 | Sr Cyber Investigator | $76,864 | 19 | 53 | 3 | 1 | 1 | NE | ||||
| 4361 | 6/10/11 | Forensics Analyst | $87,601 | 16 | 30 | 4 | 1 | 1 | IL | ||||
| 4368 | 2/24/18 | Cyber Mgr | $79,063 | 14 | 40 | 3 | 2 | 1 | IL | ||||
| 4369 | 8/31/05 | Cyber Analyst | $156,750 | 16 | 51 | 3 | 1 | 2 | NE | ||||
| 4377 | 2/12/08 | Cyber Analyst | $151,523 | 16 | 56 | 1 | 1 | 1 | IL | ||||
| 4380 | 7/1/17 | Cyber Software Engineer | $104,793 | 14 | 25 | 3 | 2 | 1 | NE | ||||
| 4381 | 12/29/11 | Cyber Analyst | $112,223 | 16 | 44 | 3 | 1 | 1 | IL | ||||
| 4382 | 4/29/12 | Public and Business Office Team Mgr | $79,591 | 12 | 47 | 3 | 1 | 1 | PA | ||||
| 4383 | 12/16/09 | Eng Mgr | $175,916 | 14 | 44 | 3 | 1 | 1 | NE | ||||
| 4385 | 9/25/08 | Malware Reverse Engineer | $74,039 | 19 | 49 | 3 | 1 | 2 | IL | ||||
| 4386 | 7/19/08 | COO | $154,933 | 19 | 43 | 3 | 1 | 2 | IL | ||||
| 4387 | 8/20/15 | Public and Business Office Team | $91,444 | 19 | 61 | 4 | 1 | 1 | PA | ||||
| 4388 | 10/16/14 | Public and Business Office Team | $119,156 | 16 | 41 | 3 | 1 | 1 | PA | ||||
| 4393 | 9/2/15 | Admin | $108,058 | 16 | 37 | 4 | 1 | 2 | IL | ||||
| 4394 | 5/6/18 | Forensics Analyst | $89,197 | 14 | 21 | 3 | 1 | 2 | NE | ||||
| 4395 | 1/4/18 | Public and Business Office Team | $71,697 | 14 | 32 | 3 | 1 | 1 | PA | ||||
| 4396 | 12/10/12 | Advertising | $101,341 | 14 | 39 | 3 | 2 | 2 | PA | ||||
| 4397 | 5/20/13 | Cyber Analyst | $84,175 | 16 | 37 | 3 | 1 | 1 | PA | ||||
| 4401 | 8/25/03 | IT Staff | $76,305 | 16 | 55 | 1 | 1 | 1 | PA | ||||
| 4402 | 12/7/18 | Acctg/Fin | $152,030 | 16 | 25 | 3 | 2 | 1 | NE | ||||
| 4405 | 9/27/12 | Cyber Software Engineer | $54,080 | 19 | 44 | 2 | 1 | 2 | NE | ||||
| 4406 | 6/10/13 | Sr Cyber Investigator | $116,075 | 19 | 37 | 1 | 1 | 2 | IL | ||||
| 4407 | 11/20/08 | Cyber Analyst | $73,005 | 14 | 43 | 3 | 1 | 1 | PA | ||||
| 4409 | 5/1/12 | Cyber Analyst | $112,402 | 14 | 41 | 2 | 1 | 1 | IL | ||||
| 4410 | 6/20/15 | Cyber Analyst | $68,222 | 19 | 29 | 3 | 1 | 2 | PA | ||||
| 4411 | 9/25/14 | Cyber Software Engineer | $95,128 | 19 | 42 | 3 | 2 | 1 | IL | ||||
| 4413 | 12/21/16 | IT Staff | $95,622 | 19 | 36 | 2 | 1 | 1 | PA | ||||
| 4418 | 7/11/04 | CEO | $239,315 | 19 | 58 | 3 | 1 | 1 | PA | ||||
| 4419 | 12/17/06 | Cyber Analyst | $70,237 | 16 | 57 | 2 | 1 | 1 | PA | ||||
| 4421 | 2/12/15 | Logistics | $64,201 | 16 | 34 | 3 | 1 | 1 | IL | ||||
| 4423 | 6/20/15 | Cyber Analyst | $102,641 | 14 | 29 | 1 | 1 | 1 | NE | ||||
| 4424 | 2/23/16 | Sr Public and Business Office Team Mgr | $107,153 | 16 | 51 | 3 | 2 | 1 | NE | ||||
| 4428 | 2/6/10 | Cyber Analyst | $73,640 | 16 | 45 | 3 | 1 | 1 | PA | ||||
| 4429 | 1/28/10 | IT Staff | $68,647 | 14 | 50 | 3 | 1 | 1 | NE | ||||
| 4435 | 6/17/17 | Public and Business Office Team | $141,110 | 16 | 37 | 1 | 2 | 1 | IL | ||||
| 4436 | 10/5/04 | Controller | $71,727 | 19 | 50 | 3 | 2 | 1 | IL | ||||
| 4438 | 11/18/09 | Forensics Analyst | $54,060 | 16 | 32 | 3 | 2 | 2 | IL | ||||
| 4439 | 2/2/04 | Cyber Analyst | $69,656 | 16 | 57 | 1 | 1 | 1 | NE | ||||
| 4440 | 7/21/14 | Public and Business Office Team | $111,794 | 19 | 45 | 1 | 1 | 2 | NE | ||||
| 4441 | 8/5/12 | Cyber Analyst | $80,198 | 16 | 37 | 1 | 1 | 1 | IL | ||||
| 4442 | 11/10/11 | Physical Security | $72,536 | 14 | 39 | 1 | 2 | 1 | IL | ||||
| 4450 | 1/12/06 | Investigator | $90,794 | 16 | 39 | 3 | 1 | 1 | NE | ||||
| 4455 | 10/17/08 | Cyber Software Engineer | $152,446 | 16 | 54 | 3 | 1 | 1 | NE | ||||
| 4457 | 8/13/17 | Cyber Analyst | $102,913 | 16 | 25 | 1 | 2 | 2 | IL | ||||
| 4458 | 12/15/06 | Sr Cyber Investigator | $156,750 | 16 | 61 | 1 | 1 | 2 | NE | ||||
| 4459 | 5/22/09 | Cyber Analyst | $115,580 | 16 | 54 | 1 | 1 | 1 | IL | ||||
| 4460 | 11/28/18 | Public and Business Office Team | $154,122 | 14 | 35 | 3 | 1 | 2 | PA | ||||
| 4461 | 11/16/05 | Cyber Analyst | $75,074 | 19 | 58 | 1 | 1 | 1 | PA | ||||
| 4465 | 10/13/13 | Cyber Analyst | $83,367 | 16 | 37 | 1 | 1 | 2 | PA | ||||
| 4466 | 6/2/07 | Cyber Analyst | $94,876 | 16 | 48 | 3 | 1 | 1 | PA | ||||
| 4467 | 8/11/14 | Logistics | $43,367 | 16 | 38 | 3 | 2 | 1 | PA | ||||
| 4468 | 1/10/17 | Sr Cyber Investigator | $163,045 | 16 | 33 | 1 | 1 | 1 | IL | ||||
| 4470 | 5/17/15 | Acctg/Fin | $66,528 | 16 | 35 | 1 | 2 | 1 | NE | ||||
| 4471 | 5/15/18 | Cyber Software Engineer | $164,033 | 14 | 30 | 3 | 1 | 1 | IL | ||||
| 4472 | 2/15/11 | Cyber Analyst | $74,381 | 16 | 46 | 3 | 1 | 1 | NE | ||||
| 4474 | 9/26/13 | Forensics Analyst | $113,023 | 16 | 28 | 3 | 1 | 2 | IL | ||||
| 4475 | 12/12/12 | Acctg/Fin | $75,415 | 12 | 48 | 3 | 1 | 1 | NE | ||||
| 4479 | 3/16/11 | Cyber Analyst | $68,375 | 16 | 40 | 1 | 1 | 2 | NE | ||||
| 4480 | 1/4/14 | Forensics Analyst | $101,709 | 16 | 24 | 4 | 1 | 1 | NE | ||||
| 4482 | 7/20/01 | Cyber Mgr | $77,247 | 14 | 48 | 4 | 2 | 1 | IL | ||||
| 4484 | 4/18/18 | Quality Assurance | $111,424 | 16 | 35 | 3 | 1 | 1 | NE | ||||
| 4489 | 3/28/14 | Cyber Analyst | $83,075 | 16 | 38 | 3 | 1 | 2 | NE | ||||
| 4490 | 3/11/13 | Cyber Software Engineer | $100,571 | 16 | 42 | 2 | 2 | 1 | NE | ||||
| 4497 | 10/28/12 | Investigator | $68,012 | 16 | 36 | 4 | 2 | 1 | PA | ||||
| 4498 | 12/4/11 | Malware Reverse Engineer | $82,319 | 19 | 40 | 3 | 1 | 1 | NE | ||||
| 4500 | 12/5/13 | IT Mgr | $113,056 | 19 | 56 | 3 | 1 | 1 | PA | ||||
| 4507 | 8/11/16 | Physical Security | $55,542 | 14 | 30 | 2 | 2 | 1 | IL | ||||
| 4513 | 2/19/12 | Cyber Analyst | $103,721 | 14 | 46 | 3 | 1 | 1 | NE | ||||
| 4515 | 6/13/09 | Cyber Analyst | $89,165 | 19 | 49 | 3 | 2 | 1 | PA | ||||
| 4517 | 7/27/08 | Cyber Analyst | $140,865 | 19 | 49 | 1 | 1 | 2 | NE | ||||
| 4519 | 5/29/18 | Forensics Analyst | $128,901 | 14 | 26 | 3 | 1 | 2 | NE | ||||
| 4520 | 4/11/04 | CIO | $179,195 | 19 | 50 | 3 | 1 | 1 | NE | ||||
| 4522 | 12/10/15 | Sr Cyber Investigator | $85,442 | 19 | 38 | 1 | 2 | 1 | IL | ||||
| 4530 | 5/1/17 | Physical Security | $72,946 | 14 | 24 | 1 | 2 | 2 | PA | ||||
| 4532 | 2/10/16 | Physical Security | $43,367 | 16 | 34 | 3 | 1 | 1 | IL | ||||
| 4535 | 6/14/06 | Cyber Analyst | $110,708 | 16 | 55 | 3 | 1 | 1 | IL | ||||
| 4541 | 12/2/09 | Eng Mgr | $170,954 | 12 | 49 | 3 | 1 | 2 | PA | ||||
| 4543 | 10/20/12 | Cyber Analyst | $148,111 | 14 | 33 | 3 | 1 | 1 | PA | ||||
| 4544 | 8/15/18 | Forensics Analyst | $69,935 | 16 | 22 | 1 | 1 | 2 | NE | ||||
| 4554 | 1/22/18 | Physical Security | $43,962 | 12 | 22 | 3 | 2 | 2 | IL | ||||
| 4558 | 1/31/11 | Cyber Analyst | $85,256 | 16 | 41 | 3 | 1 | 1 | PA | ||||
| 4563 | 3/16/16 | IT Staff | $62,319 | 16 | 28 | 3 | 1 | 1 | PA | ||||
| 4564 | 11/23/12 | Advertising | $88,639 | 16 | 34 | 3 | 1 | 2 | NE | ||||
| 4565 | 6/13/04 | Cyber Analyst | $79,584 | 14 | 55 | 3 | 1 | 1 | IL | ||||
| 4566 | 9/28/01 | Cyber Analyst | $87,517 | 14 | 57 | 3 | 1 | 1 | IL | ||||
| 4567 | 11/6/07 | IT Staff | $71,747 | 16 | 46 | 2 | 1 | 1 | PA | ||||
| 4571 | 7/12/11 | Cyber Analyst | $75,261 | 12 | 43 | 3 | 1 | 1 | IL | ||||
| 4572 | 10/6/10 | Sr Cyber Investigator | $92,079 | 19 | 40 | 3 | 1 | 1 | NE | ||||
| 4576 | 10/30/10 | Cyber Analyst | $92,931 | 16 | 51 | 3 | 1 | 1 | IL | ||||
| 4580 | 7/16/01 | Cyber Analyst | $186,670 | 16 | 60 | 1 | 1 | 2 | PA | ||||
| 4587 | 6/24/08 | Cyber Analyst | $76,499 | 14 | 46 | 1 | 1 | 1 | PA | ||||
| 4589 | 7/11/03 | Cyber Analyst | $70,358 | 14 | 55 | 3 | 1 | 1 | PA | ||||
| 4591 | 1/4/16 | Sr Forensics Mgr | $109,128 | 16 | 48 | 3 | 1 | 1 | IL | ||||
| 4592 | 10/6/09 | Investigator | $133,138 | 16 | 33 | 3 | 2 | 1 | IL | ||||
| 4593 | 1/20/12 | Cyber Analyst | $86,597 | 14 | 44 | 1 | 1 | 1 | PA | ||||
| 4594 | 5/3/14 | Cyber Analyst | $78,529 | 16 | 44 | 1 | 1 | 1 | PA | ||||
| 4595 | 11/29/09 | Sr Cyber Investigator | $96,566 | 19 | 46 | 3 | 1 | 1 | PA | ||||
| 4597 | 12/17/15 | Cyber Analyst | $158,066 | 16 | 28 | 4 | 1 | 1 | IL | ||||
| 4598 | 7/20/01 | Sr Cyber Investigator | $81,287 | 16 | 65 | 3 | 1 | 1 | PA | ||||
| 4604 | 11/10/11 | Forensics Analyst | $71,671 | 16 | 31 | 1 | 1 | 1 | PA | ||||
| 4611 | 7/17/02 | Investigator | $132,142 | 14 | 53 | 3 | 1 | 1 | NE | ||||
| 4612 | 3/17/16 | Cyber Mgr | $111,196 | 16 | 36 | 4 | 1 | 1 | NE | ||||
| 4617 | 9/20/06 | IT Staff | $87,407 | 14 | 51 | 1 | 1 | 1 | NE | ||||
| 4618 | 6/13/11 | Cyber Software Engineer | $76,031 | 19 | 42 | 3 | 1 | 1 | NE | ||||
| 4619 | 9/30/12 | Cyber Software Engineer | $83,424 | 16 | 44 | 3 | 2 | 1 | IL | ||||
| 4620 | 4/29/11 | Malware Reverse Engineer | $178,456 | 16 | 34 | 3 | 1 | 1 | NE | ||||
| 4621 | 12/1/18 | Cyber Analyst | $81,730 | 16 | 27 | 3 | 2 | 1 | IL | ||||
| 4626 | 8/19/14 | Malware Reverse Engineer | $55,720 | 16 | 34 | 3 | 1 | 2 | IL | ||||
| 4630 | 10/13/07 | Investigator | $61,779 | 16 | 34 | 1 | 1 | 1 | IL | ||||
| 4636 | 7/7/04 | Sr Cyber Investigator | $75,293 | 16 | 57 | 3 | 2 | 1 | PA | ||||
| 4639 | 3/12/13 | Sr Cyber Investigator | $152,446 | 16 | 37 | 3 | 1 | 1 | PA | ||||
| 4648 | 7/7/17 | Marketing | $115,966 | 16 | 42 | 3 | 2 | 1 | PA | ||||
| 4653 | 9/13/12 | Forensics Analyst | $91,131 | 19 | 30 | 3 | 1 | 1 | IL | ||||
| 4656 | 12/29/17 | Cyber Software Engineer | $151,174 | 16 | 40 | 3 | 2 | 1 | PA | ||||
| 4660 | 9/9/12 | Forensics Analyst | $120,986 | 19 | 29 | 4 | 1 | 1 | IL | ||||
| 4661 | 8/29/15 | Cyber Analyst | $117,062 | 16 | 27 | 3 | 1 | 1 | PA | ||||
| 4665 | 8/16/13 | Cyber Analyst | $115,283 | 14 | 37 | 1 | 1 | 1 | IL | ||||
| 4668 | 5/21/13 | Physical Security | $43,367 | 16 | 29 | 3 | 1 | 2 | NE | ||||
| 4671 | 1/13/15 | Cyber Software Engineer | $105,637 | 19 | 44 | 3 | 1 | 1 | PA | ||||
| 4675 | 8/10/13 | Quality Assurance | $101,360 | 16 | 40 | 3 | 1 | 1 | IL | ||||
| 4677 | 11/11/14 | Physical Security | $43,367 | 16 | 33 | 3 | 1 | 1 | IL | ||||
| 4680 | 6/18/09 | Sr Cyber Investigator | $84,713 | 16 | 39 | 4 | 1 | 1 | PA | ||||
| 4683 | 5/6/11 | Sr Cyber Investigator | $58,294 | 19 | 40 | 4 | 1 | 1 | NE | ||||
| 4687 | 8/25/18 | Malware Reverse Engineer | $87,583 | 14 | 39 | 2 | 1 | 2 | IL | ||||
| 4690 | 6/27/12 | Cyber Analyst | $82,471 | 16 | 39 | 3 | 1 | 2 | PA | ||||
| 4693 | 10/2/15 | Physical Security | $75,920 | 14 | 30 | 3 | 2 | 1 | PA | ||||
| 4694 | 11/16/15 | Cyber Analyst | $101,016 | 16 | 35 | 4 | 1 | 2 | PA | ||||
| 4695 | 1/31/15 | Cyber Analyst | $88,743 | 19 | 33 | 2 | 2 | 2 | IL | ||||
| 4696 | 8/26/17 | Cyber Analyst | $128,825 | 16 | 25 | 3 | 1 | 2 | PA | ||||
| 4699 | 10/8/10 | Cyber Analyst | $79,542 | 16 | 50 | 3 | 1 | 1 | NE | ||||
| 4700 | 10/7/14 | Cyber Mgr | $63,946 | 19 | 42 | 3 | 2 | 1 | PA | ||||
| 4705 | 8/21/13 | IT Staff | $80,045 | 14 | 43 | 1 | 1 | 1 | PA | ||||
| 4709 | 10/4/12 | Forensics Analyst | $143,063 | 16 | 31 | 1 | 1 | 2 | NE | ||||
| 4712 | 2/25/14 | Cyber Analyst | $97,323 | 14 | 34 | 1 | 2 | 1 | PA | ||||
| 4713 | 2/13/14 | Physical Security | $86,666 | 12 | 27 | 1 | 1 | 2 | PA | ||||
| 4714 | 8/24/15 | Forensics Analyst | $94,700 | 14 | 35 | 1 | 1 | 2 | NE | ||||
| 4717 | 12/19/09 | Cyber Analyst | $82,601 | 19 | 41 | 1 | 1 | 1 | PA | ||||
| 4719 | 9/1/06 | Cyber Analyst | $98,234 | 16 | 58 | 3 | 1 | 1 | PA | ||||
| 4723 | 10/8/11 | IT Staff | $75,270 | 19 | 35 | 3 | 1 | 1 | PA | ||||
| 4724 | 3/8/15 | Sr Public and Business Office Team Mgr | $103,349 | 14 | 56 | 3 | 1 | 2 | PA | ||||
| 4726 | 1/4/05 | Sr Cyber Investigator | $134,847 | 16 | 55 | 1 | 1 | 1 | PA | ||||
| 4727 | 9/7/12 | CFO | $122,391 | 16 | 48 | 4 | 1 | 2 | IL | ||||
| 4730 | 8/31/04 | Acctg/Fin | $107,530 | 14 | 42 | 3 | 2 | 2 | NE | ||||
| 4731 | 10/12/12 | Cyber Analyst | $83,430 | 16 | 38 | 3 | 1 | 1 | PA | ||||
| 4733 | 8/9/12 | Acctg/Fin | $80,666 | 16 | 44 | 3 | 1 | 1 | PA | ||||
| 4734 | 10/21/16 | Admin | $87,047 | 14 | 25 | 3 | 2 | 2 | PA | ||||
| 4740 | 11/1/16 | Quality Assurance | $77,495 | 16 | 45 | 3 | 2 | 2 | IL | ||||
| 4742 | 4/21/08 | Cyber Analyst | $90,599 | 16 | 50 | 1 | 1 | 1 | IL | ||||
| 4745 | 3/14/17 | Cyber Software Engineer | $75,144 | 16 | 28 | 1 | 2 | 2 | NE | ||||
| 4746 | 10/4/12 | Cyber Analyst | $84,679 | 19 | 35 | 3 | 1 | 1 | PA | ||||
| 4748 | 10/19/12 | Forensics Analyst | $75,612 | 16 | 31 | 3 | 1 | 1 | PA | ||||
| 4757 | 10/15/14 | Cyber Software Engineer | $112,994 | 16 | 38 | 3 | 1 | 1 | PA | ||||
| 4759 | 10/11/13 | Malware Reverse Engineer | $67,624 | 16 | 37 | 3 | 2 | 1 | NE | ||||
| 4761 | 1/17/15 | Cyber Analyst | $162,731 | 16 | 32 | 1 | 1 | 1 | PA | ||||
| 4766 | 9/23/15 | Logistics | $84,076 | 19 | 36 | 3 | 2 | 1 | IL | ||||
| 4768 | 5/3/13 | Public and Business Office Team | $114,251 | 14 | 44 | 2 | 2 | 1 | PA | ||||
| 4769 | 9/15/14 | IT Staff | $71,311 | 14 | 37 | 3 | 1 | 1 | NE | ||||
| 4771 | 12/1/13 | Marketing | $159,215 | 19 | 40 | 1 | 1 | 1 | IL | ||||
| 4775 | 6/24/13 | Acctg/Fin | $162,030 | 14 | 38 | 2 | 1 | 2 | NE | ||||
| 4780 | 8/2/02 | IT Staff | $62,747 | 19 | 52 | 3 | 1 | 1 | IL | ||||
| 4782 | 4/6/19 | Sr Cyber Analyst | $154,122 | 19 | 33 | 1 | 1 | 2 | IL | ||||
| 4784 | 5/12/12 | Cyber Software Engineer | $102,238 | 16 | 45 | 3 | 1 | 1 | PA | ||||
| 4786 | 8/6/11 | Forensics Analyst | $154,933 | 16 | 31 | 1 | 1 | 1 | NE | ||||
| 4790 | 6/11/13 | IT Staff | $141,110 | 16 | 36 | 3 | 1 | 1 | IL | ||||
| 4792 | 7/11/03 | Malware Reverse Engineer | $131,698 | 14 | 63 | 3 | 1 | 1 | PA | ||||
| 4794 | 5/3/13 | Physical Security | $67,987 | 16 | 34 | 3 | 2 | 1 | PA | ||||
| 4798 | 9/22/13 | Cyber Analyst | $119,285 | 16 | 28 | 3 | 1 | 2 | NE | ||||
| 4803 | 10/29/11 | Cyber Analyst | $52,064 | 14 | 34 | 3 | 1 | 1 | NE | ||||
| 4806 | 5/4/11 | Forensics Analyst | $116,208 | 16 | 32 | 1 | 1 | 1 | NE | ||||
| 4809 | 11/6/10 | Forensics Analyst | $99,135 | 14 | 35 | 3 | 1 | 1 | IL | ||||
| 4811 | 4/22/10 | Cyber Analyst | $74,814 | 19 | 42 | 2 | 1 | 1 | IL | ||||
| 4813 | 6/20/08 | Cyber Analyst | $127,890 | 12 | 47 | 3 | 1 | 1 | PA | ||||
| 4817 | 7/4/17 | Acctg/Fin | $84,270 | 16 | 30 | 3 | 1 | 1 | PA | ||||
| 4818 | 12/29/16 | Cyber Software Engineer | $64,458 | 16 | 29 | 2 | 2 | 2 | PA | ||||
| 4820 | 12/14/13 | Cyber Analyst | $69,777 | 19 | 43 | 3 | 1 | 1 | NE | ||||
| 4823 | 8/14/03 | Sr Cyber Investigator | $72,005 | 19 | 61 | 1 | 2 | 1 | PA | ||||
| 4824 | 5/17/10 | Cyber Analyst | $148,111 | 16 | 39 | 3 | 1 | 1 | NE | ||||
| 4825 | 9/5/16 | Forensics Analyst | $78,900 | 12 | 26 | 3 | 1 | 2 | PA | ||||
| 4826 | 1/7/12 | Physical Security | $64,797 | 14 | 45 | 3 | 2 | 1 | PA | ||||
| 4830 | 8/3/17 | Malware Reverse Engineer | $91,748 | 16 | 36 | 3 | 1 | 2 | NE | ||||
| 4831 | 11/23/08 | Cyber Analyst | $100,632 | 16 | 47 | 3 | 1 | 1 | NE | ||||
| 4834 | 4/24/19 | Cyber Mgr | $100,198 | 16 | 34 | 1 | 2 | 1 | IL | ||||
| 4837 | 2/6/14 | Forensics Analyst | $62,836 | 16 | 42 | 3 | 1 | 1 | NE | ||||
| 4840 | 2/1/14 | Cyber Analyst | $87,054 | 14 | 34 | 2 | 1 | 1 | IL | ||||
| 4841 | 1/8/13 | Physical Security | $61,121 | 16 | 44 | 3 | 1 | 1 | NE | ||||
| 4842 | 7/11/04 | Cyber Software Engineer | $60,802 | 16 | 59 | 3 | 1 | 1 | PA | ||||
| 4843 | 6/23/16 | Malware Reverse Engineer | $86,199 | 16 | 27 | 4 | 2 | 2 | IL | ||||
| 4845 | 5/23/11 | Cyber Analyst | $149,466 | 16 | 42 | 3 | 1 | 1 | PA | ||||
| 4846 | 10/10/13 | Physical Security | $87,943 | 12 | 29 | 1 | 1 | 1 | PA | ||||
| 4854 | 11/8/14 | Cyber Analyst | $149,466 | 19 | 30 | 3 | 1 | 1 | PA | ||||
| 4855 | 4/2/15 | Public and Business Office Team | $96,338 | 16 | 42 | 3 | 2 | 1 | PA | ||||
| 4857 | 9/2/14 | Eng Mgr | $172,291 | 16 | 52 | 3 | 1 | 1 | NE | ||||
| 4860 | 5/5/06 | Cyber Analyst | $75,179 | 14 | 49 | 1 | 2 | 2 | PA | ||||
| 4864 | 1/26/18 | IT Staff | $69,665 | 16 | 24 | 2 | 2 | 1 | PA | ||||
| 4872 | 1/19/12 | Cyber Analyst | $68,762 | 16 | 43 | 4 | 2 | 1 | IL | ||||
| 4876 | 1/11/17 | Cyber Analyst | $139,377 | 16 | 27 | 3 | 1 | 2 | IL | ||||
| 4879 | 7/13/02 | Advertising | $106,600 | 16 | 60 | 3 | 1 | 1 | PA | ||||
| 4880 | 9/13/11 | Forensics Analyst | $95,662 | 14 | 31 | 1 | 2 | 1 | PA | ||||
| 4882 | 3/30/11 | Cyber Analyst | $81,276 | 14 | 44 | 3 | 1 | 1 | IL | ||||
| 4883 | 7/31/11 | Sr Forensics Mgr | $131,580 | 14 | 41 | 3 | 1 | 1 | PA | ||||
| 4885 | 8/25/02 | Advertising | $144,571 | 16 | 39 | 3 | 1 | 1 | IL | ||||
| 4897 | 10/24/07 | Marketing | $108,604 | 19 | 47 | 3 | 2 | 1 | PA | ||||
| 4901 | 6/12/11 | Acctg/Fin | $154,122 | 12 | 49 | 3 | 2 | 2 | PA | ||||
| 4902 | 9/5/11 | Cyber Analyst | $82,016 | 16 | 44 | 3 | 1 | 1 | IL | ||||
| 4904 | 12/19/13 | Quality Assurance | $139,515 | 16 | 52 | 1 | 2 | 1 | NE | ||||
| 4905 | 5/12/18 | Cyber Software Engineer | $140,865 | 14 | 30 | 3 | 1 | 2 | NE | ||||
| 4906 | 11/20/10 | Cyber Mgr | $186,925 | 16 | 39 | 1 | 1 | 1 | IL | ||||
| 4907 | 2/6/19 | Forensics Analyst | $50,421 | 16 | 26 | 3 | 2 | 2 | NE | ||||
| 4911 | 5/29/06 | Sr Cyber Investigator | $92,076 | 14 | 47 | 2 | 1 | 1 | IL | ||||
| 4913 | 6/13/17 | Cyber Analyst | $71,851 | 14 | 25 | 4 | 1 | 2 | IL | ||||
| 4915 | 10/25/11 | Cyber Analyst | $132,230 | 19 | 31 | 1 | 1 | 1 | IL | ||||
| 4918 | 5/15/11 | Cyber Analyst | $143,005 | 19 | 36 | 3 | 1 | 1 | PA | ||||
| 4919 | 1/29/13 | Cyber Analyst | $125,367 | 16 | 35 | 3 | 1 | 2 | IL | ||||
| 4931 | 9/1/16 | Cyber Analyst | $161,867 | 16 | 26 | 3 | 1 | 2 | IL | ||||
| 4932 | 2/2/14 | Malware Reverse Engineer | $128,943 | 14 | 49 | 3 | 1 | 1 | PA | ||||
| 4943 | 12/5/17 | Sr Cyber Investigator | $77,443 | 16 | 33 | 3 | 1 | 1 | NE | ||||
| 4944 | 6/17/17 | Cyber Analyst | $143,005 | 14 | 25 | 4 | 2 | 2 | IL | ||||
| 4945 | 10/13/05 | Cyber Analyst | $61,902 | 16 | 52 | 3 | 1 | 2 | NE | ||||
| 4946 | 2/21/15 | Forensics Analyst | $72,352 | 16 | 29 | 4 | 1 | 2 | PA | ||||
| 4947 | 6/21/13 | Cyber Analyst | $121,455 | 16 | 40 | 1 | 1 | 1 | PA | ||||
| 4950 | 10/18/17 | Cyber Analyst | $118,997 | 14 | 25 | 1 | 1 | 1 | PA | ||||
| 4953 | 1/5/16 | Forensics Analyst | $114,854 | 14 | 26 | 3 | 1 | 2 | PA | ||||
| 4957 | 3/2/09 | Cyber Analyst | $110,877 | 19 | 50 | 3 | 1 | 1 | PA | ||||
| 4958 | 7/17/13 | Forensics Analyst | $162,030 | 12 | 31 | 4 | 1 | 2 | IL | ||||
| 4960 | 4/10/13 | Cyber Analyst | $84,275 | 16 | 41 | 3 | 1 | 1 | PA | ||||
| 4961 | 1/25/05 | Cyber Analyst | $117,214 | 16 | 54 | 2 | 1 | 1 | PA | ||||
| 4964 | 10/21/10 | Cyber Analyst | $83,911 | 16 | 48 | 3 | 1 | 1 | NE | ||||
| 4965 | 2/27/12 | Cyber Analyst | $163,045 | 16 | 50 | 1 | 1 | 1 | PA | ||||
| 4971 | 1/24/04 | Marketing | $76,702 | 14 | 48 | 3 | 2 | 1 | NE | ||||
| 4972 | 7/27/07 | Forensics Analyst | $151,523 | 16 | 34 | 3 | 1 | 2 | PA | ||||
| 4981 | 2/2/10 | Cyber Analyst | $117,692 | 14 | 43 | 1 | 1 | 2 | IL | ||||
| 4982 | 1/19/18 | Physical Security | $74,512 | 14 | 24 | 1 | 2 | 1 | NE | ||||
| 4992 | 4/20/15 | Malware Reverse Engineer | $99,821 | 12 | 36 | 3 | 2 | 2 | IL | ||||
| 4998 | 9/25/10 | Cyber Analyst | $75,969 | 14 | 37 | 3 | 1 | 2 | IL | ||||
| Section 2: Complete Summary Tables for Graphing | |||||||||||||
| Sales Summary (Provided) | |||||||||||||
| Roles | # | # | % | Yr | Sales | ||||||||
| Acctg/Fin | 1 | African-Am | 2003 | $1,656,872 | |||||||||
| Admin | 2 | Asian | 2004 | $47,830,245 | |||||||||
| Advertising | 3 | Caucasian | 2005 | $84,088,009 | |||||||||
| CEO | 4 | Hispanic | 2006 | $130,427,572 | |||||||||
| CFO | TOTAL | 2007 | $146,938,882 | ||||||||||
| CIO | 2008 | $139,117,818 | |||||||||||
| Controller | 2009 | $143,547,199 | |||||||||||
| COO | Gender | # | % | 2010 | $144,834,875 | ||||||||
| Cyber Analyst | 1 | Male | 2011 | $149,578,842 | |||||||||
| Cyber Mgr | 2 | Female | 2012 | $155,740,613 | |||||||||
| Cyber Software Engineer | TOTAL | 2013 | $144,759,828 | ||||||||||
| Eng Mgr | 2014 | $156,714,301 | |||||||||||
| Forensics Analyst | 2015 | $150,201,379 | |||||||||||
| Investigator | Education Level | # | % | 2016 | $154,750,829 | ||||||||
| IT Mgr | 12 | HS | 2017 | $158,253,462 | |||||||||
| IT Staff | 14 | AA | 2018 | $156,494,223 | |||||||||
| Logistics | 16 | BA/BS | 2019 | $165,800,498 | |||||||||
| Logistics Mgr | 19 | Masters+ | 2020 | ||||||||||
| Malware Reverse Engineer | TOTAL | 2021 | |||||||||||
| Marketing | 2022 | ||||||||||||
| Physical Security | 2023 | ||||||||||||
| Public and Business Office Team | Marital Status | # | % | 2024 | |||||||||
| Public and Business Office Team Mgr | 1 | Married | |||||||||||
| Quality Assurance | 2 | Single | |||||||||||
| Sr Cyber Analyst | TOTAL | ||||||||||||
| Sr Cyber Investigator | |||||||||||||
| Sr Forensics Mgr | |||||||||||||
| Sr Public and Business Office Team Mgr | Region Key | ||||||||||||
| TOTAL | State | Region | # | % | |||||||||
| PA | Northeast | ||||||||||||
| IL | Midwest | ||||||||||||
| NE | C-Plains | ||||||||||||
| TOTAL | |||||||||||||
| Section 3: Complete Descriptive Statistics | |||||||||||||
| Be sure to include the correct units where applicable for the summary statistics below | |||||||||||||
| Descriptive Statistics | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Frequency Table by Salary Ranges | |||||||
| Mean | Bin Range / Upper Limit | Label | |||||||||||
| 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 | ||||||||||||
| 200+ |
