Project: Conduct Quantitative Analysis ( Need Corrections)

profileA-K1
MySpreadSheetdonewhichneedcorrections.xlsx

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 $44.36 5 19 35 NO 3 1 1 IL Midwest
4004 7/13/02 Cyber Analyst $111,801 $53.75 17 16 60 YES 3 1 1 IL Midwest
4010 11/25/18 Forensics Analyst $90,688 $43.60 1 16 23 NO 1 2 2 PA Northeast
4012 1/26/10 Cyber Analyst $95,985 $46.15 10 14 43 NO 1 1 1 NE C-Plains
4013 12/29/11 Cyber Analyst $100,520 $48.33 8 19 44 NO 3 1 1 IL Midwest
4014 10/2/11 Forensics Analyst $125,156 $60.17 8 19 31 NO 1 1 1 IL Midwest
4015 1/1/12 Cyber Analyst $78,475 $37.73 8 16 40 NO 3 1 2 PA Northeast
4020 5/9/11 Cyber Analyst $93,518 $44.96 9 14 39 NO 1 1 1 PA Northeast
4022 5/27/04 Cyber Analyst $69,529 $33.43 16 16 53 YES 3 1 1 PA Northeast
4023 2/6/14 Advertising $128,384 $61.72 6 16 28 NO 1 2 2 NE C-Plains
4025 12/12/14 Cyber Mgr $151,174 $72.68 5 16 38 NO 3 1 1 PA Northeast
4027 8/19/06 Sr Cyber Investigator $71,914 $34.57 13 16 51 YES 1 1 1 NE C-Plains
4029 6/5/11 Cyber Analyst $152,446 $73.29 9 14 36 NO 4 1 2 IL Midwest
4030 7/10/11 IT Staff $57,727 $27.75 8 16 51 NO 3 1 1 IL Midwest
4031 10/20/13 Cyber Software Engineer $78,869 $37.92 6 16 39 NO 3 1 1 PA Northeast
4034 5/21/06 IT Staff $90,930 $43.72 14 19 45 YES 3 1 1 PA Northeast
4037 9/13/13 Forensics Analyst $67,866 $32.63 6 14 25 NO 3 1 2 PA Northeast
4038 4/14/12 Cyber Analyst $64,580 $31.05 8 16 40 NO 1 1 1 PA Northeast
4039 5/30/13 Cyber Analyst $91,771 $44.12 7 16 30 NO 3 1 2 PA Northeast
4044 12/3/15 Cyber Analyst $59,219 $28.47 4 14 35 NO 3 1 2 NE C-Plains
4045 6/7/16 Physical Security $32,367 $15.56 4 12 25 NO 3 2 2 NE C-Plains
4046 9/4/06 Cyber Analyst $115,974 $55.76 13 16 54 YES 1 1 1 PA Northeast
4055 6/17/18 IT Staff $99,786 $47.97 2 14 31 NO 1 2 2 PA Northeast
4060 2/1/12 Sr Cyber Investigator $73,650 $35.41 8 19 42 NO 3 1 1 IL Midwest
4061 2/28/12 Cyber Analyst $154,933 $74.49 8 16 34 NO 3 1 2 PA Northeast
4064 1/18/16 Cyber Analyst $144,571 $69.51 4 16 36 NO 4 1 2 PA Northeast
4067 10/29/12 Malware Reverse Engineer $124,996 $60.09 7 16 49 NO 2 1 2 PA Northeast
4068 7/15/03 Cyber Analyst $145,776 $70.08 16 16 59 YES 3 1 1 IL Midwest
4070 4/4/17 Forensics Analyst $80,191 $38.55 3 16 28 NO 1 1 1 PA Northeast
4075 10/2/16 Forensics Analyst $75,053 $36.08 3 14 25 NO 3 1 2 IL Midwest
4078 7/15/09 Cyber Analyst $83,851 $40.31 10 16 51 YES 1 1 1 PA Northeast
4082 7/2/15 Cyber Analyst $82,411 $39.62 4 16 37 NO 3 1 1 IL Midwest
4086 9/18/07 Cyber Analyst $114,721 $55.15 12 14 51 YES 3 1 1 PA Northeast
4088 7/18/17 Public and Business Office Team $108,342 $52.09 2 16 34 NO 3 2 1 IL Midwest
4089 10/16/16 Cyber Software Engineer $81,050 $38.97 3 16 36 NO 3 1 1 PA Northeast
4090 11/15/15 Cyber Analyst $87,641 $42.14 4 14 33 NO 4 1 2 IL Midwest
4092 7/7/08 Forensics Analyst $98,943 $47.57 11 16 36 YES 3 1 1 PA Northeast
4093 8/25/10 Cyber Analyst $93,936 $45.16 9 19 47 NO 3 1 2 NE C-Plains
4095 12/31/04 Cyber Analyst $133,678 $64.27 15 16 52 YES 3 1 1 PA Northeast
4097 2/26/07 Cyber Analyst $162,731 $78.24 13 16 53 YES 1 1 2 IL Midwest
4104 7/21/08 Logistics $71,690 $34.47 11 16 51 YES 3 2 1 PA Northeast
4106 5/7/17 Public and Business Office Team $150,263 $72.24 3 16 57 NO 3 1 1 IL Midwest
4107 11/5/13 Cyber Analyst $78,334 $37.66 6 19 34 NO 3 1 1 PA Northeast
4118 8/13/17 IT Mgr $154,933 $74.49 2 16 24 NO 3 1 1 IL Midwest
4119 8/31/16 Cyber Analyst $86,384 $41.53 3 16 26 NO 3 1 2 IL Midwest
4120 8/30/13 Sr Cyber Investigator $127,190 $61.15 6 16 34 NO 3 1 1 IL Midwest
4121 8/31/11 Cyber Analyst $148,111 $71.21 8 16 36 NO 2 1 1 NE C-Plains
4122 8/4/14 Cyber Analyst $86,147 $41.42 5 16 39 NO 2 1 1 IL Midwest
4126 12/24/16 Cyber Analyst $60,641 $29.15 3 16 34 NO 4 1 1 NE C-Plains
4128 5/16/03 Cyber Analyst $126,426 $60.78 17 14 56 YES 3 1 1 PA Northeast
4133 5/29/12 Forensics Analyst $119,165 $57.29 8 16 31 NO 4 1 1 PA Northeast
4134 6/30/17 Acctg/Fin $98,007 $47.12 3 19 28 NO 1 1 2 PA Northeast
4135 2/24/16 Forensics Analyst $76,956 $37.00 4 16 26 NO 3 1 2 NE C-Plains
4137 1/14/09 Cyber Analyst $98,634 $47.42 11 16 52 YES 3 1 1 NE C-Plains
4139 2/20/14 Cyber Analyst $87,056 $41.85 6 16 41 NO 3 1 1 IL Midwest
4144 12/4/17 Sr Cyber Investigator $96,062 $46.18 2 16 31 NO 4 2 1 IL Midwest
4146 12/4/11 Cyber Analyst $104,961 $50.46 8 16 41 NO 1 1 1 PA Northeast
4147 9/30/17 Cyber Analyst $122,352 $58.82 2 16 28 NO 3 2 2 IL Midwest
4150 9/6/17 Physical Security $33,367 $16.04 2 12 22 NO 1 1 1 IL Midwest
4152 7/19/12 Cyber Analyst $151,523 $72.85 7 16 41 NO 1 1 1 NE C-Plains
4155 7/16/01 Public and Business Office Team $89,522 $43.04 18 19 68 YES 3 1 1 NE C-Plains
4163 9/11/14 Cyber Analyst $74,419 $35.78 5 14 38 NO 1 1 1 IL Midwest
4167 8/26/05 Cyber Analyst $111,536 $53.62 14 16 51 YES 1 1 1 NE C-Plains
4169 3/14/14 Acctg/Fin $65,100 $31.30 6 14 40 NO 3 2 1 PA Northeast
4175 11/29/11 Cyber Software Engineer $162,731 $78.24 8 16 54 NO 3 1 1 NE C-Plains
4176 11/23/17 Cyber Analyst $135,533 $65.16 2 14 28 NO 3 1 1 IL Midwest
4177 3/26/12 Sr Cyber Investigator $82,515 $39.67 8 16 39 NO 1 1 2 PA Northeast
4181 7/15/03 Cyber Analyst $123,391 $59.32 16 12 59 YES 3 1 1 IL Midwest
4183 10/29/14 IT Staff $65,126 $31.31 5 16 38 NO 1 1 1 NE C-Plains
4186 3/9/18 Sr Public and Business Office Team Mgr $172,291 $82.83 2 16 57 NO 1 1 1 IL Midwest
4189 4/24/11 Physical Security $53,669 $25.80 9 14 42 NO 1 2 1 PA Northeast
4191 7/11/04 Acctg/Fin $71,026 $34.15 15 16 49 YES 3 1 2 NE C-Plains
4193 10/27/15 Sr Cyber Investigator $125,004 $60.10 4 16 32 NO 1 2 1 PA Northeast
4198 6/5/17 Forensics Analyst $73,447 $35.31 3 14 27 NO 3 1 2 IL Midwest
4199 7/16/12 Cyber Analyst $151,174 $72.68 7 16 38 NO 3 1 1 NE C-Plains
4204 12/14/13 Cyber Analyst $61,212 $29.43 6 14 43 NO 1 1 1 IL Midwest
4205 11/26/14 Cyber Analyst $106,640 $51.27 5 14 40 NO 4 2 1 IL Midwest
4207 6/22/14 Cyber Analyst $91,205 $43.85 6 14 37 NO 3 1 1 NE C-Plains
4208 2/15/16 IT Staff $61,383 $29.51 4 14 26 NO 3 1 1 IL Midwest
4212 4/4/19 Public and Business Office Team $61,068 $29.36 1 16 37 NO 3 1 1 NE C-Plains
4214 5/9/13 Advertising $145,776 $70.08 7 19 30 NO 3 2 2 IL Midwest
4218 11/30/06 Cyber Analyst $99,130 $47.66 13 14 50 YES 3 1 1 IL Midwest
4220 9/17/06 Cyber Analyst $164,033 $78.86 13 16 54 YES 3 1 1 PA Northeast
4221 7/10/11 Malware reverse engineer $74,000 $35.58 8 19 40 NO 3 2 2 IL Midwest
4225 8/1/04 Quality Assurance $63,125 $30.35 15 16 54 YES 3 1 1 PA Northeast
4232 4/9/13 Cyber Analyst $86,787 $41.72 7 16 34 NO 1 2 1 IL Midwest
4237 11/2/14 IT Staff $95,957 $46.13 5 16 41 NO 3 2 1 IL Midwest
4238 6/24/18 Malware Reverse Engineer $101,386 $48.74 2 16 27 NO 1 1 2 PA Northeast
4239 1/6/17 Investigator $78,985 $37.97 3 16 33 NO 3 1 2 IL Midwest
4247 11/23/19 Forensics Analyst $105,069 $50.51 0 16 21 NO 1 1 2 IL Midwest
4249 8/17/07 Sr Cyber Investigator $107,496 $51.68 12 16 43 YES 1 1 1 PA Northeast
4252 3/23/16 Forensics Analyst $97,885 $47.06 4 16 28 NO 1 1 1 PA Northeast
4253 11/18/13 Malware reverse engineer $86,377 $41.53 6 14 40 NO 1 1 2 IL Midwest
4257 7/11/03 Cyber Mgr $104,220 $50.11 16 19 51 YES 3 2 1 PA Northeast
4258 1/24/13 Cyber Analyst $58,540 $28.14 7 14 44 NO 1 1 1 IL Midwest
4259 9/4/04 Forensics Analyst $106,267 $51.09 15 16 40 YES 3 1 1 PA Northeast
4260 9/19/15 Cyber Analyst $88,743 $42.66 4 14 27 NO 3 1 2 IL Midwest
4265 6/24/13 Cyber Analyst $81,042 $38.96 7 16 30 NO 3 1 2 NE C-Plains
4271 8/5/11 Sr Cyber Investigator $72,213 $34.72 8 16 41 NO 3 1 1 PA Northeast
4272 7/18/14 Admin $78,873 $37.92 5 12 36 NO 1 2 2 PA Northeast
4274 12/8/14 Cyber Analyst $87,092 $41.87 5 16 30 NO 3 1 1 NE C-Plains
4278 9/6/10 Cyber Analyst $90,153 $43.34 9 14 40 NO 4 1 1 NE C-Plains
4279 11/3/17 Investigator $95,220 $45.78 2 19 31 NO 2 1 1 IL Midwest
4284 12/16/10 Forensics Analyst $143,063 $68.78 9 14 36 NO 1 1 1 PA Northeast
4285 3/30/11 Cyber Analyst $80,909 $38.90 9 16 40 NO 1 1 1 IL Midwest
4287 2/5/14 Cyber Analyst $63,777 $30.66 6 14 35 NO 3 1 2 PA Northeast
4291 12/25/15 Cyber Analyst $66,938 $32.18 4 16 39 NO 3 1 1 IL Midwest
4296 12/9/07 Cyber Analyst $150,868 $72.53 12 16 53 YES 2 1 1 NE C-Plains
4298 8/28/07 Logistics $83,294 $40.05 12 16 49 YES 3 1 2 PA Northeast
4299 6/1/11 Cyber Analyst $76,158 $36.61 9 16 38 NO 4 1 1 NE C-Plains
4300 7/10/18 Cyber Analyst $108,866 $52.34 1 16 27 NO 1 2 1 PA Northeast
4301 11/7/13 Sr Forensics Mgr $96,582 $46.43 6 19 40 NO 1 1 1 NE C-Plains
4302 3/8/17 Marketing $87,519 $42.08 3 16 37 NO 3 2 1 IL Midwest
4303 1/19/18 Cyber Software Engineer $113,246 $54.45 2 19 34 NO 2 1 1 PA Northeast
4304 6/1/06 Cyber Software Engineer $81,779 $39.32 14 16 51 YES 3 1 1 NE C-Plains
4305 7/27/16 Cyber Analyst $78,015 $37.51 3 16 31 NO 3 1 1 PA Northeast
4307 8/27/07 Sr Cyber Investigator $73,807 $35.48 12 16 46 YES 3 1 2 IL Midwest
4310 1/21/11 Cyber Analyst $108,326 $52.08 9 19 41 NO 3 1 1 PA Northeast
4311 12/13/15 Cyber Analyst $92,847 $44.64 4 16 31 NO 3 1 1 IL Midwest
4313 11/11/10 Physical Security $39,808 $19.14 9 16 46 NO 1 1 1 PA Northeast
4314 12/28/05 Cyber Analyst $98,771 $47.49 14 19 59 YES 1 1 1 IL Midwest
4316 10/7/17 Sr Cyber Analyst $149,466 $71.86 2 16 31 NO 4 1 1 IL Midwest
4319 12/3/13 Forensics Analyst $63,933 $30.74 6 19 34 NO 3 1 2 IL Midwest
4324 6/4/11 Public and Business Office Team $87,409 $42.02 9 14 58 NO 4 1 1 IL Midwest
4326 5/3/12 Cyber Analyst $65,955 $31.71 8 14 39 NO 3 1 1 NE C-Plains
4327 1/29/12 Malware Reverse Engineer $68,226 $32.80 8 16 54 NO 3 1 1 PA Northeast
4329 6/21/10 Cyber Analyst $119,537 $57.47 10 19 47 NO 4 1 2 PA Northeast
4330 10/14/15 Cyber Analyst $94,038 $45.21 4 16 30 NO 1 1 2 NE C-Plains
4332 9/28/04 Cyber Analyst $91,507 $43.99 15 19 53 YES 3 1 1 PA Northeast
4334 12/28/10 Cyber Software Engineer $103,736 $49.87 9 19 56 NO 3 1 1 PA Northeast
4337 10/11/15 Logistics Mgr $64,200 $30.87 4 16 53 NO 1 1 1 IL Midwest
4342 7/13/11 Cyber Analyst $156,750 $75.36 8 16 38 NO 4 1 1 PA Northeast
4343 12/29/17 Public and Business Office Team $96,327 $46.31 2 16 40 NO 4 1 1 NE C-Plains
4345 7/4/13 Forensics Analyst $87,480 $42.06 6 16 26 NO 1 1 1 NE C-Plains
4346 9/4/06 Investigator $100,314 $48.23 13 16 51 YES 3 1 1 NE C-Plains
4352 7/4/16 Cyber Software Engineer $50,377 $24.22 3 12 31 NO 2 1 1 PA Northeast
4354 7/17/02 Acctg/Fin $68,056 $32.72 17 14 62 YES 1 1 1 NE C-Plains
4355 4/1/07 Cyber Analyst $150,263 $72.24 13 12 53 YES 2 1 1 NE C-Plains
4359 11/26/06 Sr Cyber Investigator $76,864 $36.95 13 19 53 YES 3 1 1 NE C-Plains
4361 6/10/11 Forensics Analyst $87,601 $42.12 9 16 30 NO 4 1 1 IL Midwest
4368 2/24/18 Cyber Mgr $79,063 $38.01 2 14 40 NO 3 2 1 IL Midwest
4369 8/31/05 Cyber Analyst $156,750 $75.36 14 16 51 YES 3 1 2 NE C-Plains
4377 2/12/08 Cyber Analyst $151,523 $72.85 12 16 56 YES 1 1 1 IL Midwest
4380 7/1/17 Cyber Software Engineer $104,793 $50.38 3 14 25 NO 3 2 1 NE C-Plains
4381 12/29/11 Cyber Analyst $112,223 $53.95 8 16 44 NO 3 1 1 IL Midwest
4382 4/29/12 Public and Business Office Team Mgr $79,591 $38.26 8 12 47 NO 3 1 1 PA Northeast
4383 12/16/09 Eng Mgr $175,916 $84.58 10 14 44 YES 3 1 1 NE C-Plains
4385 9/25/08 Malware Reverse Engineer $74,039 $35.60 11 19 49 YES 3 1 2 IL Midwest
4386 7/19/08 COO $154,933 $74.49 11 19 43 YES 3 1 2 IL Midwest
4387 8/20/15 Public and Business Office Team $91,444 $43.96 4 19 61 NO 4 1 1 PA Northeast
4388 10/16/14 Public and Business Office Team $119,156 $57.29 5 16 41 NO 3 1 1 PA Northeast
4393 9/2/15 Admin $108,058 $51.95 4 16 37 NO 4 1 2 IL Midwest
4394 5/6/18 Forensics Analyst $89,197 $42.88 2 14 21 NO 3 1 2 NE C-Plains
4395 1/4/18 Public and Business Office Team $71,697 $34.47 2 14 32 NO 3 1 1 PA Northeast
4396 12/10/12 Advertising $101,341 $48.72 7 14 39 NO 3 2 2 PA Northeast
4397 5/20/13 Cyber Analyst $84,175 $40.47 7 16 37 NO 3 1 1 PA Northeast
4401 8/25/03 IT Staff $76,305 $36.69 16 16 55 YES 1 1 1 PA Northeast
4402 12/7/18 Acctg/Fin $152,030 $73.09 1 16 25 NO 3 2 1 NE C-Plains
4405 9/27/12 Cyber Software Engineer $54,080 $26.00 7 19 44 NO 2 1 2 NE C-Plains
4406 6/10/13 Sr Cyber Investigator $116,075 $55.81 7 19 37 NO 1 1 2 IL Midwest
4407 11/20/08 Cyber Analyst $73,005 $35.10 11 14 43 YES 3 1 1 PA Northeast
4409 5/1/12 Cyber Analyst $112,402 $54.04 8 14 41 NO 2 1 1 IL Midwest
4410 6/20/15 Cyber Analyst $68,222 $32.80 5 19 29 NO 3 1 2 PA Northeast
4411 9/25/14 Cyber Software Engineer $95,128 $45.73 5 19 42 NO 3 2 1 IL Midwest
4413 12/21/16 IT Staff $95,622 $45.97 3 19 36 NO 2 1 1 PA Northeast
4418 7/11/04 CEO $239,315 $115.06 15 19 58 YES 3 1 1 PA Northeast
4419 12/17/06 Cyber Analyst $70,237 $33.77 13 16 57 YES 2 1 1 PA Northeast
4421 2/12/15 Logistics $64,201 $30.87 5 16 34 NO 3 1 1 IL Midwest
4423 6/20/15 Cyber Analyst $102,641 $49.35 5 14 29 NO 1 1 1 NE C-Plains
4424 2/23/16 Sr Public and Business Office Team Mgr $107,153 $51.52 4 16 51 NO 3 2 1 NE C-Plains
4428 2/6/10 Cyber Analyst $73,640 $35.40 10 16 45 NO 3 1 1 PA Northeast
4429 1/28/10 IT Staff $68,647 $33.00 10 14 50 NO 3 1 1 NE C-Plains
4435 6/17/17 Public and Business Office Team $141,110 $67.84 3 16 37 NO 1 2 1 IL Midwest
4436 10/5/04 Controller $71,727 $34.48 15 19 50 YES 3 2 1 IL Midwest
4438 11/18/09 Forensics Analyst $54,060 $25.99 10 16 32 YES 3 2 2 IL Midwest
4439 2/2/04 Cyber Analyst $69,656 $33.49 16 16 57 YES 1 1 1 NE C-Plains
4440 7/21/14 Public and Business Office Team $111,794 $53.75 5 19 45 NO 1 1 2 NE C-Plains
4441 8/5/12 Cyber Analyst $80,198 $38.56 7 16 37 NO 1 1 1 IL Midwest
4442 11/10/11 Physical Security $72,536 $34.87 8 14 39 NO 1 2 1 IL Midwest
4450 1/12/06 Investigator $90,794 $43.65 14 16 39 YES 3 1 1 NE C-Plains
4455 10/17/08 Cyber Software Engineer $152,446 $73.29 11 16 54 YES 3 1 1 NE C-Plains
4457 8/13/17 Cyber Analyst $102,913 $49.48 2 16 25 NO 1 2 2 IL Midwest
4458 12/15/06 Sr Cyber Investigator $156,750 $75.36 13 16 61 YES 1 1 2 NE C-Plains
4459 5/22/09 Cyber Analyst $115,580 $55.57 11 16 54 YES 1 1 1 IL Midwest
4460 11/28/18 Public and Business Office Team $154,122 $74.10 1 14 35 NO 3 1 2 PA Northeast
4461 11/16/05 Cyber Analyst $75,074 $36.09 14 19 58 YES 1 1 1 PA Northeast
4465 10/13/13 Cyber Analyst $83,367 $40.08 6 16 37 NO 1 1 2 PA Northeast
4466 6/2/07 Cyber Analyst $94,876 $45.61 13 16 48 YES 3 1 1 PA Northeast
4467 8/11/14 Logistics $43,367 $20.85 5 16 38 NO 3 2 1 PA Northeast
4468 1/10/17 Sr Cyber Investigator $163,045 $78.39 3 16 33 NO 1 1 1 IL Midwest
4470 5/17/15 Acctg/Fin $66,528 $31.98 5 16 35 NO 1 2 1 NE C-Plains
4471 5/15/18 Cyber Software Engineer $164,033 $78.86 2 14 30 NO 3 1 1 IL Midwest
4472 2/15/11 Cyber Analyst $74,381 $35.76 9 16 46 NO 3 1 1 NE C-Plains
4474 9/26/13 Forensics Analyst $113,023 $54.34 6 16 28 NO 3 1 2 IL Midwest
4475 12/12/12 Acctg/Fin $75,415 $36.26 7 12 48 NO 3 1 1 NE C-Plains
4479 3/16/11 Cyber Analyst $68,375 $32.87 9 16 40 NO 1 1 2 NE C-Plains
4480 1/4/14 Forensics Analyst $101,709 $48.90 6 16 24 NO 4 1 1 NE C-Plains
4482 7/20/01 Cyber Mgr $77,247 $37.14 18 14 48 YES 4 2 1 IL Midwest
4484 4/18/18 Quality Assurance $111,424 $53.57 2 16 35 NO 3 1 1 NE C-Plains
4489 3/28/14 Cyber Analyst $83,075 $39.94 6 16 38 NO 3 1 2 NE C-Plains
4490 3/11/13 Cyber Software Engineer $100,571 $48.35 7 16 42 NO 2 2 1 NE C-Plains
4497 10/28/12 Investigator $68,012 $32.70 7 16 36 NO 4 2 1 PA Northeast
4498 12/4/11 Malware Reverse Engineer $82,319 $39.58 8 19 40 NO 3 1 1 NE C-Plains
4500 12/5/13 IT Mgr $113,056 $54.35 6 19 56 NO 3 1 1 PA Northeast
4507 8/11/16 Physical Security $55,542 $26.70 3 14 30 NO 2 2 1 IL Midwest
4513 2/19/12 Cyber Analyst $103,721 $49.87 8 14 46 NO 3 1 1 NE C-Plains
4515 6/13/09 Cyber Analyst $89,165 $42.87 11 19 49 YES 3 2 1 PA Northeast
4517 7/27/08 Cyber Analyst $140,865 $67.72 11 19 49 YES 1 1 2 NE C-Plains
4519 5/29/18 Forensics Analyst $128,901 $61.97 2 14 26 NO 3 1 2 NE C-Plains
4520 4/11/04 CIO $179,195 $86.15 16 19 50 YES 3 1 1 NE C-Plains
4522 12/10/15 Sr Cyber Investigator $85,442 $41.08 4 19 38 NO 1 2 1 IL Midwest
4530 5/1/17 Physical Security $72,946 $35.07 3 14 24 NO 1 2 2 PA Northeast
4532 2/10/16 Physical Security $43,367 $20.85 4 16 34 NO 3 1 1 IL Midwest
4535 6/14/06 Cyber Analyst $110,708 $53.23 14 16 55 YES 3 1 1 IL Midwest
4541 12/2/09 Eng Mgr $170,954 $82.19 10 12 49 YES 3 1 2 PA Northeast
4543 10/20/12 Cyber Analyst $148,111 $71.21 7 14 33 NO 3 1 1 PA Northeast
4544 8/15/18 Forensics Analyst $69,935 $33.62 1 16 22 NO 1 1 2 NE C-Plains
4554 1/22/18 Physical Security $43,962 $21.14 2 12 22 NO 3 2 2 IL Midwest
4558 1/31/11 Cyber Analyst $85,256 $40.99 9 16 41 NO 3 1 1 PA Northeast
4563 3/16/16 IT Staff $62,319 $29.96 4 16 28 NO 3 1 1 PA Northeast
4564 11/23/12 Advertising $88,639 $42.61 7 16 34 NO 3 1 2 NE C-Plains
4565 6/13/04 Cyber Analyst $79,584 $38.26 16 14 55 YES 3 1 1 IL Midwest
4566 9/28/01 Cyber Analyst $87,517 $42.08 18 14 57 YES 3 1 1 IL Midwest
4567 11/6/07 IT Staff $71,747 $34.49 12 16 46 YES 2 1 1 PA Northeast
4571 7/12/11 Cyber Analyst $75,261 $36.18 8 12 43 NO 3 1 1 IL Midwest
4572 10/6/10 Sr Cyber Investigator $92,079 $44.27 9 19 40 NO 3 1 1 NE C-Plains
4576 10/30/10 Cyber Analyst $92,931 $44.68 9 16 51 NO 3 1 1 IL Midwest
4580 7/16/01 Cyber Analyst $186,670 $89.75 18 16 60 YES 1 1 2 PA Northeast
4587 6/24/08 Cyber Analyst $76,499 $36.78 12 14 46 YES 1 1 1 PA Northeast
4589 7/11/03 Cyber Analyst $70,358 $33.83 16 14 55 YES 3 1 1 PA Northeast
4591 1/4/16 Sr Forensics Mgr $109,128 $52.47 4 16 48 NO 3 1 1 IL Midwest
4592 10/6/09 Investigator $133,138 $64.01 10 16 33 YES 3 2 1 IL Midwest
4593 1/20/12 Cyber Analyst $86,597 $41.63 8 14 44 NO 1 1 1 PA Northeast
4594 5/3/14 Cyber Analyst $78,529 $37.75 6 16 44 NO 1 1 1 PA Northeast
4595 11/29/09 Sr Cyber Investigator $96,566 $46.43 10 19 46 YES 3 1 1 PA Northeast
4597 12/17/15 Cyber Analyst $158,066 $75.99 4 16 28 NO 4 1 1 IL Midwest
4598 7/20/01 Sr Cyber Investigator $81,287 $39.08 18 16 65 YES 3 1 1 PA Northeast
4604 11/10/11 Forensics Analyst $71,671 $34.46 8 16 31 NO 1 1 1 PA Northeast
4611 7/17/02 Investigator $132,142 $63.53 17 14 53 YES 3 1 1 NE C-Plains
4612 3/17/16 Cyber Mgr $111,196 $53.46 4 16 36 NO 4 1 1 NE C-Plains
4617 9/20/06 IT Staff $87,407 $42.02 13 14 51 YES 1 1 1 NE C-Plains
4618 6/13/11 Cyber Software Engineer $76,031 $36.55 9 19 42 NO 3 1 1 NE C-Plains
4619 9/30/12 Cyber Software Engineer $83,424 $40.11 7 16 44 NO 3 2 1 IL Midwest
4620 4/29/11 Malware Reverse Engineer $178,456 $85.80 9 16 34 NO 3 1 1 NE C-Plains
4621 12/1/18 Cyber Analyst $81,730 $39.29 1 16 27 NO 3 2 1 IL Midwest
4626 8/19/14 Malware Reverse Engineer $55,720 $26.79 5 16 34 NO 3 1 2 IL Midwest
4630 10/13/07 Investigator $61,779 $29.70 12 16 34 YES 1 1 1 IL Midwest
4636 7/7/04 Sr Cyber Investigator $75,293 $36.20 15 16 57 YES 3 2 1 PA Northeast
4639 3/12/13 Sr Cyber Investigator $152,446 $73.29 7 16 37 NO 3 1 1 PA Northeast
4648 7/7/17 Marketing $115,966 $55.75 2 16 42 NO 3 2 1 PA Northeast
4653 9/13/12 Forensics Analyst $91,131 $43.81 7 19 30 NO 3 1 1 IL Midwest
4656 12/29/17 Cyber Software Engineer $151,174 $72.68 2 16 40 NO 3 2 1 PA Northeast
4660 9/9/12 Forensics Analyst $120,986 $58.17 7 19 29 NO 4 1 1 IL Midwest
4661 8/29/15 Cyber Analyst $117,062 $56.28 4 16 27 NO 3 1 1 PA Northeast
4665 8/16/13 Cyber Analyst $115,283 $55.42 6 14 37 NO 1 1 1 IL Midwest
4668 5/21/13 Physical Security $43,367 $20.85 7 16 29 NO 3 1 2 NE C-Plains
4671 1/13/15 Cyber Software Engineer $105,637 $50.79 5 19 44 NO 3 1 1 PA Northeast
4675 8/10/13 Quality Assurance $101,360 $48.73 6 16 40 NO 3 1 1 IL Midwest
4677 11/11/14 Physical Security $43,367 $20.85 5 16 33 NO 3 1 1 IL Midwest
4680 6/18/09 Sr Cyber Investigator $84,713 $40.73 11 16 39 YES 4 1 1 PA Northeast
4683 5/6/11 Sr Cyber Investigator $58,294 $28.03 9 19 40 NO 4 1 1 NE C-Plains
4687 8/25/18 Malware Reverse Engineer $87,583 $42.11 1 14 39 NO 2 1 2 IL Midwest
4690 6/27/12 Cyber Analyst $82,471 $39.65 8 16 39 NO 3 1 2 PA Northeast
4693 10/2/15 Physical Security $75,920 $36.50 4 14 30 NO 3 2 1 PA Northeast
4694 11/16/15 Cyber Analyst $101,016 $48.57 4 16 35 NO 4 1 2 PA Northeast
4695 1/31/15 Cyber Analyst $88,743 $42.66 5 19 33 NO 2 2 2 IL Midwest
4696 8/26/17 Cyber Analyst $128,825 $61.94 2 16 25 NO 3 1 2 PA Northeast
4699 10/8/10 Cyber Analyst $79,542 $38.24 9 16 50 NO 3 1 1 NE C-Plains
4700 10/7/14 Cyber Mgr $63,946 $30.74 5 19 42 NO 3 2 1 PA Northeast
4705 8/21/13 IT Staff $80,045 $38.48 6 14 43 NO 1 1 1 PA Northeast
4709 10/4/12 Forensics Analyst $143,063 $68.78 7 16 31 NO 1 1 2 NE C-Plains
4712 2/25/14 Cyber Analyst $97,323 $46.79 6 14 34 NO 1 2 1 PA Northeast
4713 2/13/14 Physical Security $86,666 $41.67 6 12 27 NO 1 1 2 PA Northeast
4714 8/24/15 Forensics Analyst $94,700 $45.53 4 14 35 NO 1 1 2 NE C-Plains
4717 12/19/09 Cyber Analyst $82,601 $39.71 10 19 41 YES 1 1 1 PA Northeast
4719 9/1/06 Cyber Analyst $98,234 $47.23 13 16 58 YES 3 1 1 PA Northeast
4723 10/8/11 IT Staff $75,270 $36.19 8 19 35 NO 3 1 1 PA Northeast
4724 3/8/15 Sr Public and Business Office Team Mgr $103,349 $49.69 5 14 56 NO 3 1 2 PA Northeast
4726 1/4/05 Sr Cyber Investigator $134,847 $64.83 15 16 55 YES 1 1 1 PA Northeast
4727 9/7/12 CFO $122,391 $58.84 7 16 48 NO 4 1 2 IL Midwest
4730 8/31/04 Acctg/Fin $107,530 $51.70 15 14 42 YES 3 2 2 NE C-Plains
4731 10/12/12 Cyber Analyst $83,430 $40.11 7 16 38 NO 3 1 1 PA Northeast
4733 8/9/12 Acctg/Fin $80,666 $38.78 7 16 44 NO 3 1 1 PA Northeast
4734 10/21/16 Admin $87,047 $41.85 3 14 25 NO 3 2 2 PA Northeast
4740 11/1/16 Quality Assurance $77,495 $37.26 3 16 45 NO 3 2 2 IL Midwest
4742 4/21/08 Cyber Analyst $90,599 $43.56 12 16 50 YES 1 1 1 IL Midwest
4745 3/14/17 Cyber Software Engineer $75,144 $36.13 3 16 28 NO 1 2 2 NE C-Plains
4746 10/4/12 Cyber Analyst $84,679 $40.71 7 19 35 NO 3 1 1 PA Northeast
4748 10/19/12 Forensics Analyst $75,612 $36.35 7 16 31 NO 3 1 1 PA Northeast
4757 10/15/14 Cyber Software Engineer $112,994 $54.32 5 16 38 NO 3 1 1 PA Northeast
4759 10/11/13 Malware Reverse Engineer $67,624 $32.51 6 16 37 NO 3 2 1 NE C-Plains
4761 1/17/15 Cyber Analyst $162,731 $78.24 5 16 32 NO 1 1 1 PA Northeast
4766 9/23/15 Logistics $84,076 $40.42 4 19 36 NO 3 2 1 IL Midwest
4768 5/3/13 Public and Business Office Team $114,251 $54.93 7 14 44 NO 2 2 1 PA Northeast
4769 9/15/14 IT Staff $71,311 $34.28 5 14 37 NO 3 1 1 NE C-Plains
4771 12/1/13 Marketing $159,215 $76.55 6 19 40 NO 1 1 1 IL Midwest
4775 6/24/13 Acctg/Fin $162,030 $77.90 7 14 38 NO 2 1 2 NE C-Plains
4780 8/2/02 IT Staff $62,747 $30.17 17 19 52 YES 3 1 1 IL Midwest
4782 4/6/19 Sr Cyber Analyst $154,122 $74.10 1 19 33 NO 1 1 2 IL Midwest
4784 5/12/12 Cyber Software Engineer $102,238 $49.15 8 16 45 NO 3 1 1 PA Northeast
4786 8/6/11 Forensics Analyst $154,933 $74.49 8 16 31 NO 1 1 1 NE C-Plains
4790 6/11/13 IT Staff $141,110 $67.84 7 16 36 NO 3 1 1 IL Midwest
4792 7/11/03 Malware Reverse Engineer $131,698 $63.32 16 14 63 YES 3 1 1 PA Northeast
4794 5/3/13 Physical Security $67,987 $32.69 7 16 34 NO 3 2 1 PA Northeast
4798 9/22/13 Cyber Analyst $119,285 $57.35 6 16 28 NO 3 1 2 NE C-Plains
4803 10/29/11 Cyber Analyst $52,064 $25.03 8 14 34 NO 3 1 1 NE C-Plains
4806 5/4/11 Forensics Analyst $116,208 $55.87 9 16 32 NO 1 1 1 NE C-Plains
4809 11/6/10 Forensics Analyst $99,135 $47.66 9 14 35 NO 3 1 1 IL Midwest
4811 4/22/10 Cyber Analyst $74,814 $35.97 10 19 42 NO 2 1 1 IL Midwest
4813 6/20/08 Cyber Analyst $127,890 $61.49 12 12 47 YES 3 1 1 PA Northeast
4817 7/4/17 Acctg/Fin $84,270 $40.51 2 16 30 NO 3 1 1 PA Northeast
4818 12/29/16 Cyber Software Engineer $64,458 $30.99 3 16 29 NO 2 2 2 PA Northeast
4820 12/14/13 Cyber Analyst $69,777 $33.55 6 19 43 NO 3 1 1 NE C-Plains
4823 8/14/03 Sr Cyber Investigator $72,005 $34.62 16 19 61 YES 1 2 1 PA Northeast
4824 5/17/10 Cyber Analyst $148,111 $71.21 10 16 39 NO 3 1 1 NE C-Plains
4825 9/5/16 Forensics Analyst $78,900 $37.93 3 12 26 NO 3 1 2 PA Northeast
4826 1/7/12 Physical Security $64,797 $31.15 8 14 45 NO 3 2 1 PA Northeast
4830 8/3/17 Malware Reverse Engineer $91,748 $44.11 2 16 36 NO 3 1 2 NE C-Plains
4831 11/23/08 Cyber Analyst $100,632 $48.38 11 16 47 YES 3 1 1 NE C-Plains
4834 4/24/19 Cyber Mgr $100,198 $48.17 1 16 34 NO 1 2 1 IL Midwest
4837 2/6/14 Forensics Analyst $62,836 $30.21 6 16 42 NO 3 1 1 NE C-Plains
4840 2/1/14 Cyber Analyst $87,054 $41.85 6 14 34 NO 2 1 1 IL Midwest
4841 1/8/13 Physical Security $61,121 $29.39 7 16 44 NO 3 1 1 NE C-Plains
4842 7/11/04 Cyber Software Engineer $60,802 $29.23 15 16 59 YES 3 1 1 PA Northeast
4843 6/23/16 Malware Reverse Engineer $86,199 $41.44 4 16 27 NO 4 2 2 IL Midwest
4845 5/23/11 Cyber Analyst $149,466 $71.86 9 16 42 NO 3 1 1 PA Northeast
4846 10/10/13 Physical Security $87,943 $42.28 6 12 29 NO 1 1 1 PA Northeast
4854 11/8/14 Cyber Analyst $149,466 $71.86 5 19 30 NO 3 1 1 PA Northeast
4855 4/2/15 Public and Business Office Team $96,338 $46.32 5 16 42 NO 3 2 1 PA Northeast
4857 9/2/14 Eng Mgr $172,291 $82.83 5 16 52 NO 3 1 1 NE C-Plains
4860 5/5/06 Cyber Analyst $75,179 $36.14 14 14 49 YES 1 2 2 PA Northeast
4864 1/26/18 IT Staff $69,665 $33.49 2 16 24 NO 2 2 1 PA Northeast
4872 1/19/12 Cyber Analyst $68,762 $33.06 8 16 43 NO 4 2 1 IL Midwest
4876 1/11/17 Cyber Analyst $139,377 $67.01 3 16 27 NO 3 1 2 IL Midwest
4879 7/13/02 Advertising $106,600 $51.25 17 16 60 YES 3 1 1 PA Northeast
4880 9/13/11 Forensics Analyst $95,662 $45.99 8 14 31 NO 1 2 1 PA Northeast
4882 3/30/11 Cyber Analyst $81,276 $39.08 9 14 44 NO 3 1 1 IL Midwest
4883 7/31/11 Sr Forensics Mgr $131,580 $63.26 8 14 41 NO 3 1 1 PA Northeast
4885 8/25/02 Advertising $144,571 $69.51 17 16 39 YES 3 1 1 IL Midwest
4897 10/24/07 Marketing $108,604 $52.21 12 19 47 YES 3 2 1 PA Northeast
4901 6/12/11 Acctg/Fin $154,122 $74.10 9 12 49 NO 3 2 2 PA Northeast
4902 9/5/11 Cyber Analyst $82,016 $39.43 8 16 44 NO 3 1 1 IL Midwest
4904 12/19/13 Quality Assurance $139,515 $67.07 6 16 52 NO 1 2 1 NE C-Plains
4905 5/12/18 Cyber Software Engineer $140,865 $67.72 2 14 30 NO 3 1 2 NE C-Plains
4906 11/20/10 Cyber Mgr $186,925 $89.87 9 16 39 NO 1 1 1 IL Midwest
4907 2/6/19 Forensics Analyst $50,421 $24.24 1 16 26 NO 3 2 2 NE C-Plains
4911 5/29/06 Sr Cyber Investigator $92,076 $44.27 14 14 47 YES 2 1 1 IL Midwest
4913 6/13/17 Cyber Analyst $71,851 $34.54 3 14 25 NO 4 1 2 IL Midwest
4915 10/25/11 Cyber Analyst $132,230 $63.57 8 19 31 NO 1 1 1 IL Midwest
4918 5/15/11 Cyber Analyst $143,005 $68.75 9 19 36 NO 3 1 1 PA Northeast
4919 1/29/13 Cyber Analyst $125,367 $60.27 7 16 35 NO 3 1 2 IL Midwest
4931 9/1/16 Cyber Analyst $161,867 $77.82 3 16 26 NO 3 1 2 IL Midwest
4932 2/2/14 Malware Reverse Engineer $128,943 $61.99 6 14 49 NO 3 1 1 PA Northeast
4943 12/5/17 Sr Cyber Investigator $77,443 $37.23 2 16 33 NO 3 1 1 NE C-Plains
4944 6/17/17 Cyber Analyst $143,005 $68.75 3 14 25 NO 4 2 2 IL Midwest
4945 10/13/05 Cyber Analyst $61,902 $29.76 14 16 52 YES 3 1 2 NE C-Plains
4946 2/21/15 Forensics Analyst $72,352 $34.78 5 16 29 NO 4 1 2 PA Northeast
4947 6/21/13 Cyber Analyst $121,455 $58.39 7 16 40 NO 1 1 1 PA Northeast
4950 10/18/17 Cyber Analyst $118,997 $57.21 2 14 25 NO 1 1 1 PA Northeast
4953 1/5/16 Forensics Analyst $114,854 $55.22 4 14 26 NO 3 1 2 PA Northeast
4957 3/2/09 Cyber Analyst $110,877 $53.31 11 19 50 YES 3 1 1 PA Northeast
4958 7/17/13 Forensics Analyst $162,030 $77.90 6 12 31 NO 4 1 2 IL Midwest
4960 4/10/13 Cyber Analyst $84,275 $40.52 7 16 41 NO 3 1 1 PA Northeast
4961 1/25/05 Cyber Analyst $117,214 $56.35 15 16 54 YES 2 1 1 PA Northeast
4964 10/21/10 Cyber Analyst $83,911 $40.34 9 16 48 NO 3 1 1 NE C-Plains
4965 2/27/12 Cyber Analyst $163,045 $78.39 8 16 50 NO 1 1 1 PA Northeast
4971 1/24/04 Marketing $76,702 $36.88 16 14 48 YES 3 2 1 NE C-Plains
4972 7/27/07 Forensics Analyst $151,523 $72.85 12 16 34 YES 3 1 2 PA Northeast
4981 2/2/10 Cyber Analyst $117,692 $56.58 10 14 43 NO 1 1 2 IL Midwest
4982 1/19/18 Physical Security $74,512 $35.82 2 14 24 NO 1 2 1 NE C-Plains
4992 4/20/15 Malware Reverse Engineer $99,821 $47.99 5 12 36 NO 3 2 2 IL Midwest
4998 9/25/10 Cyber Analyst $75,969 $36.52 9 14 37 NO 3 1 2 IL Midwest
I couldn't delete thses last two sections fully, It was messing up my charts data.
Section 2: Complete Summary tables for Graphing
Sales Summary (Provided)
# Race # % Yr Sales
Acctg/Fin 0 1 African-Am 98 26% 2003 $1,656,872
Admin 3 2 Asian 25 7% 2004 $47,830,245
Advertising 6 3 Caucasian 216 58% 2005 $84,088,009
CEO 1 4 Hispanic 33 9% 2006 $130,427,572
CFO 1 TOTAL 372 100% 2007 $146,938,882
CIO 1 2008 $139,117,818
Controller 1 2009 $143,547,199
COO 1 Gender # % 2010 $144,834,875
Cyber Analyst 146 1 Male 295 79% 2011 $149,578,842
Cyber Mgr 8 2 Female 77 21% 2012 $155,740,613
Cyber Software Engineer 0 TOTAL 372 100% 2013 $144,759,828
Eng Mgr 3 2014 $156,714,301
Forensics Analyst 0 2015 $150,201,379
Investigator 8 Education Level # % 2016 $154,750,829
IT Mgr 2 12 HS 18 5% 2017 $158,253,462
IT Staff 18 14 AA 87 23% 2018 $156,494,223
Logistics 0 16 BA/BS 203 55% 2019 $165,800,498
Logistics Mgr 0 19 Masters+ 64 17% 2020
Malware Reverse Engineer 16 TOTAL 372 100% 2021
Marketing 5 2022
Physical Security 18 2023
Public and Business Office Team 14 Marital Status # % 2024
Public and Business Office Team Mgr 0 1 Married 268 72%
Quality Assurance 5 2 Single 104 28%
Sr Cyber Analyst 2 TOTAL 372 ##
Sr Cyber Investigator 26
Sr Forensics Mgr 3
Sr Public and Business Office Team Mgr 0 Region Key
TOTAL 288 State State # %
PA Northeast 149 40%
IL Midwest 125 34%
NE C-Plains 98 26%
TOTAL 372 100%
Section 3: Complete Descriptive Statistics
Be sure to include the correct units where applicable for the summary statistics below
Descriptive Statistics 53.7504807692 17.4666666667 16 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+

Awais Khan &D &P of &N

Summary Statistics

Salary Hrly Rate Yrs of SVC Ed Age
Mean 99672.2311827957 Mean 47.9193419148 Mean 7.6339531063 Mean 15.8548387097 Mean 40.0510752688
Standard Error 1703.3349438993 Standard Error 0.8189110307 Standard Error 0.2249815139 Standard Error 0.0934079641 Standard Error 0.5151533117
Median 91475.5 Median 43.9786057692 Median 7.0819444444 Median 16 Median 39
Mode 154933 Mode 74.4870192308 Mode 15.4722222222 Mode 16 Mode 40
Standard Deviation 32852.73465592 Standard Deviation 15.7945839692 Standard Deviation 4.3392862964 Standard Deviation 1.8015875676 Standard Deviation 9.9359172536
Sample Variance 1079302174.37229 Sample Variance 249.4688827599 Sample Variance 18.8294055622 Sample Variance 3.2457177637 Sample Variance 98.7224516709
Kurtosis 0.2695669596 Kurtosis 0.2695669596 Kurtosis -0.3501254665 Kurtosis -0.0946058413 Kurtosis -0.6537591283
Skewness 0.765349626 Skewness 0.765349626 Skewness 0.6089293155 Skewness 0.1879424621 Skewness 0.3095312361
Range 206948 Range 99.4942307692 Range 18.3527777778 Range 7 Range 47
Minimum 32367 Minimum 15.5610576923 Minimum 0.1055555556 Minimum 12 Minimum 21
Maximum 239315 Maximum 115.0552884615 Maximum 18.4583333333 Maximum 19 Maximum 68
Sum 37078070 Sum 17825.9951923077 Sum 2839.8305555556 Sum 5898 Sum 14899
Count 372 Count 372 Count 372 Count 372 Count 372
1

Graphs_Charts

Pi Charts
Bar Charts
Line Chart

Martial Status

Married Single TOTAL 268 104 372 Married Single TOTAL 0.72043010752688175 0.27956989247311825 0

Number of Employees Per States

#

Northeast Midwest C-Plains TOTAL PA IL NE 149 125 98 372 %

Northeast Midwest C-Plains TOTAL PA IL NE 0.40053763440860213 0.33602150537634407 0.26344086021505375 1

States

Employees

Number of employees by race

African-Am Asian Caucasian Hispanic TOTAL 98 25 216 33 372

African-Am Asian Caucasian Hispanic TOTAL 0.26344086021505375 6.7204301075268813E-2 0.58064516129032262 8.8709677419354843E-2 1

Race

Employees

Sales Summary

Yr

2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 Sales

1656871.8930150992 47830244.546799615 84088009.193400696 130427572.07159656 146938882.11983776 139117817.9909192 143547199.3314777 144834874.89356914 149578841.81593996 155740613.19537732 144759828.34312081 156714300.52984941 150201379.20405364 154750828.73739058 158253462.20716339 156494222.6692971 165800497.95999998

Gender

[CATEGORY NAME] 79% Female 21% Male Female 300 72 Educational Level BA/BS 55% Master's 17% AA 23% HS 5% HS AA BA/BS Masters 12 14 16 19 215 37 93 27 HS AA BA/BS Masters 12 14 16 19 0.57795698924731187 9.9462365591397844E-2 0.25 7.2580645161290328E-2

Histogram

Histrogram
Frequency Table by Salary Ranges
Bin Range / Upper Limit Label
20000 9
30000 38
40000 76
50000 46
60000 75
70000 54
80000 24
90000 38
100000 6
110000 3
120000 1
130000 0
140000 1
150000 0
160000 0
170000 0
180000 0
190000 0
200000 1
More 0

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 200+ 9 38 76 46 75 54 24 38 6 3 1 0 1 0 0 0 0 0 0 1

QR 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 were 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.)

Sorted Data

Workforce Profile Analysis
Section 1: Complete all Columns in Data Set
Format for:print

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/2015 Sr Cyber Investigator $92,267 #SPILL! 5 19 35 NO 3 1 1 2 IL Midwest
4354 7/17/02 Acctg/Fin $68,056 17 14 62 YES 1 1 1 NE C-Plains
4191 7/11/04 Acctg/Fin $71,026 15 16 49 YES 3 1 2 NE C-Plains
4730 8/31/04 Acctg/Fin $107,530 15 14 42 YES 3 2 2 NE C-Plains
4475 12/12/12 Acctg/Fin $75,415 7 12 48 NO 3 1 1 NE C-Plains
4775 6/24/13 Acctg/Fin $162,030 7 14 38 NO 2 1 2 NE C-Plains
4470 5/17/15 Acctg/Fin $66,528 5 16 35 NO 1 2 1 NE C-Plains
4402 12/7/18 Acctg/Fin $152,030 1 16 25 NO 3 2 1 NE C-Plains
4564 11/23/12 Advertising $88,639 7 16 34 NO 3 1 2 NE C-Plains
4023 2/6/14 Advertising $128,384 6 16 28 NO 1 2 2 NE C-Plains
4520 4/11/04 CIO $179,195 16 19 50 YES 3 1 1 NE C-Plains
4439 2/2/04 Cyber Analyst $69,656 16 16 57 YES 1 1 1 NE C-Plains
4167 8/26/05 Cyber Analyst $111,536 14 16 51 YES 1 1 1 NE C-Plains
4369 8/31/05 Cyber Analyst $156,750 14 16 51 YES 3 1 2 NE C-Plains
4945 10/13/05 Cyber Analyst $61,902 14 16 52 YES 3 1 2 NE C-Plains
4355 4/1/07 Cyber Analyst $150,263 13 12 53 YES 2 1 1 NE C-Plains
4296 12/9/07 Cyber Analyst $150,868 12 16 53 YES 2 1 1 NE C-Plains
4517 7/27/08 Cyber Analyst $140,865 11 19 49 YES 1 1 2 NE C-Plains
4831 11/23/08 Cyber Analyst $100,632 11 16 47 YES 3 1 1 NE C-Plains
4137 1/14/09 Cyber Analyst $98,634 11 16 52 YES 3 1 1 NE C-Plains
4012 1/26/10 Cyber Analyst $95,985 10 14 43 NO 1 1 1 NE C-Plains
4824 5/17/10 Cyber Analyst $148,111 10 16 39 NO 3 1 1 NE C-Plains
4093 8/25/10 Cyber Analyst $93,936 9 19 47 NO 3 1 2 NE C-Plains
4278 9/6/10 Cyber Analyst $90,153 9 14 40 NO 4 1 1 NE C-Plains
4699 10/8/10 Cyber Analyst $79,542 9 16 50 NO 3 1 1 NE C-Plains
4964 10/21/10 Cyber Analyst $83,911 9 16 48 NO 3 1 1 NE C-Plains
4472 2/15/11 Cyber Analyst $74,381 9 16 46 NO 3 1 1 NE C-Plains
4479 3/16/11 Cyber Analyst $68,375 9 16 40 NO 1 1 2 NE C-Plains
4299 6/1/11 Cyber Analyst $76,158 9 16 38 NO 4 1 1 NE C-Plains
4121 8/31/11 Cyber Analyst $148,111 8 16 36 NO 2 1 1 NE C-Plains
4803 10/29/11 Cyber Analyst $52,064 8 14 34 NO 3 1 1 NE C-Plains
4513 2/19/12 Cyber Analyst $103,721 8 14 46 NO 3 1 1 NE C-Plains
4326 5/3/12 Cyber Analyst $65,955 8 14 39 NO 3 1 1 NE C-Plains
4199 7/16/12 Cyber Analyst $151,174 7 16 38 NO 3 1 1 NE C-Plains
4152 7/19/12 Cyber Analyst $151,523 7 16 41 NO 1 1 1 NE C-Plains
4265 6/24/13 Cyber Analyst $81,042 7 16 30 NO 3 1 2 NE C-Plains
4798 9/22/13 Cyber Analyst $119,285 6 16 28 NO 3 1 2 NE C-Plains
4820 12/14/13 Cyber Analyst $69,777 6 19 43 NO 3 1 1 NE C-Plains
4489 3/28/14 Cyber Analyst $83,075 6 16 38 NO 3 1 2 NE C-Plains
4207 6/22/14 Cyber Analyst $91,205 6 14 37 NO 3 1 1 NE C-Plains
4274 12/8/14 Cyber Analyst $87,092 5 16 30 NO 3 1 1 NE C-Plains
4423 6/20/15 Cyber Analyst $102,641 5 14 29 NO 1 1 1 NE C-Plains
4330 10/14/15 Cyber Analyst $94,038 4 16 30 NO 1 1 2 NE C-Plains
4044 12/3/15 Cyber Analyst $59,219 4 14 35 NO 3 1 2 NE C-Plains
4126 12/24/16 Cyber Analyst $60,641 3 16 34 NO 4 1 1 NE C-Plains
4612 3/17/16 Cyber Mgr $111,196 4 16 36 NO 4 1 1 NE C-Plains
4304 6/1/06 Cyber Software Engineer $81,779 14 16 51 YES 3 1 1 NE C-Plains
4455 10/17/08 Cyber Software Engineer $152,446 11 16 54 YES 3 1 1 NE C-Plains
4618 6/13/11 Cyber Software Engineer $76,031 9 19 42 NO 3 1 1 NE C-Plains
4175 11/29/11 Cyber Software Engineer $162,731 8 16 54 NO 3 1 1 NE C-Plains
4405 9/27/12 Cyber Software Engineer $54,080 7 19 44 NO 2 1 2 NE C-Plains
4490 3/11/13 Cyber Software Engineer $100,571 7 16 42 NO 2 2 1 NE C-Plains
4745 3/14/17 Cyber Software Engineer $75,144 3 16 28 NO 1 2 2 NE C-Plains
4380 7/1/17 Cyber Software Engineer $104,793 3 14 25 NO 3 2 1 NE C-Plains
4905 5/12/18 Cyber Software Engineer $140,865 2 14 30 NO 3 1 2 NE C-Plains
4383 12/16/09 Eng Mgr $175,916 10 14 44 YES 3 1 1 NE C-Plains
4857 9/2/14 Eng Mgr $172,291 5 16 52 NO 3 1 1 NE C-Plains
4806 5/4/11 Forensics Analyst $116,208 9 16 32 NO 1 1 1 NE C-Plains
4786 8/6/11 Forensics Analyst $154,933 8 16 31 NO 1 1 1 NE C-Plains
4709 10/4/12 Forensics Analyst $143,063 7 16 31 NO 1 1 2 NE C-Plains
4345 7/4/13 Forensics Analyst $87,480 6 16 26 NO 1 1 1 NE C-Plains
4480 1/4/14 Forensics Analyst $101,709 6 16 24 NO 4 1 1 NE C-Plains
4837 2/6/14 Forensics Analyst $62,836 6 16 42 NO 3 1 1 NE C-Plains
4714 8/24/15 Forensics Analyst $94,700 4 14 35 NO 1 1 2 NE C-Plains
4135 2/24/16 Forensics Analyst $76,956 4 16 26 NO 3 1 2 NE C-Plains
4394 5/6/18 Forensics Analyst $89,197 2 14 21 NO 3 1 2 NE C-Plains
4519 5/29/18 Forensics Analyst $128,901 2 14 26 NO 3 1 2 NE C-Plains
4544 8/15/18 Forensics Analyst $69,935 1 16 22 NO 1 1 2 NE C-Plains
4907 2/6/19 Forensics Analyst $50,421 1 16 26 NO 3 2 2 NE C-Plains
4611 7/17/02 Investigator $132,142 17 14 53 YES 3 1 1 NE C-Plains
4450 1/12/06 Investigator $90,794 14 16 39 YES 3 1 1 NE C-Plains
4346 9/4/06 Investigator $100,314 13 16 51 YES 3 1 1 NE C-Plains
4617 9/20/06 IT Staff $87,407 13 14 51 YES 1 1 1 NE C-Plains
4429 1/28/10 IT Staff $68,647 10 14 50 NO 3 1 1 NE C-Plains
4769 9/15/14 IT Staff $71,311 5 14 37 NO 3 1 1 NE C-Plains
4183 10/29/14 IT Staff $65,126 5 16 38 NO 1 1 1 NE C-Plains
4620 4/29/11 Malware Reverse Engineer $178,456 9 16 34 NO 3 1 1 NE C-Plains
4498 12/4/11 Malware Reverse Engineer $82,319 8 19 40 NO 3 1 1 NE C-Plains
4759 10/11/13 Malware Reverse Engineer $67,624 6 16 37 NO 3 2 1 NE C-Plains
4830 8/3/17 Malware Reverse Engineer $91,748 2 16 36 NO 3 1 2 NE C-Plains
4971 1/24/04 Marketing $76,702 16 14 48 YES 3 2 1 NE C-Plains
4841 1/8/13 Physical Security $61,121 7 16 44 NO 3 1 1 NE C-Plains
4668 5/21/13 Physical Security $43,367 7 16 29 NO 3 1 2 NE C-Plains
4045 6/7/16 Physical Security $32,367 4 12 25 NO 3 2 2 NE C-Plains
4982 1/19/18 Physical Security $74,512 2 14 24 NO 1 2 1 NE C-Plains
4155 7/16/01 Public and Business Office Team $89,522 18 19 68 YES 3 1 1 NE C-Plains
4440 7/21/14 Public and Business Office Team $111,794 5 19 45 NO 1 1 2 NE C-Plains
4343 12/29/17 Public and Business Office Team $96,327 2 16 40 NO 4 1 1 NE C-Plains
4212 4/4/19 Public and Business Office Team $61,068 1 16 37 NO 3 1 1 NE C-Plains
4904 12/19/13 Quality Assurance $139,515 6 16 52 NO 1 2 1 NE C-Plains
4484 4/18/18 Quality Assurance $111,424 2 16 35 NO 3 1 1 NE C-Plains
4027 8/19/06 Sr Cyber Investigator $71,914 13 16 51 YES 1 1 1 NE C-Plains
4359 11/26/06 Sr Cyber Investigator $76,864 13 19 53 YES 3 1 1 NE C-Plains
4458 12/15/06 Sr Cyber Investigator $156,750 13 16 61 YES 1 1 2 NE C-Plains
4572 10/6/10 Sr Cyber Investigator $92,079 9 19 40 NO 3 1 1 NE C-Plains
4683 5/6/11 Sr Cyber Investigator $58,294 9 19 40 NO 4 1 1 NE C-Plains
4943 12/5/17 Sr Cyber Investigator $77,443 2 16 33 NO 3 1 1 NE C-Plains
4301 11/7/13 Sr Forensics Mgr $96,582 6 19 40 NO 1 1 1 NE C-Plains
4424 2/23/16 Sr Public and Business Office Team Mgr $107,153 4 16 51 NO 3 2 1 NE C-Plains
4393 9/2/15 Admin $108,058 4 16 37 NO 4 1 2 IL Midwest
4885 8/25/02 Advertising $144,571 17 16 39 YES 3 1 1 IL Midwest
4214 5/9/13 Advertising $145,776 7 19 30 NO 3 2 2 IL Midwest
4727 9/7/12 CFO $122,391 7 16 48 NO 4 1 2 IL Midwest
4436 10/5/04 Controller $71,727 15 19 50 YES 3 2 1 IL Midwest
4386 7/19/08 COO $154,933 11 19 43 YES 3 1 2 IL Midwest
4566 9/28/01 Cyber Analyst $87,517 18 14 57 YES 3 1 1 IL Midwest
4004 7/13/02 Cyber Analyst $111,801 17 16 60 YES 3 1 1 IL Midwest
4068 7/15/03 Cyber Analyst $145,776 16 16 59 YES 3 1 1 IL Midwest
4181 7/15/03 Cyber Analyst $123,391 16 12 59 YES 3 1 1 IL Midwest
4565 6/13/04 Cyber Analyst $79,584 16 14 55 YES 3 1 1 IL Midwest
4314 12/28/05 Cyber Analyst $98,771 14 19 59 YES 1 1 1 IL Midwest
4535 6/14/06 Cyber Analyst $110,708 14 16 55 YES 3 1 1 IL Midwest
4218 11/30/06 Cyber Analyst $99,130 13 14 50 YES 3 1 1 IL Midwest
4097 2/26/07 Cyber Analyst $162,731 13 16 53 YES 1 1 2 IL Midwest
4377 2/12/08 Cyber Analyst $151,523 12 16 56 YES 1 1 1 IL Midwest
4742 4/21/08 Cyber Analyst $90,599 12 16 50 YES 1 1 1 IL Midwest
4459 5/22/09 Cyber Analyst $115,580 11 16 54 YES 1 1 1 IL Midwest
4981 2/2/10 Cyber Analyst $117,692 10 14 43 NO 1 1 2 IL Midwest
4811 4/22/10 Cyber Analyst $74,814 10 19 42 NO 2 1 1 IL Midwest
4998 9/25/10 Cyber Analyst $75,969 9 14 37 NO 3 1 2 IL Midwest
4576 10/30/10 Cyber Analyst $92,931 9 16 51 NO 3 1 1 IL Midwest
4285 3/30/11 Cyber Analyst $80,909 9 16 40 NO 1 1 1 IL Midwest
4882 3/30/11 Cyber Analyst $81,276 9 14 44 NO 3 1 1 IL Midwest
4029 6/5/11 Cyber Analyst $152,446 9 14 36 NO 4 1 2 IL Midwest
4571 7/12/11 Cyber Analyst $75,261 8 12 43 NO 3 1 1 IL Midwest
4902 9/5/11 Cyber Analyst $82,016 8 16 44 NO 3 1 1 IL Midwest
4915 10/25/11 Cyber Analyst $132,230 8 19 31 NO 1 1 1 IL Midwest
4013 12/29/11 Cyber Analyst $100,520 8 19 44 NO 3 1 1 IL Midwest
4381 12/29/11 Cyber Analyst $112,223 8 16 44 NO 3 1 1 IL Midwest
4872 1/19/12 Cyber Analyst $68,762 8 16 43 NO 4 2 1 IL Midwest
4409 5/1/12 Cyber Analyst $112,402 8 14 41 NO 2 1 1 IL Midwest
4441 8/5/12 Cyber Analyst $80,198 7 16 37 NO 1 1 1 IL Midwest
4258 1/24/13 Cyber Analyst $58,540 7 14 44 NO 1 1 1 IL Midwest
4919 1/29/13 Cyber Analyst $125,367 7 16 35 NO 3 1 2 IL Midwest
4232 4/9/13 Cyber Analyst $86,787 7 16 34 NO 1 2 1 IL Midwest
4665 8/16/13 Cyber Analyst $115,283 6 14 37 NO 1 1 1 IL Midwest
4204 12/14/13 Cyber Analyst $61,212 6 14 43 NO 1 1 1 IL Midwest
4840 2/1/14 Cyber Analyst $87,054 6 14 34 NO 2 1 1 IL Midwest
4139 2/20/14 Cyber Analyst $87,056 6 16 41 NO 3 1 1 IL Midwest
4122 8/4/14 Cyber Analyst $86,147 5 16 39 NO 2 1 1 IL Midwest
4163 9/11/14 Cyber Analyst $74,419 5 14 38 NO 1 1 1 IL Midwest
4205 11/26/14 Cyber Analyst $106,640 5 14 40 NO 4 2 1 IL Midwest
4695 1/31/15 Cyber Analyst $88,743 5 19 33 NO 2 2 2 IL Midwest
4082 7/2/15 Cyber Analyst $82,411 4 16 37 NO 3 1 1 IL Midwest
4260 9/19/15 Cyber Analyst $88,743 4 14 27 NO 3 1 2 IL Midwest
4090 11/15/15 Cyber Analyst $87,641 4 14 33 NO 4 1 2 IL Midwest
4311 12/13/15 Cyber Analyst $92,847 4 16 31 NO 3 1 1 IL Midwest
4597 12/17/15 Cyber Analyst $158,066 4 16 28 NO 4 1 1 IL Midwest
4291 12/25/15 Cyber Analyst $66,938 4 16 39 NO 3 1 1 IL Midwest
4119 8/31/16 Cyber Analyst $86,384 3 16 26 NO 3 1 2 IL Midwest
4931 9/1/16 Cyber Analyst $161,867 3 16 26 NO 3 1 2 IL Midwest
4876 1/11/17 Cyber Analyst $139,377 3 16 27 NO 3 1 2 IL Midwest
4913 6/13/17 Cyber Analyst $71,851 3 14 25 NO 4 1 2 IL Midwest
4944 6/17/17 Cyber Analyst $143,005 3 14 25 NO 4 2 2 IL Midwest
4457 8/13/17 Cyber Analyst $102,913 2 16 25 NO 1 2 2 IL Midwest
4147 9/30/17 Cyber Analyst $122,352 2 16 28 NO 3 2 2 IL Midwest
4176 11/23/17 Cyber Analyst $135,533 2 14 28 NO 3 1 1 IL Midwest
4621 12/1/18 Cyber Analyst $81,730 1 16 27 NO 3 2 1 IL Midwest
4482 7/20/01 Cyber Mgr $77,247 18 14 48 YES 4 2 1 IL Midwest
4906 11/20/10 Cyber Mgr $186,925 9 16 39 NO 1 1 1 IL Midwest
4368 2/24/18 Cyber Mgr $79,063 2 14 40 NO 3 2 1 IL Midwest
4834 4/24/19 Cyber Mgr $100,198 1 16 34 NO 1 2 1 IL Midwest
4619 9/30/12 Cyber Software Engineer $83,424 7 16 44 NO 3 2 1 IL Midwest
4411 9/25/14 Cyber Software Engineer $95,128 5 19 42 NO 3 2 1 IL Midwest
4471 5/15/18 Cyber Software Engineer $164,033 2 14 30 NO 3 1 1 IL Midwest
4438 11/18/09 Forensics Analyst $54,060 10 16 32 YES 3 2 2 IL Midwest
4809 11/6/10 Forensics Analyst $99,135 9 14 35 NO 3 1 1 IL Midwest
4361 6/10/11 Forensics Analyst $87,601 9 16 30 NO 4 1 1 IL Midwest
4014 10/2/11 Forensics Analyst $125,156 8 19 31 NO 1 1 1 IL Midwest
4660 9/9/12 Forensics Analyst $120,986 7 19 29 NO 4 1 1 IL Midwest
4653 9/13/12 Forensics Analyst $91,131 7 19 30 NO 3 1 1 IL Midwest
4958 7/17/13 Forensics Analyst $162,030 6 12 31 NO 4 1 2 IL Midwest
4474 9/26/13 Forensics Analyst $113,023 6 16 28 NO 3 1 2 IL Midwest
4319 12/3/13 Forensics Analyst $63,933 6 19 34 NO 3 1 2 IL Midwest
4075 10/2/16 Forensics Analyst $75,053 3 14 25 NO 3 1 2 IL Midwest
4198 6/5/17 Forensics Analyst $73,447 3 14 27 NO 3 1 2 IL Midwest
4247 11/23/19 Forensics Analyst $105,069 0 16 21 NO 1 1 2 IL Midwest
4630 10/13/07 Investigator $61,779 12 16 34 YES 1 1 1 IL Midwest
4592 10/6/09 Investigator $133,138 10 16 33 YES 3 2 1 IL Midwest
4239 1/6/17 Investigator $78,985 3 16 33 NO 3 1 2 IL Midwest
4279 11/3/17 Investigator $95,220 2 19 31 NO 2 1 1 IL Midwest
4118 8/13/17 IT Mgr $154,933 2 16 24 NO 3 1 1 IL Midwest
4780 8/2/02 IT Staff $62,747 17 19 52 YES 3 1 1 IL Midwest
4030 7/10/11 IT Staff $57,727 8 16 51 NO 3 1 1 IL Midwest
4790 6/11/13 IT Staff $141,110 7 16 36 NO 3 1 1 IL Midwest
4237 11/2/14 IT Staff $95,957 5 16 41 NO 3 2 1 IL Midwest
4208 2/15/16 IT Staff $61,383 4 14 26 NO 3 1 1 IL Midwest
4421 2/12/15 Logistics $64,201 5 16 34 NO 3 1 1 IL Midwest
4766 9/23/15 Logistics $84,076 4 19 36 NO 3 2 1 IL Midwest
4337 10/11/15 Logistics Mgr $64,200 4 16 53 NO 1 1 1 IL Midwest
4385 9/25/08 Malware Reverse Engineer $74,039 11 19 49 YES 3 1 2 IL Midwest
4221 7/10/11 Malware reverse engineer $74,000 8 19 40 NO 3 2 2 IL Midwest
4253 11/18/13 Malware reverse engineer $86,377 6 14 40 NO 1 1 2 IL Midwest
4626 8/19/14 Malware Reverse Engineer $55,720 5 16 34 NO 3 1 2 IL Midwest
4992 4/20/15 Malware Reverse Engineer $99,821 5 12 36 NO 3 2 2 IL Midwest
4843 6/23/16 Malware Reverse Engineer $86,199 4 16 27 NO 4 2 2 IL Midwest
4687 8/25/18 Malware Reverse Engineer $87,583 1 14 39 NO 2 1 2 IL Midwest
4771 12/1/13 Marketing $159,215 6 19 40 NO 1 1 1 IL Midwest
4302 3/8/17 Marketing $87,519 3 16 37 NO 3 2 1 IL Midwest
4442 11/10/11 Physical Security $72,536 8 14 39 NO 1 2 1 IL Midwest
4677 11/11/14 Physical Security $43,367 5 16 33 NO 3 1 1 IL Midwest
4532 2/10/16 Physical Security $43,367 4 16 34 NO 3 1 1 IL Midwest
4507 8/11/16 Physical Security $55,542 3 14 30 NO 2 2 1 IL Midwest
4150 9/6/17 Physical Security $33,367 2 12 22 NO 1 1 1 IL Midwest
4554 1/22/18 Physical Security $43,962 2 12 22 NO 3 2 2 IL Midwest
4324 6/4/11 Public and Business Office Team $87,409 9 14 58 NO 4 1 1 IL Midwest
4106 5/7/17 Public and Business Office Team $150,263 3 16 57 NO 3 1 1 IL Midwest
4435 6/17/17 Public and Business Office Team $141,110 3 16 37 NO 1 2 1 IL Midwest
4088 7/18/17 Public and Business Office Team $108,342 2 16 34 NO 3 2 1 IL Midwest
4675 8/10/13 Quality Assurance $101,360 6 16 40 NO 3 1 1 IL Midwest
4740 11/1/16 Quality Assurance $77,495 3 16 45 NO 3 2 2 IL Midwest
4316 10/7/17 Sr Cyber Analyst $149,466 2 16 31 NO 4 1 1 IL Midwest
4782 4/6/19 Sr Cyber Analyst $154,122 1 19 33 NO 1 1 2 IL Midwest
4911 5/29/06 Sr Cyber Investigator $92,076 14 14 47 YES 2 1 1 IL Midwest
4307 8/27/07 Sr Cyber Investigator $73,807 12 16 46 YES 3 1 2 IL Midwest
4060 2/1/12 Sr Cyber Investigator $73,650 8 19 42 NO 3 1 1 IL Midwest
4406 6/10/13 Sr Cyber Investigator $116,075 7 19 37 NO 1 1 2 IL Midwest
4120 8/30/13 Sr Cyber Investigator $127,190 6 16 34 NO 3 1 1 IL Midwest
4522 12/10/15 Sr Cyber Investigator $85,442 4 19 38 NO 1 2 1 IL Midwest
4468 1/10/17 Sr Cyber Investigator $163,045 3 16 33 NO 1 1 1 IL Midwest
4144 12/4/17 Sr Cyber Investigator $96,062 2 16 31 NO 4 2 1 IL Midwest
4591 1/4/16 Sr Forensics Mgr $109,128 4 16 48 NO 3 1 1 IL Midwest
4186 3/9/18 Sr Public and Business Office Team Mgr $172,291 2 16 57 NO 1 1 1 IL Midwest
4901 6/12/11 Acctg/Fin $154,122 9 12 49 NO 3 2 2 PA Northeast
4733 8/9/12 Acctg/Fin $80,666 7 16 44 NO 3 1 1 PA Northeast
4169 3/14/14 Acctg/Fin $65,100 6 14 40 NO 3 2 1 PA Northeast
4134 6/30/17 Acctg/Fin $98,007 3 19 28 NO 1 1 2 PA Northeast
4817 7/4/17 Acctg/Fin $84,270 2 16 30 NO 3 1 1 PA Northeast
4272 7/18/14 Admin $78,873 5 12 36 NO 1 2 2 PA Northeast
4734 10/21/16 Admin $87,047 3 14 25 NO 3 2 2 PA Northeast
4879 7/13/02 Advertising $106,600 17 16 60 YES 3 1 1 PA Northeast
4396 12/10/12 Advertising $101,341 7 14 39 NO 3 2 2 PA Northeast
4418 7/11/04 CEO $239,315 15 19 58 YES 3 1 1 PA Northeast
4580 7/16/01 Cyber Analyst $186,670 18 16 60 YES 1 1 2 PA Northeast
4128 5/16/03 Cyber Analyst $126,426 17 14 56 YES 3 1 1 PA Northeast
4589 7/11/03 Cyber Analyst $70,358 16 14 55 YES 3 1 1 PA Northeast
4022 5/27/04 Cyber Analyst $69,529 16 16 53 YES 3 1 1 PA Northeast
4332 9/28/04 Cyber Analyst $91,507 15 19 53 YES 3 1 1 PA Northeast
4095 12/31/04 Cyber Analyst $133,678 15 16 52 YES 3 1 1 PA Northeast
4961 1/25/05 Cyber Analyst $117,214 15 16 54 YES 2 1 1 PA Northeast
4461 11/16/05 Cyber Analyst $75,074 14 19 58 YES 1 1 1 PA Northeast
4860 5/5/06 Cyber Analyst $75,179 14 14 49 YES 1 2 2 PA Northeast
4719 9/1/06 Cyber Analyst $98,234 13 16 58 YES 3 1 1 PA Northeast
4046 9/4/06 Cyber Analyst $115,974 13 16 54 YES 1 1 1 PA Northeast
4220 9/17/06 Cyber Analyst $164,033 13 16 54 YES 3 1 1 PA Northeast
4419 12/17/06 Cyber Analyst $70,237 13 16 57 YES 2 1 1 PA Northeast
4466 6/2/07 Cyber Analyst $94,876 13 16 48 YES 3 1 1 PA Northeast
4086 9/18/07 Cyber Analyst $114,721 12 14 51 YES 3 1 1 PA Northeast
4813 6/20/08 Cyber Analyst $127,890 12 12 47 YES 3 1 1 PA Northeast
4587 6/24/08 Cyber Analyst $76,499 12 14 46 YES 1 1 1 PA Northeast
4407 11/20/08 Cyber Analyst $73,005 11 14 43 YES 3 1 1 PA Northeast
4957 3/2/09 Cyber Analyst $110,877 11 19 50 YES 3 1 1 PA Northeast
4515 6/13/09 Cyber Analyst $89,165 11 19 49 YES 3 2 1 PA Northeast
4078 7/15/09 Cyber Analyst $83,851 10 16 51 YES 1 1 1 PA Northeast
4717 12/19/09 Cyber Analyst $82,601 10 19 41 YES 1 1 1 PA Northeast
4428 2/6/10 Cyber Analyst $73,640 10 16 45 NO 3 1 1 PA Northeast
4329 6/21/10 Cyber Analyst $119,537 10 19 47 NO 4 1 2 PA Northeast
4310 1/21/11 Cyber Analyst $108,326 9 19 41 NO 3 1 1 PA Northeast
4558 1/31/11 Cyber Analyst $85,256 9 16 41 NO 3 1 1 PA Northeast
4020 5/9/11 Cyber Analyst $93,518 9 14 39 NO 1 1 1 PA Northeast
4918 5/15/11 Cyber Analyst $143,005 9 19 36 NO 3 1 1 PA Northeast
4845 5/23/11 Cyber Analyst $149,466 9 16 42 NO 3 1 1 PA Northeast
4342 7/13/11 Cyber Analyst $156,750 8 16 38 NO 4 1 1 PA Northeast
4146 12/4/11 Cyber Analyst $104,961 8 16 41 NO 1 1 1 PA Northeast
4015 1/1/12 Cyber Analyst $78,475 8 16 40 NO 3 1 2 PA Northeast
4593 1/20/12 Cyber Analyst $86,597 8 14 44 NO 1 1 1 PA Northeast
4965 2/27/12 Cyber Analyst $163,045 8 16 50 NO 1 1 1 PA Northeast
4061 2/28/12 Cyber Analyst $154,933 8 16 34 NO 3 1 2 PA Northeast
4038 4/14/12 Cyber Analyst $64,580 8 16 40 NO 1 1 1 PA Northeast
4690 6/27/12 Cyber Analyst $82,471 8 16 39 NO 3 1 2 PA Northeast
4746 10/4/12 Cyber Analyst $84,679 7 19 35 NO 3 1 1 PA Northeast
4731 10/12/12 Cyber Analyst $83,430 7 16 38 NO 3 1 1 PA Northeast
4543 10/20/12 Cyber Analyst $148,111 7 14 33 NO 3 1 1 PA Northeast
4960 4/10/13 Cyber Analyst $84,275 7 16 41 NO 3 1 1 PA Northeast
4397 5/20/13 Cyber Analyst $84,175 7 16 37 NO 3 1 1 PA Northeast
4039 5/30/13 Cyber Analyst $91,771 7 16 30 NO 3 1 2 PA Northeast
4947 6/21/13 Cyber Analyst $121,455 7 16 40 NO 1 1 1 PA Northeast
4465 10/13/13 Cyber Analyst $83,367 6 16 37 NO 1 1 2 PA Northeast
4107 11/5/13 Cyber Analyst $78,334 6 19 34 NO 3 1 1 PA Northeast
4287 2/5/14 Cyber Analyst $63,777 6 14 35 NO 3 1 2 PA Northeast
4712 2/25/14 Cyber Analyst $97,323 6 14 34 NO 1 2 1 PA Northeast
4594 5/3/14 Cyber Analyst $78,529 6 16 44 NO 1 1 1 PA Northeast
4854 11/8/14 Cyber Analyst $149,466 5 19 30 NO 3 1 1 PA Northeast
4761 1/17/15 Cyber Analyst $162,731 5 16 32 NO 1 1 1 PA Northeast
4410 6/20/15 Cyber Analyst $68,222 5 19 29 NO 3 1 2 PA Northeast
4661 8/29/15 Cyber Analyst $117,062 4 16 27 NO 3 1 1 PA Northeast
4694 11/16/15 Cyber Analyst $101,016 4 16 35 NO 4 1 2 PA Northeast
4064 1/18/16 Cyber Analyst $144,571 4 16 36 NO 4 1 2 PA Northeast
4305 7/27/16 Cyber Analyst $78,015 3 16 31 NO 3 1 1 PA Northeast
4696 8/26/17 Cyber Analyst $128,825 2 16 25 NO 3 1 2 PA Northeast
4950 10/18/17 Cyber Analyst $118,997 2 14 25 NO 1 1 1 PA Northeast
4300 7/10/18 Cyber Analyst $108,866 1 16 27 NO 1 2 1 PA Northeast
4257 7/11/03 Cyber Mgr $104,220 16 19 51 YES 3 2 1 PA Northeast
4700 10/7/14 Cyber Mgr $63,946 5 19 42 NO 3 2 1 PA Northeast
4025 12/12/14 Cyber Mgr $151,174 5 16 38 NO 3 1 1 PA Northeast
4842 7/11/04 Cyber Software Engineer $60,802 15 16 59 YES 3 1 1 PA Northeast
4334 12/28/10 Cyber Software Engineer $103,736 9 19 56 NO 3 1 1 PA Northeast
4784 5/12/12 Cyber Software Engineer $102,238 8 16 45 NO 3 1 1 PA Northeast
4031 10/20/13 Cyber Software Engineer $78,869 6 16 39 NO 3 1 1 PA Northeast
4757 10/15/14 Cyber Software Engineer $112,994 5 16 38 NO 3 1 1 PA Northeast
4671 1/13/15 Cyber Software Engineer $105,637 5 19 44 NO 3 1 1 PA Northeast
4352 7/4/16 Cyber Software Engineer $50,377 3 12 31 NO 2 1 1 PA Northeast
4089 10/16/16 Cyber Software Engineer $81,050 3 16 36 NO 3 1 1 PA Northeast
4818 12/29/16 Cyber Software Engineer $64,458 3 16 29 NO 2 2 2 PA Northeast
4656 12/29/17 Cyber Software Engineer $151,174 2 16 40 NO 3 2 1 PA Northeast
4303 1/19/18 Cyber Software Engineer $113,246 2 19 34 NO 2 1 1 PA Northeast
4541 12/2/09 Eng Mgr $170,954 10 12 49 YES 3 1 2 PA Northeast
4259 9/4/04 Forensics Analyst $106,267 15 16 40 YES 3 1 1 PA Northeast
4972 7/27/07 Forensics Analyst $151,523 12 16 34 YES 3 1 2 PA Northeast
4092 7/7/08 Forensics Analyst $98,943 11 16 36 YES 3 1 1 PA Northeast
4284 12/16/10 Forensics Analyst $143,063 9 14 36 NO 1 1 1 PA Northeast
4880 9/13/11 Forensics Analyst $95,662 8 14 31 NO 1 2 1 PA Northeast
4604 11/10/11 Forensics Analyst $71,671 8 16 31 NO 1 1 1 PA Northeast
4133 5/29/12 Forensics Analyst $119,165 8 16 31 NO 4 1 1 PA Northeast
4748 10/19/12 Forensics Analyst $75,612 7 16 31 NO 3 1 1 PA Northeast
4037 9/13/13 Forensics Analyst $67,866 6 14 25 NO 3 1 2 PA Northeast
4946 2/21/15 Forensics Analyst $72,352 5 16 29 NO 4 1 2 PA Northeast
4953 1/5/16 Forensics Analyst $114,854 4 14 26 NO 3 1 2 PA Northeast
4252 3/23/16 Forensics Analyst $97,885 4 16 28 NO 1 1 1 PA Northeast
4825 9/5/16 Forensics Analyst $78,900 3 12 26 NO 3 1 2 PA Northeast
4070 4/4/17 Forensics Analyst $80,191 3 16 28 NO 1 1 1 PA Northeast
4010 11/25/18 Forensics Analyst $90,688 1 16 23 NO 1 2 2 PA Northeast
4497 10/28/12 Investigator $68,012 7 16 36 NO 4 2 1 PA Northeast
4500 12/5/13 IT Mgr $113,056 6 19 56 NO 3 1 1 PA Northeast
4401 8/25/03 IT Staff $76,305 16 16 55 YES 1 1 1 PA Northeast
4034 5/21/06 IT Staff $90,930 14 19 45 YES 3 1 1 PA Northeast
4567 11/6/07 IT Staff $71,747 12 16 46 YES 2 1 1 PA Northeast
4723 10/8/11 IT Staff $75,270 8 19 35 NO 3 1 1 PA Northeast
4705 8/21/13 IT Staff $80,045 6 14 43 NO 1 1 1 PA Northeast
4563 3/16/16 IT Staff $62,319 4 16 28 NO 3 1 1 PA Northeast
4413 12/21/16 IT Staff $95,622 3 19 36 NO 2 1 1 PA Northeast
4864 1/26/18 IT Staff $69,665 2 16 24 NO 2 2 1 PA Northeast
4055 6/17/18 IT Staff $99,786 2 14 31 NO 1 2 2 PA Northeast
4298 8/28/07 Logistics $83,294 12 16 49 YES 3 1 2 PA Northeast
4104 7/21/08 Logistics $71,690 11 16 51 YES 3 2 1 PA Northeast
4467 8/11/14 Logistics $43,367 5 16 38 NO 3 2 1 PA Northeast
4792 7/11/03 Malware Reverse Engineer $131,698 16 14 63 YES 3 1 1 PA Northeast
4327 1/29/12 Malware Reverse Engineer $68,226 8 16 54 NO 3 1 1 PA Northeast
4067 10/29/12 Malware Reverse Engineer $124,996 7 16 49 NO 2 1 2 PA Northeast
4932 2/2/14 Malware Reverse Engineer $128,943 6 14 49 NO 3 1 1 PA Northeast
4238 6/24/18 Malware Reverse Engineer $101,386 2 16 27 NO 1 1 2 PA Northeast
4897 10/24/07 Marketing $108,604 12 19 47 YES 3 2 1 PA Northeast
4648 7/7/17 Marketing $115,966 2 16 42 NO 3 2 1 PA Northeast
4313 11/11/10 Physical Security $39,808 9 16 46 NO 1 1 1 PA Northeast
4189 4/24/11 Physical Security $53,669 9 14 42 NO 1 2 1 PA Northeast
4826 1/7/12 Physical Security $64,797 8 14 45 NO 3 2 1 PA Northeast
4794 5/3/13 Physical Security $67,987 7 16 34 NO 3 2 1 PA Northeast
4846 10/10/13 Physical Security $87,943 6 12 29 NO 1 1 1 PA Northeast
4713 2/13/14 Physical Security $86,666 6 12 27 NO 1 1 2 PA Northeast
4693 10/2/15 Physical Security $75,920 4 14 30 NO 3 2 1 PA Northeast
4530 5/1/17 Physical Security $72,946 3 14 24 NO 1 2 2 PA Northeast
4768 5/3/13 Public and Business Office Team $114,251 7 14 44 NO 2 2 1 PA Northeast
4388 10/16/14 Public and Business Office Team $119,156 5 16 41 NO 3 1 1 PA Northeast
4855 4/2/15 Public and Business Office Team $96,338 5 16 42 NO 3 2 1 PA Northeast
4387 8/20/15 Public and Business Office Team $91,444 4 19 61 NO 4 1 1 PA Northeast
4395 1/4/18 Public and Business Office Team $71,697 2 14 32 NO 3 1 1 PA Northeast
4460 11/28/18 Public and Business Office Team $154,122 1 14 35 NO 3 1 2 PA Northeast
4382 4/29/12 Public and Business Office Team Mgr $79,591 8 12 47 NO 3 1 1 PA Northeast
4225 8/1/04 Quality Assurance $63,125 15 16 54 YES 3 1 1 PA Northeast
4598 7/20/01 Sr Cyber Investigator $81,287 18 16 65 YES 3 1 1 PA Northeast
4823 8/14/03 Sr Cyber Investigator $72,005 16 19 61 YES 1 2 1 PA Northeast
4636 7/7/04 Sr Cyber Investigator $75,293 15 16 57 YES 3 2 1 PA Northeast
4726 1/4/05 Sr Cyber Investigator $134,847 15 16 55 YES 1 1 1 PA Northeast
4249 8/17/07 Sr Cyber Investigator $107,496 12 16 43 YES 1 1 1 PA Northeast
4680 6/18/09 Sr Cyber Investigator $84,713 11 16 39 YES 4 1 1 PA Northeast
4595 11/29/09 Sr Cyber Investigator $96,566 10 19 46 YES 3 1 1 PA Northeast
4271 8/5/11 Sr Cyber Investigator $72,213 8 16 41 NO 3 1 1 PA Northeast
4177 3/26/12 Sr Cyber Investigator $82,515 8 16 39 NO 1 1 2 PA Northeast
4639 3/12/13 Sr Cyber Investigator $152,446 7 16 37 NO 3 1 1 PA Northeast
4193 10/27/15 Sr Cyber Investigator $125,004 4 16 32 NO 1 2 1 PA Northeast
4883 7/31/11 Sr Forensics Mgr $131,580 8 14 41 NO 3 1 1 PA Northeast
4724 3/8/15 Sr Public and Business Office Team Mgr $103,349 5 14 56 NO 3 1 2 PA Northeast
Sr Public and Business Office Team Mgr 0 Region Key
TOTAL 288 State State # %
PA Northeast 149 40%
IL Midwest 125 34%
NE C-Plains 98 26%
TOTAL 372 100%

Awais Khan &D &P of &N