Quantitative Analysis Project/Apply Quantitative Reasoning.

Quantitative Analysis Project/Apply Quantitative Reasoning.

 

Quantitative Analysis Project/Apply Quantitative Reasoning.

Now that you have completed your analysis, think about the patterns you’ve seen in theworkforce.1. From the histogram, there are two pronounced peaks of salaries. This mayindicate reasonable promotion rate for new employees. Is this distributionunimodal or bimodal?2. The Sales Summary shows sales figure over the years from 1999 to 2014. In2015, sales slightly decreased. Investors want to know what the projected saleswill be in 2017. One method for determining this value is to calculate the averageannual growth rate per year, based on historical trends. For example, if saleswere $200 last year and $500 this year, the average annual growth rate would becalculated as ($500 – $200/$200)/2. Calculate the average annual growth rate for1999 – 2015 and projected sales for 2017.3. The standard deviation provides insight into the distribution of values around themean. If the standard deviation is small, the more narrow the range between thelowest and highest value. That is, values will cluster close to the mean. From yourdescriptive statistics, please describe your standard deviations. What does this tellyou about the variables?4. The company has a keen interest in the educational, race and gender makeup ofits workforce. Their emphasis is on a diverse, dynamic workforce. From your‘Graph Charts’ spreadsheet, please describe your pie chart findings for thesecharacteristics of the workforce. Describe how you would determine how thecompany was meeting expectations on these characteristics.5. The company is conducting an analysis on how many positions to create to keepup with demand. Specifically, it wants to identify a rough estimate of the numberof positions per job title. From your Excel chart, please identify the mode of thejob title distribution. Describe your findings.For your final assignment, write a short three- to four-paragraph summary of youranalysis. This is important. While you have done a wonderful job with your analysis, youcan never assume that the end user will be able to interpret the data the way it shouldbe 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 ofinterest;b. Provide an explanation of the potential relevance of such patterns;c. Provide a description of how you would investigate further to determine if yourresults are “good or bad” for the company.Prepare your response in this workbook. Create a tab for QR Analysis, create a text boxand paste your answers to the above questions in it. Move the tab to the first tabposition.STEP 1 – 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.    As a simple starting point, in cell D9, review the value linked to “Annual Hrs.” This was created in Define a Name under the Formulas. You can review this defined named from the Name Manager under Formulas.  The Annual Hrs is defined as the constant 2080.  This is the number most often used in annual salary calculations based on full time, 40 hours per week, 52 weeks per year.2.    In E11, 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. Complete the calculations for the remainder of Column E.3.    In Column F, calculate the number of years worked for each employee by creating a formula that incorporates cell F9 and demonstrates your understanding of relative and absolute cells in Excel.4.    In Column I, use an IF statement to flag with a “Yes” any employees who have been employed 10 years or more.5.    Using the function VLookup, 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!
STEP 2-USE FUNCTIONS TO SUMMARIZE THE DATAYou are now ready to move into Section 2 to prepare the data for future analysis, to include some 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!

STEP 3-ANALYZE THE WORKFORCE
In this section, you will expand your analysis by employing descriptive statistics or summary statistics to further describe characteristics of the workforce. Your summary table described “how many” and also offered proportions in relation to the entire workforce, but through this analysis, you can describe much more. For each of the following: salary, hourly rate, years of service, education, and age, calculate the: mean, median, mode – average, middle, and most frequent data points in a set.standard deviation – how spread out individual data points are from the mean; if data points vary greatly, the result is a higher standard deviation and vice versa. It is referred to as a “measure of dispersion” calculated as the square root of the variance. (Note: standard deviations – when calculating manually in Excel, you might see a slight difference between the result you get manually and the result you get using the Analysis Toolpak, depending on whether your version of Excel requires you to use the function DSTDEV or STDEV.S). variance – the average squared distance between the mean and each data value. It is also a measure of dispersion, which is used to calculate the standard deviation. It is always nonnegative because the calculated squares are positive or zero. A small variance means that the data points are very close to the mean and to each other; thus, a high variance tells us that the data points are very spread out from the mean and from each other. range – the difference between the highest (MAX) and lowest (MIN) values in a data set.skewness and kurtosis – numerical measures to describe the shape of a data set and how close it is to a normal distribution. Skewness describes how symmetrical the data is around the mean. Kurtosis describes height and sharpness of the central peak (its peakedness or flatness) in comparison to a normal curve.STEP 4-USE THE ANALYSIS TOOLPACK
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? Excel features an add-in to work with statistics as follows:1. First, make sure you have enabled the data analysis toolpak feature.2. Calculate the statistics for salary, hourly rate, years of service, education level, and age. Hint: You can perform these calculations in one step by highlighting the adjacent columns of data in D10:H382. Place the output on a new sheet in the workbook. Label the tab “Excel Summary Stats.”3. 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. How did you do?

STEP 5-CREATE CHARTS AND A HISTOGRAM
It is often helpful to view and interpret analytical results when they are presented visually. Graphs and charts help readers digest and interpret information more 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 the percentage of employees by a) gender, b) education level, and c) marital status. Explore pie chart formats.2. Create separate bar charts that show the a) number of employees by race, and b) 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-$10,000, $10,999-$20,000, up to $210,000. This involves counting how many for each “salary bucket,” creating what is called a frequency distribution table and histogram. Histograms seem hard, but mastering how to visualize the frequency of events is so helpful in analysis! 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 6-COPY AND SORT THE DATAMany 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. In this step you will create Tab5: Sorted Data. See below for example of sorted spreadsheet.
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. How to Copy Excel 2010 Sheet to Another SheetHere are the steps to copy a sheet within a workbook in Excel:1. Find the tab for the sheet you want to copy at the bottom of the screen. 2  Right click on the sheet you want to copy.3  Select “Move or copy.”4  Check the “Create a copy” box towards the bottom of the menu 5. Press ok
STEP 7-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(PLEASE SEE ATTACHMENT FILE #3 FOR THIS DOCUMENT) by answering the questions provided in the resource and writing a short essay.After you answer the questions, your short essay 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 response in this workbook. Create a tab for Quantitative Analysis, create a text box, and paste your answers to above questions and your essay in it. Move the tab to the first tab position.Good job! In the next step, you’ll submit your workbook and analysis.
FINAL STEP-SUBMIT THE COMPLETED WORKBOOK AND ANALYSIS
You’re now ready to submit your 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 o Tab 1: Data – completed data sheet (Steps 1–6 above)o Tab 2: Excel Summary Stats (Step 6)o Tab 3: Graphs – Charts (Step 7)o Tab 4: Histogram (Step 7)o Tab 5: Sorted Data (Step 8)o Quantitative Analysis (Step 9; see detail below and move to first position upon completion.)
2. Quantitative Analysis: Answers to Questions and Short EssayPrepare 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:o Quantitative Analysiso Datao Excel Summary Statso Graphs–Chartso Histogramo Sorted Data
3. Format to Be PrintedFormat this workbook so that all the spreadsheets can be printed.
Before you submit your assignment, review the competencies below, which your instructor will use to evaluate your work. A good practice would be to use each competency as a self-check to confirm you have incorporated all of them in your work.• 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment.• 1.2: Develop coherent paragraphs or points so that each is internally unified and so that each functions as part of the whole document or presentation.• 1.4: Tailor communications to the audience.• 1.5: Use sentence structure appropriate to the task, message and audience.• 1.6: Follow conventions of Standard Written English.• 3.1: Identify numerical or mathematical information that is relevant in a problem or situation.• 3.2: Employ mathematical or statistical operations and data analysis techniques to arrive at a correct or optimal solution.• 3.3: Analyze mathematical or statistical information, or the results of quantitative inquiry and manipulation of data.• 3.4: Employ software applications and analytic tools to analyze, visualize, and present data to inform decision-making.

 

 

Format for: Number Date Text Currency Currency Number Text Number Number Number Number Number Text Text mm/dd/yy Year Ending Vested Yr 12/31/2014 10 Emp # Hire Date Role Salary Hrly Rate Yrs of Svc Ed Age Vested Race Gender Status State Region1001 03/15/99 CEO $290,210 20 56 3 1 2 PA 1002 12/15/99 CIO $279,723 19 45 3 1 2 PA 1003 09/07/12 Sr Cyber Analyst $166,750 17 29 1 1 1 IL 1004 06/13/12 Cyber Analyst $131,924 17 24 3 1 2 NE 1005 10/25/08 Cyber Analyst $142,687 14 35 3 1 1 PA 1006 08/05/06 Cyber Analyst $150,307 14 41 3 1 1 IL 1014 06/03/09 IT Staff $98,818 16 40 4 2 1 IL 1015 07/08/13 Investigator $81,250 14 26 3 1 2 PA 1016 09/23/08 Cyber Analyst $92,719 15 35 3 1 2 NE 1018 01/15/11 Acctg/Fin $72,836 16 32 3 2 2 PA 1018 05/03/12 Cyber Analyst $82,157 15 24 3 2 1 NE 1019 05/21/07 Cyber Analyst $98,317 16 38 3 1 1 NE 1024 08/17/11 Cyber Analyst $83,005 14 26 3 1 1 IL 1036 09/25/00 Cyber Analyst $107,822 16 51 2 1 1 NE 1038 08/21/12 IT Staff $85,451 16 32 2 1 1 PA 1043 06/18/09 Forensics Analyst $76,168 16 27 3 1 1 IL 1048 09/19/13 Physical Security $61,655 12 20 1 2 2 IL 1049 02/23/04 IT Staff $88,421 19 41 3 1 1 PA 1053 05/31/13 Cyber Analyst $80,241 14 20 3 1 2 PA 1053 09/08/09 Cyber Analyst $85,293 14 30 1 1 1 IL 1055 06/15/01 Controller $149,836 19 45 3 2 1 PA 1055 06/04/01 Cyber Analyst $106,663 16 50 3 1 1 PA 1055 9/30/2001 Cyber Analyst $107,385 16 50 1 1 1 IL 1056 05/06/07 Cyber Analyst $98,059 14 38 3 1 1 IL 1059 02/14/12 Acctg/Fin $126,589 16 33 3 2 1 NE 1061 02/02/09 Cyber Analyst $99,931 14 34 1 1 1 NE 1062 03/04/13 Acctg/Fin $112,238 16 28 3 1 2 IL 1062 07/08/09 Cyber Mgr $162,803 16 35 3 1 1 PA 1069 02/03/11 Cyber Software Engineer $179,938 16 35 2 2 1 IL 1070 08/21/09 Cyber Analyst $95,498 14 31 3 1 1 NE 1071 01/09/05 Cyber Software Engineer $166,238 19 41 3 1 1 NE 1071 08/08/05 Cyber Software Engineer $167,019 19 51 3 1 1 IL 1075 01/14/10 Cyber Analyst $84,317 16 28 3 2 1 NE 1079 10/15/03 Investigator $71,459 16 31 3 1 1 PA 1083 08/27/09 Cyber Analyst $85,396 14 31 3 1 2 PA 1083 4/30/2000 Cyber Analyst $108,771 14 52 3 1 1 IL 1084 03/15/99 Public and Business Office Team $135,671 19 62 3 1 1 PA 1088 10/03/11 Sr Forensics Mgr $173,974 16 35 1 2 1 NE 1096 03/06/06 Cyber Analyst $100,502 14 42 3 1 1 NE 1097 08/14/05 Cyber Analyst $110,571 16 43 1 1 1 PA 1098 01/13/14 Cyber Software Engineer $162,245 16 25 3 1 2 PA 1101 06/08/02 Investigator $125,994 16 31 1 1 1 NE 1102 04/08/00 IT Staff $88,900 19 48 3 1 1 PA 1104 02/01/05 Cyber Analyst $112,450 16 44 3 1 1 NE 1105 09/06/12 Investigator $92,633 12 28 3 1 2 NE 1106 5/9/2002 Cyber Analyst $115,744 14 48 1 1 1 IL 1108 06/15/07 Forensics Analyst $127,403 16 29 3 1 2 IL 1109 02/22/07 Cyber Analyst $99,201 14 39 3 1 1 NE 1113 05/02/12 Cyber Analyst $82,124 16 24 1 2 2 PA 1113 09/08/00 Sr Cyber Investigator $151,695 16 50 1 1 1 PA 1116 12/30/08 Cyber Analyst $112,235 16 34 3 1 1 IL 1116 04/05/00 Quality Assurance $111,526 16 52 3 1 1 PA 1117 05/27/09 Forensics Analyst $136,360 18 27 3 2 1 PA 1117 08/15/12 Cyber Analyst $121,262 17 22 2 1 2 IL 1128 06/07/10 Cyber Mgr $174,104 18 35 3 2 1 NE 1130 03/15/99 Cyber Analyst $79,438 16 53 3 1 1 PA 1132 07/10/09 Cyber Analyst $85,822 14 32 3 1 1 PA 1133 02/12/09 Public and Business Office Team $93,337 19 58 4 1 1 PA 1136 12/14/11 Cyber Analyst $82,523 16 24 1 1 2 IL 1138 10/18/10 Forensics Analyst $124,017 14 24 4 2 1 PA 1138 4/12/2008 Cyber Analyst $94,204 16 35 4 1 1 PA 1140 07/10/09 Cyber Analyst $85,934 14 32 2 1 1 IL 1141 06/18/09 Forensics Analyst $75,999 16 24 3 1 1 IL 1142 06/17/09 Cyber Analyst $86,901 14 32 1 1 1 PA 1145 02/16/09 Forensics Analyst $75,131 14 24 2 1 2 IL 1145 11/05/09 Cyber Analyst $74,680 14 29 1 1 2 NE 1145 09/15/04 Cyber Analyst $103,327 16 45 3 1 1 IL 1150 04/26/13 Cyber Analyst $80,808 16 21 1 1 2 IL 1153 02/05/12 Sr Cyber Investigator $154,843 20 30 3 1 1 IL 1156 05/21/11 Cyber Analyst $83,395 16 26 3 1 2 IL 1167 11/15/11 Cyber Analyst $82,766 16 24 3 1 1 PA 1169 01/22/09 Cyber Analyst $90,871 14 34 3 1 1 PA 1175 09/25/02 Cyber Analyst $104,886 16 48 3 1 1 NE 1180 01/24/05 Cyber Analyst $102,469 14 45 1 1 1 NE 1185 04/16/09 Cyber Analyst $87,914 14 33 1 1 1 PA 1186 08/14/05 Cyber Analyst $100,636 14 43 3 1 1 NE 1188 05/16/09 Cyber Software Engineer $143,198 19 38 3 1 1 IL 1189 02/12/10 Public and Business Office Team $110,520 16 40 2 2 1 PA 1190 5/9/2002 Cyber Analyst $105,716 14 48 1 1 1 IL 1190 8/31/1999 Cyber Analyst $59,147 14 53 1 1 1 IL 1196 09/08/09 Cyber Analyst $135,327 16 30 3 1 1 IL 1198 09/17/10 Forensics Analyst $123,484 16 22 1 1 1 PA 1201 08/01/08 Cyber Analyst $143,003 16 35 3 1 1 IL 1202 03/15/99 Acctg/Fin $125,123 16 48 3 1 1 PA 1210 09/10/06 Cyber Analyst $120,133 16 40 3 1 1 NE 1215 05/06/07 Cyber Software Engineer $166,673 19 43 2 1 1 PA 1216 07/12/06 Physical Security $72,654 14 40 1 1 1 PA 1218 07/23/09 Malware Reverse Engineers $164,504 17 34 1 1 2 PA 1220 10/16/02 Cyber Analyst $114,368 16 48 3 1 1 NE 1220 04/15/00 Sr Cyber Investigator $143,377 14 55 1 2 1 IL 1224 09/23/13 Cyber Software Engineer $150,886 16 30 2 1 1 PA 1226 06/02/07 Forensics Analyst $127,435 16 29 1 1 1 IL 1227 05/03/00 Investigator $85,234 16 45 3 1 1 IL 1227 04/25/06 Cyber Analyst $120,320 14 41 3 1 2 PA 1232 07/12/10 Physical Security $67,456 12 28 3 1 1 IL 1233 05/31/13 Cyber Analyst $80,577 16 21 3 1 2 NE 1237 08/08/07 Cyber Analyst $86,904 14 38 1 1 1 IL 1246 07/27/00 Sr Cyber Investigator $142,315 14 54 3 2 1 IL 1248 07/25/09 Forensics Analyst $76,156 16 25 3 1 1 NE 1254 02/02/09 Cyber Analyst $79,755 14 34 2 1 1 PA 1255 03/14/09 Forensics Analyst $96,621 16 27 3 1 2 PA 1257 08/09/09 Cyber Software Engineer $135,463 14 38 3 1 1 NE 1257 03/11/10 Cyber Analyst $74,232 19 28 3 1 2 PA 1258 07/09/03 Sr Cyber Investigator $130,234 18 46 3 1 1 NE 1261 04/13/13 Cyber Analyst $80,165 16 20 3 1 2 IL 1261 06/02/09 Sr Cyber Investigator $148,014 16 33 1 2 2 IL 1265 03/04/13 Acctg/Fin $109,632 16 24 1 1 2 NE 1265 07/08/11 Cyber Software Engineer $115,825 19 40 3 2 1 NE 1267 2/5/2008 Cyber Analyst $94,747 14 35 2 1 1 IL 1269 03/14/07 Malware Reverse Engineers $176,577 16 39 3 2 2 NE 1272 09/18/10 IT Mgr $120,515 19 52 3 1 1 PA 1276 05/04/11 IT Staff $85,469 16 32 3 1 1 NE 1279 10/20/07 Cyber Analyst $96,057 14 37 1 1 1 NE 1280 08/11/14 Acctg/Fin $79,442 16 22 3 2 1 PA 1285 04/04/11 Advertising $103,064 16 26 3 2 2 NE 1288 03/25/10 Public and Business Office Team $120,708 16 41 1 1 2 NE 1289 09/05/11 Forensics Analyst $97,943 14 19 1 1 2 NE 1289 10/22/06 Cyber Analyst $100,078 17 40 1 1 1 IL 1292 05/13/01 Cyber Analyst $106,815 14 50 3 1 1 PA 1295 07/08/12 Logistics $85,670 12 30 3 2 1 NE 1296 05/05/00 Forensics Analyst $138,901 16 36 3 1 1 PA 1296 09/15/10 Investigator $112,765 12 29 4 2 1 IL 1296 09/23/11 Quality Assurance $123,487 16 34 3 1 1 NE 1297 06/06/05 Sr Cyber Investigator $169,628 16 41 3 1 2 IL 1299 04/08/09 Logistics Mgr $175,286 16 47 1 1 1 PA 1300 07/10/09 Cyber Software Engineer $80,637 14 36 3 2 1 PA 1300 06/17/09 Cyber Analyst $86,882 16 32 3 1 2 PA 1308 04/03/10 Cyber Software Engineer $115,261 14 31 3 1 1 NE 1308 06/30/01 IT Staff $88,698 16 43 2 2 1 IL 1308 4/30/2000 Cyber Analyst $78,742 19 51 3 1 2 NE 1314 1/22/2008 Cyber Analyst $84,765 14 35 1 1 1 IL 1315 02/15/07 Cyber Analyst $89,672 14 39 3 1 1 IL 1315 02/07/08 Sr Cyber Investigator $128,913 16 34 4 1 1 PA 1317 08/12/08 Sr Cyber Investigator $138,677 15 35 3 1 1 PA 1320 06/18/09 Forensics Analyst $86,351 16 27 4 1 2 IL 1320 09/01/12 Cyber Analyst $81,170 16 22 4 2 2 PA 1320 05/07/11 Sr Cyber Investigator $147,380 16 31 1 1 2 NE 1323 02/05/05 Cyber Analyst $102,235 14 44 4 1 2 IL 1325 03/15/99 Sr Cyber Investigator $143,413 14 57 3 1 1 PA 1329 09/20/09 Forensics Analyst $96,020 16 25 1 1 1 PA 1332 04/12/11 Physical Security $76,789 12 24 3 1 2 PA 1339 05/01/12 Cyber Analyst $81,992 16 24 3 1 2 NE 1341 03/07/04 Forensics Analyst $78,325 14 32 3 1 1 PA 1343 04/15/10 Forensics Analyst $71,897 16 22 1 1 2 IL 1343 12/18/07 Cyber Analyst $104,860 16 36 1 1 1 IL 1346 06/12/10 Sr Cyber Investigator $147,679 14 31 3 1 1 PA 1350 06/21/12 Admin $61,387 12 23 3 2 2 NE 1356 09/19/10 Sr Public and Business Office Team Mgr $164,068 19 48 3 2 1 NE 1357 03/15/99 Advertising $99,741 16 52 3 1 1 PA 1357 04/08/05 COO $235,779 19 39 3 1 2 PA 1364 3/16/2008 Cyber Analyst $94,576 14 35 3 1 1 PA 1364 04/20/05 Cyber Analyst $101,431 14 44 1 1 2 IL 1373 04/08/09 Cyber Analyst $88,873 14 33 4 1 1 PA 1373 06/25/07 Cyber Analyst $97,648 14 38 3 1 1 PA 1378 07/09/10 Cyber Analyst $103,968 17 28 3 1 1 PA 1379 06/09/07 Marketing $121,191 16 36 1 1 1 NE 1381 10/23/10 Public and Business Office Team $132,181 16 52 3 1 1 IL 1387 07/14/09 Forensics Analyst $126,163 14 26 1 1 2 NE 1387 12/18/07 Cyber Analyst $145,130 16 36 1 1 2 IL 1387 07/23/05 Cyber Analyst $100,914 16 43 3 1 1 IL 1391 05/30/09 Cyber Analyst $87,084 14 32 3 1 2 NE 1393 2/3/2001 Cyber Analyst $107,643 14 51 3 1 1 NE 1394 04/30/00 Cyber Analyst $118,640 16 51 1 1 1 IL 1400 06/16/05 Malware Reverse Engineers $180,483 18 46 3 1 2 NE 1402 08/17/11 Cyber Analyst $82,812 16 26 4 1 1 IL 1403 12/01/10 Public and Business Office Team $121,265 16 42 3 2 1 IL 1404 10/15/11 Forensics Analyst $118,097 16 19 3 1 2 PA 1405 08/13/07 Forensics Analyst $128,537 16 34 3 1 1 IL 1411 03/05/09 Malware Reverse Engineers $161,333 16 30 3 1 2 NE 1417 04/15/07 Sr Cyber Investigator $169,102 17 34 4 1 1 PA 1418 07/04/11 Quality Assurance $133,981 16 36 3 1 1 IL 1422 05/30/09 Cyber Analyst $86,918 14 32 1 1 1 IL 1422 09/08/13 Public and Business Office Team $112,485 16 25 3 1 1 NE 1424 03/15/99 Cyber Mgr $145,737 16 45 3 2 1 PA 1424 01/14/10 Cyber Analyst $84,512 20 29 3 1 2 NE 1424 02/15/13 Public and Business Office Team $105,460 16 32 1 2 2 PA 1424 03/15/99 Sr Cyber Investigator $144,505 14 59 3 1 1 PA 1426 10/20/07 Cyber Analyst $95,934 14 37 3 1 1 IL 1429 06/30/10 Sr Cyber Investigator $127,692 16 32 1 1 1 IL 1432 10/15/09 Malware Reverse Engineers $174,904 16 38 3 1 1 PA 1434 01/21/07 Cyber Analyst $99,797 14 39 2 1 1 NE 1442 01/08/12 Admin $72,415 12 25 1 2 2 IL 1443 09/12/06 Sr Cyber Investigator $149,372 16 40 3 1 1 PA 1444 06/15/02 Marketing $121,221 16 42 3 2 1 IL 1444 08/02/11 Public and Business Office Team $104,415 16 34 3 1 1 IL 1445 08/08/10 Cyber Analyst $113,808 17 28 3 1 1 NE 1446 12/15/05 Forensics Analyst $127,574 16 30 4 1 2 PA 1447 10/18/10 Forensics Analyst $123,971 16 23 1 1 2 PA 1447 09/05/12 Public and Business Office Team $123,836 16 32 3 1 1 NE 1448 05/03/11 Admin $75,456 14 31 4 1 2 PA 1450 01/22/09 Cyber Analyst $90,705 14 34 3 1 1 NE 1452 11/06/06 Cyber Analyst $99,838 12 39 3 1 1 IL 1456 06/25/07 Cyber Analyst $97,522 14 38 1 1 1 NE 1456 05/07/04 Sr Cyber Investigator $119,997 16 41 1 1 1 PA 1461 10/12/10 Advertising $83,215 16 28 3 1 2 IL 1466 03/19/09 Cyber Analyst $99,634 14 34 1 1 1 NE 1466 05/04/12 Public and Business Office Team $114,329 16 33 3 1 2 IL 1468 7/21/2001 Cyber Analyst $126,291 16 50 1 1 2 NE 1471 07/10/09 Cyber Analyst $86,729 14 32 3 1 1 PA 1474 03/25/09 Cyber Analyst $89,331 14 34 3 1 1 NE 1476 05/23/11 Logistics $98,560 14 32 3 2 1 IL 1477 03/15/03 Logistics $113,388 16 44 3 2 1 PA 1477 01/15/12 Physical Security $83,169 12 23 1 1 2 PA 1481 09/06/03 Cyber Analyst $104,158 14 47 3 1 1 NE 1484 03/04/09 Physical Security $75,622 14 35 1 2 1 PA 1492 10/25/2001 Cyber Analyst $105,936 14 49 1 1 2 IL 1496 05/07/13 Physical Security $71,035 12 19 1 1 2 NE 1498 02/22/11 Cyber Analyst $93,574 14 27 1 1 1 IL 1498 08/04/13 Sr Cyber Investigator $125,283 12 28 4 2 1 NE 1504 03/14/05 Cyber Analyst $72,104 12 44 1 1 1 PA 1504 04/30/10 Physical Security $68,455 12 28 3 2 1 PA 1505 12/06/10 Cyber Analyst $83,609 16 28 1 2 1 IL 1506 06/27/04 IT Staff $88,517 19 43 1 1 1 NE 1507 04/15/14 Forensics Analyst $115,182 18 18 1 1 2 IL 1513 08/14/03 Cyber Analyst $104,358 14 47 3 1 1 PA 1515 05/01/00 Acctg/Fin $106,230 16 36 3 2 2 NE 1517 11/12/12 Cyber Software Engineer $122,572 16 26 1 2 2 IL 1519 06/04/11 Malware Reverse Engineers $163,010 16 33 3 1 2 IL 1519 02/15/13 Cyber Analyst $79,819 17 19 4 2 2 NE 1523 05/21/11 Acctg/Fin $60,767 16 35 2 1 2 IL 1525 05/09/05 Forensics Analyst $127,633 16 30 3 1 2 NE 1527 03/15/99 Cyber Analyst $99,872 12 54 3 1 1 PA 1529 10/16/11 Cyber Analyst $92,797 16 24 3 1 1 NE 1531 04/07/13 Malware Reverse Engineers $162,412 16 32 3 1 2 PA 1533 12/28/07 Cyber Analyst $95,283 14 36 3 1 1 PA 1539 12/15/12 Forensics Analyst $78,102 17 21 3 1 2 IL 1541 04/09/07 Sr Cyber Investigator $139,128 16 36 3 1 1 IL 1543 10/06/09 Cyber Analyst $85,002 14 30 3 1 2 IL 1550 02/19/14 IT Staff $75,067 16 28 1 2 2 IL 1550 11/14/08 Sr Cyber Investigator $128,317 16 33 3 1 1 IL 1552 5/30/1999 Cyber Analyst $79,316 14 53 3 1 1 PA 1553 04/12/09 Cyber Analyst $88,398 14 33 1 1 1 NE 1553 10/20/07 Cyber Analyst $96,097 14 38 3 1 1 PA 1554 10/23/13 Cyber Software Engineer $142,458 16 26 2 2 2 IL 1554 10/20/06 Cyber Analyst $110,082 16 40 3 1 1 NE 1556 03/21/09 Forensics Analyst $96,466 16 27 4 1 2 PA 1557 07/21/04 Cyber Analyst $93,537 12 46 3 1 2 NE 1558 01/06/05 Cyber Analyst $92,946 12 45 2 1 1 PA 1560 05/06/12 Forensics Analyst $88,270 17 21 3 1 2 PA 1565 03/16/07 Cyber Analyst $88,712 14 38 3 1 1 IL 1568 08/07/12 Physical Security $62,960 12 20 3 2 2 IL 1568 02/07/10 Sr Cyber Investigator $137,771 16 32 1 1 2 NE 1569 04/23/10 Quality Assurance $95,254 16 42 3 2 2 IL 1571 04/16/09 Cyber Analyst $87,917 14 33 4 1 2 PA 1575 02/04/09 Cyber Analyst $90,629 14 34 3 1 1 IL 1579 01/12/05 Cyber Analyst $102,580 14 45 1 1 1 IL 1580 09/16/10 Forensics Analyst $93,342 16 22 3 1 2 PA 1584 03/15/99 Cyber Analyst $110,239 16 54 1 1 2 PA 1588 8/17/2002 Cyber Analyst $105,566 14 48 2 1 1 PA 1589 04/15/13 Malware Reverse Engineers $101,233 16 25 3 2 2 IL 1591 7/12/2008 Cyber Analyst $93,213 14 35 3 1 1 IL 1593 08/15/08 Physical Security $77,891 12 38 1 2 1 NE 1596 06/12/09 CFO $231,276 19 42 3 1 2 PA 1597 11/20/11 Cyber Mgr $170,293 16 34 3 1 1 IL 1598 02/15/13 Cyber Analyst $89,661 16 19 3 1 2 PA 1608 03/15/99 Cyber Mgr $175,375 19 44 3 2 1 IL 1608 04/15/09 Public and Business Office Team $133,258 14 53 3 1 1 PA 1609 07/20/11 Cyber Analyst $83,266 16 26 3 1 2 NE 1611 09/23/07 Cyber Analyst $96,378 14 38 3 1 1 PA 1612 03/06/11 Physical Security $67,800 12 25 2 1 1 NE 1613 05/04/12 Cyber Analyst $82,496 16 24 1 1 1 PA 1616 09/15/09 Advertising $115,027 16 34 3 2 2 PA 1616 08/09/06 Cyber Software Engineer $166,818 19 48 3 1 1 NE 1619 11/3/2007 Cyber Analyst $95,641 14 36 3 1 1 NE 1620 06/07/13 Forensics Analyst $85,248 17 18 1 2 2 NE 1622 02/06/12 Physical Security $73,047 12 21 3 2 2 PA 1623 03/04/12 Cyber Software Engineer $114,153 16 28 2 1 1 IL 1625 09/12/09 Logistics $90,346 16 31 3 1 1 IL 1626 07/08/12 Forensics Analyst $99,141 17 21 3 2 2 NE 1629 09/04/11 Physical Security $65,550 12 24 1 1 1 IL 1630 09/12/08 Physical Security $77,650 12 36 3 1 1 IL 1636 04/17/09 Forensics Analyst $85,671 16 24 4 1 1 NE 1637 06/07/11 Public and Business Office Team $114,494 16 37 4 1 1 PA 1638 09/01/07 Cyber Analyst $96,787 14 38 3 1 2 IL 1639 07/30/12 Cyber Analyst $81,567 16 23 1 1 2 PA 1640 08/13/07 Malware Reverse Engineers $137,045 16 42 3 1 1 PA 1644 09/05/11 Forensics Analyst $77,598 17 19 3 1 2 PA 1654 06/07/11 Cyber Software Engineer $129,709 16 35 3 2 1 NE 1658 03/22/10 Admin $72,300 16 33 1 2 2 PA 1659 11/02/06 Cyber Analyst $99,925 12 40 1 1 2 NE 1660 01/14/10 Cyber Analyst $84,420 16 28 1 2 1 PA 1661 03/18/13 Public and Business Office Team $102,300 12 28 3 2 1 IL 1661 11/18/11 Physical Security $64,456 16 23 1 2 2 NE 1667 01/15/08 Cyber Software Engineer $86,096 14 40 3 1 1 PA 1667 03/14/05 Cyber Analyst $101,554 16 44 3 1 1 PA 1668 05/01/00 Advertising $105,089 16 35 3 1 1 IL 1668 07/10/09 Cyber Analyst $95,688 14 32 4 1 2 PA 1669 09/05/11 Malware Reverse Engineers $161,882 18 32 3 2 1 PA 1671 06/13/12 Cyber Analyst $81,809 16 23 3 1 1 IL 1672 05/04/08 Sr Forensics Mgr $146,546 16 38 3 1 1 IL 1673 03/07/13 Marketing $117,415 16 35 3 2 1 IL 1679 05/18/09 Acctg/Fin $116,109 16 39 3 1 1 PA 1680 01/06/13 Malware Reverse Engineers $151,226 17 24 1 1 2 IL 1687 12/15/05 Forensics Analyst $97,541 14 30 1 1 1 NE 1687 06/02/04 Cyber Analyst $103,784 12 46 3 1 1 IL 1693 03/15/99 Cyber Software Engineer $143,678 19 54 3 1 1 PA 1709 09/20/05 Cyber Analyst $110,522 16 43 1 1 1 IL 1723 06/02/12 Forensics Analyst $99,397 14 21 3 1 2 PA 1723 11/10/2007 Cyber Analyst $95,495 17 36 1 1 1 PA 1726 03/15/99 Malware Reverse Engineers $161,159 19 56 3 1 1 PA 1733 09/18/13 Cyber Mgr $165,780 20 32 1 2 1 PA 1736 09/18/07 Forensics Analyst $97,221 17 28 3 2 2 PA 1736 04/01/09 Cyber Analyst $109,130 16 33 3 1 2 IL 1737 03/15/99 Investigator $116,188 16 52 3 1 1 PA 1741 03/30/09 Cyber Analyst $89,191 14 34 3 1 1 IL 1744 06/15/11 Eng Mgr $160,233 16 45 3 1 1 PA 1744 08/16/06 Forensics Analyst $98,486 19 32 1 1 1 NE 1744 11/12/2007 Cyber Analyst $115,317 16 36 3 1 1 NE 1745 06/10/10 Cyber Analyst $114,196 17 28 4 1 1 PA 1748 08/25/10 Marketing $98,352 16 35 3 2 1 PA 1749 08/14/00 Sr Cyber Investigator $142,777 14 56 1 1 2 NE 1750 06/22/10 Forensics Analyst $91,828 16 22 3 1 2 NE 1750 08/13/09 Cyber Analyst $115,536 16 31 1 1 1 IL 1754 05/06/03 Sr Cyber Investigator $70,507 14 48 1 1 1 PA 1756 05/13/01 Cyber Analyst $106,888 14 50 3 1 1 PA 1756 07/01/09 Sr Forensics Mgr $153,478 16 42 3 1 1 PA 1757 2/16/2002 Cyber Analyst $105,840 14 49 3 1 1 PA 1760 02/04/11 Malware Reverse Engineers $160,348 16 28 2 1 2 PA 1760 09/15/12 Cyber Analyst $81,049 17 22 3 1 2 IL 1764 6/17/2001 Cyber Analyst $117,530 14 50 3 1 2 IL 1767 05/20/05 Cyber Analyst $111,360 16 44 3 1 1 IL 1770 03/06/04 Cyber Software Engineer $138,697 16 48 3 1 1 NE 1771 03/14/05 Cyber Analyst $101,899 14 44 3 1 1 PA 1773 06/07/05 Logistics $110,999 16 42 3 1 2 PA 1774 10/25/13 Cyber Mgr $148,455 17 33 3 2 1 NE 1776 11/13/09 Malware Reverse Engineers $161,441 14 30 3 2 2 IL 1776 03/15/99 Cyber Analyst $110,198 19 54 3 1 1 PA 1779 09/07/10 Cyber Analyst $113,631 17 28 3 1 1 NE 1779 06/01/05 Cyber Analyst $121,084 16 43 3 1 1 IL 1782 03/04/04 Cyber Analyst $123,903 16 46 1 1 1 NE 1785 07/06/06 Cyber Software Engineer $156,972 16 50 3 1 1 IL 1785 09/21/09 Forensics Analyst $96,096 16 25 4 1 2 IL 1785 02/08/10 Physical Security $82,456 12 32 3 2 1 PA 1787 07/21/07 Acctg/Fin $116,261 16 45 3 1 1 IL 1789 09/23/08 Cyber Analyst $92,802 14 35 3 1 1 PA 1793 03/15/99 Malware Reverse Engineers $161,077 19 54 1 1 1 IL 1793 09/07/07 Physical Security $70,788 14 40 3 2 1 IL 1793 09/08/08 Sr Public and Business Office Team Mgr $140,822 19 50 3 1 2 IL 1794 01/14/14 Cyber Software Engineer $110,323 16 24 3 1 2 PA 1796 03/14/10 Public and Business Office Team Mgr $151,275 19 43 3 1 1 PA 1797 02/08/03 Sr Cyber Investigator $150,084 14 44 2 1 1 NE 1800 05/14/09 Cyber Analyst $86,918 14 32 1 1 1 PA 1800 03/15/99 Cyber Analyst $109,647 14 54 3 1 1 PA 1802 5/31/2008 Cyber Analyst $93,498 14 35 4 1 1 NE 1803 09/30/00 Marketing $111,282 16 45 3 1 1 PA 1804 08/19/09 Quality Assurance $124,510 16 46 1 2 1 PA 1809 10/16/2001 Cyber Analyst $106,946 14 50 1 1 1 NE 1812 04/06/05 Forensics Analyst $97,781 14 30 1 1 1 PA 1813 01/15/03 Cyber Analyst $103,922 14 47 1 1 2 IL 1814 08/19/11 Sr Public and Business Office Team Mgr $147,102 16 53 1 1 1 PA 1815 08/17/11 Cyber Analyst $83,244 16 26 3 1 1 NE 1816 04/16/09 Cyber Analyst $87,144 14 33 3 1 1 NE 1819 10/06/09 Cyber Analyst $84,804 14 30 2 1 1 IL 1820 08/06/09 Physical Security $84,236 12 32 3 1 1 NE 1821 09/13/06 Cyber Analyst $100,130 14 40 3 1 1 PA 1822 05/02/07 Cyber Software Engineer $151,691 16 36 3 1 1 NE 1824 04/13/13 Cyber Analyst $80,089 16 20 1 2 2 NE 1829 03/01/07 Cyber Analyst $98,826 14 39 1 1 1 PA 1830 1/15/2000 Cyber Analyst $108,928 14 52 3 1 1 IL 1831 08/16/12 Sr Cyber Investigator $135,938 17 29 1 2 1 PA 1835 06/07/13 Sr Cyber Investigator $135,556 18 29 4 1 1 NE 1836 08/12/06 Cyber Analyst $100,199 14 41 1 1 1 NE 1840 2/16/2000 Cyber Analyst $108,792 14 52 3 1 1 IL 1841 06/07/07 Malware Reverse Engineers $179,865 16 45 2 1 2 PA 1841 08/05/13 Sr Cyber Investigator $165,117 18 28 3 1 1 PA 1846 04/23/09 Malware Reverse Engineers $180,113 14 46 3 2 2 PA 1846 03/05/13 Cyber Software Engineer $140,324 16 24 3 1 1 IL 1846 08/30/04 Cyber Analyst $103,369 19 46 2 1 1 PA 1848 12/15/09 Malware Reverse Engineers $170,722 14 52 3 1 1 PA 1848 06/05/04 Forensics Analyst $98,344 19 32 3 1 1 PA 1850 11/20/10 Forensics Analyst $94,060 16 24 3 1 2 PA 1850 08/05/07 Investigator $118,068 12 30 3 2 1 IL $41,433,167