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

Only someone expert in (EXCEL) can do this project. First of all, I have already done the project in the attached file (Spread Sheet needs corrections). Also, I am providing an example of a spreadsheet that will give you an idea of how it looked like before I actually started working on this. Moving on, I ended up failing this project due to not following the instructions given by those steps provided by the professor. . For that reason, I would like you to make corrections by following Project Instructions, Starting from steps 1-10.

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.

Don't use plagiarized sources. Get Your Custom Essay on
Project: Conduct Quantitative Analysis ( Need expert in Excel to make these corrections)
Just from $13/Page
Order 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

Print

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

1

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:

2

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.

3

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.

2

>DATA Workforce Profile Analysis Section

1

: Complete all Columns in Data Set Format for: Windows User: Format cells in column according to indicated format. Number Date General Currency

Currency Number General Number General Number Number Number

Text

General
mm/dd/yy Year Ending Vested Yr 12

/

3

1/

1

9 1

0 Emp

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

Vested

Race Gender Status State Region 4

0

00 4/

23

/1

5 Sr Cyber

Investigator $92,2

6 7 $

44

.

36

5

19 35 No

3 1 1

IL Midwest 40

04 7/

13

/02 Cyber Analyst $

11

1,

8

01 $

53

.75 17 16 60 Yes

3 1 1 IL Midwest
40

10 11/

25

/

18 Forensics Analyst $90,

68

8 $

43

.60

1 16 23 No 1 2 2

PA Northeast 4012 1/

26

/10

Cyber Analyst

$95,

98

5 $

46

.

15

10

14

43 No 1 1 1

NE C-Plains 4013 12/

29

/11

Cyber Analyst

$100,

52

0 $

48

.

33

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

Forensics Analyst

$

125

,1

56 $60.17

8 19

31

No 1 1 1 IL Midwest
4015 1/1/12

Cyber Analyst

$78,

47

5 $

37

.73

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

Cyber Analyst

$93,

51

8 $44.96

9 14

39

No 1 1 1 PA Northeast
40

22 5/

27

/04

Cyber Analyst

$69,529 $33.43

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

28

,

38

4 $

61

.72

6 16 28 No 1 2 2 NE C-Plains
4025 12/12/14 Cyber Mgr $151,174 $72.68

5 16 38 No 3 1 1 PA Northeast
4027 8/19/06 Sr Cyber Investigator $71,914 $

34

.

57

13 16 51 Yes 1 1 1 NE C-Plains
4029 6/5/11

Cyber Analyst

$152,446 $73.29

9 14 36 No 4 1 2 IL Midwest
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/

21

/06

IT Staff

$90,930 $43.72

14 19

45

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

Forensics Analyst

$67,866 $

32

.

63

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

Cyber Analyst

$

64

,

58

0 $31.05

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

Cyber Analyst

$91,

77

1 $44.12

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

Cyber Analyst

$

59

,219 $28.47

4 14 35 No 3 1 2 NE C-Plains
4045 6/7/16 Physical Security $32,367 $15.56

4 12 25 No 3 2 2 NE C-Plains
4046 9/4/06

Cyber Analyst

$115,974 $

55

.76

13 16

54

Yes 1 1 1 PA Northeast
4055 6/17/18

IT Staff

$99,786 $47.97

2 14 31 No 1 2 2 PA Northeast
4060 2/1/12

Sr Cyber Investigator

$73,6

50 $35.

41

8 19

42

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

Cyber Analyst

$154,933 $74.

49

8 16 34 No 3 1 2 PA Northeast
4064 1/18/16

Cyber Analyst

$144,571 $69.51

4 16 36 No 4 1 2 PA Northeast
4067 10/29/12 Malware Reverse Engineer $1

24

,996 $60.09

7 16 49 No 2 1 2 PA Northeast
4068 7/15/03

Cyber Analyst

$145,776 $70.08

16 16 59 Yes 3 1 1 IL Midwest
4070 4/4/17

Forensics Analyst

$80,191 $38.55

3 16 28 No 1 1 1 PA Northeast
4075 10/2/16

Forensics Analyst

$75,053 $36.08

3 14 25 No 3 1 2 IL Midwest
4078 7/15/09

Cyber Analyst

$83,851 $40.31

10 16 51 Yes 1 1 1 PA Northeast
4082 7/2/15

Cyber Analyst

$82,411 $39.

62

4 16 37 No 3 1 1 IL Midwest
4086 9/18/07

Cyber Analyst

$114,721 $55.15

12 14 51 Yes 3 1 1 PA Northeast
4088 7/18/17 Public and Business Office Team $108,342 $52.09

2 16 34 No 3 2 1 IL Midwest
4089 10/16/16

Cyber Software Engineer

$81,050 $38.97

3 16 36 No 3 1 1 PA Northeast
4090 11/15/15

Cyber Analyst

$

87

,641 $42.14

4 14 33 No 4 1 2 IL Midwest
4092 7/7/08

Forensics Analyst

$98,943 $47.57

11 16 36 Yes 3 1 1 PA Northeast
4093 8/25/10

Cyber Analyst

$93,936 $45.16

9 19 47 No 3 1 2 NE C-Plains
4095 12/31/04

Cyber Analyst

$133,678 $64.27

15 16 52 Yes 3 1 1 PA Northeast
4097 2/26/07

Cyber Analyst

$162,731 $78.24

13 16 53 Yes 1 1 2 IL Midwest
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
Section 2: Complete

Sum

mary Tables for Graphing

Sales

Summary

(Provided)

Roles

# #

%

Yr Sales
Acctg/Fin 12 1

African-Am

98

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

Asian

25

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

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

Hispanic

33

8.87% 2006 $130,427,572 CFO 1

TOTAL 372 100.00% 2007 $146,938,882 CIO 1

2008 $139,117,818 Controller 1

2009 $143,547,199 COO 1 Gender # %

2010 $144,834,875 Cyber Analyst 146 1

Male 295 79.30% 2011 $149,578,842 Cyber Mgr 8 2

Female

77

20.70% 2012 $155,740,613 Cyber Software Engineer 23 TOTAL 372 100.00%

2013 $144,759,828 Eng Mgr 3

2014 $156,714,301 Forensics Analyst 39

2015 $150,201,379 Investigator 8

Education Level

# %

2016 $154,750,829 IT Mgr 2 12

HS

18

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

AA

87

23.39% 2018 $156,494,223 Logistics 5 16

BA/BS 203 54.57% 2019 $165,800,498 Logistics Mgr 1 19

Masters+

64

17.20% 2020 $191,210,386 Malware Reverse Engineer 16 TOTAL 372 100.00%

2021 $197,876,014 Marketing 5

2022 $204,541,642 Physical Security 18

2023 $211,207,270 Public and Business Office Team 14

Marital Status

# %

2024 $217,872,898 Public and Business Office Team Mgr 1 1

Married 268 72.04% Quality Assurance 5 2

Single

104

27.96% Sr Cyber Analyst 2 TOTAL 372 100.00%
Sr Cyber Investigator 26
Sr Forensics Mgr 3
Sr Public and Business Office Team Mgr 3

Region Key TOTAL 372 State Region # %
PA Northeast 149

40.05% IL Midwest 125

33.60% NE C-Plains 98 26.34%
TOTAL 372 100.00%
Section 3: Complete

Descriptive Statistics Be sure to include the correct units where applicable for the summary statistics below Descriptive Statistics

Frequency

Table by Salary

Range

s Column1

Salary

Hourly Rate

Yrs of Svc Ed Age

Bin Range / Upper Limit Label 20000 Up to 20 Graph on next Tab Mean 99672.2311827957 47.9193419148 7.6339531063 15.8548387097 40.0510752688 30000 21-30 Standard Error 1703.3349438993 0.8189110307 0.2249815139 0.0934079641 0.5151533117 4000

0 31-40 Median 91475.5 43.9786057692 7.0819444444

16 39

50000 41-50 Mode 154933 74.4870192308 15.4722222222

16 40

60000 51-60 Standard Deviation 32852.73465592 15.7945839692 4.3392862964 1.8015875676 9.9359172536 70000 61-70 Sample Variance 1079302174.37229 249.4688827599 18.8294055622 3.2457177637 98.7224516709 80000 71-80 Kurtosis 0.2695669596

0.2695669596

-0.3501254665 -0.0946058413 -0.6537591283 90000 81-90 Skewness 0.765349626

0.765349626

0.6089293155 0.1879424621 0.3095312361 100000 91-100 Range

206948 99.4942307692 18.3527777778

7 47

110000 101-110 Minimum 32367 15.5610576923 0.1055555556

12 21

120000 111-120 Maximum 239315 115.0552884615 18.4583333333

19 68

130000 121-130 Sum

37078070 17825.9951923077 2839.8305555556 5898 14899 140000 131-140 Count

372 372 372 372 372

150000 141-150 160000 151-160 170000 161-170 180000 171-180 190000 181-190 200000 191-200 200+

Summary Statistics

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

Graph&Charts

Line Graph

Emplyees by Gender

Male Female 0.793010752688172 0.20698924731182797

Employee by education level

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

Employees by Marital Status

Married Single 0.72043010752688175 0.27956989247311825

No. of Employees by Race

African-Am Asian Caucasian Hispanic 98 25 216 33

No. of Employees Per State

PA IL NE 149 125 98

Sales Summary

Yr

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

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

Histogram

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

1

200000 0 30000 0
More 1 200000 0
Frequency Distribution
More

HISTOGRAM

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

Sorted Data

Workforce Profile Analysis

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

1

mm/dd/yy
Year Ending

10

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

1

4191 7/11/04 Acctg/Fin $71,026 $34.15 15 16 49 Yes 3 1 2 NE C-Plains
4354 7/17/02 Acctg/Fin $68,056 $32.72 17 14 62 Yes 1 1 1 NE C-Plains
4402 12/7/18 Acctg/Fin $152,030 $73.09 1 16 25 No 3 2 1 NE C-Plains
4470 5/17/15 Acctg/Fin $66,528 $31.98 5 16 35 No 1 2 1 NE C-Plains
4475 12/12/12 Acctg/Fin $75,415 $36.26 7 12 48 No 3 1 1 NE C-Plains
4730 8/31/04 Acctg/Fin $107,530 $51.70 15 14 42 Yes 3 2 2 NE C-Plains
4775 6/24/13 Acctg/Fin $162,030 $77.90 7 14 38 No 2 1 2 NE C-Plains
4023 2/6/14 Advertising

6 16 28 No 1 2 2 NE C-Plains
4564 11/23/12 Advertising $88,639 $42.61 7 16 34 No 3 1 2 NE C-Plains
4520 4/11/04 CIO $179,195 $86.15 16 19 50 Yes 3 1 1 NE C-Plains
4012

Cyber Analyst

10 14 43 No 1 1 1 NE C-Plains
4044 12/3/15 Cyber Analyst

$28.47 4 14 35 No 3 1 2 NE C-Plains
4093 8/25/10 Cyber Analyst $93,936 $45.16 9 19 47 No 3 1 2 NE C-Plains
4121 8/31/11 Cyber Analyst $148,111 $71.21 8 16 36 No 2 1 1 NE C-Plains
4126

Cyber Analyst $60,641 $29.15 3 16 34 No 4 1 1 NE C-Plains
4137 1/14/09 Cyber Analyst $98,634 $47.42 11 16 52 Yes 3 1 1 NE C-Plains
4152 7/19/12 Cyber Analyst $151,523 $72.85 7 16 41 No 1 1 1 NE C-Plains
4167 8/26/05 Cyber Analyst $111,536 $53.62 14 16 51 Yes 1 1 1 NE C-Plains
4199 7/16/12 Cyber Analyst $151,174 $72.68 7 16 38 No 3 1 1 NE C-Plains
4207 6/22/14 Cyber Analyst $91,205 $43.85 6 14 37 No 3 1 1 NE C-Plains
4265 6/24/13 Cyber Analyst $81,042 $38.96 7 16 30 No 3 1 2 NE C-Plains
4274 12/8/14 Cyber Analyst $87,092 $41.87 5 16 30 No 3 1 1 NE C-Plains
4278 9/6/10 Cyber Analyst $90,153 $43.34 9 14 40 No 4 1 1 NE C-Plains
4296 12/9/07 Cyber Analyst $150,868 $72.53 12 16 53 Yes 2 1 1 NE C-Plains
4299 6/1/11 Cyber Analyst $76,158 $36.61 9 16 38 No 4 1 1 NE C-Plains
4326 5/3/12 Cyber Analyst $65,955 $31.71 8 14 39 No 3 1 1 NE C-Plains
4330 10/14/15 Cyber Analyst $94,038 $45.21 4 16 30 No 1 1 2 NE C-Plains
4355 4/1/07 Cyber Analyst $150,263 $72.24 13 12 53 Yes 2 1 1 NE C-Plains
4369 8/31/05 Cyber Analyst $156,750 $75.36 14 16 51 Yes 3 1 2 NE C-Plains
4423 6/20/15 Cyber Analyst $102,641 $49.35 5 14 29 No 1 1 1 NE C-Plains
4439 2/2/04 Cyber Analyst $69,656 $33.49 16 16 57 Yes 1 1 1 NE C-Plains
4472 2/15/11 Cyber Analyst $74,381 $35.76 9 16 46 No 3 1 1 NE C-Plains
4479 3/16/11 Cyber Analyst $68,375 $32.87 9 16 40 No 1 1 2 NE C-Plains
4489 3/28/14 Cyber Analyst $83,075 $39.94 6 16 38 No 3 1 2 NE C-Plains
4513 2/19/12 Cyber Analyst $103,721 $49.87 8 14 46 No 3 1 1 NE C-Plains
4517 7/27/08 Cyber Analyst $140,865 $67.72 11 19 49 Yes 1 1 2 NE C-Plains
4699 10/8/10 Cyber Analyst $79,542 $38.24 9 16 50 No 3 1 1 NE C-Plains
4798 9/22/13 Cyber Analyst $119,285 $57.35 6 16 28 No 3 1 2 NE C-Plains
4803 10/29/11 Cyber Analyst $52,064 $25.03 8 14 34 No 3 1 1 NE C-Plains
4820 12/14/13 Cyber Analyst $69,777 $33.55 6 19 43 No 3 1 1 NE C-Plains
4824 5/17/10 Cyber Analyst $148,111 $71.21 10 16 39 No 3 1 1 NE C-Plains
4831 11/23/08 Cyber Analyst $100,632 $48.38 11 16 47 Yes 3 1 1 NE C-Plains
4945 10/13/05 Cyber Analyst $61,902 $29.76 14 16 52 Yes 3 1 2 NE C-Plains
4964 10/21/10 Cyber Analyst $83,911 $40.34 9 16 48 No 3 1 1 NE C-Plains
4612 3/17/16 Cyber Mgr $111,196 $53.46 4 16 36 No 4 1 1 NE C-Plains
4175 11/29/11 Cyber Software Engineer $162,731 $78.24 8 16 54 No 3 1 1 NE C-Plains
4304 6/1/06 Cyber Software Engineer $81,779 $39.32 14 16 51 Yes 3 1 1 NE C-Plains
4380 7/1/17 Cyber Software Engineer $104,793 $50.38 3 14 25 No 3 2 1 NE C-Plains
4405 9/27/12 Cyber Software Engineer $54,080 $26.00 7 19 44 No 2 1 2 NE C-Plains
4455 10/17/08 Cyber Software Engineer $152,446 $73.29 11 16 54 Yes 3 1 1 NE C-Plains
4490 3/11/13 Cyber Software Engineer $100,571 $48.35 7 16 42 No 2 2 1 NE C-Plains
4618 6/13/11 Cyber Software Engineer $76,031 $36.55 9 19 42 No 3 1 1 NE C-Plains
4745 3/14/17 Cyber Software Engineer $75,144 $36.13 3 16 28 No 1 2 2 NE C-Plains
4905 5/12/18 Cyber Software Engineer $140,865 $67.72 2 14 30 No 3 1 2 NE C-Plains
4383 12/16/09 Eng Mgr $175,916 $84.58 10 14 44 Yes 3 1 1 NE C-Plains
4857 9/2/14 Eng Mgr $172,291 $82.83 5 16 52 No 3 1 1 NE C-Plains
4135 2/24/16 Forensics Analyst $76,956 $37.00 4 16 26 No 3 1 2 NE C-Plains
4345 7/4/13 Forensics Analyst $87,480 $42.06 6 16 26 No 1 1 1 NE C-Plains
4394 5/6/18 Forensics Analyst $89,197 $42.88 2 14 21 No 3 1 2 NE C-Plains
4480 1/4/14 Forensics Analyst $101,709 $48.90 6 16 24 No 4 1 1 NE C-Plains
4519 5/29/18 Forensics Analyst $128,901 $61.97 2 14 26 No 3 1 2 NE C-Plains
4544 8/15/18 Forensics Analyst $69,935 $33.62 1 16 22 No 1 1 2 NE C-Plains
4709 10/4/12 Forensics Analyst $143,063 $68.78 7 16 31 No 1 1 2 NE C-Plains
4714 8/24/15 Forensics Analyst $94,700 $45.53 4 14 35 No 1 1 2 NE C-Plains
4786 8/6/11 Forensics Analyst $154,933 $74.49 8 16 31 No 1 1 1 NE C-Plains
4806 5/4/11 Forensics Analyst $116,208 $55.87 9 16 32 No 1 1 1 NE C-Plains
4837 2/6/14 Forensics Analyst $62,836 $30.21 6 16 42 No 3 1 1 NE C-Plains
4907 2/6/19 Forensics Analyst $50,421 $24.24 1 16 26 No 3 2 2 NE C-Plains
4346 9/4/06 Investigator $100,314 $48.23 13 16 51 Yes 3 1 1 NE C-Plains
4450 1/12/06 Investigator $90,794 $43.65 14 16 39 Yes 3 1 1 NE C-Plains
4611 7/17/02 Investigator $132,142 $63.53 17 14 53 Yes 3 1 1 NE C-Plains
4183 10/29/14 IT Staff $65,126 $31.31 5 16 38 No 1 1 1 NE C-Plains
4429 1/28/10 IT Staff $68,647 $33.00 10 14 50 No 3 1 1 NE C-Plains
4617 9/20/06 IT Staff $87,407 $42.02 13 14 51 Yes 1 1 1 NE C-Plains
4769 9/15/14 IT Staff $71,311 $34.28 5 14 37 No 3 1 1 NE C-Plains
4498 12/4/11 Malware Reverse Engineer $82,319 $39.58 8 19 40 No 3 1 1 NE C-Plains
4620 4/29/11 Malware Reverse Engineer $178,456 $85.80 9 16 34 No 3 1 1 NE C-Plains
4759 10/11/13 Malware Reverse Engineer $67,624 $32.51 6 16 37 No 3 2 1 NE C-Plains
4830 8/3/17 Malware Reverse Engineer $91,748 $44.11 2 16 36 No 3 1 2 NE C-Plains
4971 1/24/04 Marketing $76,702 $36.88 16 14 48 Yes 3 2 1 NE C-Plains
4045 6/7/16 Physical Security $32,367 $15.56 4 12 25 No 3 2 2 NE C-Plains
4668 5/21/13 Physical Security $43,367 $20.85 7 16 29 No 3 1 2 NE C-Plains
4841 1/8/13 Physical Security $61,121 $29.39 7 16 44 No 3 1 1 NE C-Plains
4982 1/19/18 Physical Security $74,512 $35.82 2 14 24 No 1 2 1 NE C-Plains
4155 7/16/01 Public and Business Office Team $89,522 $43.04 18 19 68 Yes 3 1 1 NE C-Plains
4212 4/4/19 Public and Business Office Team $61,068 $29.36 1 16 37 No 3 1 1 NE C-Plains
4343 12/29/17 Public and Business Office Team $96,327 $46.31 2 16 40 No 4 1 1 NE C-Plains
4440 7/21/14 Public and Business Office Team $111,794 $53.75 5 19 45 No 1 1 2 NE C-Plains
4484 4/18/18 Quality Assurance $111,424 $53.57 2 16 35 No 3 1 1 NE C-Plains
4904 12/19/13 Quality Assurance $139,515 $67.07 6 16 52 No 1 2 1 NE C-Plains
4027 8/19/06 Sr Cyber Investigator $71,914

13 16 51 Yes 1 1 1 NE C-Plains
4359 11/26/06 Sr Cyber Investigator $76,864 $36.95 13 19 53 Yes 3 1 1 NE C-Plains
4458 12/15/06 Sr Cyber Investigator $156,750 $75.36 13 16 61 Yes 1 1 2 NE C-Plains
4572 10/6/10 Sr Cyber Investigator $92,079 $44.27 9 19 40 No 3 1 1 NE C-Plains
4683 5/6/11 Sr Cyber Investigator $58,294 $28.03 9 19 40 No 4 1 1 NE C-Plains
4943 12/5/17 Sr Cyber Investigator $77,443 $37.23 2 16 33 No 3 1 1 NE C-Plains
4301 11/7/13 Sr Forensics Mgr $96,582 $46.43 6 19 40 No 1 1 1 NE C-Plains
4424 2/23/16 Sr Public and Business Office Team Mgr $107,153 $51.52 4 16 51 No 3 2 1 NE C-Plains

98

4393 9/2/15 Admin $108,058 $51.95 4 16 37 No 4 1 2 IL Midwest
4214 5/9/13 Advertising $145,776 $70.08 7 19 30 No 3 2 2 IL Midwest
4885 8/25/02 Advertising $144,571 $69.51 17 16 39 Yes 3 1 1 IL Midwest
4727 9/7/12 CFO $122,391 $58.84 7 16 48 No 4 1 2 IL Midwest
4436 10/5/04 Controller $71,727 $34.48 15 19 50 Yes 3 2 1 IL Midwest
4386 7/19/08 COO $154,933 $74.49 11 19 43 Yes 3 1 2 IL Midwest

7/13/02 Cyber Analyst

$53.75 17 16 60 Yes 3 1 1 IL Midwest
4013 12/29/11 Cyber Analyst

8 19 44 No 3 1 1 IL Midwest
4029 6/5/11 Cyber Analyst $152,446 $73.29 9 14 36 No 4 1 2 IL Midwest
4068 7/15/03 Cyber Analyst $145,776 $70.08 16 16 59 Yes 3 1 1 IL Midwest
4082 7/2/15 Cyber Analyst $82,411

4 16 37 No 3 1 1 IL Midwest
4090 11/15/15 Cyber Analyst

$42.14 4 14 33 No 4 1 2 IL Midwest
4097 2/26/07 Cyber Analyst $162,731 $78.24 13 16 53 Yes 1 1 2 IL Midwest
4119 8/31/16 Cyber Analyst $86,384 $41.53 3 16 26 No 3 1 2 IL Midwest
4122 8/4/14 Cyber Analyst $86,147 $41.42 5 16 39 No 2 1 1 IL Midwest
4139 2/20/14 Cyber Analyst $87,056 $41.85 6 16 41 No 3 1 1 IL Midwest
4147 9/30/17 Cyber Analyst $122,352 $58.82 2 16 28 No 3 2 2 IL Midwest
4163 9/11/14 Cyber Analyst $74,419 $35.78 5 14 38 No 1 1 1 IL Midwest
4176 11/23/17 Cyber Analyst $135,533 $65.16 2 14 28 No 3 1 1 IL Midwest
4181 7/15/03 Cyber Analyst $123,391 $59.32 16 12 59 Yes 3 1 1 IL Midwest
4204 12/14/13 Cyber Analyst $61,212 $29.43 6 14 43 No 1 1 1 IL Midwest
4205 11/26/14 Cyber Analyst $106,640 $51.27 5 14 40 No 4 2 1 IL Midwest
4218 11/30/06 Cyber Analyst $99,130 $47.66 13 14 50 Yes 3 1 1 IL Midwest
4232 4/9/13 Cyber Analyst $86,787 $41.72 7 16 34 No 1 2 1 IL Midwest
4258 1/24/13 Cyber Analyst $58,540 $28.14 7 14 44 No 1 1 1 IL Midwest
4260 9/19/15 Cyber Analyst $88,743 $42.66 4 14 27 No 3 1 2 IL Midwest
4285 3/30/11 Cyber Analyst $80,909 $38.90 9 16 40 No 1 1 1 IL Midwest
4291 12/25/15 Cyber Analyst $66,938 $32.18 4 16 39 No 3 1 1 IL Midwest
4311 12/13/15 Cyber Analyst $92,847 $44.64 4 16 31 No 3 1 1 IL Midwest
4314 12/28/05 Cyber Analyst $98,771 $47.49 14 19 59 Yes 1 1 1 IL Midwest
4377 2/12/08 Cyber Analyst $151,523 $72.85 12 16 56 Yes 1 1 1 IL Midwest
4381 12/29/11 Cyber Analyst $112,223 $53.95 8 16 44 No 3 1 1 IL Midwest
4409 5/1/12 Cyber Analyst $112,402 $54.04 8 14 41 No 2 1 1 IL Midwest
4441 8/5/12 Cyber Analyst $80,198 $38.56 7 16 37 No 1 1 1 IL Midwest
4457 8/13/17 Cyber Analyst $102,913 $49.48 2 16 25 No 1 2 2 IL Midwest
4459 5/22/09 Cyber Analyst $115,580 $55.57 11 16 54 Yes 1 1 1 IL Midwest
4535 6/14/06 Cyber Analyst $110,708 $53.23 14 16 55 Yes 3 1 1 IL Midwest
4565 6/13/04 Cyber Analyst $79,584 $38.26 16 14 55 Yes 3 1 1 IL Midwest
4566 9/28/01 Cyber Analyst $87,517 $42.08 18 14 57 Yes 3 1 1 IL Midwest
4571 7/12/11 Cyber Analyst $75,261 $36.18 8 12 43 No 3 1 1 IL Midwest
4576 10/30/10 Cyber Analyst $92,931 $44.68 9 16 51 No 3 1 1 IL Midwest
4597 12/17/15 Cyber Analyst $158,066 $75.99 4 16 28 No 4 1 1 IL Midwest
4621 12/1/18 Cyber Analyst $81,730 $39.29 1 16 27 No 3 2 1 IL Midwest
4665 8/16/13 Cyber Analyst $115,283 $55.42 6 14 37 No 1 1 1 IL Midwest
4695 1/31/15 Cyber Analyst $88,743 $42.66 5 19 33 No 2 2 2 IL Midwest
4742 4/21/08 Cyber Analyst $90,599 $43.56 12 16 50 Yes 1 1 1 IL Midwest
4811 4/22/10 Cyber Analyst $74,814 $35.97 10 19 42 No 2 1 1 IL Midwest
4840 2/1/14 Cyber Analyst $87,054 $41.85 6 14 34 No 2 1 1 IL Midwest
4872 1/19/12 Cyber Analyst $68,762 $33.06 8 16 43 No 4 2 1 IL Midwest
4876 1/11/17 Cyber Analyst $139,377 $67.01 3 16 27 No 3 1 2 IL Midwest
4882 3/30/11 Cyber Analyst $81,276 $39.08 9 14 44 No 3 1 1 IL Midwest
4902 9/5/11 Cyber Analyst $82,016 $39.43 8 16 44 No 3 1 1 IL Midwest
4913 6/13/17 Cyber Analyst $71,851 $34.54 3 14 25 No 4 1 2 IL Midwest
4915 10/25/11 Cyber Analyst $132,230 $63.57 8 19 31 No 1 1 1 IL Midwest
4919 1/29/13 Cyber Analyst $125,367 $60.27 7 16 35 No 3 1 2 IL Midwest
4931 9/1/16 Cyber Analyst $161,867 $77.82 3 16 26 No 3 1 2 IL Midwest
4944 6/17/17 Cyber Analyst $143,005 $68.75 3 14 25 No 4 2 2 IL Midwest
4981 2/2/10 Cyber Analyst $117,692 $56.58 10 14 43 No 1 1 2 IL Midwest
4998 9/25/10 Cyber Analyst $75,969 $36.52 9 14 37 No 3 1 2 IL Midwest
4368 2/24/18 Cyber Mgr $79,063 $38.01 2 14 40 No 3 2 1 IL Midwest
4482 7/20/01 Cyber Mgr $77,247 $37.14 18 14 48 Yes 4 2 1 IL Midwest
4834 4/24/19 Cyber Mgr $100,198 $48.17 1 16 34 No 1 2 1 IL Midwest
4906 11/20/10 Cyber Mgr $186,925 $89.87 9 16 39 No 1 1 1 IL Midwest
4411 9/25/14 Cyber Software Engineer $95,128 $45.73 5 19 42 No 3 2 1 IL Midwest
4471 5/15/18 Cyber Software Engineer $164,033 $78.86 2 14 30 No 3 1 1 IL Midwest
4619 9/30/12 Cyber Software Engineer $83,424 $40.11 7 16 44 No 3 2 1 IL Midwest
4014 10/2/11 Forensics Analyst

$60.17 8 19 31 No 1 1 1 IL Midwest
4075 10/2/16 Forensics Analyst $75,053 $36.08 3 14 25 No 3 1 2 IL Midwest
4198 6/5/17 Forensics Analyst $73,447 $35.31 3 14 27 No 3 1 2 IL Midwest
4247 11/23/19 Forensics Analyst $105,069 $50.51 0 16 21 No 1 1 2 IL Midwest
4319 12/3/13 Forensics Analyst $63,933 $30.74 6 19 34 No 3 1 2 IL Midwest
4361 6/10/11 Forensics Analyst $87,601 $42.12 9 16 30 No 4 1 1 IL Midwest
4438 11/18/09 Forensics Analyst $54,060 $25.99 10 16 32 Yes 3 2 2 IL Midwest
4474 9/26/13 Forensics Analyst $113,023 $54.34 6 16 28 No 3 1 2 IL Midwest
4653 9/13/12 Forensics Analyst $91,131 $43.81 7 19 30 No 3 1 1 IL Midwest
4660 9/9/12 Forensics Analyst $120,986 $58.17 7 19 29 No 4 1 1 IL Midwest
4809 11/6/10 Forensics Analyst $99,135 $47.66 9 14 35 No 3 1 1 IL Midwest
4958 7/17/13 Forensics Analyst $162,030 $77.90 6 12 31 No 4 1 2 IL Midwest
4239 1/6/17 Investigator $78,985 $37.97 3 16 33 No 3 1 2 IL Midwest
4279 11/3/17 Investigator $95,220 $45.78 2 19 31 No 2 1 1 IL Midwest
4592 10/6/09 Investigator $133,138 $64.01 10 16 33 Yes 3 2 1 IL Midwest
4630 10/13/07 Investigator $61,779 $29.70 12 16 34 Yes 1 1 1 IL Midwest
4118 8/13/17 IT Mgr $154,933 $74.49 2 16 24 No 3 1 1 IL Midwest

7/10/11 IT Staff $57,727 $27.75 8 16 51 No 3 1 1 IL Midwest
4208 2/15/16 IT Staff $61,383 $29.51 4 14 26 No 3 1 1 IL Midwest
4237 11/2/14 IT Staff $95,957 $46.13 5 16 41 No 3 2 1 IL Midwest
4780 8/2/02 IT Staff $62,747 $30.17 17 19 52 Yes 3 1 1 IL Midwest
4790 6/11/13 IT Staff $141,110 $67.84 7 16 36 No 3 1 1 IL Midwest
4421 2/12/15 Logistics $64,201 $30.87 5 16 34 No 3 1 1 IL Midwest
4766 9/23/15 Logistics $84,076 $40.42 4 19 36 No 3 2 1 IL Midwest
4337 10/11/15 Logistics Mgr $64,200 $30.87 4 16 53 No 1 1 1 IL Midwest
4221 7/10/11 Malware reverse engineer $74,000 $35.58 8 19 40 No 3 2 2 IL Midwest
4253 11/18/13 Malware reverse engineer $86,377 $41.53 6 14 40 No 1 1 2 IL Midwest
4385 9/25/08 Malware Reverse Engineer $74,039 $35.60 11 19 49 Yes 3 1 2 IL Midwest
4626 8/19/14 Malware Reverse Engineer $55,720 $26.79 5 16 34 No 3 1 2 IL Midwest
4687 8/25/18 Malware Reverse Engineer $87,583 $42.11 1 14 39 No 2 1 2 IL Midwest
4843 6/23/16 Malware Reverse Engineer $86,199 $41.44 4 16 27 No 4 2 2 IL Midwest
4992 4/20/15 Malware Reverse Engineer $99,821 $47.99 5 12 36 No 3 2 2 IL Midwest
4302 3/8/17 Marketing $87,519 $42.08 3 16 37 No 3 2 1 IL Midwest
4771 12/1/13 Marketing $159,215 $76.55 6 19 40 No 1 1 1 IL Midwest
4150 9/6/17 Physical Security $33,367 $16.04 2 12 22 No 1 1 1 IL Midwest
4442 11/10/11 Physical Security $72,536 $34.87 8 14 39 No 1 2 1 IL Midwest
4507 8/11/16 Physical Security $55,542 $26.70 3 14 30 No 2 2 1 IL Midwest
4532 2/10/16 Physical Security $43,367 $20.85 4 16 34 No 3 1 1 IL Midwest
4554 1/22/18 Physical Security $43,962 $21.14 2 12 22 No 3 2 2 IL Midwest
4677 11/11/14 Physical Security $43,367 $20.85 5 16 33 No 3 1 1 IL Midwest
4088 7/18/17 Public and Business Office Team $108,342 $52.09 2 16 34 No 3 2 1 IL Midwest
4106 5/7/17 Public and Business Office Team $150,263 $72.24 3 16 57 No 3 1 1 IL Midwest
4324 6/4/11 Public and Business Office Team $87,409 $42.02 9 14 58 No 4 1 1 IL Midwest
4435 6/17/17 Public and Business Office Team $141,110 $67.84 3 16 37 No 1 2 1 IL Midwest
4675 8/10/13 Quality Assurance $101,360 $48.73 6 16 40 No 3 1 1 IL Midwest
4740 11/1/16 Quality Assurance $77,495 $37.26 3 16 45 No 3 2 2 IL Midwest
4316 10/7/17 Sr Cyber Analyst $149,466 $71.86 2 16 31 No 4 1 1 IL Midwest
4782 4/6/19 Sr Cyber Analyst $154,122 $74.10 1 19 33 No 1 1 2 IL Midwest
4000

Sr Cyber Investigator

5 19 35 No 3 1 1 IL Midwest
4060 2/1/12 Sr Cyber Investigator

8 19 42 No 3 1 1 IL Midwest
4120 8/30/13 Sr Cyber Investigator $127,190 $61.15 6 16 34 No 3 1 1 IL Midwest
4144 12/4/17 Sr Cyber Investigator $96,062 $46.18 2 16 31 No 4 2 1 IL Midwest
4307 8/27/07 Sr Cyber Investigator $73,807 $35.48 12 16 46 Yes 3 1 2 IL Midwest
4406 6/10/13 Sr Cyber Investigator $116,075 $55.81 7 19 37 No 1 1 2 IL Midwest
4468 1/10/17 Sr Cyber Investigator $163,045 $78.39 3 16 33 No 1 1 1 IL Midwest
4522 12/10/15 Sr Cyber Investigator $85,442 $41.08 4 19 38 No 1 2 1 IL Midwest
4911 5/29/06 Sr Cyber Investigator $92,076 $44.27 14 14 47 Yes 2 1 1 IL Midwest
4591 1/4/16 Sr Forensics Mgr $109,128 $52.47 4 16 48 No 3 1 1 IL Midwest
4186 3/9/18 Sr Public and Business Office Team Mgr $172,291 $82.83 2 16 57 No 1 1 1 IL Midwest

125

4134 6/30/17 Acctg/Fin $98,007 $47.12 3 19 28 No 1 1 2 PA Northeast
4169 3/14/14 Acctg/Fin $65,100 $31.30 6 14 40 No 3 2 1 PA Northeast
4733 8/9/12 Acctg/Fin $80,666 $38.78 7 16 44 No 3 1 1 PA Northeast
4817 7/4/17 Acctg/Fin $84,270 $40.51 2 16 30 No 3 1 1 PA Northeast
4901 6/12/11 Acctg/Fin $154,122 $74.10 9 12 49 No 3 2 2 PA Northeast
4272 7/18/14 Admin $78,873 $37.92 5 12 36 No 1 2 2 PA Northeast
4734 10/21/16 Admin $87,047 $41.85 3 14 25 No 3 2 2 PA Northeast
4396 12/10/12 Advertising $101,341 $48.72 7 14 39 No 3 2 2 PA Northeast
4879 7/13/02 Advertising $106,600 $51.25 17 16 60 Yes 3 1 1 PA Northeast
4418 7/11/04 CEO $239,315 $115.06 15 19 58 Yes 3 1 1 PA Northeast
4015 1/1/12 Cyber Analyst

8 16 40 No 3 1 2 PA Northeast
4020 5/9/11 Cyber Analyst

$44.96 9 14 39 No 1 1 1 PA Northeast

Cyber Analyst $69,529 $33.43 16 16 53 Yes 3 1 1 PA Northeast
4038 4/14/12 Cyber Analyst

$31.05 8 16 40 No 1 1 1 PA Northeast
4039 5/30/13 Cyber Analyst

$44.12 7 16 30 No 3 1 2 PA Northeast
4046 9/4/06 Cyber Analyst $115,974

13 16 54 Yes 1 1 1 PA Northeast
4061 2/28/12 Cyber Analyst $154,933 $74.49 8 16 34 No 3 1 2 PA Northeast
4064 1/18/16 Cyber Analyst $144,571 $69.51 4 16 36 No 4 1 2 PA Northeast
4078 7/15/09 Cyber Analyst $83,851 $40.31 10 16 51 Yes 1 1 1 PA Northeast
4086 9/18/07 Cyber Analyst $114,721 $55.15 12 14 51 Yes 3 1 1 PA Northeast
4095 12/31/04 Cyber Analyst $133,678 $64.27 15 16 52 Yes 3 1 1 PA Northeast
4107 11/5/13 Cyber Analyst $78,334 $37.66 6 19 34 No 3 1 1 PA Northeast
4128 5/16/03 Cyber Analyst $126,426 $60.78 17 14 56 Yes 3 1 1 PA Northeast

12/4/11 Cyber Analyst $104,961 $50.46 8 16 41 No 1 1 1 PA Northeast
4220 9/17/06 Cyber Analyst $164,033 $78.86 13 16 54 Yes 3 1 1 PA Northeast
4287 2/5/14 Cyber Analyst $63,777 $30.66 6 14 35 No 3 1 2 PA Northeast
4300 7/10/18 Cyber Analyst $108,866 $52.34 1 16 27 No 1 2 1 PA Northeast
4305 7/27/16 Cyber Analyst $78,015 $37.51 3 16 31 No 3 1 1 PA Northeast
4310 1/21/11 Cyber Analyst $108,326 $52.08 9 19 41 No 3 1 1 PA Northeast
4329 6/21/10 Cyber Analyst $119,537 $57.47 10 19 47 No 4 1 2 PA Northeast
4332 9/28/04 Cyber Analyst $91,507 $43.99 15 19 53 Yes 3 1 1 PA Northeast
4342 7/13/11 Cyber Analyst $156,750 $75.36 8 16 38 No 4 1 1 PA Northeast
4397 5/20/13 Cyber Analyst $84,175 $40.47 7 16 37 No 3 1 1 PA Northeast
4407 11/20/08 Cyber Analyst $73,005 $35.10 11 14 43 Yes 3 1 1 PA Northeast
4410 6/20/15 Cyber Analyst $68,222 $32.80 5 19 29 No 3 1 2 PA Northeast
4419 12/17/06 Cyber Analyst $70,237 $33.77 13 16 57 Yes 2 1 1 PA Northeast
4428 2/6/10 Cyber Analyst $73,640 $35.40 10 16 45 No 3 1 1 PA Northeast
4461 11/16/05 Cyber Analyst $75,074 $36.09 14 19 58 Yes 1 1 1 PA Northeast
4465 10/13/13 Cyber Analyst $83,367 $40.08 6 16 37 No 1 1 2 PA Northeast
4466 6/2/07 Cyber Analyst $94,876 $45.61 13 16 48 Yes 3 1 1 PA Northeast
4515 6/13/09 Cyber Analyst $89,165 $42.87 11 19 49 Yes 3 2 1 PA Northeast
4543 10/20/12 Cyber Analyst $148,111 $71.21 7 14 33 No 3 1 1 PA Northeast
4558 1/31/11 Cyber Analyst $85,256 $40.99 9 16 41 No 3 1 1 PA Northeast
4580 7/16/01 Cyber Analyst $186,670 $89.75 18 16 60 Yes 1 1 2 PA Northeast
4587 6/24/08 Cyber Analyst $76,499 $36.78 12 14 46 Yes 1 1 1 PA Northeast
4589 7/11/03 Cyber Analyst $70,358 $33.83 16 14 55 Yes 3 1 1 PA Northeast
4593 1/20/12 Cyber Analyst $86,597 $41.63 8 14 44 No 1 1 1 PA Northeast
4594 5/3/14 Cyber Analyst $78,529 $37.75 6 16 44 No 1 1 1 PA Northeast
4661 8/29/15 Cyber Analyst $117,062 $56.28 4 16 27 No 3 1 1 PA Northeast
4690 6/27/12 Cyber Analyst $82,471 $39.65 8 16 39 No 3 1 2 PA Northeast
4694 11/16/15 Cyber Analyst $101,016 $48.57 4 16 35 No 4 1 2 PA Northeast
4696 8/26/17 Cyber Analyst $128,825 $61.94 2 16 25 No 3 1 2 PA Northeast
4712 2/25/14 Cyber Analyst $97,323 $46.79 6 14 34 No 1 2 1 PA Northeast
4717 12/19/09 Cyber Analyst $82,601 $39.71 10 19 41 Yes 1 1 1 PA Northeast
4719 9/1/06 Cyber Analyst $98,234 $47.23 13 16 58 Yes 3 1 1 PA Northeast
4731 10/12/12 Cyber Analyst $83,430 $40.11 7 16 38 No 3 1 1 PA Northeast
4746 10/4/12 Cyber Analyst $84,679 $40.71 7 19 35 No 3 1 1 PA Northeast
4761 1/17/15 Cyber Analyst $162,731 $78.24 5 16 32 No 1 1 1 PA Northeast
4813 6/20/08 Cyber Analyst $127,890 $61.49 12 12 47 Yes 3 1 1 PA Northeast
4845 5/23/11 Cyber Analyst $149,466 $71.86 9 16 42 No 3 1 1 PA Northeast
4854 11/8/14 Cyber Analyst $149,466 $71.86 5 19 30 No 3 1 1 PA Northeast
4860 5/5/06 Cyber Analyst $75,179 $36.14 14 14 49 Yes 1 2 2 PA Northeast
4918 5/15/11 Cyber Analyst $143,005 $68.75 9 19 36 No 3 1 1 PA Northeast
4947 6/21/13 Cyber Analyst $121,455 $58.39 7 16 40 No 1 1 1 PA Northeast
4950 10/18/17 Cyber Analyst $118,997 $57.21 2 14 25 No 1 1 1 PA Northeast
4957 3/2/09 Cyber Analyst $110,877 $53.31 11 19 50 Yes 3 1 1 PA Northeast
4960 4/10/13 Cyber Analyst $84,275 $40.52 7 16 41 No 3 1 1 PA Northeast
4961 1/25/05 Cyber Analyst $117,214 $56.35 15 16 54 Yes 2 1 1 PA Northeast
4965 2/27/12 Cyber Analyst $163,045 $78.39 8 16 50 No 1 1 1 PA Northeast
4025 12/12/14 Cyber Mgr $151,174 $72.68 5 16 38 No 3 1 1 PA Northeast
4257 7/11/03 Cyber Mgr $104,220 $50.11 16 19 51 Yes 3 2 1 PA Northeast
4700 10/7/14 Cyber Mgr $63,946 $30.74 5 19 42 No 3 2 1 PA Northeast
4031 10/20/13 Cyber Software Engineer $78,869 $37.92 6 16 39 No 3 1 1 PA Northeast
4089 10/16/16 Cyber Software Engineer $81,050 $38.97 3 16 36 No 3 1 1 PA Northeast
4303 1/19/18 Cyber Software Engineer $113,246 $54.45 2 19 34 No 2 1 1 PA Northeast
4334 12/28/10 Cyber Software Engineer $103,736 $49.87 9 19 56 No 3 1 1 PA Northeast
4352 7/4/16 Cyber Software Engineer $50,377 $24.22 3 12 31 No 2 1 1 PA Northeast
4656 12/29/17 Cyber Software Engineer $151,174 $72.68 2 16 40 No 3 2 1 PA Northeast
4671 1/13/15 Cyber Software Engineer $105,637 $50.79 5 19 44 No 3 1 1 PA Northeast
4757 10/15/14 Cyber Software Engineer $112,994 $54.32 5 16 38 No 3 1 1 PA Northeast
4784 5/12/12 Cyber Software Engineer $102,238 $49.15 8 16 45 No 3 1 1 PA Northeast
4818 12/29/16 Cyber Software Engineer $64,458 $30.99 3 16 29 No 2 2 2 PA Northeast
4842 7/11/04 Cyber Software Engineer $60,802 $29.23 15 16 59 Yes 3 1 1 PA Northeast
4541 12/2/09 Eng Mgr $170,954 $82.19 10 12 49 Yes 3 1 2 PA Northeast

Forensics Analyst

1 16 23 No 1 2 2 PA Northeast
4037 9/13/13 Forensics Analyst $67,866

6 14 25 No 3 1 2 PA Northeast
4070 4/4/17 Forensics Analyst $80,191 $38.55 3 16 28 No 1 1 1 PA Northeast
4092 7/7/08 Forensics Analyst $98,943 $47.57 11 16 36 Yes 3 1 1 PA Northeast
4133 5/29/12 Forensics Analyst

$57.29 8 16 31 No 4 1 1 PA Northeast
4252 3/23/16 Forensics Analyst $97,885 $47.06 4 16 28 No 1 1 1 PA Northeast
4259 9/4/04 Forensics Analyst $106,267 $51.09 15 16 40 Yes 3 1 1 PA Northeast
4284 12/16/10 Forensics Analyst $143,063 $68.78 9 14 36 No 1 1 1 PA Northeast
4604 11/10/11 Forensics Analyst $71,671 $34.46 8 16 31 No 1 1 1 PA Northeast
4748 10/19/12 Forensics Analyst $75,612 $36.35 7 16 31 No 3 1 1 PA Northeast
4825 9/5/16 Forensics Analyst $78,900 $37.93 3 12 26 No 3 1 2 PA Northeast
4880 9/13/11 Forensics Analyst $95,662 $45.99 8 14 31 No 1 2 1 PA Northeast
4946 2/21/15 Forensics Analyst $72,352 $34.78 5 16 29 No 4 1 2 PA Northeast
4953 1/5/16 Forensics Analyst $114,854 $55.22 4 14 26 No 3 1 2 PA Northeast
4972 7/27/07 Forensics Analyst $151,523 $72.85 12 16 34 Yes 3 1 2 PA Northeast
4497 10/28/12 Investigator $68,012 $32.70 7 16 36 No 4 2 1 PA Northeast
4500 12/5/13 IT Mgr $113,056 $54.35 6 19 56 No 3 1 1 PA Northeast
4034

IT Staff $90,930 $43.72 14 19 45 Yes 3 1 1 PA Northeast
4055 6/17/18 IT Staff $99,786 $47.97 2 14 31 No 1 2 2 PA Northeast
4401 8/25/03 IT Staff $76,305 $36.69 16 16 55 Yes 1 1 1 PA Northeast
4413 12/21/16 IT Staff $95,622 $45.97 3 19 36 No 2 1 1 PA Northeast
4563 3/16/16 IT Staff $62,319 $29.96 4 16 28 No 3 1 1 PA Northeast
4567 11/6/07 IT Staff $71,747 $34.49 12 16 46 Yes 2 1 1 PA Northeast
4705 8/21/13 IT Staff $80,045 $38.48 6 14 43 No 1 1 1 PA Northeast
4723 10/8/11 IT Staff $75,270 $36.19 8 19 35 No 3 1 1 PA Northeast
4864 1/26/18 IT Staff $69,665 $33.49 2 16 24 No 2 2 1 PA Northeast

7/21/08 Logistics $71,690 $34.47 11 16 51 Yes 3 2 1 PA Northeast
4298 8/28/07 Logistics $83,294 $40.05 12 16 49 Yes 3 1 2 PA Northeast
4467 8/11/14 Logistics $43,367 $20.85 5 16 38 No 3 2 1 PA Northeast
4067 10/29/12 Malware Reverse Engineer

$60.09 7 16 49 No 2 1 2 PA Northeast
4238 6/24/18 Malware Reverse Engineer $101,386 $48.74 2 16 27 No 1 1 2 PA Northeast
4327 1/29/12 Malware Reverse Engineer $68,226 $32.80 8 16 54 No 3 1 1 PA Northeast
4792 7/11/03 Malware Reverse Engineer $131,698 $63.32 16 14 63 Yes 3 1 1 PA Northeast
4932 2/2/14 Malware Reverse Engineer $128,943 $61.99 6 14 49 No 3 1 1 PA Northeast
4648 7/7/17 Marketing $115,966 $55.75 2 16 42 No 3 2 1 PA Northeast
4897 10/24/07 Marketing $108,604 $52.21 12 19 47 Yes 3 2 1 PA Northeast
4189 4/24/11 Physical Security $53,669 $25.80 9 14 42 No 1 2 1 PA Northeast
4313 11/11/10 Physical Security $39,808 $19.14 9 16 46 No 1 1 1 PA Northeast
4530 5/1/17 Physical Security $72,946 $35.07 3 14 24 No 1 2 2 PA Northeast
4693 10/2/15 Physical Security $75,920 $36.50 4 14 30 No 3 2 1 PA Northeast
4713 2/13/14 Physical Security $86,666 $41.67 6 12 27 No 1 1 2 PA Northeast
4794 5/3/13 Physical Security $67,987 $32.69 7 16 34 No 3 2 1 PA Northeast
4826 1/7/12 Physical Security $64,797 $31.15 8 14 45 No 3 2 1 PA Northeast
4846 10/10/13 Physical Security $87,943 $42.28 6 12 29 No 1 1 1 PA Northeast
4387 8/20/15 Public and Business Office Team $91,444 $43.96 4 19 61 No 4 1 1 PA Northeast
4388 10/16/14 Public and Business Office Team $119,156 $57.29 5 16 41 No 3 1 1 PA Northeast
4395 1/4/18 Public and Business Office Team $71,697 $34.47 2 14 32 No 3 1 1 PA Northeast
4460 11/28/18 Public and Business Office Team $154,122 $74.10 1 14 35 No 3 1 2 PA Northeast
4768 5/3/13 Public and Business Office Team $114,251 $54.93 7 14 44 No 2 2 1 PA Northeast
4855 4/2/15 Public and Business Office Team $96,338 $46.32 5 16 42 No 3 2 1 PA Northeast
4382 4/29/12 Public and Business Office Team Mgr $79,591 $38.26 8 12 47 No 3 1 1 PA Northeast
4225 8/1/04 Quality Assurance $63,125 $30.35 15 16 54 Yes 3 1 1 PA Northeast
4177 3/26/12 Sr Cyber Investigator $82,515 $39.67 8 16 39 No 1 1 2 PA Northeast
4193 10/27/15 Sr Cyber Investigator $125,004 $60.10 4 16 32 No 1 2 1 PA Northeast
4249 8/17/07 Sr Cyber Investigator $107,496 $51.68 12 16 43 Yes 1 1 1 PA Northeast
4271 8/5/11 Sr Cyber Investigator $72,213 $34.72 8 16 41 No 3 1 1 PA Northeast
4595 11/29/09 Sr Cyber Investigator $96,566 $46.43 10 19 46 Yes 3 1 1 PA Northeast
4598 7/20/01 Sr Cyber Investigator $81,287 $39.08 18 16 65 Yes 3 1 1 PA Northeast
4636 7/7/04 Sr Cyber Investigator $75,293 $36.20 15 16 57 Yes 3 2 1 PA Northeast
4639 3/12/13 Sr Cyber Investigator $152,446 $73.29 7 16 37 No 3 1 1 PA Northeast
4680 6/18/09 Sr Cyber Investigator $84,713 $40.73 11 16 39 Yes 4 1 1 PA Northeast
4726 1/4/05 Sr Cyber Investigator $134,847 $64.83 15 16 55 Yes 1 1 1 PA Northeast
4823 8/14/03 Sr Cyber Investigator $72,005 $34.62 16 19 61 Yes 1 2 1 PA Northeast
4883 7/31/11 Sr Forensics Mgr $131,580 $63.26 8 14 41 No 3 1 1 PA Northeast
4724 3/8/15 Sr Public and Business Office Team Mgr $103,349 $49.69 5 14 56 No 3 1 2 PA Northeast

149

State Region # %

PA Northeast 149 40.05%
IL Midwest 125 33.60%
NE C-Plains 98 26.34%
TOTAL 372 100.00%

Section 1: Complete all Columns in Data Set
General Count
Vested Yr 12/31/19 Emp #
Region Count
$128,384 $61.72 1/26/10 $95,985 $46.15 $59,219 12/24/16 $34.57
C-Plains Count
4004 $111,801 $100,520 $48.33 $39.62 $87,641 $125,156 4030 4/23/15 $92,267 $44.36 $73,650 $35.41
Midwest Count
$78,475 $37.73 $93,518 4022 5/27/04 $64,580 $91,771 $55.76 4146 4010 11/25/18 $90,688 $43.60 $32.63 $119,165 5/21/06 4104 $124,996
Northeast Count
Grand Count 374

QR Questions_Responses

 Apply Quantitative Reasoning
Now that you have completed your analysis, think about the patterns you have seen in the workforce.
In this final section, you will answer five questions and write a short essay.
1. From the created histogram, it appears that a large share of employees have a salary between $61,000–$110,000 or $131,000–$170,000. This may indicate a reasonable promotion rate for new and seasoned employees. Is this distribution unimodal or bimodal? Please explain.
Histogram indicates the no.of employees falls within specific salry ranges. As indicated by histogram, there are two salary ranges in which most number of emplyees fall. This can create a possibility of best promotional rate and this data is bi-modal.
2. The line chart, as detailed in your “Graph Charts” Excel spreadsheet, shows sales generally increasing over the years, although sales in the first two years were notably lower. Assuming that the sales are linear, please use the Forecast tool to find projected sales for 2020 thru 2024. Hint: An easy way to do this is to highlight the sales from the data page and apply the Forecast tool to this data or use the forecast function in excel. You will generate a chart on a new sheet with projected sales; rename this sheet “Projected Sales”.
Sales forecast has been made on the data sheet worksheet. it is done by using =FORECAST function.
3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, in general, the more narrow the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe your standard deviations of Salary, Hryly Rate, Yrs Worked, Education, and Age. What does this tell you about the variables?
On performing descriptive statistical analysis, we have seen that only salary data has a diversion from mean inspite of all the other data that remained close to the mean.
4. The company has a keen interest in the educational, race, and gender makeup of its workforce. Its emphasis is on a diverse, dynamic workforce. From your “Graph Charts” spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how you would determine if the company was meeting expectations on these characteristics.
As per the pie charts, we seen that
1. Company has 21% of female employees in comparison to Male employees
2. Company has 5%HS level of education, 23% of AA level education, 55% of BA/BS levell eduaction and 17% of MAsters level education.
3. 72% of emplyees are married and 28% of employees are unmarried.
As per the above results we can conclude that company needs improvement to achieve its goals. Statics has shown diversion from achieving objectives.
5. The company is conducting an analysis on how many positions to create to keep up with demand. Specifically, it wants to know an estimate of the number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings.
Upon excel findings we have seen that, the mode of the job roles is Cyber Analyst which has 146 number of position at one time.
FINAL ESSAY:
Now that you have done all the work with data, you will write a short three- to four-paragraph summary of your analysis. This is important. While you have done a wonderful job with your analysis, you can never assume that the end user will be able to interpret the data the way it should be understood. Supporting narrative is helpful. Never simply provide a “raw data” dump. Instead, seek to provide information!
Structure your essay like this:
a. Write a one-paragraph narrative summary of your findings, describing patterns of interest.
b. Provide an explanation of the potential relevance of such patterns.
c. Provide a description of how you would investigate further to determine if your results are “good or bad” for the company.
Prepare your response in this workbook. (Simply expand this text box to accommodate your essay and other answers, or you can copy and paste from another document.)
Final Essay:
In this complete analysis we have prepare some descriptive statistical analysis which includes some statistical tools and graphs and charts. We have perormed on following data
1. Employees by gender
2.Employees by education level.
3. Employees by Marrital Status
4. No. of emnployees by race.
5. No.of employees per state
6. Sales summary
7. Statistical analysis of Salary, Hourly Rate ,Years of Service,Education and Age.
upon above analysis we have concluded that there are only two ranges of salaries where most number of employees falls. The company has most number of male employees. There are most number of graduates emplyees. Mostly emplyees are married. We have forecasted the sales for coming 4 years upto 2024. Statistical summary is expained in the summary statistics portion but we have to say that salary is the only column in which there is a great dispersion of data from its mean. The results of the company are good in my point of view but it can be better if there should be a policy to improve the figures to achieve its goals.

2

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

10

,000 or $1

3

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

4

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

Yr

s Worked,

Ed

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

Yr

/

/

10

Salary

Ed Age Vested

00

/15

7

19

3 1 1

3 1 1 IL

/18

8

16 23 1 2 2

Cyber Analyst

1 1 1

/11

Cyber Analyst

0

19

3 1 1 IL

Forensics Analyst

19 31 1 1 1 IL

Cyber Analyst

5

16 40 3 1 2 PA

Cyber Analyst

8

14

1 1 1 PA

/04

Cyber Analyst

16

3 1 1 PA

,

4

16 28 1 2 2 NE

16 38 3 1 1 PA

16 51 1 1 1 NE

Cyber Analyst

14

4 1 2 IL

,727

16 51 3 1 1 IL

16 39 3 1 1 PA

/06

IT Staff

19

3 1 1 PA

Forensics Analyst

14 25 3 1 2 PA

Cyber Analyst

0

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

16

1 1 1 PA

IT Staff

14 31 1 2 2 PA

Sr Cyber Investigator

19

3 1 1 IL

Cyber Analyst

16 34 3 1 2 PA

Cyber Analyst

16 36 4 1 2 PA

,996

16

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

1

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

IL

NE

TOTAL
Descriptive Statistics Salary Hrly Rate Yrs of Svc Ed Age

s

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+

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.

image

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.

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.

image

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
image

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.

image

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

Categories
All samples
Essay (any type)
Essay (any type)
The Value of a Nursing Degree
Undergrad. (yrs 3-4)
Nursing
2
View this sample

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
image

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.

See How We Helped 9000+ Students Achieve Success

image

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

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
image

Order your essay today and save 30% with the discount code Happy