Project: Conduct Quantitative Analysis ( Need Corrections)

For this project, I have already done the project in the attached file of (My Spread Sheet folder ). However, I ended up failing this project. For that reason, I would like you to make corrections to my given attached spreadsheet through the given attached folder of (professor feedback) and ( professor instruction folder) give it back to me. you might have to redo the several steps completely as well. Like answering questions and essay.

Don't use plagiarized sources. Get Your Custom Essay on

Just from $13/Page

Order Essay

>DATA Workforce

Profile Analysis Section

: 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

9 1

0 Emp

# Hire Date Role Salary Hrly Rate Yrs of SVC Ed Age

Vested

Race Gender Status State Region 4

00 4/

5 Sr Cyber

Investigator $92,2

6 7 $

19 35 NO

3 1 1

IL Midwest 40

04 7/

/02 Cyber Analyst $

01 $

75 17 16 60 YES

3 1 1 IL Midwest
40

10 11/

18 Forensics Analyst $90,

8 $

.60

1 16 23 NO 1 2 2

PA Northeast 4012 1/

/10

Cyber Analyst

$95,

5 $

43 NO 1 1 1

NE C-Plains 4013 12/

/11

Cyber Analyst

$100,

0 $

8 19 44 NO 3 1 1 IL Midwest
4014 10/2/11

Forensics Analyst

125

56 $60.17

8 19

NO 1 1 1 IL Midwest
4015 1/1/12

Cyber Analyst

$78,

5 $

.73

8 16 40 NO 3 1 2 PA Northeast
4020 5/9/11

Cyber Analyst

$93,

8 $44.96

9 14

NO 1 1 1 PA Northeast
40

22 5/

/04

Cyber Analyst

$69,529 $33.43

16 16 53 YES 3 1 1 PA Northeast
4023 2/6/14 Advertising $1

4 $

.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 $

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
40

30 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/

/06

IT Staff

$90,930 $43.72

14 19

YES 3 1 1 PA Northeast
4037 9/13/13

Forensics Analyst

$67,866 $

6 14 25 NO 3 1 2 PA Northeast
4038 4/14/12

Cyber Analyst

0 $31.05

8 16 40 NO 1 1 1 PA Northeast
4039 5/30/13

Cyber Analyst

$91,

1 $44.12

7 16 30 NO 3 1 2 PA Northeast
4044 12/3/15

Cyber Analyst

,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 $

13 16

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,6

50 $35.

8 19

NO 3 1 1 IL Midwest
4061 2/28/12

Cyber Analyst

$154,933 $74.

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 $1

,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.

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

,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
4

104 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 1

2/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,1

65 $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
4

146 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

Sum

mary tables for Graphing

Sales

Summary

(Provided)

# Race #

Yr Sales
Acctg/Fin 0 1

African-Am

26% 2003 $1,656,872 Admin 3 2

Asian

7% 2004 $47,830,245 Advertising 6 3

Caucasian 216 58% 2005 $84,088,009 CEO 1 4

Hispanic

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

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

5% 2017 $158,253,462 IT Staff 18 14

23% 2018 $156,494,223 Logistics 0 16

BA/BS 203 55% 2019 $165,800,498 Logistics Mgr 0 19

Masters+

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

Range

s Mean Bin Range / Upper Limit Label Median 20000 Up to 20 Graph on next Tab Mode 30000 21-30 Std Deviation 4000

0 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

Mean

Standard Error

Median

Median 16 Median 39

Mode

Mode 16 Mode 40

Standard Deviation

Sample Variance

Kurtosis

Kurtosis 0.2695669596 Kurtosis

Kurtosis

Skewness

Skewness 0.765349626 Skewness

Skewness

Range

Range 7 Range 47

Minimum

Minimum 12 Minimum 21

Maximum

Maximum 19 Maximum 68

Sum

Count 372 Count 372 Count 372 Count 372 Count 372
1

99672.2311827957	47.9193419148	7.6339531063	15.8548387097	40.0510752688
				Standard Error	1703.3349438993	0.8189110307	0.2249815139	0.0934079641	0.5151533117
91475.5	43.9786057692	7.0819444444
154933	74.4870192308	15.4722222222
				Standard Deviation	32852.73465592	15.7945839692	4.3392862964	1.8015875676	9.9359172536
				Sample Variance	1079302174.37229	249.4688827599	18.8294055622	3.2457177637	98.7224516709
	0.2695669596	-0.3501254665	-0.0946058413	-0.6537591283
	0.765349626	0.6089293155	0.1879424621	0.3095312361
206948	99.4942307692	18.3527777778
				Minimum	32367	15.5610576923	0.1055555556
				Maximum	239315	115.0552884615	18.4583333333
37078070	17825.9951923077	2839.8305555556	5898	14899

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

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

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

Histrogram

Frequency Table by Salary Ranges

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

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

Hire Date Role Salary Hrly Rate Yrs of SVC Ed Age Vested Race Gender Status State Region

4000

Sr Cyber Investigator

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

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

Cyber Analyst

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

4 14 35 NO 3 1 2 NE C-Plains

4126

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

7/13/02 Cyber Analyst

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

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

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

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

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

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

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

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

12/4/11 Cyber Analyst $104,961 8 16 41 NO 1 1 1 PA Northeast

4015 1/1/12 Cyber Analyst

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

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

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

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

Forensics Analyst

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

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

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

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%

Workforce Profile Analysis	Section 1: Complete all Columns in Data Set
Format for:print
Vested Yr	12/31/19
Emp #
4/23/2015	$92,267	#SPILL!	5	19	35	3	1	1 2
$128,384
1/26/10	$95,985
$59,219
12/24/16
4004	$111,801
$100,520
$87,641
$125,156
4030
$73,650
4022	5/27/04
$93,518
4146
$78,475
$64,580
$91,771
$119,165
4010	11/25/18	$90,688
5/21/06
4104
$124,996

Awais Khan &D &P of &N

>QR Questions_Responses

. From the created histogram, it appears that a large share of employees have a salary between $

,000–$1

,000 or $1

1,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 202

. 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,

s Worked,

ucation, and

Age

. What does this tell you about the variables?
4. The company has a keen interest in the educational, race, and gender makeup of its workforce. Its emphasis is on a diverse, dynamic workforce. From your “Graph Charts” spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how you would determine if the company was meeting expectations on these characteristics.
5. The company is conducting an analysis on how many positions to create to keep up with demand. Specifically, it wants to know an estimate of the number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings.
FINAL ESSAY:
Now that you have done all the work with data, you will write a short three- to four-paragraph summary of your analysis. This is important. While you have done a wonderful job with your analysis, you can never assume that the end user will be able to interpret the data the way it should be understood. Supporting narrative is helpful. Never simply provide a “raw data” dump. Instead, seek to provide information!
Structure your essay like this:
a. Write a one-paragraph narrative summary of your findings, describing patterns of interest.
b. Provide an explanation of the potential relevance of such patterns.
c. Provide a description of how you would investigate further to determine if your results are “good or bad” for the company.
Prepare your response in this workbook. (Simply expand this text box to accommodate your essay and other answers, or you can copy and paste from another document.)

DATA

Currency Number General Number General Number Number Number

General

Salary

Ed Age Vested

/15

3 1 1

3 1 1 IL

/18

16 23 1 2 2

Cyber Analyst

1 1 1

/11

Cyber Analyst

3 1 1 IL

Forensics Analyst

19 31 1 1 1 IL

Cyber Analyst

16 40 3 1 2 PA

Cyber Analyst

1 1 1 PA

/04

Cyber Analyst

3 1 1 PA

16 28 1 2 2 NE

16 38 3 1 1 PA

16 51 1 1 1 NE

Cyber Analyst

4 1 2 IL

,727

16 51 3 1 1 IL

16 39 3 1 1 PA

/06

IT Staff

3 1 1 PA

Forensics Analyst

14 25 3 1 2 PA

Cyber Analyst

16 40 1 1 1 PA

Cyber Analyst

16 30 3 1 2 PA

Cyber Analyst

,219

14 35 3 1 2 NE

,367

12 25 3 2 2 NE

Cyber Analyst

1 1 1 PA

IT Staff

14 31 1 2 2 PA

Sr Cyber Investigator

3 1 1 IL

Cyber Analyst

16 34 3 1 2 PA

Cyber Analyst

16 36 4 1 2 PA

,996

2 1 2 PA

Cyber Analyst

16 59 3 1 1 IL

Forensics Analyst

16 28 1 1 1 PA

Forensics Analyst

14 25 3 1 2 IL

Cyber Analyst

16 51 1 1 1 PA

Cyber Analyst

16 37 3 1 1 IL

Cyber Analyst

14 51 3 1 1 PA

16 34 3 2 1 IL

Cyber Software Engineer

16 36 3 1 1 PA

Cyber Analyst

14 33 4 1 2 IL

Forensics Analyst

16 36 3 1 1 PA

Cyber Analyst

19 47 3 1 2 NE

Cyber Analyst

16 52 3 1 1 PA

Cyber Analyst

,731

16 53 1 1 2 IL

16 51 3 2 1 PA

Public and Business Office Team

16 57 3 1 1 IL

Cyber Analyst

19 34 3 1 1 PA

16 24 3 1 1 IL

Cyber Analyst

16 26 3 1 2 IL

Sr Cyber Investigator

16 34 3 1 1 IL

Cyber Analyst

,111

16 36 2 1 1 NE

Cyber Analyst

16 39 2 1 1 IL

Cyber Analyst

16 34 4 1 1 NE

Cyber Analyst

14 56 3 1 1 PA

Forensics Analyst

16 31 4 1 1 PA

19 28 1 1 2 PA

2/24/16 Forensics Analyst

16 26 3 1 2 NE

Cyber Analyst

16 52 3 1 1 NE

Cyber Analyst

16 41 3 1 1 IL

Sr Cyber Investigator

16 31 4 2 1 IL

Cyber Analyst

16 41 1 1 1 PA

Cyber Analyst

16 28 3 2 2 IL

Physical Security

12 22 1 1 1 IL

Cyber Analyst

16 41 1 1 1 NE

Public and Business Office Team

19 68 3 1 1 NE

Cyber Analyst

14 38 1 1 1 IL

Cyber Analyst

16 51 1 1 1 NE

Acctg/Fin

14 40 3 2 1 PA

Cyber Software Engineer

16 54 3 1 1 NE

Cyber Analyst

14 28 3 1 1 IL

Sr Cyber Investigator

16 39 1 1 2 PA

7/15/03 Cyber Analyst

12 59 3 1 1 IL

IT Staff

16 38 1 1 1 NE

16 57 1 1 1 IL

Physical Security

14 42 1 2 1 PA

Acctg/Fin

16 49 3 1 2 NE

Sr Cyber Investigator

16 32 1 2 1 PA

Forensics Analyst

14 27 3 1 2 IL

Cyber Analyst $151,174 16 38 3 1 1 NE

Cyber Analyst

14 43 1 1 1 IL

Cyber Analyst

14 40 4 2 1 IL

Cyber Analyst

14 37 3 1 1 NE

IT Staff

14 26 3 1 1 IL

Public and Business Office Team

16 37 3 1 1 NE

Advertising $145,776 19 30 3 2 2 IL

Cyber Analyst

14 50 3 1 1 IL

Cyber Analyst

16 54 3 1 1 PA

7/10/11

19 40 3 2 2 IL

16 54 3 1 1 PA

Cyber Analyst

16 34 1 2 1 IL

IT Staff

16 41 3 2 1 IL

Malware Reverse Engineer

16 27 1 1 2 PA

Investigator

16 33 3 1 2 IL

Forensics Analyst

16 21 1 1 2 IL

Sr Cyber Investigator

16 43 1 1 1 PA

Forensics Analyst

16 28 1 1 1 PA

Malware reverse engineer

14 40 1 1 2 IL

Cyber Mgr

19 51 3 2 1 PA

Cyber Analyst

14 44 1 1 1 IL

Forensics Analyst

16 40 3 1 1 PA

Cyber Analyst

14 27 3 1 2 IL

Cyber Analyst

16 30 3 1 2 NE

Sr Cyber Investigator

16 41 3 1 1 PA

12 36 1 2 2 PA

Cyber Analyst

16 30 3 1 1 NE

Cyber Analyst

14 40 4 1 1 NE

Investigator

19 31 2 1 1 IL

Forensics Analyst

14 36 1 1 1 PA

Cyber Analyst

16 40 1 1 1 IL

Cyber Analyst

14 35 3 1 2 PA

Cyber Analyst

16 39 3 1 1 IL

Cyber Analyst

16 53 2 1 1 NE

Logistics

16 49 3 1 2 PA

Cyber Analyst

16 38 4 1 1 NE

Cyber Analyst

16 27 1 2 1 PA

19 40 1 1 1 NE

16 37 3 2 1 IL

Cyber Software Engineer

19 34 2 1 1 PA

Cyber Software Engineer

16 51 3 1 1 NE

Cyber Analyst

16 31 3 1 1 PA

Sr Cyber Investigator

16 46 3 1 2 IL

Cyber Analyst

19 41 3 1 1 PA

Cyber Analyst

16 31 3 1 1 IL

Physical Security

16 46 1 1 1 PA

Cyber Analyst

19 59 1 1 1 IL

16 31 4 1 1 IL

Forensics Analyst

19 34 3 1 2 IL

Public and Business Office Team

14 58 4 1 1 IL

Cyber Analyst

14 39 3 1 1 NE

Malware Reverse Engineer

16 54 3 1 1 PA

Cyber Analyst

19 47 4 1 2 PA

Cyber Analyst

16 30 1 1 2 NE

Cyber Analyst

19 53 3 1 1 PA

Cyber Software Engineer

19 56 3 1 1 PA

16 53 1 1 1 IL

Cyber Analyst

16 38 4 1 1 PA

Public and Business Office Team

16 40 4 1 1 NE

Forensics Analyst

16 26 1 1 1 NE

9/4/06 Investigator

16 51 3 1 1 NE

Cyber Software Engineer

12 31 2 1 1 PA

Acctg/Fin

14 62 1 1 1 NE

Cyber Analyst $150,263 12 53 2 1 1 NE

Sr Cyber Investigator

19 53 3 1 1 NE

Forensics Analyst

16 30 4 1 1 IL

Cyber Mgr

14 40 3 2 1 IL

Cyber Analyst $156,750 16 51 3 1 2 NE

Cyber Analyst $151,523 16 56 1 1 1 IL

Cyber Software Engineer

14 25 3 2 1 NE

12/29/11 Cyber Analyst

16 44 3 1 1 IL

Public and Business Office Team Mgr

12 47 3 1 1 PA

14 44 3 1 1 NE

Malware Reverse Engineer

19 49 3 1 2 IL

$154,933 19 43 3 1 2 IL

Public and Business Office Team

19 61 4 1 1 PA

Public and Business Office Team

16 41 3 1 1 PA

Admin

16 37 4 1 2 IL

Forensics Analyst

14 21 3 1 2 NE

Public and Business Office Team

14 32 3 1 1 PA

Advertising

14 39 3 2 2 PA

Cyber Analyst

16 37 3 1 1 PA

IT Staff

16 55 1 1 1 PA

Acctg/Fin

16 25 3 2 1 NE

Cyber Software Engineer

19 44 2 1 2 NE

Sr Cyber Investigator

19 37 1 1 2 IL

Cyber Analyst

14 43 3 1 1 PA

Cyber Analyst

14 41 2 1 1 IL

Cyber Analyst

19 29 3 1 2 PA

Cyber Software Engineer

19 42 3 2 1 IL

IT Staff

19 36 2 1 1 PA

7/11/04

19 58 3 1 1 PA

Cyber Analyst

16 57 2 1 1 PA

Logistics

16 34 3 1 1 IL

6/20/15 Cyber Analyst

14 29 1 1 1 NE

16 51 3 2 1 NE

Cyber Analyst

16 45 3 1 1 PA

IT Staff

14 50 3 1 1 NE

Public and Business Office Team

16 37 1 2 1 IL

19 50 3 2 1 IL

Forensics Analyst

16 32 3 2 2 IL

Cyber Analyst

16 57 1 1 1 NE

Public and Business Office Team

19 45 1 1 2 NE

Cyber Analyst

16 37 1 1 1 IL

Physical Security

14 39 1 2 1 IL

Investigator

16 39 3 1 1 NE

Cyber Software Engineer

16 54 3 1 1 NE

8/13/17 Cyber Analyst

16 25 1 2 2 IL

Sr Cyber Investigator $156,750 16 61 1 1 2 NE

Cyber Analyst

16 54 1 1 1 IL

Public and Business Office Team

14 35 3 1 2 PA

Cyber Analyst

19 58 1 1 1 PA

Cyber Analyst

16 37 1 1 2 PA

Cyber Analyst

16 48 3 1 1 PA

Logistics

16 38 3 2 1 PA

Sr Cyber Investigator

16 33 1 1 1 IL

Acctg/Fin

16 35 1 2 1 NE

Cyber Software Engineer $164,033 14 30 3 1 1 IL

Cyber Analyst

16 46 3 1 1 NE

Forensics Analyst

16 28 3 1 2 IL

Acctg/Fin

12 48 3 1 1 NE

Cyber Analyst

16 40 1 1 2 NE

Forensics Analyst

16 24 4 1 1 NE

Cyber Mgr

14 48 4 2 1 IL

Quality Assurance

16 35 3 1 1 NE

Cyber Analyst

16 38 3 1 2 NE

Cyber Software Engineer

16 42 2 2 1 NE

Investigator

16 36 4 2 1 PA

12/4/11 Malware Reverse Engineer

19 40 3 1 1 NE

IT Mgr

19 56 3 1 1 PA

Physical Security

14 30 2 2 1 IL

Cyber Analyst

14 46 3 1 1 NE

Cyber Analyst

19 49 3 2 1 PA

Cyber Analyst

19 49 1 1 2 NE

Forensics Analyst

14 26 3 1 2 NE

19 50 3 1 1 NE

Sr Cyber Investigator

19 38 1 2 1 IL

Physical Security

14 24 1 2 2 PA

Physical Security $43,367 16 34 3 1 1 IL

Cyber Analyst

16 55 3 1 1 IL

Eng Mgr

12 49 3 1 2 PA

Cyber Analyst

14 33 3 1 1 PA

Forensics Analyst

16 22 1 1 2 NE

Physical Security

12 22 3 2 2 IL

Cyber Analyst

16 41 3 1 1 PA

IT Staff

16 28 3 1 1 PA

Advertising

16 34 3 1 2 NE

Cyber Analyst

14 55 3 1 1 IL

Cyber Analyst

14 57 3 1 1 IL

IT Staff

16 46 2 1 1 PA

Cyber Analyst

12 43 3 1 1 IL

Sr Cyber Investigator

19 40 3 1 1 NE

Cyber Analyst

16 51 3 1 1 IL

7/16/01 Cyber Analyst

16 60 1 1 2 PA

Cyber Analyst

14 46 1 1 1 PA

7/11/03 Cyber Analyst

14 55 3 1 1 PA

Sr Forensics Mgr

16 48 3 1 1 IL

Investigator

16 33 3 2 1 IL

Cyber Analyst

14 44 1 1 1 PA

Cyber Analyst

16 44 1 1 1 PA

Sr Cyber Investigator

19 46 3 1 1 PA

Cyber Analyst

16 28 4 1 1 IL

7/20/01 Sr Cyber Investigator

16 65 3 1 1 PA

11/10/11 Forensics Analyst

16 31 1 1 1 PA

7/17/02 Investigator

14 53 3 1 1 NE

Cyber Mgr

16 36 4 1 1 NE

IT Staff

14 51 1 1 1 NE

Cyber Software Engineer

19 42 3 1 1 NE

Cyber Software Engineer

16 44 3 2 1 IL

Malware Reverse Engineer

16 34 3 1 1 NE

Cyber Analyst

16 27 3 2 1 IL

Malware Reverse Engineer

16 34 3 1 2 IL

Investigator

16 34 1 1 1 IL

Sr Cyber Investigator

16 57 3 2 1 PA

Sr Cyber Investigator $152,446 16 37 3 1 1 PA

Marketing

16 42 3 2 1 PA

Forensics Analyst

19 30 3 1 1 IL

12/29/17 Cyber Software Engineer $151,174 16 40 3 2 1 PA

Forensics Analyst

19 29 4 1 1 IL

Cyber Analyst

16 27 3 1 1 PA

Cyber Analyst

14 37 1 1 1 IL

Physical Security $43,367 16 29 3 1 2 NE

Cyber Software Engineer

19 44 3 1 1 PA

Quality Assurance

16 40 3 1 1 IL

Physical Security $43,367 16 33 3 1 1 IL

Sr Cyber Investigator

16 39 4 1 1 PA

Sr Cyber Investigator

19 40 4 1 1 NE

Malware Reverse Engineer

14 39 2 1 2 IL

Cyber Analyst

16 39 3 1 2 PA

Physical Security

14 30 3 2 1 PA

Cyber Analyst

16 35 4 1 2 PA

Cyber Analyst $88,743 19 33 2 2 2 IL

Cyber Analyst

16 25 3 1 2 PA

Cyber Analyst

16 50 3 1 1 NE

Cyber Mgr

19 42 3 2 1 PA

IT Staff

14 43 1 1 1 PA

Forensics Analyst $143,063 16 31 1 1 2 NE

Cyber Analyst

14 34 1 2 1 PA

Physical Security

12 27 1 1 2 PA

Forensics Analyst

14 35 1 1 2 NE

Cyber Analyst

19 41 1 1 1 PA

Cyber Analyst

16 58 3 1 1 PA

IT Staff

19 35 3 1 1 PA

Sr Public and Business Office Team Mgr

14 56 3 1 2 PA

Sr Cyber Investigator

16 55 1 1 1 PA

16 48 4 1 2 IL

Acctg/Fin

14 42 3 2 2 NE

Cyber Analyst

16 38 3 1 1 PA

Acctg/Fin

16 44 3 1 1 PA

Admin

14 25 3 2 2 PA

Quality Assurance

16 45 3 2 2 IL

Cyber Analyst

16 50 1 1 1 IL

Cyber Software Engineer

16 28 1 2 2 NE

10/4/12 Cyber Analyst

19 35 3 1 1 PA

Forensics Analyst

16 31 3 1 1 PA

Cyber Software Engineer

16 38 3 1 1 PA

Malware Reverse Engineer

16 37 3 2 1 NE

Cyber Analyst $162,731 16 32 1 1 1 PA

Logistics

19 36 3 2 1 IL

Public and Business Office Team

14 44 2 2 1 PA

IT Staff

14 37 3 1 1 NE

Marketing

19 40 1 1 1 IL

6/24/13 Acctg/Fin

14 38 2 1 2 NE

IT Staff

19 52 3 1 1 IL

Sr Cyber Analyst $154,122 19 33 1 1 2 IL

Cyber Software Engineer

16 45 3 1 1 PA

Forensics Analyst $154,933 16 31 1 1 1 NE

IT Staff $141,110 16 36 3 1 1 IL

7/11/03 Malware Reverse Engineer

14 63 3 1 1 PA

5/3/13 Physical Security

16 34 3 2 1 PA

Cyber Analyst

16 28 3 1 2 NE

Cyber Analyst

14 34 3 1 1 NE

Forensics Analyst

16 32 1 1 1 NE

Forensics Analyst

14 35 3 1 1 IL

Cyber Analyst

19 42 2 1 1 IL

Cyber Analyst

12 47 3 1 1 PA

Acctg/Fin

16 30 3 1 1 PA

Cyber Software Engineer

16 29 2 2 2 PA

12/14/13 Cyber Analyst

19 43 3 1 1 NE

Sr Cyber Investigator

19 61 1 2 1 PA

Cyber Analyst $148,111 16 39 3 1 1 NE

Forensics Analyst

12 26 3 1 2 PA

Physical Security

14 45 3 2 1 PA

Malware Reverse Engineer

16 36 3 1 2 NE

Cyber Analyst

16 47 3 1 1 NE

Cyber Mgr

16 34 1 2 1 IL

2/6/14 Forensics Analyst

16 42 3 1 1 NE

Cyber Analyst

14 34 2 1 1 IL

Physical Security

16 44 3 1 1 NE

7/11/04 Cyber Software Engineer

16 59 3 1 1 PA

Malware Reverse Engineer

16 27 4 2 2 IL

Cyber Analyst $149,466 16 42 3 1 1 PA

Physical Security

12 29 1 1 1 PA

Cyber Analyst $149,466 19 30 3 1 1 PA

Public and Business Office Team

16 42 3 2 1 PA

Eng Mgr $172,291 16 52 3 1 1 NE

Cyber Analyst

14 49 1 2 2 PA

IT Staff

16 24 2 2 1 PA

Cyber Analyst

16 43 4 2 1 IL

Cyber Analyst

16 27 3 1 2 IL

7/13/02 Advertising

16 60 3 1 1 PA

Forensics Analyst

14 31 1 2 1 PA

3/30/11 Cyber Analyst

14 44 3 1 1 IL

Sr Forensics Mgr

14 41 3 1 1 PA

Advertising $144,571 16 39 3 1 1 IL

Marketing

19 47 3 2 1 PA

Acctg/Fin $154,122 12 49 3 2 2 PA

Cyber Analyst

16 44 3 1 1 IL

Quality Assurance

16 52 1 2 1 NE

Cyber Software Engineer $140,865 14 30 3 1 2 NE

Cyber Mgr

16 39 1 1 1 IL

Forensics Analyst

16 26 3 2 2 NE

Sr Cyber Investigator

14 47 2 1 1 IL

Cyber Analyst

14 25 4 1 2 IL

Cyber Analyst

19 31 1 1 1 IL

Cyber Analyst

19 36 3 1 1 PA

Cyber Analyst

16 35 3 1 2 IL

Cyber Analyst

16 26 3 1 2 IL

Malware Reverse Engineer

14 49 3 1 1 PA

Sr Cyber Investigator

16 33 3 1 1 NE

6/17/17 Cyber Analyst $143,005 14 25 4 2 2 IL

Cyber Analyst

16 52 3 1 2 NE

Forensics Analyst

16 29 4 1 2 PA

Cyber Analyst

16 40 1 1 1 PA

Cyber Analyst

14 25 1 1 1 PA

Forensics Analyst

14 26 3 1 2 PA

Cyber Analyst

19 50 3 1 1 PA

Forensics Analyst $162,030 12 31 4 1 2 IL

Cyber Analyst

16 41 3 1 1 PA

Cyber Analyst

16 54 2 1 1 PA

Cyber Analyst

16 48 3 1 1 NE

Cyber Analyst $163,045 16 50 1 1 1 PA

Marketing

14 48 3 2 1 NE

Forensics Analyst $151,523 16 34 3 1 2 PA

Cyber Analyst

14 43 1 1 2 IL

1/19/18 Physical Security

14 24 1 2 1 NE

Malware Reverse Engineer

12 36 3 2 2 IL

Cyber Analyst

14 37 3 1 2 IL

mary Tables for Graphing

# #

Yr Sales

Acctg/Fin 1

Admin 2

Advertising 3

CEO 4

CFO

CIO

Controller

COO Gender # %

Cyber Analyst 1

Cyber Mgr 2

Cyber Software Engineer TOTAL

Eng Mgr

Forensics Analyst

Investigator

# %

IT Mgr 12

IT Staff 14

Logistics 16

Logistics Mgr 19

2020

Malware Reverse Engineer TOTAL

Marketing

Physical Security

Public and Business Office Team

# %

Public and Business Office Team Mgr 1

Quality Assurance 2

Sr Cyber Analyst TOTAL
Sr Cyber Investigator
Sr Forensics Mgr
Sr Public and Business Office Team Mgr

TOTAL State Region # %
PA

TOTAL
Descriptive Statistics Salary Hrly Rate Yrs of Svc Ed Age

Range

Sum

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

For this Project, you have to follow the instruction given in each steps 1 – 10 below. I have already done the project but end up failing this project. For that reason , I would like you to make corrections on my given attached sheet and give it back to me.However, you have to redo the several steps compelty as well. Like answering questions and essay.

Conduct Quantitative Analysis – Management

Transcript

Your manager, Pat Williams, invites you to meet again to discuss another project. It turns out that Cybertech’s competitors have been closing in on market share. Pat asks you to analyze data about the company’s workforce and to prepare an analysis of its current composition. The report is due in two weeks. Your quantitative analysis will be used to advise the company’s management on the cost of doing business, and how to achieve success and income revenues, as well as make recommendations on the allocation of salaries across the company. Pat explains more about the requirements. Pat asks that your report must consider personnel by organizational roles, salaries, length of service, level of education, age, race, gender, marital status, and region. Pat explains that your analysis will be reviewed to determine how the company’s employee demographics compare with industry peers and competitors. You learn that you will present your report to leadership at their quarterly strategic planning meeting. You know that you’ll need to use your statistical skills and technical skills to identify and manipulate the data. You’ll also need to draw relevant conclusions based on quantitative reasoning. First, sketch out a plan to review your skills in math, statistics, and Excel. Second, you’ll need to work through the data to produce supporting charts and graphs. Third, you’ll need to complete the analysis well before the due date. Time to get busy.

Step 2: Set Up Your Spreadsheet

Now that you’ve assessed and refreshed these important skills, you’re ready to begin. First

download the Excel template

( I have attached spreadsheet already.) and use it to

set up your spreadsheet

. ) I am providing another work sheet that I worked on and end up not getting good grade. So make correction on that sheet.) This step has you set up a basic view in preparation for the use of several tools.

After you’ve formatted and set up the basic view and saved it with your name, you’re ready to move to the next step and

add data

Step 3: Add Data

With the spreadsheet set up and saved with your last name, you’re ready to add data. In Section 1 on the Data page, complete each column of the spreadsheet to arrive at the desired calculations.

When you’re ready, move on to the next step, where you will use functions to

summarize the data

Add Data

In Section 1 on the Data page, complete each column of the spreadsheet to arrive at the desired calculations. Use Excel formulas to demonstrate that you can perform the calculations in Excel. Remember, a cell address is the combination of a column and a row. For example, C11 refers to Column C, Row 11 in a spreadsheet.

Reminder: Occasionally in Excel, you will create an unintentional circular reference. This means that within a formula in a cell, you directly or indirectly referred to (back to) the cell. For example, while entering a formula in A3, you enter =A1+A2+A3. This is not correct and will result in an error. Excel allows you to remove or allow these references.

Hint: Another helpful feature in Excel is Paste Special. Mastering this feature allows you to copy and paste all elements of a cell, or just select elements like the formula, the value or the formatting.

“Names” are a way to define cells and ranges in your spreadsheet and can be used in formulas. For review and refresh, see the resources for Create Complex Formulas and Work with Functions.

Ready to Begin?

1. To calculate hourly rate, you will use the annual hourly rate already computed in Excel, which is 2080. This is the number most often used in annual salary calculations based on full time, 40 hours per week, 52 weeks per year. In E11 (or the first cell in the Hrly Rate column), create a formula that calculates the hourly rate for each employee by referencing the employee’s salary in Column D, divided by the value of annual hours, 2080. To do this, you will create a simple formula: =D11/2080. Complete the calculations for the remainder of Column E. If you don’t want to do this cell by cell, you can create a new formula that will let you use that same formula all the way to the end of the column. It would look like this: =$D$11:$D$382/2080.

2. In Column F, calculate the number of years worked for each employee by creating a formula that incorporates the date in cell F9 and demonstrates your understanding of relative and absolute cells in Excel. For this, you will need a formula that can compute absolute values to determine years of service. You could do this longhand, but it would take a long time. So, try the YEARFRAC formula, which computes the number of years (and even rounds). Once you start the formula in Excel, the element will appear to guide you. You need to know the “ending” date (F9) and the hiring date (B11). The formula looks like this: =YEARFRAC($F$9,B11), and the $ will repeat the formula calculation down the column as before if you grab the edge of the cell and drag it to the bottom of the column.

3. To determine if an employee is vested or not In Column I, use an IF statement to flag with a “Yes” any employees who have been employed 10 years or more. Here is how an IF statement works: =IF(X is greater (or less than) Y, “Answer”, IF not, “Answer”). To create this as a formula, it would look like this: =IF(F11>=10,”Yes”,”No”). You can drag this formula down the column, or highlight the starting cell, hold down the Shift key, and zip down to cell 382 and release, and the whole column should compute properly.

4. Using the VLookup function, use the Region Key located at F417:G420 to fill in the cells in Column N to identify the region in which the employee is located based on the state listed in Column M. (If this function is new to you— hang in there—this one is worth it.

VLOOKUP requires that you tell Excel where to look for the information. =VLOOKUP(Cell value to look up, From:To, Position, Alternate answer?) Go to the data first:

Snip is used by courtesy of Microsoft.

You will devise a formula that will match the state to a region (in position 2). We will use the $ function to enable a repeat of the formula down the column. =VLOOKUP(M11,$F$417:$G$420,2,FALSE).

To view videos that explain these formulas, refer back to Step 1 under the link titled Access Tutoring Help and Other Resources. The videos were created for another course but pertain to this same data set.

Step 4: Use Functions to

Summarize the Data

With the data built, you are ready to start using tools to summarize the data, using Countif and the Sum function to do the math. In this step, you’ll begin to see patterns in the data and the story of the workforce.

Take a breather here if you need it. You should strive to work through the first four steps this week. Check in with your instructor.

With this step complete, you’re ready to begin your analysis.

Learning Topic

Summarize the Data

You are now ready to move into Section 2 to prepare the data for future analysis, to include simple statistical analyses and charts and graphs to present the data. To start, begin by presenting categories of data in summary tables and counting them, totaling them, and calculating percentages. This basic analysis helps you begin to describe patterns in the data and starts to form the story of the workforce.

Complete each table in Section 2. Use the Countif Function to count each item in each table. Use the Sum Function to total the tables when required. Calculate percentages for each table as required. Format cells appropriately. Remember to make smart use of reference cells in formulas (avoid typing in numbers or text into formulas—point to other cells) and use mixed and fixed cell references to make copying formulas easier/faster. Your supervisor will look for this!

Using the COUNTIF Function

The COUNTIF function allows the student to tabulate the instances (or frequency) of a specified value (character or numeric) within a range of cells in Excel. To begin, you select a cell and type:

After entering the initial text, it will ask you to select your range and criteria. The range represents your highlighted selection of cells that you are tabulating a specified value. To select your range, you can highlight the cells. When you do that, you’ll see how the function automatically inserts the cell range into your formula (below). When you do that, you can insert a comma (,) after the range (as shown by the circle) and then move to the criteria portion of the formula.

Your criteria is the investigate component of the formula. So if the formula is asking for cell values less than 2, it will tabulate all selected cells in your range that are less than 2. In the formula, it would resemble the following: =COUNTIF(A4:A12, <2). Note: In terms of tabulating the frequency of text (such as region), it’s important to note the need to use “ “ to make the variable character (below). When you entered your criteria and are ready to tabulate, you can close your formula by entering a close parenthesis --- ).

Note: If you are dealing with numeric data, the “ “ are not needed before and after the text of your key variable.

Step 5: Analyze the Workforce

You’ve summarized the data. Next, you will employ

descriptive or summary statistics

to analyze the workforce. Your summary tables described “how many.” Now you will

calculate mean, median, and mode for the categories of data, and derive the deviation, variance, and dispersion, and distribution

. This is where it gets interesting.

You will be working in Section 3 of the Data tab in the spreadsheet to complete the descriptive statistics for the five categories (Salary, Hourly Rate, Years of Service, Education, and Age). Using Excel formulas, complete the table.

After you have used Excel formulas to find this information, you will next use the Toolpak to find summary statistics.

Step 6: Use the Analysis Toolpak

Your data set is now built. Now, you will use the same functions to perform the

Descriptive Analysis Using the Analysis Toolpak

. This is a handy feature to know. Remember that there may be some minor differences in the answers depending on the version.

You should now have Tab 2 complete: Excel Summary Stats. Next, you’ll create charts and a histogram for Tabs 3 and 4.

Descriptive Analysis Using the Analysis Toolpak

The steps you just followed enabled you to calculate descriptive statistics using individual Excel functions. Did you know that you can generate the same descriptive statistics in one easy step? 1. First, make sure you have enabled the data analysis toolpak feature. When you completed that successfully, you will see the words “Data Analysis” or an icon on the top right on the Data functions. Select that and then choose “Descriptive Statistics” from the list. 2. The next step will be to provide the input and output. Since you want to have statistics for all the selected categories, you will provide the location of the data on the spreadsheet in the input box. o Provide the inclusive cells for the five categories by typing in the field, or capture the columns with your mouse and the field will show in the input range. o Check the labels box so you have titles for the categories. Then select “New Worksheet Ply.” Your output will be now be in a new sheet on your tab. 3. Label your new sheet Summary Stats and format the columns for readability. 4. Compare your calculations using the data analysis feature to the results you obtained in the previous step, when you calculated the results manually with individual functions. You should not have a large disparity. This tool is handy for quick computations, and you will use it again to create your histogram in Step 7.

Step 7: Create Charts and a Histogram

Where would we be without the ability to view data in charts? It is sometimes easier to grasp the context of data if it is captured in an image. In this step, you will

work with data to create charts

, adding a tab for charts, and another for a histogram.

In this step, you will build Tab 3: Graphs—Charts and Tab 4: Histogram. After you complete these tabs, you’ll be ready to sort the data.

Work With Data to Create Charts

It is often helpful to view and interpret analytical results when they are presented visually. Graphs and charts help readers digest and interpret information quickly, consistent with the familiar adage “a picture is worth a thousand words.” Let’s see what we can see in your data analysis.

Create the following graphs in your workbook on a separate tab named Graphs_Charts:

1. Create separate pie charts that show percentages of employees by (1) gender, (2) education level, and (3) marital status. Explore pie chart formats.

2. Create separate bar charts that show the (1) number of employees by race and (2) the number of employee per state.

3. Create a line graph for the sales summary provided.

4. Create a histogram that shows the number of employees in incremental salary ranges of $10,000. Here, you want to show how many employees are making $0–$20,000; $20,001–$30,000; $30,001–$40,000; and so forth, up to the highest salary range. This involves counting how many employees are in each “salary bucket” to create a frequency distribution table and histogram. Histograms seem hard, but mastering how to visualize the frequency of events is helpful for analysis.

Used with permission from Microsoft.

Note: Your Excel spreadsheet template has the upper limit and labels already identified. Complete the table and histogram by engaging the Data Analysis Toolpak. Place the output on a new worksheet and label it Histogram.

Step 8: Copy and Sort the Data

You’ve accomplished a lot with the data set, summary stats, charts, and histograms. Another skill you’ll need to be able to do is sorting data in an Excel worksheet for reporting purposes. You’ll

copy the data so that you can learn how to sort it

. This is a good skill that applies to any Excel application.

In this step, you will create Tab 5: Sorted Data. When you’re finished, you’ll be ready to conduct a quantitative analysis.

See below for example of a sorted spreadsheet.

Copy the Data So That You Can Learn How to Sort It

Many times we want to sort data on an Excel worksheet for reporting purposes. Let’s see what other perspectives the functions of sorting and subtotaling yield.

1. Begin by following the steps in the “How to Copy Excel 2010 Sheet to Another Sheet” provided below. This will allow you to retain your work for Steps 2 through 7. Place the sheet at the end of the workbook and title the tab “Sorted Data.”

2. Delete all rows containing Section 2 and Section 3 work. Be sure to leave the section in cells F417:I422, as this section is referenced for the Vlookup function populating the region; otherwise, you will get a #N/A or #REF! Error in the column for region.

3. Apply the ability to sort data on each column of the spreadsheet, so that you can sort by employee #, hire date, role, etc.

4. Experiment with the filter funnel, sorting the data by various columns. For example, try sorting by employee number from smallest to largest. Try sorting by role in ascending order (A-Z).

5. Sort the spreadsheet by region.

6. Employ the subtotal feature to subtotal the salary for each region, with a grand total for the company.

7. Format the entire spreadsheet to print, so that the columns fit on the pages, and Row 1 repeats on each page.

Step 9: Conduct Quantitative Analysis

In this step, your hard work bears fruit. What does it all mean? Think back to your boss’s reasons for tasking you with this project. Bring your powers of analysis to bear to determine what the data may be telling you. Apply your quantitative reasoning skills to answer five questions that demonstrate your interpretation of the data. The questions are located on the QR Questions_Responses tab in your workbook.

After answering the five questions, finish the project by writing a short essay. The essay will include:

· a one-paragraph narrative summary of your findings, describing patterns of interest

· an explanation of the potential relevance of such patterns

· a description of how you would investigate further to determine if your results could be perceived as good or bad for the company.

Prepare your responses in your workbook on the QR Questions_Responses tab.

Good job! In the next step, you’ll submit the workbook and analysis.

Step 10: Submit Your Completed Workbook and Analysis

You’re now ready to submit the workbook and analysis for review and feedback. Review the requirements for the final deliverable to be sure you have:

1. Excel Workbook with Six Tabs

· Tab 1: Data – completed data sheet (Steps 1–6 above)

· Tab 2: Excel Summary Stats (Step 6)

· Tab 3: Graphs – Charts (Step 7)

· Tab 4: Histogram (Step 7)

· Tab 5: Sorted Data (Step 8)

· Quantitative Analysis

(Step 9; see detail below and move to first position upon completion.)

2. Quantitative Analysis: Answers to Questions and Short Essay

· Prepare your response in this workbook. Create a tab for Quantitative Analysis, create a text box, and paste your answers to the questions in it. Move the Quantitative Analysis tab to the first tab position.

· Your final workbook tabs:

· Quantitative Analysis

· Data

· Excel Summary Stats

· Graphs–Charts

· Histogram

· Sorted Data

3. Format to Be Printed

· Format this workbook so that all the spreadsheets can be printed.

Criterion Feedback

2 Mar: Answers and essay were sloppy with no attempt at editing, spell checking, are grammar checking being accomplished.

Criterion Feedback

2 Mar: Did not identify a pattern of interest. Instead, you regurgitated a single data point from steps 1 – 8 of the project.

Criterion Feedback

2 Mar: Did not employ the requires calculations

Criterion Feedback

2 Mar: No analysis of the data was accomplished. See comments in the attached. Issues with the essay as well as incomplete or incorrect answers for Q2, Q3 and Q4.

Criterion Feedback

2 Mar: Your histogram is not correct and you did not create the projected sales following the instructions in Question 2. For the histogram, your bins for up to 20000 and 30000 should have been zero. There are no employees making 0 – 20000 or making 20001 to 30000. As such, these bins are zero. See your histogram sheet where I started you off with the correct information. For the projected sales, select the “Sales Summary (Provided)” chart and simply click on Forecast Sheet on the data tab. Excel will calculate your forecast for you. Additionally, your formulas for the role table in section 2 are incorrect and you chose not to complete section 3. You should know that there are 372 employees. If you add up every instance of every job title…there should be 372 instead of the 288 you came up with in section 2. There are two problems with your formulas. First, you did not read the section in the steps concerning absolute references. Your array is C11:C382 as documented in cell C389. Since you did not use an absolute reference, you have different arrays in use. For example, the array in cell C406 is C11:C410 which also created a circular reference in that your formula is including itself in the array. Your array in C389 should have included the dollar sign to make it an absolute reference as follows: C$11:C$382. The other issue is that you manually entered incorrect values for the roles. Instead of “Acctg/Fin”, you entered “ACCT/FIN”. Of course your count is going to be zero. What you should have used for the formula is =COUNTIF(C$11:C$382,B389). This tells excel to identify the value of cell B389 and count every instance of that value being included in the array starting in cell C$11 and ending in cell C$382.

What Will You Get?

We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.

Premium Quality

Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.

Experienced Writers

Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.

On-Time Delivery

Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.

24/7 Customer Support

Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.

Complete Confidentiality

Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.

Authentic Sources

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

Moneyback Guarantee

Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.

Order Tracking

You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.

Order Now Talk to Us

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Trusted Partner of 9650+ Students for Writing

From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.

Preferred Writer

Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.

Grammar Check Report

Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.

One Page Summary

You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.

Plagiarism Report

You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.

Free Features $66FREE

Most Qualified Writer $10FREE
Plagiarism Scan Report $10FREE
Unlimited Revisions $08FREE
Paper Formatting $05FREE
Cover Page $05FREE
Referencing & Bibliography $10FREE
Dedicated User Area $08FREE
24/7 Order Tracking $05FREE
Periodic Email Alerts $05FREE

Our Services

Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.

On-time Delivery
24/7 Order Tracking
Access to Authentic Sources

Academic Writing

We create perfect papers according to the guidelines.

Professional Editing

We seamlessly edit out errors from your papers.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

Delegate Your Challenging Writing Tasks to Experienced Professionals

Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!

Check Out Our Sample Work

Dedication. Quality. Commitment. Punctuality

It May Not Be Much, but It’s Honest Work!

Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.

0+

Happy Clients

0+

Words Written This Week

0+

Ongoing Orders

0%

Customer Satisfaction Rate

Process as Fine as Brewed Coffee

We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.

Call Us +1 (877) 657-8180 Discuss Order Details Now

See How We Helped 9000+ Students Achieve Success

We Analyze Your Problem and Offer Customized Writing

We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.

Clear elicitation of your requirements.
Customized writing as per your needs.

We Mirror Your Guidelines to Deliver Quality Services

We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.

Proactive analysis of your writing.
Active communication to understand requirements.

We Handle Your Writing Tasks to Ensure Excellent Grades

We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.

Thorough research and analysis for every order.
Deliverance of reliable writing service to improve your grades.

Place an Order Start Chat Now

Project: Conduct Quantitative Analysis ( Need Corrections)

Summary Statistics

Graphs_Charts

Histogram

QR Questions_Responses

Sorted Data

DATA

What Will You Get?

Premium Quality

Experienced Writers

On-Time Delivery

24/7 Customer Support

Complete Confidentiality

Authentic Sources

Moneyback Guarantee

Order Tracking

Areas of Expertise

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Areas of Expertise

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Trusted Partner of 9650+ Students for Writing

Preferred Writer

Grammar Check Report

One Page Summary

Plagiarism Report

Free Features $66FREE

Our Services

Academic Writing

Professional Editing

Thorough Proofreading

Thorough Proofreading

Delegate Your Challenging Writing Tasks to Experienced Professionals

Check Out Our Sample Work

It May Not Be Much, but It’s Honest Work!

0+

Happy Clients

0+

Words Written This Week

0+

Ongoing Orders

0%

Customer Satisfaction Rate

Process as Fine as Brewed Coffee

Share Your Requirements

Place Order & Deposit Funds

Release Payment to Your Writer

See How We Helped 9000+ Students Achieve Success

We Analyze Your Problem and Offer Customized Writing

We Mirror Your Guidelines to Deliver Quality Services

We Handle Your Writing Tasks to Ensure Excellent Grades