Project: Conduct Quantitative Analysis ( Need expert in Excel to make these corrections)

profileA-K1
SpreadSheepwhichNeedCorrections.xlsx
Home>Computer Science homework help>Project: Conduct Quantitative Analysis ( Need expert in Excel to make these corrections)

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
Section 2: Complete Summary Tables for Graphing
Sales Summary (Provided)
Roles # # % Yr Sales
Acctg/Fin 12 1 African-Am 98 26.34% 2003 $1,656,872
Admin 3 2 Asian 25 6.72% 2004 $47,830,245
Advertising 6 3 Caucasian 216 58.06% 2005 $84,088,009
CEO 1 4 Hispanic 33 8.87% 2006 $130,427,572
CFO 1 TOTAL 372 100.00% 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.30% 2011 $149,578,842
Cyber Mgr 8 2 Female 77 20.70% 2012 $155,740,613
Cyber Software Engineer 23 TOTAL 372 100.00% 2013 $144,759,828
Eng Mgr 3 2014 $156,714,301
Forensics Analyst 39 2015 $150,201,379
Investigator 8 Education Level # % 2016 $154,750,829
IT Mgr 2 12 HS 18 4.84% 2017 $158,253,462
IT Staff 18 14 AA 87 23.39% 2018 $156,494,223
Logistics 5 16 BA/BS 203 54.57% 2019 $165,800,498
Logistics Mgr 1 19 Masters+ 64 17.20% 2020 $191,210,386
Malware Reverse Engineer 16 TOTAL 372 100.00% 2021 $197,876,014
Marketing 5 2022 $204,541,642
Physical Security 18 2023 $211,207,270
Public and Business Office Team 14 Marital Status # % 2024 $217,872,898
Public and Business Office Team Mgr 1 1 Married 268 72.04%
Quality Assurance 5 2 Single 104 27.96%
Sr Cyber Analyst 2 TOTAL 372 100.00%
Sr Cyber Investigator 26
Sr Forensics Mgr 3
Sr Public and Business Office Team Mgr 3 Region Key
TOTAL 372 State Region # %
PA Northeast 149 40.05%
IL Midwest 125 33.60%
NE C-Plains 98 26.34%
TOTAL 372 100.00%
Section 3: Complete Descriptive Statistics
Be sure to include the correct units where applicable for the summary statistics below
Descriptive Statistics Frequency Table by Salary Ranges
Column1 Salary Hourly Rate Yrs of Svc Ed Age Bin Range / Upper Limit Label
20000 Up to 20 Graph on next Tab
Mean 99672.2311827957 47.9193419148 7.6339531063 15.8548387097 40.0510752688 30000 21-30
Standard Error 1703.3349438993 0.8189110307 0.2249815139 0.0934079641 0.5151533117 40000 31-40
Median 91475.5 43.9786057692 7.0819444444 16 39 50000 41-50
Mode 154933 74.4870192308 15.4722222222 16 40 60000 51-60
Standard Deviation 32852.73465592 15.7945839692 4.3392862964 1.8015875676 9.9359172536 70000 61-70
Sample Variance 1079302174.37229 249.4688827599 18.8294055622 3.2457177637 98.7224516709 80000 71-80
Kurtosis 0.2695669596 0.2695669596 -0.3501254665 -0.0946058413 -0.6537591283 90000 81-90
Skewness 0.765349626 0.765349626 0.6089293155 0.1879424621 0.3095312361 100000 91-100
Range 206948 99.4942307692 18.3527777778 7 47 110000 101-110
Minimum 32367 15.5610576923 0.1055555556 12 21 120000 111-120
Maximum 239315 115.0552884615 18.4583333333 19 68 130000 121-130
Sum 37078070 17825.9951923077 2839.8305555556 5898 14899 140000 131-140
Count 372 372 372 372 372 150000 141-150
160000 151-160
170000 161-170
180000 171-180
190000 181-190
200000 191-200
200+

Summary Statistics

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

Graph&Charts

Line Graph

Emplyees by Gender

Male Female 0.793010752688172 0.20698924731182797

Employee by education level

HS AA BA/BS Masters+ 4.8387096774193547E-2 0.23387096774193547 0.545698924731 18276 0.17204301075268819

Employees by Marital Status

Married Single 0.72043010752688175 0.27956989247311825

No. of Employees by Race

African-Am Asian Caucasian Hispanic 98 25 216 33

No. of Employees Per State

PA IL NE 149 125 98

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

Histogram

Frequency Distribution
20000 Frequency 20000 Frequency
30000 0 80000 60
40000 3 90000 58
50000 5 100000 43
60000 12 70000 40
70000 40 110000 33
80000 60 120000 30
90000 58 160000 25
100000 43 150000 18
110000 33 130000 16
120000 30 60000 12
130000 16 140000 10
140000 10 170000 10
150000 18 180000 6
160000 25 50000 5
170000 10 40000 3
180000 6 190000 2
190000 2 More 1
200000 0 30000 0
More 1 200000 0

HISTOGRAM

Frequency 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 150000 160000 170000 180000 190000 200000 More 0 3 5 12 40 60 58 43 33 30 16 10 18 25 10 6 2 0 1

Sorted 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
General Count 1
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
Region Count 1
4191 7/11/04 Acctg/Fin $71,026 $34.15 15 16 49 Yes 3 1 2 NE C-Plains
4354 7/17/02 Acctg/Fin $68,056 $32.72 17 14 62 Yes 1 1 1 NE C-Plains
4402 12/7/18 Acctg/Fin $152,030 $73.09 1 16 25 No 3 2 1 NE C-Plains
4470 5/17/15 Acctg/Fin $66,528 $31.98 5 16 35 No 1 2 1 NE C-Plains
4475 12/12/12 Acctg/Fin $75,415 $36.26 7 12 48 No 3 1 1 NE C-Plains
4730 8/31/04 Acctg/Fin $107,530 $51.70 15 14 42 Yes 3 2 2 NE C-Plains
4775 6/24/13 Acctg/Fin $162,030 $77.90 7 14 38 No 2 1 2 NE C-Plains
4023 2/6/14 Advertising $128,384 $61.72 6 16 28 No 1 2 2 NE C-Plains
4564 11/23/12 Advertising $88,639 $42.61 7 16 34 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
4012 1/26/10 Cyber Analyst $95,985 $46.15 10 14 43 No 1 1 1 NE C-Plains
4044 12/3/15 Cyber Analyst $59,219 $28.47 4 14 35 No 3 1 2 NE C-Plains
4093 8/25/10 Cyber Analyst $93,936 $45.16 9 19 47 No 3 1 2 NE C-Plains
4121 8/31/11 Cyber Analyst $148,111 $71.21 8 16 36 No 2 1 1 NE C-Plains
4126 12/24/16 Cyber Analyst $60,641 $29.15 3 16 34 No 4 1 1 NE C-Plains
4137 1/14/09 Cyber Analyst $98,634 $47.42 11 16 52 Yes 3 1 1 NE C-Plains
4152 7/19/12 Cyber Analyst $151,523 $72.85 7 16 41 No 1 1 1 NE C-Plains
4167 8/26/05 Cyber Analyst $111,536 $53.62 14 16 51 Yes 1 1 1 NE C-Plains
4199 7/16/12 Cyber Analyst $151,174 $72.68 7 16 38 No 3 1 1 NE C-Plains
4207 6/22/14 Cyber Analyst $91,205 $43.85 6 14 37 No 3 1 1 NE C-Plains
4265 6/24/13 Cyber Analyst $81,042 $38.96 7 16 30 No 3 1 2 NE C-Plains
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
4296 12/9/07 Cyber Analyst $150,868 $72.53 12 16 53 Yes 2 1 1 NE C-Plains
4299 6/1/11 Cyber Analyst $76,158 $36.61 9 16 38 No 4 1 1 NE C-Plains
4326 5/3/12 Cyber Analyst $65,955 $31.71 8 14 39 No 3 1 1 NE C-Plains
4330 10/14/15 Cyber Analyst $94,038 $45.21 4 16 30 No 1 1 2 NE C-Plains
4355 4/1/07 Cyber Analyst $150,263 $72.24 13 12 53 Yes 2 1 1 NE C-Plains
4369 8/31/05 Cyber Analyst $156,750 $75.36 14 16 51 Yes 3 1 2 NE C-Plains
4423 6/20/15 Cyber Analyst $102,641 $49.35 5 14 29 No 1 1 1 NE C-Plains
4439 2/2/04 Cyber Analyst $69,656 $33.49 16 16 57 Yes 1 1 1 NE C-Plains
4472 2/15/11 Cyber Analyst $74,381 $35.76 9 16 46 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
4489 3/28/14 Cyber Analyst $83,075 $39.94 6 16 38 No 3 1 2 NE C-Plains
4513 2/19/12 Cyber Analyst $103,721 $49.87 8 14 46 No 3 1 1 NE C-Plains
4517 7/27/08 Cyber Analyst $140,865 $67.72 11 19 49 Yes 1 1 2 NE C-Plains
4699 10/8/10 Cyber Analyst $79,542 $38.24 9 16 50 No 3 1 1 NE C-Plains
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
4820 12/14/13 Cyber Analyst $69,777 $33.55 6 19 43 No 3 1 1 NE C-Plains
4824 5/17/10 Cyber Analyst $148,111 $71.21 10 16 39 No 3 1 1 NE C-Plains
4831 11/23/08 Cyber Analyst $100,632 $48.38 11 16 47 Yes 3 1 1 NE C-Plains
4945 10/13/05 Cyber Analyst $61,902 $29.76 14 16 52 Yes 3 1 2 NE C-Plains
4964 10/21/10 Cyber Analyst $83,911 $40.34 9 16 48 No 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
4175 11/29/11 Cyber Software Engineer $162,731 $78.24 8 16 54 No 3 1 1 NE C-Plains
4304 6/1/06 Cyber Software Engineer $81,779 $39.32 14 16 51 Yes 3 1 1 NE C-Plains
4380 7/1/17 Cyber Software Engineer $104,793 $50.38 3 14 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
4455 10/17/08 Cyber Software Engineer $152,446 $73.29 11 16 54 Yes 3 1 1 NE C-Plains
4490 3/11/13 Cyber Software Engineer $100,571 $48.35 7 16 42 No 2 2 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
4745 3/14/17 Cyber Software Engineer $75,144 $36.13 3 16 28 No 1 2 2 NE C-Plains
4905 5/12/18 Cyber Software Engineer $140,865 $67.72 2 14 30 No 3 1 2 NE C-Plains
4383 12/16/09 Eng Mgr $175,916 $84.58 10 14 44 Yes 3 1 1 NE C-Plains
4857 9/2/14 Eng Mgr $172,291 $82.83 5 16 52 No 3 1 1 NE C-Plains
4135 2/24/16 Forensics Analyst $76,956 $37.00 4 16 26 No 3 1 2 NE C-Plains
4345 7/4/13 Forensics Analyst $87,480 $42.06 6 16 26 No 1 1 1 NE C-Plains
4394 5/6/18 Forensics Analyst $89,197 $42.88 2 14 21 No 3 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
4519 5/29/18 Forensics Analyst $128,901 $61.97 2 14 26 No 3 1 2 NE C-Plains
4544 8/15/18 Forensics Analyst $69,935 $33.62 1 16 22 No 1 1 2 NE C-Plains
4709 10/4/12 Forensics Analyst $143,063 $68.78 7 16 31 No 1 1 2 NE C-Plains
4714 8/24/15 Forensics Analyst $94,700 $45.53 4 14 35 No 1 1 2 NE C-Plains
4786 8/6/11 Forensics Analyst $154,933 $74.49 8 16 31 No 1 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
4837 2/6/14 Forensics Analyst $62,836 $30.21 6 16 42 No 3 1 1 NE C-Plains
4907 2/6/19 Forensics Analyst $50,421 $24.24 1 16 26 No 3 2 2 NE C-Plains
4346 9/4/06 Investigator $100,314 $48.23 13 16 51 Yes 3 1 1 NE C-Plains
4450 1/12/06 Investigator $90,794 $43.65 14 16 39 Yes 3 1 1 NE C-Plains
4611 7/17/02 Investigator $132,142 $63.53 17 14 53 Yes 3 1 1 NE C-Plains
4183 10/29/14 IT Staff $65,126 $31.31 5 16 38 No 1 1 1 NE C-Plains
4429 1/28/10 IT Staff $68,647 $33.00 10 14 50 No 3 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
4769 9/15/14 IT Staff $71,311 $34.28 5 14 37 No 3 1 1 NE C-Plains
4498 12/4/11 Malware Reverse Engineer $82,319 $39.58 8 19 40 No 3 1 1 NE C-Plains
4620 4/29/11 Malware Reverse Engineer $178,456 $85.80 9 16 34 No 3 1 1 NE C-Plains
4759 10/11/13 Malware Reverse Engineer $67,624 $32.51 6 16 37 No 3 2 1 NE C-Plains
4830 8/3/17 Malware Reverse Engineer $91,748 $44.11 2 16 36 No 3 1 2 NE C-Plains
4971 1/24/04 Marketing $76,702 $36.88 16 14 48 Yes 3 2 1 NE C-Plains
4045 6/7/16 Physical Security $32,367 $15.56 4 12 25 No 3 2 2 NE C-Plains
4668 5/21/13 Physical Security $43,367 $20.85 7 16 29 No 3 1 2 NE C-Plains
4841 1/8/13 Physical Security $61,121 $29.39 7 16 44 No 3 1 1 NE C-Plains
4982 1/19/18 Physical Security $74,512 $35.82 2 14 24 No 1 2 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
4212 4/4/19 Public and Business Office Team $61,068 $29.36 1 16 37 No 3 1 1 NE C-Plains
4343 12/29/17 Public and Business Office Team $96,327 $46.31 2 16 40 No 4 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
4484 4/18/18 Quality Assurance $111,424 $53.57 2 16 35 No 3 1 1 NE C-Plains
4904 12/19/13 Quality Assurance $139,515 $67.07 6 16 52 No 1 2 1 NE C-Plains
4027 8/19/06 Sr Cyber Investigator $71,914 $34.57 13 16 51 Yes 1 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
4458 12/15/06 Sr Cyber Investigator $156,750 $75.36 13 16 61 Yes 1 1 2 NE C-Plains
4572 10/6/10 Sr Cyber Investigator $92,079 $44.27 9 19 40 No 3 1 1 NE C-Plains
4683 5/6/11 Sr Cyber Investigator $58,294 $28.03 9 19 40 No 4 1 1 NE C-Plains
4943 12/5/17 Sr Cyber Investigator $77,443 $37.23 2 16 33 No 3 1 1 NE C-Plains
4301 11/7/13 Sr Forensics Mgr $96,582 $46.43 6 19 40 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
C-Plains Count 98
4393 9/2/15 Admin $108,058 $51.95 4 16 37 No 4 1 2 IL Midwest
4214 5/9/13 Advertising $145,776 $70.08 7 19 30 No 3 2 2 IL Midwest
4885 8/25/02 Advertising $144,571 $69.51 17 16 39 Yes 3 1 1 IL Midwest
4727 9/7/12 CFO $122,391 $58.84 7 16 48 No 4 1 2 IL Midwest
4436 10/5/04 Controller $71,727 $34.48 15 19 50 Yes 3 2 1 IL Midwest
4386 7/19/08 COO $154,933 $74.49 11 19 43 Yes 3 1 2 IL Midwest
4004 7/13/02 Cyber Analyst $111,801 $53.75 17 16 60 Yes 3 1 1 IL Midwest
4013 12/29/11 Cyber Analyst $100,520 $48.33 8 19 44 No 3 1 1 IL Midwest
4029 6/5/11 Cyber Analyst $152,446 $73.29 9 14 36 No 4 1 2 IL Midwest
4068 7/15/03 Cyber Analyst $145,776 $70.08 16 16 59 Yes 3 1 1 IL Midwest
4082 7/2/15 Cyber Analyst $82,411 $39.62 4 16 37 No 3 1 1 IL Midwest
4090 11/15/15 Cyber Analyst $87,641 $42.14 4 14 33 No 4 1 2 IL Midwest
4097 2/26/07 Cyber Analyst $162,731 $78.24 13 16 53 Yes 1 1 2 IL Midwest
4119 8/31/16 Cyber Analyst $86,384 $41.53 3 16 26 No 3 1 2 IL Midwest
4122 8/4/14 Cyber Analyst $86,147 $41.42 5 16 39 No 2 1 1 IL Midwest
4139 2/20/14 Cyber Analyst $87,056 $41.85 6 16 41 No 3 1 1 IL Midwest
4147 9/30/17 Cyber Analyst $122,352 $58.82 2 16 28 No 3 2 2 IL Midwest
4163 9/11/14 Cyber Analyst $74,419 $35.78 5 14 38 No 1 1 1 IL Midwest
4176 11/23/17 Cyber Analyst $135,533 $65.16 2 14 28 No 3 1 1 IL Midwest
4181 7/15/03 Cyber Analyst $123,391 $59.32 16 12 59 Yes 3 1 1 IL Midwest
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
4218 11/30/06 Cyber Analyst $99,130 $47.66 13 14 50 Yes 3 1 1 IL Midwest
4232 4/9/13 Cyber Analyst $86,787 $41.72 7 16 34 No 1 2 1 IL Midwest
4258 1/24/13 Cyber Analyst $58,540 $28.14 7 14 44 No 1 1 1 IL Midwest
4260 9/19/15 Cyber Analyst $88,743 $42.66 4 14 27 No 3 1 2 IL Midwest
4285 3/30/11 Cyber Analyst $80,909 $38.90 9 16 40 No 1 1 1 IL Midwest
4291 12/25/15 Cyber Analyst $66,938 $32.18 4 16 39 No 3 1 1 IL Midwest
4311 12/13/15 Cyber Analyst $92,847 $44.64 4 16 31 No 3 1 1 IL Midwest
4314 12/28/05 Cyber Analyst $98,771 $47.49 14 19 59 Yes 1 1 1 IL Midwest
4377 2/12/08 Cyber Analyst $151,523 $72.85 12 16 56 Yes 1 1 1 IL Midwest
4381 12/29/11 Cyber Analyst $112,223 $53.95 8 16 44 No 3 1 1 IL Midwest
4409 5/1/12 Cyber Analyst $112,402 $54.04 8 14 41 No 2 1 1 IL Midwest
4441 8/5/12 Cyber Analyst $80,198 $38.56 7 16 37 No 1 1 1 IL Midwest
4457 8/13/17 Cyber Analyst $102,913 $49.48 2 16 25 No 1 2 2 IL Midwest
4459 5/22/09 Cyber Analyst $115,580 $55.57 11 16 54 Yes 1 1 1 IL Midwest
4535 6/14/06 Cyber Analyst $110,708 $53.23 14 16 55 Yes 3 1 1 IL Midwest
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
4571 7/12/11 Cyber Analyst $75,261 $36.18 8 12 43 No 3 1 1 IL Midwest
4576 10/30/10 Cyber Analyst $92,931 $44.68 9 16 51 No 3 1 1 IL Midwest
4597 12/17/15 Cyber Analyst $158,066 $75.99 4 16 28 No 4 1 1 IL Midwest
4621 12/1/18 Cyber Analyst $81,730 $39.29 1 16 27 No 3 2 1 IL Midwest
4665 8/16/13 Cyber Analyst $115,283 $55.42 6 14 37 No 1 1 1 IL Midwest
4695 1/31/15 Cyber Analyst $88,743 $42.66 5 19 33 No 2 2 2 IL Midwest
4742 4/21/08 Cyber Analyst $90,599 $43.56 12 16 50 Yes 1 1 1 IL Midwest
4811 4/22/10 Cyber Analyst $74,814 $35.97 10 19 42 No 2 1 1 IL Midwest
4840 2/1/14 Cyber Analyst $87,054 $41.85 6 14 34 No 2 1 1 IL Midwest
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
4882 3/30/11 Cyber Analyst $81,276 $39.08 9 14 44 No 3 1 1 IL Midwest
4902 9/5/11 Cyber Analyst $82,016 $39.43 8 16 44 No 3 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
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
4944 6/17/17 Cyber Analyst $143,005 $68.75 3 14 25 No 4 2 2 IL Midwest
4981 2/2/10 Cyber Analyst $117,692 $56.58 10 14 43 No 1 1 2 IL Midwest
4998 9/25/10 Cyber Analyst $75,969 $36.52 9 14 37 No 3 1 2 IL Midwest
4368 2/24/18 Cyber Mgr $79,063 $38.01 2 14 40 No 3 2 1 IL Midwest
4482 7/20/01 Cyber Mgr $77,247 $37.14 18 14 48 Yes 4 2 1 IL Midwest
4834 4/24/19 Cyber Mgr $100,198 $48.17 1 16 34 No 1 2 1 IL Midwest
4906 11/20/10 Cyber Mgr $186,925 $89.87 9 16 39 No 1 1 1 IL Midwest
4411 9/25/14 Cyber Software Engineer $95,128 $45.73 5 19 42 No 3 2 1 IL Midwest
4471 5/15/18 Cyber Software Engineer $164,033 $78.86 2 14 30 No 3 1 1 IL Midwest
4619 9/30/12 Cyber Software Engineer $83,424 $40.11 7 16 44 No 3 2 1 IL Midwest
4014 10/2/11 Forensics Analyst $125,156 $60.17 8 19 31 No 1 1 1 IL Midwest
4075 10/2/16 Forensics Analyst $75,053 $36.08 3 14 25 No 3 1 2 IL Midwest
4198 6/5/17 Forensics Analyst $73,447 $35.31 3 14 27 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
4319 12/3/13 Forensics Analyst $63,933 $30.74 6 19 34 No 3 1 2 IL Midwest
4361 6/10/11 Forensics Analyst $87,601 $42.12 9 16 30 No 4 1 1 IL Midwest
4438 11/18/09 Forensics Analyst $54,060 $25.99 10 16 32 Yes 3 2 2 IL Midwest
4474 9/26/13 Forensics Analyst $113,023 $54.34 6 16 28 No 3 1 2 IL Midwest
4653 9/13/12 Forensics Analyst $91,131 $43.81 7 19 30 No 3 1 1 IL Midwest
4660 9/9/12 Forensics Analyst $120,986 $58.17 7 19 29 No 4 1 1 IL Midwest
4809 11/6/10 Forensics Analyst $99,135 $47.66 9 14 35 No 3 1 1 IL Midwest
4958 7/17/13 Forensics Analyst $162,030 $77.90 6 12 31 No 4 1 2 IL Midwest
4239 1/6/17 Investigator $78,985 $37.97 3 16 33 No 3 1 2 IL Midwest
4279 11/3/17 Investigator $95,220 $45.78 2 19 31 No 2 1 1 IL Midwest
4592 10/6/09 Investigator $133,138 $64.01 10 16 33 Yes 3 2 1 IL Midwest
4630 10/13/07 Investigator $61,779 $29.70 12 16 34 Yes 1 1 1 IL Midwest
4118 8/13/17 IT Mgr $154,933 $74.49 2 16 24 No 3 1 1 IL Midwest
4030 7/10/11 IT Staff $57,727 $27.75 8 16 51 No 3 1 1 IL Midwest
4208 2/15/16 IT Staff $61,383 $29.51 4 14 26 No 3 1 1 IL Midwest
4237 11/2/14 IT Staff $95,957 $46.13 5 16 41 No 3 2 1 IL Midwest
4780 8/2/02 IT Staff $62,747 $30.17 17 19 52 Yes 3 1 1 IL Midwest
4790 6/11/13 IT Staff $141,110 $67.84 7 16 36 No 3 1 1 IL Midwest
4421 2/12/15 Logistics $64,201 $30.87 5 16 34 No 3 1 1 IL Midwest
4766 9/23/15 Logistics $84,076 $40.42 4 19 36 No 3 2 1 IL Midwest
4337 10/11/15 Logistics Mgr $64,200 $30.87 4 16 53 No 1 1 1 IL Midwest
4221 7/10/11 Malware reverse engineer $74,000 $35.58 8 19 40 No 3 2 2 IL Midwest
4253 11/18/13 Malware reverse engineer $86,377 $41.53 6 14 40 No 1 1 2 IL Midwest
4385 9/25/08 Malware Reverse Engineer $74,039 $35.60 11 19 49 Yes 3 1 2 IL Midwest
4626 8/19/14 Malware Reverse Engineer $55,720 $26.79 5 16 34 No 3 1 2 IL Midwest
4687 8/25/18 Malware Reverse Engineer $87,583 $42.11 1 14 39 No 2 1 2 IL Midwest
4843 6/23/16 Malware Reverse Engineer $86,199 $41.44 4 16 27 No 4 2 2 IL Midwest
4992 4/20/15 Malware Reverse Engineer $99,821 $47.99 5 12 36 No 3 2 2 IL Midwest
4302 3/8/17 Marketing $87,519 $42.08 3 16 37 No 3 2 1 IL Midwest
4771 12/1/13 Marketing $159,215 $76.55 6 19 40 No 1 1 1 IL Midwest
4150 9/6/17 Physical Security $33,367 $16.04 2 12 22 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
4507 8/11/16 Physical Security $55,542 $26.70 3 14 30 No 2 2 1 IL Midwest
4532 2/10/16 Physical Security $43,367 $20.85 4 16 34 No 3 1 1 IL Midwest
4554 1/22/18 Physical Security $43,962 $21.14 2 12 22 No 3 2 2 IL Midwest
4677 11/11/14 Physical Security $43,367 $20.85 5 16 33 No 3 1 1 IL Midwest
4088 7/18/17 Public and Business Office Team $108,342 $52.09 2 16 34 No 3 2 1 IL Midwest
4106 5/7/17 Public and Business Office Team $150,263 $72.24 3 16 57 No 3 1 1 IL Midwest
4324 6/4/11 Public and Business Office Team $87,409 $42.02 9 14 58 No 4 1 1 IL Midwest
4435 6/17/17 Public and Business Office Team $141,110 $67.84 3 16 37 No 1 2 1 IL Midwest
4675 8/10/13 Quality Assurance $101,360 $48.73 6 16 40 No 3 1 1 IL Midwest
4740 11/1/16 Quality Assurance $77,495 $37.26 3 16 45 No 3 2 2 IL Midwest
4316 10/7/17 Sr Cyber Analyst $149,466 $71.86 2 16 31 No 4 1 1 IL Midwest
4782 4/6/19 Sr Cyber Analyst $154,122 $74.10 1 19 33 No 1 1 2 IL Midwest
4000 4/23/15 Sr Cyber Investigator $92,267 $44.36 5 19 35 No 3 1 1 IL Midwest
4060 2/1/12 Sr Cyber Investigator $73,650 $35.41 8 19 42 No 3 1 1 IL Midwest
4120 8/30/13 Sr Cyber Investigator $127,190 $61.15 6 16 34 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
4307 8/27/07 Sr Cyber Investigator $73,807 $35.48 12 16 46 Yes 3 1 2 IL Midwest
4406 6/10/13 Sr Cyber Investigator $116,075 $55.81 7 19 37 No 1 1 2 IL Midwest
4468 1/10/17 Sr Cyber Investigator $163,045 $78.39 3 16 33 No 1 1 1 IL Midwest
4522 12/10/15 Sr Cyber Investigator $85,442 $41.08 4 19 38 No 1 2 1 IL Midwest
4911 5/29/06 Sr Cyber Investigator $92,076 $44.27 14 14 47 Yes 2 1 1 IL Midwest
4591 1/4/16 Sr Forensics Mgr $109,128 $52.47 4 16 48 No 3 1 1 IL Midwest
4186 3/9/18 Sr Public and Business Office Team Mgr $172,291 $82.83 2 16 57 No 1 1 1 IL Midwest
Midwest Count 125
4134 6/30/17 Acctg/Fin $98,007 $47.12 3 19 28 No 1 1 2 PA Northeast
4169 3/14/14 Acctg/Fin $65,100 $31.30 6 14 40 No 3 2 1 PA Northeast
4733 8/9/12 Acctg/Fin $80,666 $38.78 7 16 44 No 3 1 1 PA Northeast
4817 7/4/17 Acctg/Fin $84,270 $40.51 2 16 30 No 3 1 1 PA Northeast
4901 6/12/11 Acctg/Fin $154,122 $74.10 9 12 49 No 3 2 2 PA Northeast
4272 7/18/14 Admin $78,873 $37.92 5 12 36 No 1 2 2 PA Northeast
4734 10/21/16 Admin $87,047 $41.85 3 14 25 No 3 2 2 PA Northeast
4396 12/10/12 Advertising $101,341 $48.72 7 14 39 No 3 2 2 PA Northeast
4879 7/13/02 Advertising $106,600 $51.25 17 16 60 Yes 3 1 1 PA Northeast
4418 7/11/04 CEO $239,315 $115.06 15 19 58 Yes 3 1 1 PA Northeast
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
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
4046 9/4/06 Cyber Analyst $115,974 $55.76 13 16 54 Yes 1 1 1 PA Northeast
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
4078 7/15/09 Cyber Analyst $83,851 $40.31 10 16 51 Yes 1 1 1 PA Northeast
4086 9/18/07 Cyber Analyst $114,721 $55.15 12 14 51 Yes 3 1 1 PA Northeast
4095 12/31/04 Cyber Analyst $133,678 $64.27 15 16 52 Yes 3 1 1 PA Northeast
4107 11/5/13 Cyber Analyst $78,334 $37.66 6 19 34 No 3 1 1 PA Northeast
4128 5/16/03 Cyber Analyst $126,426 $60.78 17 14 56 Yes 3 1 1 PA Northeast
4146 12/4/11 Cyber Analyst $104,961 $50.46 8 16 41 No 1 1 1 PA Northeast
4220 9/17/06 Cyber Analyst $164,033 $78.86 13 16 54 Yes 3 1 1 PA Northeast
4287 2/5/14 Cyber Analyst $63,777 $30.66 6 14 35 No 3 1 2 PA Northeast
4300 7/10/18 Cyber Analyst $108,866 $52.34 1 16 27 No 1 2 1 PA Northeast
4305 7/27/16 Cyber Analyst $78,015 $37.51 3 16 31 No 3 1 1 PA Northeast
4310 1/21/11 Cyber Analyst $108,326 $52.08 9 19 41 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
4332 9/28/04 Cyber Analyst $91,507 $43.99 15 19 53 Yes 3 1 1 PA Northeast
4342 7/13/11 Cyber Analyst $156,750 $75.36 8 16 38 No 4 1 1 PA Northeast
4397 5/20/13 Cyber Analyst $84,175 $40.47 7 16 37 No 3 1 1 PA Northeast
4407 11/20/08 Cyber Analyst $73,005 $35.10 11 14 43 Yes 3 1 1 PA Northeast
4410 6/20/15 Cyber Analyst $68,222 $32.80 5 19 29 No 3 1 2 PA Northeast
4419 12/17/06 Cyber Analyst $70,237 $33.77 13 16 57 Yes 2 1 1 PA Northeast
4428 2/6/10 Cyber Analyst $73,640 $35.40 10 16 45 No 3 1 1 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
4515 6/13/09 Cyber Analyst $89,165 $42.87 11 19 49 Yes 3 2 1 PA Northeast
4543 10/20/12 Cyber Analyst $148,111 $71.21 7 14 33 No 3 1 1 PA Northeast
4558 1/31/11 Cyber Analyst $85,256 $40.99 9 16 41 No 3 1 1 PA Northeast
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
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
4661 8/29/15 Cyber Analyst $117,062 $56.28 4 16 27 No 3 1 1 PA Northeast
4690 6/27/12 Cyber Analyst $82,471 $39.65 8 16 39 No 3 1 2 PA Northeast
4694 11/16/15 Cyber Analyst $101,016 $48.57 4 16 35 No 4 1 2 PA Northeast
4696 8/26/17 Cyber Analyst $128,825 $61.94 2 16 25 No 3 1 2 PA Northeast
4712 2/25/14 Cyber Analyst $97,323 $46.79 6 14 34 No 1 2 1 PA Northeast
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
4731 10/12/12 Cyber Analyst $83,430 $40.11 7 16 38 No 3 1 1 PA Northeast
4746 10/4/12 Cyber Analyst $84,679 $40.71 7 19 35 No 3 1 1 PA Northeast
4761 1/17/15 Cyber Analyst $162,731 $78.24 5 16 32 No 1 1 1 PA Northeast
4813 6/20/08 Cyber Analyst $127,890 $61.49 12 12 47 Yes 3 1 1 PA Northeast
4845 5/23/11 Cyber Analyst $149,466 $71.86 9 16 42 No 3 1 1 PA Northeast
4854 11/8/14 Cyber Analyst $149,466 $71.86 5 19 30 No 3 1 1 PA Northeast
4860 5/5/06 Cyber Analyst $75,179 $36.14 14 14 49 Yes 1 2 2 PA Northeast
4918 5/15/11 Cyber Analyst $143,005 $68.75 9 19 36 No 3 1 1 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
4957 3/2/09 Cyber Analyst $110,877 $53.31 11 19 50 Yes 3 1 1 PA Northeast
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
4965 2/27/12 Cyber Analyst $163,045 $78.39 8 16 50 No 1 1 1 PA Northeast
4025 12/12/14 Cyber Mgr $151,174 $72.68 5 16 38 No 3 1 1 PA Northeast
4257 7/11/03 Cyber Mgr $104,220 $50.11 16 19 51 Yes 3 2 1 PA Northeast
4700 10/7/14 Cyber Mgr $63,946 $30.74 5 19 42 No 3 2 1 PA Northeast
4031 10/20/13 Cyber Software Engineer $78,869 $37.92 6 16 39 No 3 1 1 PA Northeast
4089 10/16/16 Cyber Software Engineer $81,050 $38.97 3 16 36 No 3 1 1 PA Northeast
4303 1/19/18 Cyber Software Engineer $113,246 $54.45 2 19 34 No 2 1 1 PA Northeast
4334 12/28/10 Cyber Software Engineer $103,736 $49.87 9 19 56 No 3 1 1 PA Northeast
4352 7/4/16 Cyber Software Engineer $50,377 $24.22 3 12 31 No 2 1 1 PA Northeast
4656 12/29/17 Cyber Software Engineer $151,174 $72.68 2 16 40 No 3 2 1 PA Northeast
4671 1/13/15 Cyber Software Engineer $105,637 $50.79 5 19 44 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
4784 5/12/12 Cyber Software Engineer $102,238 $49.15 8 16 45 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
4842 7/11/04 Cyber Software Engineer $60,802 $29.23 15 16 59 Yes 3 1 1 PA Northeast
4541 12/2/09 Eng Mgr $170,954 $82.19 10 12 49 Yes 3 1 2 PA Northeast
4010 11/25/18 Forensics Analyst $90,688 $43.60 1 16 23 No 1 2 2 PA Northeast
4037 9/13/13 Forensics Analyst $67,866 $32.63 6 14 25 No 3 1 2 PA Northeast
4070 4/4/17 Forensics Analyst $80,191 $38.55 3 16 28 No 1 1 1 PA Northeast
4092 7/7/08 Forensics Analyst $98,943 $47.57 11 16 36 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
4252 3/23/16 Forensics Analyst $97,885 $47.06 4 16 28 No 1 1 1 PA Northeast
4259 9/4/04 Forensics Analyst $106,267 $51.09 15 16 40 Yes 3 1 1 PA Northeast
4284 12/16/10 Forensics Analyst $143,063 $68.78 9 14 36 No 1 1 1 PA Northeast
4604 11/10/11 Forensics Analyst $71,671 $34.46 8 16 31 No 1 1 1 PA Northeast
4748 10/19/12 Forensics Analyst $75,612 $36.35 7 16 31 No 3 1 1 PA Northeast
4825 9/5/16 Forensics Analyst $78,900 $37.93 3 12 26 No 3 1 2 PA Northeast
4880 9/13/11 Forensics Analyst $95,662 $45.99 8 14 31 No 1 2 1 PA Northeast
4946 2/21/15 Forensics Analyst $72,352 $34.78 5 16 29 No 4 1 2 PA Northeast
4953 1/5/16 Forensics Analyst $114,854 $55.22 4 14 26 No 3 1 2 PA Northeast
4972 7/27/07 Forensics Analyst $151,523 $72.85 12 16 34 Yes 3 1 2 PA Northeast
4497 10/28/12 Investigator $68,012 $32.70 7 16 36 No 4 2 1 PA Northeast
4500 12/5/13 IT Mgr $113,056 $54.35 6 19 56 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
4055 6/17/18 IT Staff $99,786 $47.97 2 14 31 No 1 2 2 PA Northeast
4401 8/25/03 IT Staff $76,305 $36.69 16 16 55 Yes 1 1 1 PA Northeast
4413 12/21/16 IT Staff $95,622 $45.97 3 19 36 No 2 1 1 PA Northeast
4563 3/16/16 IT Staff $62,319 $29.96 4 16 28 No 3 1 1 PA Northeast
4567 11/6/07 IT Staff $71,747 $34.49 12 16 46 Yes 2 1 1 PA Northeast
4705 8/21/13 IT Staff $80,045 $38.48 6 14 43 No 1 1 1 PA Northeast
4723 10/8/11 IT Staff $75,270 $36.19 8 19 35 No 3 1 1 PA Northeast
4864 1/26/18 IT Staff $69,665 $33.49 2 16 24 No 2 2 1 PA Northeast
4104 7/21/08 Logistics $71,690 $34.47 11 16 51 Yes 3 2 1 PA Northeast
4298 8/28/07 Logistics $83,294 $40.05 12 16 49 Yes 3 1 2 PA Northeast
4467 8/11/14 Logistics $43,367 $20.85 5 16 38 No 3 2 1 PA Northeast
4067 10/29/12 Malware Reverse Engineer $124,996 $60.09 7 16 49 No 2 1 2 PA Northeast
4238 6/24/18 Malware Reverse Engineer $101,386 $48.74 2 16 27 No 1 1 2 PA Northeast
4327 1/29/12 Malware Reverse Engineer $68,226 $32.80 8 16 54 No 3 1 1 PA Northeast
4792 7/11/03 Malware Reverse Engineer $131,698 $63.32 16 14 63 Yes 3 1 1 PA Northeast
4932 2/2/14 Malware Reverse Engineer $128,943 $61.99 6 14 49 No 3 1 1 PA Northeast
4648 7/7/17 Marketing $115,966 $55.75 2 16 42 No 3 2 1 PA Northeast
4897 10/24/07 Marketing $108,604 $52.21 12 19 47 Yes 3 2 1 PA Northeast
4189 4/24/11 Physical Security $53,669 $25.80 9 14 42 No 1 2 1 PA Northeast
4313 11/11/10 Physical Security $39,808 $19.14 9 16 46 No 1 1 1 PA Northeast
4530 5/1/17 Physical Security $72,946 $35.07 3 14 24 No 1 2 2 PA Northeast
4693 10/2/15 Physical Security $75,920 $36.50 4 14 30 No 3 2 1 PA Northeast
4713 2/13/14 Physical Security $86,666 $41.67 6 12 27 No 1 1 2 PA Northeast
4794 5/3/13 Physical Security $67,987 $32.69 7 16 34 No 3 2 1 PA Northeast
4826 1/7/12 Physical Security $64,797 $31.15 8 14 45 No 3 2 1 PA Northeast
4846 10/10/13 Physical Security $87,943 $42.28 6 12 29 No 1 1 1 PA Northeast
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
4395 1/4/18 Public and Business Office Team $71,697 $34.47 2 14 32 No 3 1 1 PA Northeast
4460 11/28/18 Public and Business Office Team $154,122 $74.10 1 14 35 No 3 1 2 PA Northeast
4768 5/3/13 Public and Business Office Team $114,251 $54.93 7 14 44 No 2 2 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
4382 4/29/12 Public and Business Office Team Mgr $79,591 $38.26 8 12 47 No 3 1 1 PA Northeast
4225 8/1/04 Quality Assurance $63,125 $30.35 15 16 54 Yes 3 1 1 PA Northeast
4177 3/26/12 Sr Cyber Investigator $82,515 $39.67 8 16 39 No 1 1 2 PA Northeast
4193 10/27/15 Sr Cyber Investigator $125,004 $60.10 4 16 32 No 1 2 1 PA Northeast
4249 8/17/07 Sr Cyber Investigator $107,496 $51.68 12 16 43 Yes 1 1 1 PA Northeast
4271 8/5/11 Sr Cyber Investigator $72,213 $34.72 8 16 41 No 3 1 1 PA Northeast
4595 11/29/09 Sr Cyber Investigator $96,566 $46.43 10 19 46 Yes 3 1 1 PA Northeast
4598 7/20/01 Sr Cyber Investigator $81,287 $39.08 18 16 65 Yes 3 1 1 PA Northeast
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
4680 6/18/09 Sr Cyber Investigator $84,713 $40.73 11 16 39 Yes 4 1 1 PA Northeast
4726 1/4/05 Sr Cyber Investigator $134,847 $64.83 15 16 55 Yes 1 1 1 PA Northeast
4823 8/14/03 Sr Cyber Investigator $72,005 $34.62 16 19 61 Yes 1 2 1 PA Northeast
4883 7/31/11 Sr Forensics Mgr $131,580 $63.26 8 14 41 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
Northeast Count 149
Grand Count 374
State Region # %
PA Northeast 149 40.05%
IL Midwest 125 33.60%
NE C-Plains 98 26.34%
TOTAL 372 100.00%

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. Histogram indicates the no.of employees falls within specific salry ranges. As indicated by histogram, there are two salary ranges in which most number of emplyees fall. This can create a possibility of best promotional rate and this data is bi-modal. 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". Sales forecast has been made on the data sheet worksheet. it is done by using =FORECAST function. 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? On performing descriptive statistical analysis, we have seen that only salary data has a diversion from mean inspite of all the other data that remained close to the mean. 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. As per the pie charts, we seen that 1. Company has 21% of female employees in comparison to Male employees 2. Company has 5%HS level of education, 23% of AA level education, 55% of BA/BS levell eduaction and 17% of MAsters level education. 3. 72% of emplyees are married and 28% of employees are unmarried. As per the above results we can conclude that company needs improvement to achieve its goals. Statics has shown diversion from achieving objectives. 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. Upon excel findings we have seen that, the mode of the job roles is Cyber Analyst which has 146 number of position at one time. 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.) Final Essay: In this complete analysis we have prepare some descriptive statistical analysis which includes some statistical tools and graphs and charts. We have perormed on following data 1. Employees by gender 2.Employees by education level. 3. Employees by Marrital Status 4. No. of emnployees by race. 5. No.of employees per state 6. Sales summary 7. Statistical analysis of Salary, Hourly Rate ,Years of Service,Education and Age. upon above analysis we have concluded that there are only two ranges of salaries where most number of employees falls. The company has most number of male employees. There are most number of graduates emplyees. Mostly emplyees are married. We have forecasted the sales for coming 4 years upto 2024. Statistical summary is expained in the summary statistics portion but we have to say that salary is the only column in which there is a great dispersion of data from its mean. The results of the company are good in my point of view but it can be better if there should be a policy to improve the figures to achieve its goals.