Conduct Quantitative Analysis
nbroomstqrq
NanaKarikari-needsrevision.xlsxQuantitative Analysis
Employee salary data shows a bimodal distribution, with a significant number employees (76) having a salary of between $31,000 and $40,000, while another equally large share of employees (75) having a salary of between $51,000 and $60,000. The company has also experienced a positve growth in sales revenue over the years. Precisely, the company has achived a 276% average percentage growth in sales between 2002 and 2015. While the mode years of service in the company is 16 years with a large share of employees working in the company for an average of only 7 years and a standard deviation of 4 years. In addition, majority of the employees (80.65%) are males. Also there are more caucasian employees (227) with most of the employees (68.28%) being married. These results suggest that there is a reasonable promotion rate within the company as many employees earn salary in the middle-range. With a consistently large average percentage growth in sales over the years, it is expected that the sales revenue in 2016 and 2017 will continue to increase despite a decrease in 2015. Moreover, there is reason to believe that most of the workforce is not vested in the company. In conjuction to this, there is significant gender and racial imbalance in the workforce, which is contrary to the company's goal of ensuring a diversifiedworkforce. Hence, should consider hiring more females than males as well as more Hispanians, African-Americans and Asians as it creates more positions to keep up with demand. In order to investigate further whether these quantitave results are good or bad for the company, a qualitative analysis may be conducted. In a qualitative analysis, structured interviews with key personnel in the company as well as focused group discussions with the employees, may help yield additional information. These additional information may support the results of the quantitaive analysis especially on issues to deal with salary and job promotion expectations amongst employees. Furthermore, it may also give employee perceptions on the gender and racial distribution of the workforce.
Quantitative Analysis-Cooksey
[Cooksey Comment]: Hi Nana, You seemed to combine your answers to the following questions into paragraphs in your quantitative analysis tab. However, you should answer each of the following questions one by one. I am listing your the questions below, which can be found in Step9 in your classroom. Please redo this step please. In addition, please complete your sorted data step too. Thanks. ~ Prof. Cooksey Apply Quantitative Reasoning Now that you have completed your analysis, think about the patterns you’ve seen in the workforce. 1. From the created histogram, it appears that a large share of employees have a salary between $31,000—$40,000 or $51,000—$60,000. This may indicate reasonable promotion rate for new employees. Is this distribution unimodal or bimodal? Explain. 2. The line chart, as detailed in your "Graph Charts" Excel spreadsheet, shows sales increasing over the years, after an initial few rocky years from 1999 to 2002. In 2015, sales slightly decreased to under $4,000,000. Investors want to know what the projected sales will be in 2017. One method for determining this value is to calculate the average percentage growth, based on historical trends. For example, if sales were $200 last year and $500 this year, the average percentage growth between these years was 150%. ((500-200)/200)*100. Calculate the average percentage growth for 2002–2015 and projected sales for 2016 and 2017. 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, 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. 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. 6. 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. Create a tab for QR Analysis, create a text box, and paste your answers to the above questions in it. Move the tab to the first tab position.
Data
| Workforce Profile Analysis | |||||||||||||
| Section 1: Complete all Columns in Data Set | |||||||||||||
| 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/14 | 10 | ||||||||||||
| Emp # | Hire Date | Role | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Vested | Race | Gender | Status | State | Region |
| 1001 | 03/15/99 | CEO | $200,210 | $96.25 | 16 | 19 | 56 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1002 | 12/15/99 | Design | $79,723 | $38.33 | 15 | 16 | 45 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1003 | 09/07/12 | Sr Mach | $66,750 | $32.09 | 2 | 12 | 29 | No | 1 | 1 | 1 | IL | Midwest |
| 1004 | 06/13/12 | Machine | $31,924 | $15.35 | 3 | 12 | 24 | No | 3 | 1 | 2 | NE | C-Plains |
| 1005 | 10/25/08 | Machine | $42,687 | $20.52 | 6 | 14 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1006 | 08/05/06 | Machine | $50,307 | $24.19 | 8 | 14 | 41 | No | 3 | 1 | 1 | IL | Midwest |
| 1014 | 06/03/09 | IT Staff | $87,818 | $42.22 | 6 | 16 | 40 | No | 4 | 2 | 1 | IL | Midwest |
| 1015 | 07/08/13 | Invent | $31,250 | $15.02 | 1 | 14 | 26 | No | 3 | 1 | 2 | PA | Northeast |
| 1016 | 09/23/08 | Machine | $42,719 | $20.54 | 6 | 12 | 35 | No | 3 | 1 | 2 | NE | C-Plains |
| 1018 | 01/15/11 | Acctg/Fin | $42,836 | $20.59 | 4 | 16 | 32 | No | 3 | 2 | 2 | PA | Northeast |
| 1018 | 05/03/12 | Machine | $32,157 | $15.46 | 3 | 12 | 24 | No | 3 | 2 | 1 | NE | C-Plains |
| 1019 | 05/21/07 | Machine | $48,317 | $23.23 | 8 | 12 | 38 | No | 3 | 1 | 1 | NE | C-Plains |
| 1024 | 08/17/11 | Machine | $33,005 | $15.87 | 3 | 12 | 26 | No | 3 | 1 | 1 | IL | Midwest |
| 1036 | 09/25/00 | Machine | $57,822 | $27.80 | 14 | 16 | 51 | Yes | 2 | 1 | 1 | NE | C-Plains |
| 1038 | 08/21/12 | IT Staff | $65,451 | $31.47 | 2 | 16 | 32 | No | 2 | 1 | 1 | PA | Northeast |
| 1043 | 06/18/09 | Gen Shop | $26,168 | $12.58 | 6 | 12 | 27 | No | 3 | 1 | 1 | IL | Midwest |
| 1048 | 09/19/13 | Shipping | $31,655 | $15.22 | 1 | 12 | 20 | No | 1 | 2 | 2 | IL | Midwest |
| 1049 | 02/23/04 | IT Staff | $88,421 | $42.51 | 11 | 19 | 41 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1053 | 05/31/13 | Machine | $30,241 | $14.54 | 2 | 12 | 20 | No | 3 | 1 | 2 | PA | Northeast |
| 1053 | 09/08/09 | Machine | $35,293 | $16.97 | 5 | 12 | 30 | No | 1 | 1 | 1 | IL | Midwest |
| 1055 | 06/15/01 | Controller | $99,836 | $48.00 | 14 | 19 | 45 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1055 | 06/04/01 | Machine | $56,663 | $27.24 | 14 | 16 | 50 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1055 | 9/30/01 | Machine | $57,385 | $27.59 | 13 | 16 | 50 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1056 | 05/06/07 | Machine | $48,059 | $23.11 | 8 | 12 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1059 | 02/14/12 | Acctg/Fin | $46,589 | $22.40 | 3 | 16 | 33 | No | 3 | 2 | 1 | NE | C-Plains |
| 1061 | 02/02/09 | Machine | $39,931 | $19.20 | 6 | 12 | 34 | No | 1 | 1 | 1 | NE | C-Plains |
| 1062 | 03/04/13 | Acctg/Fin | $32,238 | $15.50 | 2 | 16 | 28 | No | 3 | 1 | 2 | IL | Midwest |
| 1062 | 07/08/09 | Flr Supr | $72,803 | $35.00 | 5 | 14 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1069 | 02/03/11 | Engineering | $79,938 | $38.43 | 4 | 16 | 35 | No | 2 | 2 | 1 | IL | Midwest |
| 1070 | 08/21/09 | Machine | $35,498 | $17.07 | 5 | 12 | 31 | No | 3 | 1 | 1 | NE | C-Plains |
| 1071 | 01/09/05 | Engineering | $86,238 | $41.46 | 10 | 19 | 41 | No | 3 | 1 | 1 | NE | C-Plains |
| 1071 | 08/08/05 | Engineering | $87,019 | $41.84 | 9 | 19 | 51 | No | 3 | 1 | 1 | IL | Midwest |
| 1075 | 01/14/10 | Machine | $34,317 | $16.50 | 5 | 12 | 28 | No | 3 | 2 | 1 | NE | C-Plains |
| 1079 | 10/15/03 | Invent | $51,459 | $24.74 | 11 | 16 | 31 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1083 | 08/27/09 | Machine | $35,396 | $17.02 | 5 | 12 | 31 | No | 3 | 1 | 2 | PA | Northeast |
| 1083 | 4/30/00 | Machine | $58,771 | $28.26 | 15 | 14 | 52 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1084 | 03/15/99 | Sales | $85,671 | $41.19 | 16 | 19 | 62 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1088 | 10/03/11 | Sr Flr Mgr | $83,974 | $40.37 | 3 | 16 | 35 | No | 1 | 2 | 1 | NE | C-Plains |
| 1096 | 03/06/06 | Machine | $50,502 | $24.28 | 9 | 12 | 42 | No | 3 | 1 | 1 | NE | C-Plains |
| 1097 | 08/14/05 | Machine | $50,571 | $24.31 | 9 | 12 | 43 | No | 1 | 1 | 1 | PA | Northeast |
| 1098 | 01/13/14 | Engineering | $62,245 | $29.93 | 1 | 16 | 25 | No | 3 | 1 | 2 | PA | Northeast |
| 1101 | 06/08/02 | Invent | $55,994 | $26.92 | 13 | 16 | 31 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1102 | 04/08/00 | IT Staff | $88,900 | $42.74 | 15 | 19 | 48 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1104 | 02/01/05 | Machine | $52,450 | $25.22 | 10 | 12 | 44 | No | 3 | 1 | 1 | NE | C-Plains |
| 1105 | 09/06/12 | Invent | $32,633 | $15.69 | 2 | 12 | 28 | No | 3 | 1 | 2 | NE | C-Plains |
| 1106 | 5/9/02 | Machine | $55,744 | $26.80 | 13 | 12 | 48 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1108 | 06/15/07 | Gen Shop | $27,403 | $13.17 | 8 | 12 | 29 | No | 3 | 1 | 2 | IL | Midwest |
| 1109 | 02/22/07 | Machine | $49,201 | $23.65 | 8 | 12 | 39 | No | 3 | 1 | 1 | NE | C-Plains |
| 1113 | 05/02/12 | Machine | $32,124 | $15.44 | 3 | 12 | 24 | No | 1 | 2 | 2 | PA | Northeast |
| 1113 | 09/08/00 | Sr Mach | $81,695 | $39.28 | 14 | 14 | 50 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1116 | 12/30/08 | Machine | $42,235 | $20.31 | 6 | 12 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1116 | 04/05/00 | Quality | $81,526 | $39.20 | 15 | 16 | 52 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1117 | 05/27/09 | Gen Shop | $26,360 | $12.67 | 6 | 12 | 27 | No | 3 | 2 | 1 | PA | Northeast |
| 1117 | 08/15/12 | Machine | $31,262 | $15.03 | 2 | 12 | 22 | No | 2 | 1 | 2 | IL | Midwest |
| 1128 | 06/07/10 | Flr Supr | $74,104 | $35.63 | 5 | 16 | 35 | No | 3 | 2 | 1 | NE | C-Plains |
| 1130 | 03/15/99 | Machine | $59,438 | $28.58 | 16 | 16 | 53 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1132 | 07/10/09 | Machine | $35,822 | $17.22 | 5 | 12 | 32 | No | 3 | 1 | 1 | PA | Northeast |
| 1133 | 02/12/09 | Sales | $73,337 | $35.26 | 6 | 19 | 58 | No | 4 | 1 | 1 | PA | Northeast |
| 1136 | 12/14/11 | Machine | $32,523 | $15.64 | 3 | 12 | 24 | No | 1 | 1 | 2 | IL | Midwest |
| 1138 | 10/18/10 | Gen Shop | $24,017 | $11.55 | 4 | 12 | 24 | No | 4 | 2 | 1 | PA | Northeast |
| 1138 | 4/12/08 | Machine | $44,204 | $21.25 | 7 | 12 | 35 | No | 4 | 1 | 1 | PA | Northeast |
| 1140 | 07/10/09 | Machine | $35,934 | $17.28 | 5 | 12 | 32 | No | 2 | 1 | 1 | IL | Midwest |
| 1141 | 06/18/09 | Gen Shop | $25,999 | $12.50 | 6 | 12 | 24 | No | 3 | 1 | 1 | IL | Midwest |
| 1142 | 06/17/09 | Machine | $36,901 | $17.74 | 6 | 12 | 32 | No | 1 | 1 | 1 | PA | Northeast |
| 1145 | 02/16/09 | Gen Shop | $25,131 | $12.08 | 6 | 12 | 24 | No | 2 | 1 | 2 | IL | Midwest |
| 1145 | 11/05/09 | Machine | $34,680 | $16.67 | 5 | 12 | 29 | No | 1 | 1 | 2 | NE | C-Plains |
| 1145 | 09/15/04 | Machine | $53,327 | $25.64 | 10 | 12 | 45 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1150 | 04/26/13 | Machine | $30,808 | $14.81 | 2 | 12 | 21 | No | 1 | 1 | 2 | IL | Midwest |
| 1153 | 02/05/12 | Sr Mach | $66,843 | $32.14 | 3 | 12 | 30 | No | 3 | 1 | 1 | IL | Midwest |
| 1156 | 05/21/11 | Machine | $33,395 | $16.06 | 4 | 12 | 26 | No | 3 | 1 | 2 | IL | Midwest |
| 1167 | 11/15/11 | Machine | $32,766 | $15.75 | 3 | 12 | 24 | No | 3 | 1 | 1 | PA | Northeast |
| 1169 | 01/22/09 | Machine | $40,871 | $19.65 | 6 | 12 | 34 | No | 3 | 1 | 1 | PA | Northeast |
| 1175 | 09/25/02 | Machine | $54,886 | $26.39 | 12 | 14 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1180 | 01/24/05 | Machine | $52,469 | $25.23 | 10 | 12 | 45 | No | 1 | 1 | 1 | NE | C-Plains |
| 1185 | 04/16/09 | Machine | $37,914 | $18.23 | 6 | 12 | 33 | No | 1 | 1 | 1 | PA | Northeast |
| 1186 | 08/14/05 | Machine | $50,636 | $24.34 | 9 | 12 | 43 | No | 3 | 1 | 1 | NE | C-Plains |
| 1188 | 05/16/09 | Engineering | $83,198 | $40.00 | 6 | 19 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1189 | 02/12/10 | Sales | $70,520 | $33.90 | 5 | 16 | 40 | No | 2 | 2 | 1 | PA | Northeast |
| 1190 | 5/9/02 | Machine | $55,716 | $26.79 | 13 | 12 | 48 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1190 | 8/31/99 | Machine | $59,147 | $28.44 | 15 | 14 | 53 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1196 | 09/08/09 | Machine | $35,327 | $16.98 | 5 | 12 | 30 | No | 3 | 1 | 1 | IL | Midwest |
| 1198 | 09/17/10 | Gen Shop | $23,484 | $11.29 | 4 | 12 | 22 | No | 1 | 1 | 1 | PA | Northeast |
| 1201 | 08/01/08 | Machine | $43,003 | $20.67 | 6 | 12 | 35 | No | 3 | 1 | 1 | IL | Midwest |
| 1202 | 03/15/99 | Acctg/Fin | $85,123 | $40.92 | 16 | 16 | 48 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1210 | 09/10/06 | Machine | $50,133 | $24.10 | 8 | 12 | 40 | No | 3 | 1 | 1 | NE | C-Plains |
| 1215 | 05/06/07 | Engineering | $86,673 | $41.67 | 8 | 19 | 43 | No | 2 | 1 | 1 | PA | Northeast |
| 1216 | 07/12/06 | Shipping | $52,654 | $25.31 | 8 | 14 | 40 | No | 1 | 1 | 1 | PA | Northeast |
| 1218 | 07/23/09 | Design | $64,504 | $31.01 | 5 | 16 | 34 | No | 1 | 1 | 2 | PA | Northeast |
| 1220 | 10/16/02 | Machine | $54,368 | $26.14 | 12 | 12 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1220 | 04/15/00 | Sr Mach | $83,377 | $40.09 | 15 | 14 | 55 | Yes | 1 | 2 | 1 | IL | Midwest |
| 1224 | 09/23/13 | Engineering | $70,886 | $34.08 | 1 | 16 | 30 | No | 2 | 1 | 1 | PA | Northeast |
| 1226 | 06/02/07 | Gen Shop | $27,435 | $13.19 | 8 | 12 | 29 | No | 1 | 1 | 1 | IL | Midwest |
| 1227 | 05/03/00 | Invent | $65,234 | $31.36 | 15 | 14 | 45 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1227 | 04/25/06 | Machine | $50,320 | $24.19 | 9 | 12 | 41 | No | 3 | 1 | 2 | PA | Northeast |
| 1232 | 07/12/10 | Shipping | $37,456 | $18.01 | 4 | 12 | 28 | No | 3 | 1 | 1 | IL | Midwest |
| 1233 | 05/31/13 | Machine | $30,577 | $14.70 | 2 | 12 | 21 | No | 3 | 1 | 2 | NE | C-Plains |
| 1237 | 08/08/07 | Machine | $46,904 | $22.55 | 7 | 12 | 38 | No | 1 | 1 | 1 | IL | Midwest |
| 1246 | 07/27/00 | Sr Mach | $82,315 | $39.57 | 14 | 12 | 54 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1248 | 07/25/09 | Gen Shop | $26,156 | $12.58 | 5 | 12 | 25 | No | 3 | 1 | 1 | NE | C-Plains |
| 1254 | 02/02/09 | Machine | $39,755 | $19.11 | 6 | 12 | 34 | No | 2 | 1 | 1 | PA | Northeast |
| 1255 | 03/14/09 | Gen Shop | $26,621 | $12.80 | 6 | 12 | 27 | No | 3 | 1 | 2 | PA | Northeast |
| 1257 | 08/09/09 | Engineering | $85,463 | $41.09 | 5 | 19 | 38 | No | 3 | 1 | 1 | NE | C-Plains |
| 1257 | 03/11/10 | Machine | $34,232 | $16.46 | 5 | 12 | 28 | No | 3 | 1 | 2 | PA | Northeast |
| 1258 | 07/09/03 | Sr Mach | $70,234 | $33.77 | 11 | 12 | 46 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1261 | 04/13/13 | Machine | $30,165 | $14.50 | 2 | 12 | 20 | No | 3 | 1 | 2 | IL | Midwest |
| 1261 | 06/02/09 | Sr Mach | $68,014 | $32.70 | 6 | 12 | 33 | No | 1 | 2 | 2 | IL | Midwest |
| 1265 | 03/04/13 | Acctg/Fin | $29,632 | $14.25 | 2 | 16 | 24 | No | 1 | 1 | 2 | NE | C-Plains |
| 1265 | 07/08/11 | Engineering | $85,825 | $41.26 | 3 | 19 | 40 | No | 3 | 2 | 1 | NE | C-Plains |
| 1267 | 2/5/08 | Machine | $44,747 | $21.51 | 7 | 12 | 35 | No | 2 | 1 | 1 | IL | Midwest |
| 1269 | 03/14/07 | Design | $76,577 | $36.82 | 8 | 16 | 39 | No | 3 | 2 | 2 | NE | C-Plains |
| 1272 | 09/18/10 | IT Mgr | $100,515 | $48.32 | 4 | 19 | 52 | No | 3 | 1 | 1 | PA | Northeast |
| 1276 | 05/04/11 | IT Staff | $65,469 | $31.48 | 4 | 16 | 32 | No | 3 | 1 | 1 | NE | C-Plains |
| 1279 | 10/20/07 | Machine | $46,057 | $22.14 | 7 | 12 | 37 | No | 1 | 1 | 1 | NE | C-Plains |
| 1280 | 08/11/14 | Acctg/Fin | $29,442 | $14.15 | 0 | 16 | 22 | No | 3 | 2 | 1 | PA | Northeast |
| 1285 | 04/04/11 | Advertg | $53,064 | $25.51 | 4 | 16 | 26 | No | 3 | 2 | 2 | NE | C-Plains |
| 1288 | 03/25/10 | Sales | $70,708 | $33.99 | 5 | 16 | 41 | No | 1 | 1 | 2 | NE | C-Plains |
| 1289 | 09/05/11 | Gen Shop | $17,943 | $8.63 | 3 | 12 | 19 | No | 1 | 1 | 2 | NE | C-Plains |
| 1289 | 10/22/06 | Machine | $50,078 | $24.08 | 8 | 12 | 40 | No | 1 | 1 | 1 | IL | Midwest |
| 1292 | 05/13/01 | Machine | $56,815 | $27.31 | 14 | 14 | 50 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1295 | 07/08/12 | Purch | $45,670 | $21.96 | 2 | 12 | 30 | No | 3 | 2 | 1 | NE | C-Plains |
| 1296 | 05/05/00 | Gen Shop | $28,901 | $13.89 | 15 | 14 | 36 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1296 | 09/15/10 | Invent | $52,765 | $25.37 | 4 | 12 | 29 | No | 4 | 2 | 1 | IL | Midwest |
| 1296 | 09/23/11 | Quality | $53,487 | $25.71 | 3 | 16 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1297 | 06/06/05 | Sr Mach | $69,628 | $33.48 | 10 | 12 | 41 | No | 3 | 1 | 2 | IL | Midwest |
| 1299 | 04/08/09 | Shp Mgr | $85,286 | $41.00 | 6 | 16 | 47 | No | 1 | 1 | 1 | PA | Northeast |
| 1300 | 07/10/09 | Engineering | $80,637 | $38.77 | 5 | 16 | 36 | No | 3 | 2 | 1 | PA | Northeast |
| 1300 | 06/17/09 | Machine | $36,882 | $17.73 | 6 | 12 | 32 | No | 3 | 1 | 2 | PA | Northeast |
| 1308 | 04/03/10 | Engineering | $75,261 | $36.18 | 5 | 16 | 31 | No | 3 | 1 | 1 | NE | C-Plains |
| 1308 | 06/30/01 | IT Staff | $88,698 | $42.64 | 14 | 19 | 43 | Yes | 2 | 2 | 1 | IL | Midwest |
| 1308 | 4/30/00 | Machine | $58,742 | $28.24 | 15 | 14 | 51 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1314 | 1/22/08 | Machine | $44,765 | $21.52 | 7 | 12 | 35 | No | 1 | 1 | 1 | IL | Midwest |
| 1315 | 02/15/07 | Machine | $49,672 | $23.88 | 8 | 12 | 39 | No | 3 | 1 | 1 | IL | Midwest |
| 1315 | 02/07/08 | Sr Mach | $68,913 | $33.13 | 7 | 12 | 34 | No | 4 | 1 | 1 | PA | Northeast |
| 1317 | 08/12/08 | Sr Mach | $68,677 | $33.02 | 6 | 12 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1320 | 06/18/09 | Gen Shop | $26,351 | $12.67 | 6 | 14 | 27 | No | 4 | 1 | 2 | IL | Midwest |
| 1320 | 09/01/12 | Machine | $31,170 | $14.99 | 2 | 12 | 22 | No | 4 | 2 | 2 | PA | Northeast |
| 1320 | 05/07/11 | Sr Mach | $67,380 | $32.39 | 4 | 12 | 31 | No | 1 | 1 | 2 | NE | C-Plains |
| 1323 | 02/05/05 | Machine | $52,235 | $25.11 | 10 | 12 | 44 | No | 4 | 1 | 2 | IL | Midwest |
| 1325 | 03/15/99 | Sr Mach | $83,413 | $40.10 | 16 | 14 | 57 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1329 | 09/20/09 | Gen Shop | $26,020 | $12.51 | 5 | 14 | 25 | No | 1 | 1 | 1 | PA | Northeast |
| 1332 | 04/12/11 | Shipping | $36,789 | $17.69 | 4 | 12 | 24 | No | 3 | 1 | 2 | PA | Northeast |
| 1339 | 05/01/12 | Machine | $31,992 | $15.38 | 3 | 12 | 24 | No | 3 | 1 | 2 | NE | C-Plains |
| 1341 | 03/07/04 | Gen Shop | $28,325 | $13.62 | 11 | 14 | 32 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1343 | 04/15/10 | Gen Shop | $21,897 | $10.53 | 5 | 12 | 22 | No | 1 | 1 | 2 | IL | Midwest |
| 1343 | 12/18/07 | Machine | $44,860 | $21.57 | 7 | 12 | 36 | No | 1 | 1 | 1 | IL | Midwest |
| 1346 | 06/12/10 | Sr Mach | $67,679 | $32.54 | 5 | 12 | 31 | No | 3 | 1 | 1 | PA | Northeast |
| 1350 | 06/21/12 | Admin | $21,387 | $10.28 | 3 | 12 | 23 | No | 3 | 2 | 2 | NE | C-Plains |
| 1356 | 09/19/10 | Sr Sales Mgr | $84,068 | $40.42 | 4 | 16 | 48 | No | 3 | 2 | 1 | NE | C-Plains |
| 1357 | 03/15/99 | Advertg | $99,741 | $47.95 | 16 | 16 | 52 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1357 | 04/08/05 | COO | $105,779 | $50.86 | 10 | 19 | 39 | No | 3 | 1 | 2 | PA | Northeast |
| 1364 | 3/16/08 | Machine | $44,576 | $21.43 | 7 | 12 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1364 | 04/20/05 | Machine | $51,431 | $24.73 | 10 | 12 | 44 | No | 1 | 1 | 2 | IL | Midwest |
| 1373 | 04/08/09 | Machine | $38,873 | $18.69 | 6 | 12 | 33 | No | 4 | 1 | 1 | PA | Northeast |
| 1373 | 06/25/07 | Machine | $47,648 | $22.91 | 8 | 12 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1378 | 07/09/10 | Machine | $33,968 | $16.33 | 4 | 12 | 28 | No | 3 | 1 | 1 | PA | Northeast |
| 1379 | 06/09/07 | Mrktg | $81,191 | $39.03 | 8 | 16 | 36 | No | 1 | 1 | 1 | NE | C-Plains |
| 1381 | 10/23/10 | Sales | $72,181 | $34.70 | 4 | 16 | 52 | No | 3 | 1 | 1 | IL | Midwest |
| 1387 | 07/14/09 | Gen Shop | $26,163 | $12.58 | 5 | 12 | 26 | No | 1 | 1 | 2 | NE | C-Plains |
| 1387 | 12/18/07 | Machine | $45,130 | $21.70 | 7 | 12 | 36 | No | 1 | 1 | 2 | IL | Midwest |
| 1387 | 07/23/05 | Machine | $50,914 | $24.48 | 9 | 12 | 43 | No | 3 | 1 | 1 | IL | Midwest |
| 1391 | 05/30/09 | Machine | $37,084 | $17.83 | 6 | 12 | 32 | No | 3 | 1 | 2 | NE | C-Plains |
| 1393 | 2/3/01 | Machine | $57,643 | $27.71 | 14 | 12 | 51 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1394 | 04/30/00 | Machine | $58,640 | $28.19 | 15 | 16 | 51 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1400 | 06/16/05 | Design | $80,483 | $38.69 | 10 | 16 | 46 | No | 3 | 1 | 2 | NE | C-Plains |
| 1402 | 08/17/11 | Machine | $32,812 | $15.78 | 3 | 12 | 26 | No | 4 | 1 | 1 | IL | Midwest |
| 1403 | 12/01/10 | Sales | $71,265 | $34.26 | 4 | 16 | 42 | No | 3 | 2 | 1 | IL | Midwest |
| 1404 | 10/15/11 | Gen Shop | $18,097 | $8.70 | 3 | 14 | 19 | No | 3 | 1 | 2 | PA | Northeast |
| 1405 | 08/13/07 | Gen Shop | $28,537 | $13.72 | 7 | 14 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1411 | 03/05/09 | Design | $61,333 | $29.49 | 6 | 16 | 30 | No | 3 | 1 | 2 | NE | C-Plains |
| 1417 | 04/15/07 | Sr Mach | $69,102 | $33.22 | 8 | 12 | 34 | No | 4 | 1 | 1 | PA | Northeast |
| 1418 | 07/04/11 | Quality | $53,981 | $25.95 | 3 | 16 | 36 | No | 3 | 1 | 1 | IL | Midwest |
| 1422 | 05/30/09 | Machine | $36,918 | $17.75 | 6 | 12 | 32 | No | 1 | 1 | 1 | IL | Midwest |
| 1422 | 09/08/13 | Sales | $52,485 | $25.23 | 1 | 16 | 25 | No | 3 | 1 | 1 | NE | C-Plains |
| 1424 | 03/15/99 | Flr Supr | $75,737 | $36.41 | 16 | 14 | 45 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1424 | 01/14/10 | Machine | $34,512 | $16.59 | 5 | 12 | 29 | No | 3 | 1 | 2 | NE | C-Plains |
| 1424 | 02/15/13 | Sales | $55,460 | $26.66 | 2 | 16 | 32 | No | 1 | 2 | 2 | PA | Northeast |
| 1424 | 03/15/99 | Sr Mach | $84,505 | $40.63 | 16 | 14 | 59 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1426 | 10/20/07 | Machine | $45,934 | $22.08 | 7 | 12 | 37 | No | 3 | 1 | 1 | IL | Midwest |
| 1429 | 06/30/10 | Sr Mach | $67,692 | $32.54 | 5 | 12 | 32 | No | 1 | 1 | 1 | IL | Midwest |
| 1432 | 10/15/09 | Design | $71,204 | $34.23 | 5 | 16 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1434 | 01/21/07 | Machine | $49,797 | $23.94 | 8 | 12 | 39 | No | 2 | 1 | 1 | NE | C-Plains |
| 1442 | 01/08/12 | Admin | $22,415 | $10.78 | 3 | 12 | 25 | No | 1 | 2 | 2 | IL | Midwest |
| 1443 | 09/12/06 | Sr Mach | $69,372 | $33.35 | 8 | 12 | 40 | No | 3 | 1 | 1 | PA | Northeast |
| 1444 | 06/15/02 | Mrktg | $81,221 | $39.05 | 13 | 16 | 42 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1444 | 08/02/11 | Sales | $64,415 | $30.97 | 3 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1445 | 08/08/10 | Machine | $33,808 | $16.25 | 4 | 12 | 28 | No | 3 | 1 | 1 | NE | C-Plains |
| 1446 | 12/15/05 | Gen Shop | $27,574 | $13.26 | 9 | 14 | 30 | No | 4 | 1 | 2 | PA | Northeast |
| 1447 | 10/18/10 | Gen Shop | $23,971 | $11.52 | 4 | 12 | 23 | No | 1 | 1 | 2 | PA | Northeast |
| 1447 | 09/05/12 | Sales | $63,836 | $30.69 | 2 | 16 | 32 | No | 3 | 1 | 1 | NE | C-Plains |
| 1448 | 05/03/11 | Admin | $25,456 | $12.24 | 4 | 14 | 31 | No | 4 | 1 | 2 | PA | Northeast |
| 1450 | 01/22/09 | Machine | $40,705 | $19.57 | 6 | 12 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1452 | 11/06/06 | Machine | $49,838 | $23.96 | 8 | 12 | 39 | No | 3 | 1 | 1 | IL | Midwest |
| 1456 | 06/25/07 | Machine | $47,522 | $22.85 | 8 | 12 | 38 | No | 1 | 1 | 1 | NE | C-Plains |
| 1456 | 05/07/04 | Sr Mach | $69,997 | $33.65 | 11 | 12 | 41 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1461 | 10/12/10 | Advertg | $53,215 | $25.58 | 4 | 16 | 28 | No | 3 | 1 | 2 | IL | Midwest |
| 1466 | 03/19/09 | Machine | $39,634 | $19.05 | 6 | 12 | 34 | No | 1 | 1 | 1 | NE | C-Plains |
| 1466 | 05/04/12 | Sales | $64,329 | $30.93 | 3 | 16 | 33 | No | 3 | 1 | 2 | IL | Midwest |
| 1468 | 7/21/01 | Machine | $56,291 | $27.06 | 13 | 12 | 50 | Yes | 1 | 1 | 2 | NE | C-Plains |
| 1471 | 07/10/09 | Machine | $36,729 | $17.66 | 5 | 12 | 32 | No | 3 | 1 | 1 | PA | Northeast |
| 1474 | 03/25/09 | Machine | $39,331 | $18.91 | 6 | 12 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1476 | 05/23/11 | Purch | $48,560 | $23.35 | 4 | 14 | 32 | No | 3 | 2 | 1 | IL | Midwest |
| 1477 | 03/15/03 | Purch | $63,388 | $30.48 | 12 | 16 | 44 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1477 | 01/15/12 | Shipping | $33,169 | $15.95 | 3 | 12 | 23 | No | 1 | 1 | 2 | PA | Northeast |
| 1481 | 09/06/03 | Machine | $54,158 | $26.04 | 11 | 12 | 47 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1484 | 03/04/09 | Shipping | $45,622 | $21.93 | 6 | 14 | 35 | No | 1 | 2 | 1 | PA | Northeast |
| 1492 | 10/25/01 | Machine | $55,936 | $26.89 | 13 | 12 | 49 | Yes | 1 | 1 | 2 | IL | Midwest |
| 1496 | 05/07/13 | Shipping | $31,035 | $14.92 | 2 | 12 | 19 | No | 1 | 1 | 2 | NE | C-Plains |
| 1498 | 02/22/11 | Machine | $33,574 | $16.14 | 4 | 12 | 27 | No | 1 | 1 | 1 | IL | Midwest |
| 1498 | 08/04/13 | Sr Mach | $65,283 | $31.39 | 1 | 12 | 28 | No | 4 | 2 | 1 | NE | C-Plains |
| 1504 | 03/14/05 | Machine | $52,104 | $25.05 | 10 | 12 | 44 | No | 1 | 1 | 1 | PA | Northeast |
| 1504 | 04/30/10 | Shipping | $38,455 | $18.49 | 5 | 12 | 28 | No | 3 | 2 | 1 | PA | Northeast |
| 1505 | 12/06/10 | Machine | $33,609 | $16.16 | 4 | 12 | 28 | No | 1 | 2 | 1 | IL | Midwest |
| 1506 | 06/27/04 | IT Staff | $88,517 | $42.56 | 11 | 19 | 43 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1507 | 04/15/14 | Gen Shop | $15,182 | $7.30 | 1 | 12 | 18 | No | 1 | 1 | 2 | IL | Midwest |
| 1513 | 08/14/03 | Machine | $54,358 | $26.13 | 11 | 12 | 47 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1515 | 05/01/00 | Acctg/Fin | $66,230 | $31.84 | 15 | 16 | 36 | Yes | 3 | 2 | 2 | NE | C-Plains |
| 1517 | 11/12/12 | Engineering | $62,572 | $30.08 | 2 | 16 | 26 | No | 1 | 2 | 2 | IL | Midwest |
| 1519 | 06/04/11 | Design | $63,010 | $30.29 | 4 | 16 | 33 | No | 3 | 1 | 2 | IL | Midwest |
| 1519 | 02/15/13 | Machine | $29,819 | $14.34 | 2 | 12 | 19 | No | 4 | 2 | 2 | NE | C-Plains |
| 1523 | 05/21/11 | Acctg/Fin | $50,767 | $24.41 | 4 | 16 | 35 | No | 2 | 1 | 2 | IL | Midwest |
| 1525 | 05/09/05 | Gen Shop | $27,633 | $13.29 | 10 | 12 | 30 | No | 3 | 1 | 2 | NE | C-Plains |
| 1527 | 03/15/99 | Machine | $59,872 | $28.78 | 16 | 12 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1529 | 10/16/11 | Machine | $32,797 | $15.77 | 3 | 12 | 24 | No | 3 | 1 | 1 | NE | C-Plains |
| 1531 | 04/07/13 | Design | $62,412 | $30.01 | 2 | 16 | 32 | No | 3 | 1 | 2 | PA | Northeast |
| 1533 | 12/28/07 | Machine | $45,283 | $21.77 | 7 | 12 | 36 | No | 3 | 1 | 1 | PA | Northeast |
| 1539 | 12/15/12 | Gen Shop | $18,102 | $8.70 | 2 | 14 | 21 | No | 3 | 1 | 2 | IL | Midwest |
| 1541 | 04/09/07 | Sr Mach | $69,128 | $33.23 | 8 | 12 | 36 | No | 3 | 1 | 1 | IL | Midwest |
| 1543 | 10/06/09 | Machine | $35,002 | $16.83 | 5 | 12 | 30 | No | 3 | 1 | 2 | IL | Midwest |
| 1550 | 02/19/14 | IT Staff | $55,067 | $26.47 | 1 | 16 | 28 | No | 1 | 2 | 2 | IL | Midwest |
| 1550 | 11/14/08 | Sr Mach | $68,317 | $32.84 | 6 | 12 | 33 | No | 3 | 1 | 1 | IL | Midwest |
| 1552 | 5/30/99 | Machine | $59,316 | $28.52 | 16 | 14 | 53 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1553 | 04/12/09 | Machine | $38,398 | $18.46 | 6 | 12 | 33 | No | 1 | 1 | 1 | NE | C-Plains |
| 1553 | 10/20/07 | Machine | $46,097 | $22.16 | 7 | 12 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1554 | 10/23/13 | Engineering | $62,458 | $30.03 | 1 | 16 | 26 | No | 2 | 2 | 2 | IL | Midwest |
| 1554 | 10/20/06 | Machine | $50,082 | $24.08 | 8 | 12 | 40 | No | 3 | 1 | 1 | NE | C-Plains |
| 1556 | 03/21/09 | Gen Shop | $26,466 | $12.72 | 6 | 12 | 27 | No | 4 | 1 | 2 | PA | Northeast |
| 1557 | 07/21/04 | Machine | $53,537 | $25.74 | 10 | 12 | 46 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1558 | 01/06/05 | Machine | $52,946 | $25.45 | 10 | 12 | 45 | No | 2 | 1 | 1 | PA | Northeast |
| 1560 | 05/06/12 | Gen Shop | $18,270 | $8.78 | 3 | 14 | 21 | No | 3 | 1 | 2 | PA | Northeast |
| 1565 | 03/16/07 | Machine | $48,712 | $23.42 | 8 | 12 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1568 | 08/07/12 | Shipping | $32,960 | $15.85 | 2 | 12 | 20 | No | 3 | 2 | 2 | IL | Midwest |
| 1568 | 02/07/10 | Sr Mach | $67,771 | $32.58 | 5 | 12 | 32 | No | 1 | 1 | 2 | NE | C-Plains |
| 1569 | 04/23/10 | Quality | $55,254 | $26.56 | 5 | 16 | 42 | No | 3 | 2 | 2 | IL | Midwest |
| 1571 | 04/16/09 | Machine | $37,917 | $18.23 | 6 | 12 | 33 | No | 4 | 1 | 2 | PA | Northeast |
| 1575 | 02/04/09 | Machine | $40,629 | $19.53 | 6 | 12 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1579 | 01/12/05 | Machine | $52,580 | $25.28 | 10 | 12 | 45 | No | 1 | 1 | 1 | IL | Midwest |
| 1580 | 09/16/10 | Gen Shop | $23,342 | $11.22 | 4 | 12 | 22 | No | 3 | 1 | 2 | PA | Northeast |
| 1584 | 03/15/99 | Machine | $60,239 | $28.96 | 16 | 16 | 54 | Yes | 1 | 1 | 2 | PA | Northeast |
| 1588 | 8/17/02 | Machine | $55,566 | $26.71 | 12 | 12 | 48 | Yes | 2 | 1 | 1 | PA | Northeast |
| 1589 | 04/15/13 | Design | $51,233 | $24.63 | 2 | 16 | 25 | No | 3 | 2 | 2 | IL | Midwest |
| 1591 | 7/12/08 | Machine | $43,213 | $20.78 | 6 | 12 | 35 | No | 3 | 1 | 1 | IL | Midwest |
| 1593 | 08/15/08 | Shipping | $47,891 | $23.02 | 6 | 12 | 38 | No | 1 | 2 | 1 | NE | C-Plains |
| 1596 | 06/12/09 | CFO | $131,276 | $63.11 | 6 | 19 | 42 | No | 3 | 1 | 2 | PA | Northeast |
| 1597 | 11/20/11 | Flr Supr | $70,293 | $33.79 | 3 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1598 | 02/15/13 | Machine | $29,661 | $14.26 | 2 | 12 | 19 | No | 3 | 1 | 2 | PA | Northeast |
| 1608 | 03/15/99 | Flr Supr | $75,375 | $36.24 | 16 | 16 | 44 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1608 | 04/15/09 | Sales | $73,258 | $35.22 | 6 | 19 | 53 | No | 3 | 1 | 1 | PA | Northeast |
| 1609 | 07/20/11 | Machine | $33,266 | $15.99 | 3 | 12 | 26 | No | 3 | 1 | 2 | NE | C-Plains |
| 1611 | 09/23/07 | Machine | $46,378 | $22.30 | 7 | 12 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1612 | 03/06/11 | Shipping | $37,800 | $18.17 | 4 | 12 | 25 | No | 2 | 1 | 1 | NE | C-Plains |
| 1613 | 05/04/12 | Machine | $32,496 | $15.62 | 3 | 12 | 24 | No | 1 | 1 | 1 | PA | Northeast |
| 1616 | 09/15/09 | Advertg | $65,027 | $31.26 | 5 | 16 | 34 | No | 3 | 2 | 2 | PA | Northeast |
| 1616 | 08/09/06 | Engineering | $86,818 | $41.74 | 8 | 19 | 48 | No | 3 | 1 | 1 | NE | C-Plains |
| 1619 | 11/3/07 | Machine | $45,641 | $21.94 | 7 | 12 | 36 | No | 3 | 1 | 1 | NE | C-Plains |
| 1620 | 06/07/13 | Gen Shop | $15,248 | $7.33 | 2 | 12 | 18 | No | 1 | 2 | 2 | NE | C-Plains |
| 1622 | 02/06/12 | Shipping | $33,047 | $15.89 | 3 | 12 | 21 | No | 3 | 2 | 2 | PA | Northeast |
| 1623 | 03/04/12 | Engineering | $64,153 | $30.84 | 3 | 16 | 28 | No | 2 | 1 | 1 | IL | Midwest |
| 1625 | 09/12/09 | Purch | $60,346 | $29.01 | 5 | 16 | 31 | No | 3 | 1 | 1 | IL | Midwest |
| 1626 | 07/08/12 | Gen Shop | $19,141 | $9.20 | 2 | 14 | 21 | No | 3 | 2 | 2 | NE | C-Plains |
| 1629 | 09/04/11 | Shipping | $35,550 | $17.09 | 3 | 12 | 24 | No | 1 | 1 | 1 | IL | Midwest |
| 1630 | 09/12/08 | Shipping | $47,650 | $22.91 | 6 | 12 | 36 | No | 3 | 1 | 1 | IL | Midwest |
| 1636 | 04/17/09 | Gen Shop | $25,671 | $12.34 | 6 | 12 | 24 | No | 4 | 1 | 1 | NE | C-Plains |
| 1637 | 06/07/11 | Sales | $64,494 | $31.01 | 4 | 16 | 37 | No | 4 | 1 | 1 | PA | Northeast |
| 1638 | 09/01/07 | Machine | $46,787 | $22.49 | 7 | 12 | 38 | No | 3 | 1 | 2 | IL | Midwest |
| 1639 | 07/30/12 | Machine | $31,567 | $15.18 | 2 | 12 | 23 | No | 1 | 1 | 2 | PA | Northeast |
| 1640 | 08/13/07 | Design | $77,045 | $37.04 | 7 | 16 | 42 | No | 3 | 1 | 1 | PA | Northeast |
| 1644 | 09/05/11 | Gen Shop | $17,598 | $8.46 | 3 | 12 | 19 | No | 3 | 1 | 2 | PA | Northeast |
| 1654 | 06/07/11 | Engineering | $79,709 | $38.32 | 4 | 16 | 35 | No | 3 | 2 | 1 | NE | C-Plains |
| 1658 | 03/22/10 | Admin | $32,300 | $15.53 | 5 | 16 | 33 | No | 1 | 2 | 2 | PA | Northeast |
| 1659 | 11/02/06 | Machine | $49,925 | $24.00 | 8 | 12 | 40 | No | 1 | 1 | 2 | NE | C-Plains |
| 1660 | 01/14/10 | Machine | $34,420 | $16.55 | 5 | 12 | 28 | No | 1 | 2 | 1 | PA | Northeast |
| 1661 | 03/18/13 | Sales | $52,300 | $25.14 | 2 | 16 | 28 | No | 3 | 2 | 1 | IL | Midwest |
| 1661 | 11/18/11 | Shipping | $34,456 | $16.57 | 3 | 12 | 23 | No | 1 | 2 | 2 | NE | C-Plains |
| 1667 | 01/15/08 | Engineering | $86,096 | $41.39 | 7 | 16 | 40 | No | 3 | 1 | 1 | PA | Northeast |
| 1667 | 03/14/05 | Machine | $51,554 | $24.79 | 10 | 12 | 44 | No | 3 | 1 | 1 | PA | Northeast |
| 1668 | 05/01/00 | Advertg | $65,089 | $31.29 | 15 | 16 | 35 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1668 | 07/10/09 | Machine | $35,688 | $17.16 | 5 | 12 | 32 | No | 4 | 1 | 2 | PA | Northeast |
| 1669 | 09/05/11 | Design | $61,882 | $29.75 | 3 | 16 | 32 | No | 3 | 2 | 1 | PA | Northeast |
| 1671 | 06/13/12 | Machine | $31,809 | $15.29 | 3 | 12 | 23 | No | 3 | 1 | 1 | IL | Midwest |
| 1672 | 05/04/08 | Sr Flr Mgr | $96,546 | $46.42 | 7 | 12 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1673 | 03/07/13 | Mrktg | $67,415 | $32.41 | 2 | 16 | 35 | No | 3 | 2 | 1 | IL | Midwest |
| 1679 | 05/18/09 | Acctg/Fin | $66,109 | $31.78 | 6 | 16 | 39 | No | 3 | 1 | 1 | PA | Northeast |
| 1680 | 01/06/13 | Design | $51,226 | $24.63 | 2 | 16 | 24 | No | 1 | 1 | 2 | IL | Midwest |
| 1687 | 12/15/05 | Gen Shop | $27,541 | $13.24 | 9 | 14 | 30 | No | 1 | 1 | 1 | NE | C-Plains |
| 1687 | 06/02/04 | Machine | $53,784 | $25.86 | 11 | 12 | 46 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1693 | 03/15/99 | Engineering | $93,678 | $45.04 | 16 | 19 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1709 | 09/20/05 | Machine | $50,522 | $24.29 | 9 | 12 | 43 | No | 1 | 1 | 1 | IL | Midwest |
| 1723 | 06/02/12 | Gen Shop | $19,397 | $9.33 | 3 | 14 | 21 | No | 3 | 1 | 2 | PA | Northeast |
| 1723 | 11/10/07 | Machine | $45,495 | $21.87 | 7 | 12 | 36 | No | 1 | 1 | 1 | PA | Northeast |
| 1726 | 03/15/99 | Design | $81,159 | $39.02 | 16 | 19 | 56 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1733 | 09/18/13 | Flr Supr | $65,780 | $31.63 | 1 | 16 | 32 | No | 1 | 2 | 1 | PA | Northeast |
| 1736 | 09/18/07 | Gen Shop | $27,221 | $13.09 | 7 | 12 | 28 | No | 3 | 2 | 2 | PA | Northeast |
| 1736 | 04/01/09 | Machine | $39,130 | $18.81 | 6 | 12 | 33 | No | 3 | 1 | 2 | IL | Midwest |
| 1737 | 03/15/99 | Invent | $76,188 | $36.63 | 16 | 16 | 52 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1741 | 03/30/09 | Machine | $39,191 | $18.84 | 6 | 12 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1744 | 06/15/11 | Eng Mgr | $110,233 | $53.00 | 4 | 19 | 45 | No | 3 | 1 | 1 | PA | Northeast |
| 1744 | 08/16/06 | Gen Shop | $28,486 | $13.70 | 8 | 12 | 32 | No | 1 | 1 | 1 | NE | C-Plains |
| 1744 | 11/12/07 | Machine | $45,317 | $21.79 | 7 | 12 | 36 | No | 3 | 1 | 1 | NE | C-Plains |
| 1745 | 06/10/10 | Machine | $34,196 | $16.44 | 5 | 12 | 28 | No | 4 | 1 | 1 | PA | Northeast |
| 1748 | 08/25/10 | Mrktg | $68,352 | $32.86 | 4 | 16 | 35 | No | 3 | 2 | 1 | PA | Northeast |
| 1749 | 08/14/00 | Sr Mach | $82,777 | $39.80 | 14 | 12 | 56 | Yes | 1 | 1 | 2 | NE | C-Plains |
| 1750 | 06/22/10 | Gen Shop | $21,828 | $10.49 | 5 | 14 | 22 | No | 3 | 1 | 2 | NE | C-Plains |
| 1750 | 08/13/09 | Machine | $35,536 | $17.08 | 5 | 12 | 31 | No | 1 | 1 | 1 | IL | Midwest |
| 1754 | 05/06/03 | Sr Mach | $70,507 | $33.90 | 12 | 12 | 48 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1756 | 05/13/01 | Machine | $56,888 | $27.35 | 14 | 12 | 50 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1756 | 07/01/09 | Sr Flr Mgr | $93,478 | $44.94 | 6 | 16 | 42 | No | 3 | 1 | 1 | PA | Northeast |
| 1757 | 2/16/02 | Machine | $55,840 | $26.85 | 13 | 12 | 49 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1760 | 02/04/11 | Design | $60,348 | $29.01 | 4 | 16 | 28 | No | 2 | 1 | 2 | PA | Northeast |
| 1760 | 09/15/12 | Machine | $31,049 | $14.93 | 2 | 12 | 22 | No | 3 | 1 | 2 | IL | Midwest |
| 1764 | 6/17/01 | Machine | $57,530 | $27.66 | 14 | 12 | 50 | Yes | 3 | 1 | 2 | IL | Midwest |
| 1767 | 05/20/05 | Machine | $51,360 | $24.69 | 10 | 12 | 44 | No | 3 | 1 | 1 | IL | Midwest |
| 1770 | 03/06/04 | Engineering | $86,972 | $41.81 | 11 | 16 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1771 | 03/14/05 | Machine | $51,899 | $24.95 | 10 | 12 | 44 | No | 3 | 1 | 1 | PA | Northeast |
| 1773 | 06/07/05 | Purch | $60,999 | $29.33 | 10 | 16 | 42 | No | 3 | 1 | 2 | PA | Northeast |
| 1774 | 10/25/13 | Flr Supr | $68,455 | $32.91 | 1 | 16 | 33 | No | 3 | 2 | 1 | NE | C-Plains |
| 1776 | 11/13/09 | Design | $61,441 | $29.54 | 5 | 16 | 30 | No | 3 | 2 | 2 | IL | Midwest |
| 1776 | 03/15/99 | Machine | $60,198 | $28.94 | 16 | 12 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1779 | 09/07/10 | Machine | $33,631 | $16.17 | 4 | 12 | 28 | No | 3 | 1 | 1 | NE | C-Plains |
| 1779 | 06/01/05 | Machine | $51,084 | $24.56 | 10 | 12 | 43 | No | 3 | 1 | 1 | IL | Midwest |
| 1782 | 03/04/04 | Machine | $53,903 | $25.91 | 11 | 12 | 46 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1785 | 07/06/06 | Engineering | $86,972 | $41.81 | 8 | 16 | 50 | No | 3 | 1 | 1 | IL | Midwest |
| 1785 | 09/21/09 | Gen Shop | $26,096 | $12.55 | 5 | 14 | 25 | No | 4 | 1 | 2 | IL | Midwest |
| 1785 | 02/08/10 | Shipping | $42,456 | $20.41 | 5 | 12 | 32 | No | 3 | 2 | 1 | PA | Northeast |
| 1787 | 07/21/07 | Acctg/Fin | $66,261 | $31.86 | 7 | 16 | 45 | No | 3 | 1 | 1 | IL | Midwest |
| 1789 | 09/23/08 | Machine | $42,802 | $20.58 | 6 | 12 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1793 | 03/15/99 | Design | $81,077 | $38.98 | 16 | 19 | 54 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1793 | 09/07/07 | Shipping | $50,788 | $24.42 | 7 | 14 | 40 | No | 3 | 2 | 1 | IL | Midwest |
| 1793 | 09/08/08 | Sr Sales Mgr | $90,822 | $43.66 | 6 | 19 | 50 | No | 3 | 1 | 2 | IL | Midwest |
| 1794 | 01/14/14 | Engineering | $60,323 | $29.00 | 1 | 16 | 24 | No | 3 | 1 | 2 | PA | Northeast |
| 1796 | 03/14/10 | Sales Mgr | $101,275 | $48.69 | 5 | 19 | 43 | No | 3 | 1 | 1 | PA | Northeast |
| 1797 | 02/08/03 | Sr Mach | $70,084 | $33.69 | 12 | 12 | 44 | Yes | 2 | 1 | 1 | NE | C-Plains |
| 1800 | 05/14/09 | Machine | $36,918 | $17.75 | 6 | 12 | 32 | No | 1 | 1 | 1 | PA | Northeast |
| 1800 | 03/15/99 | Machine | $59,647 | $28.68 | 16 | 14 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1802 | 5/31/08 | Machine | $43,498 | $20.91 | 7 | 12 | 35 | No | 4 | 1 | 1 | NE | C-Plains |
| 1803 | 09/30/00 | Mrktg | $81,282 | $39.08 | 14 | 16 | 45 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1804 | 08/19/09 | Quality | $64,510 | $31.01 | 5 | 16 | 46 | No | 1 | 2 | 1 | PA | Northeast |
| 1809 | 10/16/01 | Machine | $56,946 | $27.38 | 13 | 12 | 50 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1812 | 04/06/05 | Gen Shop | $27,781 | $13.36 | 10 | 12 | 30 | No | 1 | 1 | 1 | PA | Northeast |
| 1813 | 01/15/03 | Machine | $53,922 | $25.92 | 12 | 12 | 47 | Yes | 1 | 1 | 2 | IL | Midwest |
| 1814 | 08/19/11 | Sr Sales Mgr | $87,102 | $41.88 | 3 | 16 | 53 | No | 1 | 1 | 1 | PA | Northeast |
| 1815 | 08/17/11 | Machine | $33,244 | $15.98 | 3 | 12 | 26 | No | 3 | 1 | 1 | NE | C-Plains |
| 1816 | 04/16/09 | Machine | $37,144 | $17.86 | 6 | 12 | 33 | No | 3 | 1 | 1 | NE | C-Plains |
| 1819 | 10/06/09 | Machine | $34,804 | $16.73 | 5 | 12 | 30 | No | 2 | 1 | 1 | IL | Midwest |
| 1820 | 08/06/09 | Shipping | $44,236 | $21.27 | 5 | 12 | 32 | No | 3 | 1 | 1 | NE | C-Plains |
| 1821 | 09/13/06 | Machine | $50,130 | $24.10 | 8 | 12 | 40 | No | 3 | 1 | 1 | PA | Northeast |
| 1822 | 05/02/07 | Engineering | $81,691 | $39.27 | 8 | 16 | 36 | No | 3 | 1 | 1 | NE | C-Plains |
| 1824 | 04/13/13 | Machine | $30,089 | $14.47 | 2 | 12 | 20 | No | 1 | 2 | 2 | NE | C-Plains |
| 1829 | 03/01/07 | Machine | $48,826 | $23.47 | 8 | 12 | 39 | No | 1 | 1 | 1 | PA | Northeast |
| 1830 | 1/15/00 | Machine | $58,928 | $28.33 | 15 | 14 | 52 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1831 | 08/16/12 | Sr Mach | $65,938 | $31.70 | 2 | 12 | 29 | No | 1 | 2 | 1 | PA | Northeast |
| 1835 | 06/07/13 | Sr Mach | $65,556 | $31.52 | 2 | 12 | 29 | No | 4 | 1 | 1 | NE | C-Plains |
| 1836 | 08/12/06 | Machine | $50,199 | $24.13 | 8 | 12 | 41 | No | 1 | 1 | 1 | NE | C-Plains |
| 1840 | 2/16/00 | Machine | $58,792 | $28.27 | 15 | 12 | 52 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1841 | 06/07/07 | Design | $79,865 | $38.40 | 8 | 16 | 45 | No | 2 | 1 | 2 | PA | Northeast |
| 1841 | 08/05/13 | Sr Mach | $65,117 | $31.31 | 1 | 12 | 28 | No | 3 | 1 | 1 | PA | Northeast |
| 1846 | 04/23/09 | Design | $80,113 | $38.52 | 6 | 19 | 46 | No | 3 | 2 | 2 | PA | Northeast |
| 1846 | 03/05/13 | Engineering | $60,324 | $29.00 | 2 | 16 | 24 | No | 3 | 1 | 1 | IL | Midwest |
| 1846 | 08/30/04 | Machine | $53,369 | $25.66 | 10 | 12 | 46 | Yes | 2 | 1 | 1 | PA | Northeast |
| 1848 | 12/15/09 | Design | $80,722 | $38.81 | 5 | 19 | 52 | No | 3 | 1 | 1 | PA | Northeast |
| 1848 | 06/05/04 | Gen Shop | $28,344 | $13.63 | 11 | 12 | 32 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1850 | 11/20/10 | Gen Shop | $24,060 | $11.57 | 4 | 12 | 24 | No | 3 | 1 | 2 | PA | Northeast |
| 1850 | 08/05/07 | Invent | $58,068 | $27.92 | 7 | 12 | 30 | No | 3 | 2 | 1 | IL | Midwest |
| Section 2: Complete Summary Tables for Graphing | |||||||||||||
| Sales Summary (Provided) | |||||||||||||
| Roles | Race | # | % | Yr | Sales | ||||||||
| Key Emp | 0 | 1 | African-Am | 96 | 25.81% | 1999 | ($527,000) | ||||||
| Acctg/Fin | 10 | 2 | Asian | 24 | 6.45% | 2000 | $1,215,000 | ||||||
| Admin | 4 | 3 | Caucasian | 227 | 61.02% | 2001 | ($257,000) | ||||||
| Advertg | 5 | 4 | Hispanic | 25 | 6.72% | 2002 | $985,000 | ||||||
| CEO | 1 | 372 | 100.00% | 2003 | $1,274,000 | ||||||||
| CFO | 1 | 2004 | $1,578,000 | ||||||||||
| Controller | 1 | 2005 | $2,061,000 | ||||||||||
| COO | 1 | Gender | # | % | 2006 | $1,987,000 | |||||||
| Design | 19 | 1 | Male | 300 | 80.65% | 2007 | $2,057,000 | ||||||
| Engineering | 23 | 2 | Female | 72 | 19.35% | 2008 | $2,565,000 | ||||||
| Eng Mgr | 1 | 372 | 100.00% | 2009 | $2,467,000 | ||||||||
| Flr Supr | 7 | 2010 | $3,846,000 | ||||||||||
| Gen Shop | 40 | 2011 | $3,252,000 | ||||||||||
| Invent | 8 | Education Level | # | % | 2012 | $4,226,000 | |||||||
| IT Staff | 8 | 12 | HS | 215 | 57.80% | 2013 | $4,844,000 | ||||||
| IT Mgr | 1 | 14 | AA | 37 | 9.95% | 2014 | $4,922,000 | ||||||
| Machine | 159 | 16 | BA/BS | 93 | 25.00% | 2015 | $3,702,000 | ||||||
| Mrktg | 5 | 19 | Masters | 27 | 7.26% | ||||||||
| Purch | 5 | 372 | 100.00% | ||||||||||
| Quality | 5 | ||||||||||||
| Sales | 14 | ||||||||||||
| Sales Mgr | 1 | Marital Status | # | % | |||||||||
| Shipping | 18 | 1 | Married | 254 | 68.28% | ||||||||
| Shp Mgr | 1 | 2 | Single | 118 | 31.72% | ||||||||
| Sr Flr Mgr | 3 | 372 | 100.00% | ||||||||||
| Sr Mach | 28 | ||||||||||||
| Sr Sales Mgr | 3 | ||||||||||||
| Total | 372 | Region Key | |||||||||||
| State | Region | # | % | ||||||||||
| PA | Northeast | 148 | 39.78% | ||||||||||
| IL | Midwest | 123 | 33.06% | ||||||||||
| NE | C-Plains | 101 | 27.15% | ||||||||||
| 372 | 100.00% | ||||||||||||
| Section 3: Complete Descriptive Statistics | |||||||||||||
| Descriptive Statistics | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Frequency Table by Salary Ranges | |||||||
| Mean | $53,115 | $26 | 7 | 14 | 36 | Bin Range/Upper Limit | Labels | ||||||
| Median | $51,297 | $25 | 6 | 12 | 35 | 20000 | Up to 20 | ||||||
| Mode | $36,918 | $18 | 16 | 12 | 32 | 30000 | 21-30 | ||||||
| Std Deviation | 21711.9267450277 | 10.4384263197 | 4 | 2 | 10 | 40000 | 31-40 | ||||||
| Variance | 471407762.981451 | 108.9607440323 | 17 | 5 | 94 | 50000 | 41-50 | ||||||
| Kurtosis | 4.9212734614 | 4.9212734614 | -0 | -0 | -1 | 60000 | 51-60 | ||||||
| Skewness | 1.1949185713 | 1.1949185713 | 1 | 1 | 0 | 70000 | 61-70 | ||||||
| Max - | $200,210 | $96 | 16 | 19 | 62 | 80000 | 71-80 | ||||||
| Min = | $15,182 | $7 | 0 | 12 | 18 | 90000 | 81-90 | ||||||
| Range | $185,028 | $89 | 15 | 7 | 44 | 100000 | 91-100 | ||||||
| Sum | $19,758,742 | $9,499 | 2563 | 5099 | 13330 | 110000 | 101-110 | ||||||
| Count | 372 | 372 | 372 | 372 | 372 | 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 | ||||||||||||
| 210000 | 200+ | ||||||||||||
Excel Summary Stats
| Salary | Hrly Rate | Yrs of Svc | Ed | Age | |||||
| Mean | 53114.8978494624 | Mean | 25.5360085815 | Mean | 6.8901807049 | Mean | 13.7069892473 | Mean | 35.8333333333 |
| Standard Error | 1125.710961706 | Standard Error | 0.5412071931 | Standard Error | 0.2114976563 | Standard Error | 0.1165599551 | Standard Error | 0.5028227041 |
| Median | 51296.5 | Median | 24.6617788462 | Median | 5.7305555556 | Median | 12 | Median | 35 |
| Mode | 36918 | Mode | 17.7490384615 | Mode | 15.7944444444 | Mode | 12 | Mode | 32 |
| Standard Deviation | 21711.9267450277 | Standard Deviation | 10.4384263197 | Standard Deviation | 4.0792190691 | Standard Deviation | 2.248127 | Standard Deviation | 9.6980931055 |
| Sample Variance | 471407762.981451 | Sample Variance | 108.9607440323 | Sample Variance | 16.6400282134 | Sample Variance | 5.054075008 | Sample Variance | 94.0530098832 |
| Kurtosis | 4.9212734614 | Kurtosis | 4.9212734614 | Kurtosis | -0.3933865389 | Kurtosis | -0.2802020628 | Kurtosis | -0.7144941444 |
| Skewness | 1.1949185713 | Skewness | 1.1949185713 | Skewness | 0.7304027035 | Skewness | 0.9675351693 | Skewness | 0.3102790703 |
| Range | 185028 | Range | 88.9557692308 | Range | 15.4055555556 | Range | 7 | Range | 44 |
| Minimum | 15182 | Minimum | 7.2990384615 | Minimum | 0.3888888889 | Minimum | 12 | Minimum | 18 |
| Maximum | 200210 | Maximum | 96.2548076923 | Maximum | 15.7944444444 | Maximum | 19 | Maximum | 62 |
| Sum | 19758742 | Sum | 9499.3951923077 | Sum | 2563.1472222222 | Sum | 5099 | Sum | 13330 |
| Count | 372 | Count | 372 | Count | 372 | Count | 372 | Count | 372 |
Graphs_Charts
Gender
Male Female 0.806451612903226 0.193548387096774
Education Level
HS AA BA/BS Masters 0.577956989247312 0.0994623655913978 0.25 0.0725806451612903
Marital Status
Married Single 0.682795698924731 0.317204301075269
Race
African-Am Asian Caucasian Hispanic 96.0 24.0 227.0 25.0
State
PA IL NE 148.0 123.0 101.0
Sales
Sales 1999.0 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 2015.0 -527000.0 1.215E6 -257000.0 985000.0 1.274E6 1.578E6 2.061E6 1.987E6 2.057E6 2.565E6 2.467E6 3.846E6 3.252E6 4.226E6 4.844E6 4.922E6 3.702E6
Gender
Male Female 0.806451612903226 0.193548387096774
Education Level
HS AA BA/BS Masters 0.577956989247312 0.0994623655913978 0.25 0.0725806451612903
Marital Status
Married Single 0.682795698924731 0.317204301075269
Race
African-Am Asian Caucasian Hispanic 96.0 24.0 227.0 25.0
State
PA IL NE 148.0 123.0 101.0
Sales
Sales 1999.0 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 2015.0 -527000.0 1.215E6 -257000.0 985000.0 1.274E6 1.578E6 2.061E6 1.987E6 2.057E6 2.565E6 2.467E6 3.846E6 3.252E6 4.226E6 4.844E6 4.922E6 3.702E6
Gender
Male Female 0.806451612903226 0.193548387096774
Education Level
HS AA BA/BS Masters 0.577956989247312 0.0994623655913978 0.25 0.0725806451612903
Marital Status
Married Single 0.682795698924731 0.317204301075269
Race
African-Am Asian Caucasian Hispanic 96.0 24.0 227.0 25.0
State
PA IL NE 148.0 123.0 101.0
Sales
Sales 1999.0 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 2015.0 -527000.0 1.215E6 -257000.0 985000.0 1.274E6 1.578E6 2.061E6 1.987E6 2.057E6 2.565E6 2.467E6 3.846E6 3.252E6 4.226E6 4.844E6 4.922E6 3.702E6
Gender
Male Female 0.806451612903226 0.193548387096774
Education Level
HS AA BA/BS Masters 0.577956989247312 0.0994623655913978 0.25 0.0725806451612903
Marital Status
Married Single 0.682795698924731 0.317204301075269
Race
African-Am Asian Caucasian Hispanic 96.0 24.0 227.0 25.0
State
PA IL NE 148.0 123.0 101.0
Sales
Sales 1999.0 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 2015.0 -527000.0 1.215E6 -257000.0 985000.0 1.274E6 1.578E6 2.061E6 1.987E6 2.057E6 2.565E6 2.467E6 3.846E6 3.252E6 4.226E6 4.844E6 4.922E6 3.702E6
Gender
Male Female 0.806451612903226 0.193548387096774
Education Level
HS AA BA/BS Masters 0.577956989247312 0.0994623655913978 0.25 0.0725806451612903
Marital Status
Married Single 0.682795698924731 0.317204301075269
Race
African-Am Asian Caucasian Hispanic 96.0 24.0 227.0 25.0
State
PA IL NE 148.0 123.0 101.0
Sales
Sales 1999.0 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 2015.0 -527000.0 1.215E6 -257000.0 985000.0 1.274E6 1.578E6 2.061E6 1.987E6 2.057E6 2.565E6 2.467E6 3.846E6 3.252E6 4.226E6 4.844E6 4.922E6 3.702E6
Gender
Male Female 0.806451612903226 0.193548387096774
Education Level
HS AA BA/BS Masters 0.577956989247312 0.0994623655913978 0.25 0.0725806451612903
Marital Status
Married Single 0.682795698924731 0.317204301075269
Race
African-Am Asian Caucasian Hispanic 96.0 24.0 227.0 25.0
State
PA IL NE 148.0 123.0 101.0
Sales
Sales 1999.0 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 2015.0 -527000.0 1.215E6 -257000.0 985000.0 1.274E6 1.578E6 2.061E6 1.987E6 2.057E6 2.565E6 2.467E6 3.846E6 3.252E6 4.226E6 4.844E6 4.922E6 3.702E6
Histogram
| 20000 | Frequency |
| 30000 | 47 |
| 40000 | 76 |
| 50000 | 46 |
| 60000 | 75 |
| 70000 | 54 |
| 80000 | 24 |
| 90000 | 38 |
| 100000 | 6 |
| 110000 | 3 |
| 120000 | 1 |
| 130000 | 0 |
| 140000 | 1 |
| 150000 | 0 |
| 160000 | 0 |
| 170000 | 0 |
| 180000 | 0 |
| 190000 | 0 |
| 200000 | 0 |
| 210000 | 0 |
| More | 0 |
Histogram
Frequency 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 150000 160000 170000 180000 190000 200000 210000 More 47.0 76.0 46.0 75.0 54.0 24.0 38.0 6.0 3.0 1.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.020000
Frequency
Sorted Data
| Workforce Profile Analysis | |||||||||||||
| Section 1: Complete all Columns in Data Set | |||||||||||||
| 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/14 | 10 | ||||||||||||
| Emp # | Hire Date | Role | Salary | Hrly Rate | Yrs of Svc | Ed | Age | Vested | Race | Gender | Status | State | Region |
| 1001 | 03/15/99 | CEO | $200,210 | $96.25 | 16 | 19 | 56 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1002 | 12/15/99 | Design | $79,723 | $38.33 | 15 | 16 | 45 | Yes | 3 | 1 | 2 | PA | Northeast |
| 1003 | 09/07/12 | Sr Mach | $66,750 | $32.09 | 2 | 12 | 29 | No | 1 | 1 | 1 | IL | Midwest |
| 1004 | 06/13/12 | Machine | $31,924 | $15.35 | 3 | 12 | 24 | No | 3 | 1 | 2 | NE | C-Plains |
| 1005 | 10/25/08 | Machine | $42,687 | $20.52 | 6 | 14 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1006 | 08/05/06 | Machine | $50,307 | $24.19 | 8 | 14 | 41 | No | 3 | 1 | 1 | IL | Midwest |
| 1014 | 06/03/09 | IT Staff | $87,818 | $42.22 | 6 | 16 | 40 | No | 4 | 2 | 1 | IL | Midwest |
| 1015 | 07/08/13 | Invent | $31,250 | $15.02 | 1 | 14 | 26 | No | 3 | 1 | 2 | PA | Northeast |
| 1016 | 09/23/08 | Machine | $42,719 | $20.54 | 6 | 12 | 35 | No | 3 | 1 | 2 | NE | C-Plains |
| 1018 | 01/15/11 | Acctg/Fin | $42,836 | $20.59 | 4 | 16 | 32 | No | 3 | 2 | 2 | PA | Northeast |
| 1018 | 05/03/12 | Machine | $32,157 | $15.46 | 3 | 12 | 24 | No | 3 | 2 | 1 | NE | C-Plains |
| 1019 | 05/21/07 | Machine | $48,317 | $23.23 | 8 | 12 | 38 | No | 3 | 1 | 1 | NE | C-Plains |
| 1024 | 08/17/11 | Machine | $33,005 | $15.87 | 3 | 12 | 26 | No | 3 | 1 | 1 | IL | Midwest |
| 1036 | 09/25/00 | Machine | $57,822 | $27.80 | 14 | 16 | 51 | Yes | 2 | 1 | 1 | NE | C-Plains |
| 1038 | 08/21/12 | IT Staff | $65,451 | $31.47 | 2 | 16 | 32 | No | 2 | 1 | 1 | PA | Northeast |
| 1043 | 06/18/09 | Gen Shop | $26,168 | $12.58 | 6 | 12 | 27 | No | 3 | 1 | 1 | IL | Midwest |
| 1048 | 09/19/13 | Shipping | $31,655 | $15.22 | 1 | 12 | 20 | No | 1 | 2 | 2 | IL | Midwest |
| 1049 | 02/23/04 | IT Staff | $88,421 | $42.51 | 11 | 19 | 41 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1053 | 05/31/13 | Machine | $30,241 | $14.54 | 2 | 12 | 20 | No | 3 | 1 | 2 | PA | Northeast |
| 1053 | 09/08/09 | Machine | $35,293 | $16.97 | 5 | 12 | 30 | No | 1 | 1 | 1 | IL | Midwest |
| 1055 | 06/15/01 | Controller | $99,836 | $48.00 | 14 | 19 | 45 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1055 | 06/04/01 | Machine | $56,663 | $27.24 | 14 | 16 | 50 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1055 | 9/30/01 | Machine | $57,385 | $27.59 | 13 | 16 | 50 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1056 | 05/06/07 | Machine | $48,059 | $23.11 | 8 | 12 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1059 | 02/14/12 | Acctg/Fin | $46,589 | $22.40 | 3 | 16 | 33 | No | 3 | 2 | 1 | NE | C-Plains |
| 1061 | 02/02/09 | Machine | $39,931 | $19.20 | 6 | 12 | 34 | No | 1 | 1 | 1 | NE | C-Plains |
| 1062 | 03/04/13 | Acctg/Fin | $32,238 | $15.50 | 2 | 16 | 28 | No | 3 | 1 | 2 | IL | Midwest |
| 1062 | 07/08/09 | Flr Supr | $72,803 | $35.00 | 5 | 14 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1069 | 02/03/11 | Engineering | $79,938 | $38.43 | 4 | 16 | 35 | No | 2 | 2 | 1 | IL | Midwest |
| 1070 | 08/21/09 | Machine | $35,498 | $17.07 | 5 | 12 | 31 | No | 3 | 1 | 1 | NE | C-Plains |
| 1071 | 01/09/05 | Engineering | $86,238 | $41.46 | 10 | 19 | 41 | No | 3 | 1 | 1 | NE | C-Plains |
| 1071 | 08/08/05 | Engineering | $87,019 | $41.84 | 9 | 19 | 51 | No | 3 | 1 | 1 | IL | Midwest |
| 1075 | 01/14/10 | Machine | $34,317 | $16.50 | 5 | 12 | 28 | No | 3 | 2 | 1 | NE | C-Plains |
| 1079 | 10/15/03 | Invent | $51,459 | $24.74 | 11 | 16 | 31 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1083 | 08/27/09 | Machine | $35,396 | $17.02 | 5 | 12 | 31 | No | 3 | 1 | 2 | PA | Northeast |
| 1083 | 4/30/00 | Machine | $58,771 | $28.26 | 15 | 14 | 52 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1084 | 03/15/99 | Sales | $85,671 | $41.19 | 16 | 19 | 62 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1088 | 10/03/11 | Sr Flr Mgr | $83,974 | $40.37 | 3 | 16 | 35 | No | 1 | 2 | 1 | NE | C-Plains |
| 1096 | 03/06/06 | Machine | $50,502 | $24.28 | 9 | 12 | 42 | No | 3 | 1 | 1 | NE | C-Plains |
| 1097 | 08/14/05 | Machine | $50,571 | $24.31 | 9 | 12 | 43 | No | 1 | 1 | 1 | PA | Northeast |
| 1098 | 01/13/14 | Engineering | $62,245 | $29.93 | 1 | 16 | 25 | No | 3 | 1 | 2 | PA | Northeast |
| 1101 | 06/08/02 | Invent | $55,994 | $26.92 | 13 | 16 | 31 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1102 | 04/08/00 | IT Staff | $88,900 | $42.74 | 15 | 19 | 48 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1104 | 02/01/05 | Machine | $52,450 | $25.22 | 10 | 12 | 44 | No | 3 | 1 | 1 | NE | C-Plains |
| 1105 | 09/06/12 | Invent | $32,633 | $15.69 | 2 | 12 | 28 | No | 3 | 1 | 2 | NE | C-Plains |
| 1106 | 5/9/02 | Machine | $55,744 | $26.80 | 13 | 12 | 48 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1108 | 06/15/07 | Gen Shop | $27,403 | $13.17 | 8 | 12 | 29 | No | 3 | 1 | 2 | IL | Midwest |
| 1109 | 02/22/07 | Machine | $49,201 | $23.65 | 8 | 12 | 39 | No | 3 | 1 | 1 | NE | C-Plains |
| 1113 | 05/02/12 | Machine | $32,124 | $15.44 | 3 | 12 | 24 | No | 1 | 2 | 2 | PA | Northeast |
| 1113 | 09/08/00 | Sr Mach | $81,695 | $39.28 | 14 | 14 | 50 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1116 | 12/30/08 | Machine | $42,235 | $20.31 | 6 | 12 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1116 | 04/05/00 | Quality | $81,526 | $39.20 | 15 | 16 | 52 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1117 | 05/27/09 | Gen Shop | $26,360 | $12.67 | 6 | 12 | 27 | No | 3 | 2 | 1 | PA | Northeast |
| 1117 | 08/15/12 | Machine | $31,262 | $15.03 | 2 | 12 | 22 | No | 2 | 1 | 2 | IL | Midwest |
| 1128 | 06/07/10 | Flr Supr | $74,104 | $35.63 | 5 | 16 | 35 | No | 3 | 2 | 1 | NE | C-Plains |
| 1130 | 03/15/99 | Machine | $59,438 | $28.58 | 16 | 16 | 53 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1132 | 07/10/09 | Machine | $35,822 | $17.22 | 5 | 12 | 32 | No | 3 | 1 | 1 | PA | Northeast |
| 1133 | 02/12/09 | Sales | $73,337 | $35.26 | 6 | 19 | 58 | No | 4 | 1 | 1 | PA | Northeast |
| 1136 | 12/14/11 | Machine | $32,523 | $15.64 | 3 | 12 | 24 | No | 1 | 1 | 2 | IL | Midwest |
| 1138 | 10/18/10 | Gen Shop | $24,017 | $11.55 | 4 | 12 | 24 | No | 4 | 2 | 1 | PA | Northeast |
| 1138 | 4/12/08 | Machine | $44,204 | $21.25 | 7 | 12 | 35 | No | 4 | 1 | 1 | PA | Northeast |
| 1140 | 07/10/09 | Machine | $35,934 | $17.28 | 5 | 12 | 32 | No | 2 | 1 | 1 | IL | Midwest |
| 1141 | 06/18/09 | Gen Shop | $25,999 | $12.50 | 6 | 12 | 24 | No | 3 | 1 | 1 | IL | Midwest |
| 1142 | 06/17/09 | Machine | $36,901 | $17.74 | 6 | 12 | 32 | No | 1 | 1 | 1 | PA | Northeast |
| 1145 | 02/16/09 | Gen Shop | $25,131 | $12.08 | 6 | 12 | 24 | No | 2 | 1 | 2 | IL | Midwest |
| 1145 | 11/05/09 | Machine | $34,680 | $16.67 | 5 | 12 | 29 | No | 1 | 1 | 2 | NE | C-Plains |
| 1145 | 09/15/04 | Machine | $53,327 | $25.64 | 10 | 12 | 45 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1150 | 04/26/13 | Machine | $30,808 | $14.81 | 2 | 12 | 21 | No | 1 | 1 | 2 | IL | Midwest |
| 1153 | 02/05/12 | Sr Mach | $66,843 | $32.14 | 3 | 12 | 30 | No | 3 | 1 | 1 | IL | Midwest |
| 1156 | 05/21/11 | Machine | $33,395 | $16.06 | 4 | 12 | 26 | No | 3 | 1 | 2 | IL | Midwest |
| 1167 | 11/15/11 | Machine | $32,766 | $15.75 | 3 | 12 | 24 | No | 3 | 1 | 1 | PA | Northeast |
| 1169 | 01/22/09 | Machine | $40,871 | $19.65 | 6 | 12 | 34 | No | 3 | 1 | 1 | PA | Northeast |
| 1175 | 09/25/02 | Machine | $54,886 | $26.39 | 12 | 14 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1180 | 01/24/05 | Machine | $52,469 | $25.23 | 10 | 12 | 45 | No | 1 | 1 | 1 | NE | C-Plains |
| 1185 | 04/16/09 | Machine | $37,914 | $18.23 | 6 | 12 | 33 | No | 1 | 1 | 1 | PA | Northeast |
| 1186 | 08/14/05 | Machine | $50,636 | $24.34 | 9 | 12 | 43 | No | 3 | 1 | 1 | NE | C-Plains |
| 1188 | 05/16/09 | Engineering | $83,198 | $40.00 | 6 | 19 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1189 | 02/12/10 | Sales | $70,520 | $33.90 | 5 | 16 | 40 | No | 2 | 2 | 1 | PA | Northeast |
| 1190 | 5/9/02 | Machine | $55,716 | $26.79 | 13 | 12 | 48 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1190 | 8/31/99 | Machine | $59,147 | $28.44 | 15 | 14 | 53 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1196 | 09/08/09 | Machine | $35,327 | $16.98 | 5 | 12 | 30 | No | 3 | 1 | 1 | IL | Midwest |
| 1198 | 09/17/10 | Gen Shop | $23,484 | $11.29 | 4 | 12 | 22 | No | 1 | 1 | 1 | PA | Northeast |
| 1201 | 08/01/08 | Machine | $43,003 | $20.67 | 6 | 12 | 35 | No | 3 | 1 | 1 | IL | Midwest |
| 1202 | 03/15/99 | Acctg/Fin | $85,123 | $40.92 | 16 | 16 | 48 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1210 | 09/10/06 | Machine | $50,133 | $24.10 | 8 | 12 | 40 | No | 3 | 1 | 1 | NE | C-Plains |
| 1215 | 05/06/07 | Engineering | $86,673 | $41.67 | 8 | 19 | 43 | No | 2 | 1 | 1 | PA | Northeast |
| 1216 | 07/12/06 | Shipping | $52,654 | $25.31 | 8 | 14 | 40 | No | 1 | 1 | 1 | PA | Northeast |
| 1218 | 07/23/09 | Design | $64,504 | $31.01 | 5 | 16 | 34 | No | 1 | 1 | 2 | PA | Northeast |
| 1220 | 10/16/02 | Machine | $54,368 | $26.14 | 12 | 12 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1220 | 04/15/00 | Sr Mach | $83,377 | $40.09 | 15 | 14 | 55 | Yes | 1 | 2 | 1 | IL | Midwest |
| 1224 | 09/23/13 | Engineering | $70,886 | $34.08 | 1 | 16 | 30 | No | 2 | 1 | 1 | PA | Northeast |
| 1226 | 06/02/07 | Gen Shop | $27,435 | $13.19 | 8 | 12 | 29 | No | 1 | 1 | 1 | IL | Midwest |
| 1227 | 05/03/00 | Invent | $65,234 | $31.36 | 15 | 14 | 45 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1227 | 04/25/06 | Machine | $50,320 | $24.19 | 9 | 12 | 41 | No | 3 | 1 | 2 | PA | Northeast |
| 1232 | 07/12/10 | Shipping | $37,456 | $18.01 | 4 | 12 | 28 | No | 3 | 1 | 1 | IL | Midwest |
| 1233 | 05/31/13 | Machine | $30,577 | $14.70 | 2 | 12 | 21 | No | 3 | 1 | 2 | NE | C-Plains |
| 1237 | 08/08/07 | Machine | $46,904 | $22.55 | 7 | 12 | 38 | No | 1 | 1 | 1 | IL | Midwest |
| 1246 | 07/27/00 | Sr Mach | $82,315 | $39.57 | 14 | 12 | 54 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1248 | 07/25/09 | Gen Shop | $26,156 | $12.58 | 5 | 12 | 25 | No | 3 | 1 | 1 | NE | C-Plains |
| 1254 | 02/02/09 | Machine | $39,755 | $19.11 | 6 | 12 | 34 | No | 2 | 1 | 1 | PA | Northeast |
| 1255 | 03/14/09 | Gen Shop | $26,621 | $12.80 | 6 | 12 | 27 | No | 3 | 1 | 2 | PA | Northeast |
| 1257 | 08/09/09 | Engineering | $85,463 | $41.09 | 5 | 19 | 38 | No | 3 | 1 | 1 | NE | C-Plains |
| 1257 | 03/11/10 | Machine | $34,232 | $16.46 | 5 | 12 | 28 | No | 3 | 1 | 2 | PA | Northeast |
| 1258 | 07/09/03 | Sr Mach | $70,234 | $33.77 | 11 | 12 | 46 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1261 | 04/13/13 | Machine | $30,165 | $14.50 | 2 | 12 | 20 | No | 3 | 1 | 2 | IL | Midwest |
| 1261 | 06/02/09 | Sr Mach | $68,014 | $32.70 | 6 | 12 | 33 | No | 1 | 2 | 2 | IL | Midwest |
| 1265 | 03/04/13 | Acctg/Fin | $29,632 | $14.25 | 2 | 16 | 24 | No | 1 | 1 | 2 | NE | C-Plains |
| 1265 | 07/08/11 | Engineering | $85,825 | $41.26 | 3 | 19 | 40 | No | 3 | 2 | 1 | NE | C-Plains |
| 1267 | 2/5/08 | Machine | $44,747 | $21.51 | 7 | 12 | 35 | No | 2 | 1 | 1 | IL | Midwest |
| 1269 | 03/14/07 | Design | $76,577 | $36.82 | 8 | 16 | 39 | No | 3 | 2 | 2 | NE | C-Plains |
| 1272 | 09/18/10 | IT Mgr | $100,515 | $48.32 | 4 | 19 | 52 | No | 3 | 1 | 1 | PA | Northeast |
| 1276 | 05/04/11 | IT Staff | $65,469 | $31.48 | 4 | 16 | 32 | No | 3 | 1 | 1 | NE | C-Plains |
| 1279 | 10/20/07 | Machine | $46,057 | $22.14 | 7 | 12 | 37 | No | 1 | 1 | 1 | NE | C-Plains |
| 1280 | 08/11/14 | Acctg/Fin | $29,442 | $14.15 | 0 | 16 | 22 | No | 3 | 2 | 1 | PA | Northeast |
| 1285 | 04/04/11 | Advertg | $53,064 | $25.51 | 4 | 16 | 26 | No | 3 | 2 | 2 | NE | C-Plains |
| 1288 | 03/25/10 | Sales | $70,708 | $33.99 | 5 | 16 | 41 | No | 1 | 1 | 2 | NE | C-Plains |
| 1289 | 09/05/11 | Gen Shop | $17,943 | $8.63 | 3 | 12 | 19 | No | 1 | 1 | 2 | NE | C-Plains |
| 1289 | 10/22/06 | Machine | $50,078 | $24.08 | 8 | 12 | 40 | No | 1 | 1 | 1 | IL | Midwest |
| 1292 | 05/13/01 | Machine | $56,815 | $27.31 | 14 | 14 | 50 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1295 | 07/08/12 | Purch | $45,670 | $21.96 | 2 | 12 | 30 | No | 3 | 2 | 1 | NE | C-Plains |
| 1296 | 05/05/00 | Gen Shop | $28,901 | $13.89 | 15 | 14 | 36 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1296 | 09/15/10 | Invent | $52,765 | $25.37 | 4 | 12 | 29 | No | 4 | 2 | 1 | IL | Midwest |
| 1296 | 09/23/11 | Quality | $53,487 | $25.71 | 3 | 16 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1297 | 06/06/05 | Sr Mach | $69,628 | $33.48 | 10 | 12 | 41 | No | 3 | 1 | 2 | IL | Midwest |
| 1299 | 04/08/09 | Shp Mgr | $85,286 | $41.00 | 6 | 16 | 47 | No | 1 | 1 | 1 | PA | Northeast |
| 1300 | 07/10/09 | Engineering | $80,637 | $38.77 | 5 | 16 | 36 | No | 3 | 2 | 1 | PA | Northeast |
| 1300 | 06/17/09 | Machine | $36,882 | $17.73 | 6 | 12 | 32 | No | 3 | 1 | 2 | PA | Northeast |
| 1308 | 04/03/10 | Engineering | $75,261 | $36.18 | 5 | 16 | 31 | No | 3 | 1 | 1 | NE | C-Plains |
| 1308 | 06/30/01 | IT Staff | $88,698 | $42.64 | 14 | 19 | 43 | Yes | 2 | 2 | 1 | IL | Midwest |
| 1308 | 4/30/00 | Machine | $58,742 | $28.24 | 15 | 14 | 51 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1314 | 1/22/08 | Machine | $44,765 | $21.52 | 7 | 12 | 35 | No | 1 | 1 | 1 | IL | Midwest |
| 1315 | 02/15/07 | Machine | $49,672 | $23.88 | 8 | 12 | 39 | No | 3 | 1 | 1 | IL | Midwest |
| 1315 | 02/07/08 | Sr Mach | $68,913 | $33.13 | 7 | 12 | 34 | No | 4 | 1 | 1 | PA | Northeast |
| 1317 | 08/12/08 | Sr Mach | $68,677 | $33.02 | 6 | 12 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1320 | 06/18/09 | Gen Shop | $26,351 | $12.67 | 6 | 14 | 27 | No | 4 | 1 | 2 | IL | Midwest |
| 1320 | 09/01/12 | Machine | $31,170 | $14.99 | 2 | 12 | 22 | No | 4 | 2 | 2 | PA | Northeast |
| 1320 | 05/07/11 | Sr Mach | $67,380 | $32.39 | 4 | 12 | 31 | No | 1 | 1 | 2 | NE | C-Plains |
| 1323 | 02/05/05 | Machine | $52,235 | $25.11 | 10 | 12 | 44 | No | 4 | 1 | 2 | IL | Midwest |
| 1325 | 03/15/99 | Sr Mach | $83,413 | $40.10 | 16 | 14 | 57 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1329 | 09/20/09 | Gen Shop | $26,020 | $12.51 | 5 | 14 | 25 | No | 1 | 1 | 1 | PA | Northeast |
| 1332 | 04/12/11 | Shipping | $36,789 | $17.69 | 4 | 12 | 24 | No | 3 | 1 | 2 | PA | Northeast |
| 1339 | 05/01/12 | Machine | $31,992 | $15.38 | 3 | 12 | 24 | No | 3 | 1 | 2 | NE | C-Plains |
| 1341 | 03/07/04 | Gen Shop | $28,325 | $13.62 | 11 | 14 | 32 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1343 | 04/15/10 | Gen Shop | $21,897 | $10.53 | 5 | 12 | 22 | No | 1 | 1 | 2 | IL | Midwest |
| 1343 | 12/18/07 | Machine | $44,860 | $21.57 | 7 | 12 | 36 | No | 1 | 1 | 1 | IL | Midwest |
| 1346 | 06/12/10 | Sr Mach | $67,679 | $32.54 | 5 | 12 | 31 | No | 3 | 1 | 1 | PA | Northeast |
| 1350 | 06/21/12 | Admin | $21,387 | $10.28 | 3 | 12 | 23 | No | 3 | 2 | 2 | NE | C-Plains |
| 1356 | 09/19/10 | Sr Sales Mgr | $84,068 | $40.42 | 4 | 16 | 48 | No | 3 | 2 | 1 | NE | C-Plains |
| 1357 | 03/15/99 | Advertg | $99,741 | $47.95 | 16 | 16 | 52 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1357 | 04/08/05 | COO | $105,779 | $50.86 | 10 | 19 | 39 | No | 3 | 1 | 2 | PA | Northeast |
| 1364 | 3/16/08 | Machine | $44,576 | $21.43 | 7 | 12 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1364 | 04/20/05 | Machine | $51,431 | $24.73 | 10 | 12 | 44 | No | 1 | 1 | 2 | IL | Midwest |
| 1373 | 04/08/09 | Machine | $38,873 | $18.69 | 6 | 12 | 33 | No | 4 | 1 | 1 | PA | Northeast |
| 1373 | 06/25/07 | Machine | $47,648 | $22.91 | 8 | 12 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1378 | 07/09/10 | Machine | $33,968 | $16.33 | 4 | 12 | 28 | No | 3 | 1 | 1 | PA | Northeast |
| 1379 | 06/09/07 | Mrktg | $81,191 | $39.03 | 8 | 16 | 36 | No | 1 | 1 | 1 | NE | C-Plains |
| 1381 | 10/23/10 | Sales | $72,181 | $34.70 | 4 | 16 | 52 | No | 3 | 1 | 1 | IL | Midwest |
| 1387 | 07/14/09 | Gen Shop | $26,163 | $12.58 | 5 | 12 | 26 | No | 1 | 1 | 2 | NE | C-Plains |
| 1387 | 12/18/07 | Machine | $45,130 | $21.70 | 7 | 12 | 36 | No | 1 | 1 | 2 | IL | Midwest |
| 1387 | 07/23/05 | Machine | $50,914 | $24.48 | 9 | 12 | 43 | No | 3 | 1 | 1 | IL | Midwest |
| 1391 | 05/30/09 | Machine | $37,084 | $17.83 | 6 | 12 | 32 | No | 3 | 1 | 2 | NE | C-Plains |
| 1393 | 2/3/01 | Machine | $57,643 | $27.71 | 14 | 12 | 51 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1394 | 04/30/00 | Machine | $58,640 | $28.19 | 15 | 16 | 51 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1400 | 06/16/05 | Design | $80,483 | $38.69 | 10 | 16 | 46 | No | 3 | 1 | 2 | NE | C-Plains |
| 1402 | 08/17/11 | Machine | $32,812 | $15.78 | 3 | 12 | 26 | No | 4 | 1 | 1 | IL | Midwest |
| 1403 | 12/01/10 | Sales | $71,265 | $34.26 | 4 | 16 | 42 | No | 3 | 2 | 1 | IL | Midwest |
| 1404 | 10/15/11 | Gen Shop | $18,097 | $8.70 | 3 | 14 | 19 | No | 3 | 1 | 2 | PA | Northeast |
| 1405 | 08/13/07 | Gen Shop | $28,537 | $13.72 | 7 | 14 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1411 | 03/05/09 | Design | $61,333 | $29.49 | 6 | 16 | 30 | No | 3 | 1 | 2 | NE | C-Plains |
| 1417 | 04/15/07 | Sr Mach | $69,102 | $33.22 | 8 | 12 | 34 | No | 4 | 1 | 1 | PA | Northeast |
| 1418 | 07/04/11 | Quality | $53,981 | $25.95 | 3 | 16 | 36 | No | 3 | 1 | 1 | IL | Midwest |
| 1422 | 05/30/09 | Machine | $36,918 | $17.75 | 6 | 12 | 32 | No | 1 | 1 | 1 | IL | Midwest |
| 1422 | 09/08/13 | Sales | $52,485 | $25.23 | 1 | 16 | 25 | No | 3 | 1 | 1 | NE | C-Plains |
| 1424 | 03/15/99 | Flr Supr | $75,737 | $36.41 | 16 | 14 | 45 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1424 | 01/14/10 | Machine | $34,512 | $16.59 | 5 | 12 | 29 | No | 3 | 1 | 2 | NE | C-Plains |
| 1424 | 02/15/13 | Sales | $55,460 | $26.66 | 2 | 16 | 32 | No | 1 | 2 | 2 | PA | Northeast |
| 1424 | 03/15/99 | Sr Mach | $84,505 | $40.63 | 16 | 14 | 59 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1426 | 10/20/07 | Machine | $45,934 | $22.08 | 7 | 12 | 37 | No | 3 | 1 | 1 | IL | Midwest |
| 1429 | 06/30/10 | Sr Mach | $67,692 | $32.54 | 5 | 12 | 32 | No | 1 | 1 | 1 | IL | Midwest |
| 1432 | 10/15/09 | Design | $71,204 | $34.23 | 5 | 16 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1434 | 01/21/07 | Machine | $49,797 | $23.94 | 8 | 12 | 39 | No | 2 | 1 | 1 | NE | C-Plains |
| 1442 | 01/08/12 | Admin | $22,415 | $10.78 | 3 | 12 | 25 | No | 1 | 2 | 2 | IL | Midwest |
| 1443 | 09/12/06 | Sr Mach | $69,372 | $33.35 | 8 | 12 | 40 | No | 3 | 1 | 1 | PA | Northeast |
| 1444 | 06/15/02 | Mrktg | $81,221 | $39.05 | 13 | 16 | 42 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1444 | 08/02/11 | Sales | $64,415 | $30.97 | 3 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1445 | 08/08/10 | Machine | $33,808 | $16.25 | 4 | 12 | 28 | No | 3 | 1 | 1 | NE | C-Plains |
| 1446 | 12/15/05 | Gen Shop | $27,574 | $13.26 | 9 | 14 | 30 | No | 4 | 1 | 2 | PA | Northeast |
| 1447 | 10/18/10 | Gen Shop | $23,971 | $11.52 | 4 | 12 | 23 | No | 1 | 1 | 2 | PA | Northeast |
| 1447 | 09/05/12 | Sales | $63,836 | $30.69 | 2 | 16 | 32 | No | 3 | 1 | 1 | NE | C-Plains |
| 1448 | 05/03/11 | Admin | $25,456 | $12.24 | 4 | 14 | 31 | No | 4 | 1 | 2 | PA | Northeast |
| 1450 | 01/22/09 | Machine | $40,705 | $19.57 | 6 | 12 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1452 | 11/06/06 | Machine | $49,838 | $23.96 | 8 | 12 | 39 | No | 3 | 1 | 1 | IL | Midwest |
| 1456 | 06/25/07 | Machine | $47,522 | $22.85 | 8 | 12 | 38 | No | 1 | 1 | 1 | NE | C-Plains |
| 1456 | 05/07/04 | Sr Mach | $69,997 | $33.65 | 11 | 12 | 41 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1461 | 10/12/10 | Advertg | $53,215 | $25.58 | 4 | 16 | 28 | No | 3 | 1 | 2 | IL | Midwest |
| 1466 | 03/19/09 | Machine | $39,634 | $19.05 | 6 | 12 | 34 | No | 1 | 1 | 1 | NE | C-Plains |
| 1466 | 05/04/12 | Sales | $64,329 | $30.93 | 3 | 16 | 33 | No | 3 | 1 | 2 | IL | Midwest |
| 1468 | 7/21/01 | Machine | $56,291 | $27.06 | 13 | 12 | 50 | Yes | 1 | 1 | 2 | NE | C-Plains |
| 1471 | 07/10/09 | Machine | $36,729 | $17.66 | 5 | 12 | 32 | No | 3 | 1 | 1 | PA | Northeast |
| 1474 | 03/25/09 | Machine | $39,331 | $18.91 | 6 | 12 | 34 | No | 3 | 1 | 1 | NE | C-Plains |
| 1476 | 05/23/11 | Purch | $48,560 | $23.35 | 4 | 14 | 32 | No | 3 | 2 | 1 | IL | Midwest |
| 1477 | 03/15/03 | Purch | $63,388 | $30.48 | 12 | 16 | 44 | Yes | 3 | 2 | 1 | PA | Northeast |
| 1477 | 01/15/12 | Shipping | $33,169 | $15.95 | 3 | 12 | 23 | No | 1 | 1 | 2 | PA | Northeast |
| 1481 | 09/06/03 | Machine | $54,158 | $26.04 | 11 | 12 | 47 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1484 | 03/04/09 | Shipping | $45,622 | $21.93 | 6 | 14 | 35 | No | 1 | 2 | 1 | PA | Northeast |
| 1492 | 10/25/01 | Machine | $55,936 | $26.89 | 13 | 12 | 49 | Yes | 1 | 1 | 2 | IL | Midwest |
| 1496 | 05/07/13 | Shipping | $31,035 | $14.92 | 2 | 12 | 19 | No | 1 | 1 | 2 | NE | C-Plains |
| 1498 | 02/22/11 | Machine | $33,574 | $16.14 | 4 | 12 | 27 | No | 1 | 1 | 1 | IL | Midwest |
| 1498 | 08/04/13 | Sr Mach | $65,283 | $31.39 | 1 | 12 | 28 | No | 4 | 2 | 1 | NE | C-Plains |
| 1504 | 03/14/05 | Machine | $52,104 | $25.05 | 10 | 12 | 44 | No | 1 | 1 | 1 | PA | Northeast |
| 1504 | 04/30/10 | Shipping | $38,455 | $18.49 | 5 | 12 | 28 | No | 3 | 2 | 1 | PA | Northeast |
| 1505 | 12/06/10 | Machine | $33,609 | $16.16 | 4 | 12 | 28 | No | 1 | 2 | 1 | IL | Midwest |
| 1506 | 06/27/04 | IT Staff | $88,517 | $42.56 | 11 | 19 | 43 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1507 | 04/15/14 | Gen Shop | $15,182 | $7.30 | 1 | 12 | 18 | No | 1 | 1 | 2 | IL | Midwest |
| 1513 | 08/14/03 | Machine | $54,358 | $26.13 | 11 | 12 | 47 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1515 | 05/01/00 | Acctg/Fin | $66,230 | $31.84 | 15 | 16 | 36 | Yes | 3 | 2 | 2 | NE | C-Plains |
| 1517 | 11/12/12 | Engineering | $62,572 | $30.08 | 2 | 16 | 26 | No | 1 | 2 | 2 | IL | Midwest |
| 1519 | 06/04/11 | Design | $63,010 | $30.29 | 4 | 16 | 33 | No | 3 | 1 | 2 | IL | Midwest |
| 1519 | 02/15/13 | Machine | $29,819 | $14.34 | 2 | 12 | 19 | No | 4 | 2 | 2 | NE | C-Plains |
| 1523 | 05/21/11 | Acctg/Fin | $50,767 | $24.41 | 4 | 16 | 35 | No | 2 | 1 | 2 | IL | Midwest |
| 1525 | 05/09/05 | Gen Shop | $27,633 | $13.29 | 10 | 12 | 30 | No | 3 | 1 | 2 | NE | C-Plains |
| 1527 | 03/15/99 | Machine | $59,872 | $28.78 | 16 | 12 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1529 | 10/16/11 | Machine | $32,797 | $15.77 | 3 | 12 | 24 | No | 3 | 1 | 1 | NE | C-Plains |
| 1531 | 04/07/13 | Design | $62,412 | $30.01 | 2 | 16 | 32 | No | 3 | 1 | 2 | PA | Northeast |
| 1533 | 12/28/07 | Machine | $45,283 | $21.77 | 7 | 12 | 36 | No | 3 | 1 | 1 | PA | Northeast |
| 1539 | 12/15/12 | Gen Shop | $18,102 | $8.70 | 2 | 14 | 21 | No | 3 | 1 | 2 | IL | Midwest |
| 1541 | 04/09/07 | Sr Mach | $69,128 | $33.23 | 8 | 12 | 36 | No | 3 | 1 | 1 | IL | Midwest |
| 1543 | 10/06/09 | Machine | $35,002 | $16.83 | 5 | 12 | 30 | No | 3 | 1 | 2 | IL | Midwest |
| 1550 | 02/19/14 | IT Staff | $55,067 | $26.47 | 1 | 16 | 28 | No | 1 | 2 | 2 | IL | Midwest |
| 1550 | 11/14/08 | Sr Mach | $68,317 | $32.84 | 6 | 12 | 33 | No | 3 | 1 | 1 | IL | Midwest |
| 1552 | 5/30/99 | Machine | $59,316 | $28.52 | 16 | 14 | 53 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1553 | 04/12/09 | Machine | $38,398 | $18.46 | 6 | 12 | 33 | No | 1 | 1 | 1 | NE | C-Plains |
| 1553 | 10/20/07 | Machine | $46,097 | $22.16 | 7 | 12 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1554 | 10/23/13 | Engineering | $62,458 | $30.03 | 1 | 16 | 26 | No | 2 | 2 | 2 | IL | Midwest |
| 1554 | 10/20/06 | Machine | $50,082 | $24.08 | 8 | 12 | 40 | No | 3 | 1 | 1 | NE | C-Plains |
| 1556 | 03/21/09 | Gen Shop | $26,466 | $12.72 | 6 | 12 | 27 | No | 4 | 1 | 2 | PA | Northeast |
| 1557 | 07/21/04 | Machine | $53,537 | $25.74 | 10 | 12 | 46 | Yes | 3 | 1 | 2 | NE | C-Plains |
| 1558 | 01/06/05 | Machine | $52,946 | $25.45 | 10 | 12 | 45 | No | 2 | 1 | 1 | PA | Northeast |
| 1560 | 05/06/12 | Gen Shop | $18,270 | $8.78 | 3 | 14 | 21 | No | 3 | 1 | 2 | PA | Northeast |
| 1565 | 03/16/07 | Machine | $48,712 | $23.42 | 8 | 12 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1568 | 08/07/12 | Shipping | $32,960 | $15.85 | 2 | 12 | 20 | No | 3 | 2 | 2 | IL | Midwest |
| 1568 | 02/07/10 | Sr Mach | $67,771 | $32.58 | 5 | 12 | 32 | No | 1 | 1 | 2 | NE | C-Plains |
| 1569 | 04/23/10 | Quality | $55,254 | $26.56 | 5 | 16 | 42 | No | 3 | 2 | 2 | IL | Midwest |
| 1571 | 04/16/09 | Machine | $37,917 | $18.23 | 6 | 12 | 33 | No | 4 | 1 | 2 | PA | Northeast |
| 1575 | 02/04/09 | Machine | $40,629 | $19.53 | 6 | 12 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1579 | 01/12/05 | Machine | $52,580 | $25.28 | 10 | 12 | 45 | No | 1 | 1 | 1 | IL | Midwest |
| 1580 | 09/16/10 | Gen Shop | $23,342 | $11.22 | 4 | 12 | 22 | No | 3 | 1 | 2 | PA | Northeast |
| 1584 | 03/15/99 | Machine | $60,239 | $28.96 | 16 | 16 | 54 | Yes | 1 | 1 | 2 | PA | Northeast |
| 1588 | 8/17/02 | Machine | $55,566 | $26.71 | 12 | 12 | 48 | Yes | 2 | 1 | 1 | PA | Northeast |
| 1589 | 04/15/13 | Design | $51,233 | $24.63 | 2 | 16 | 25 | No | 3 | 2 | 2 | IL | Midwest |
| 1591 | 7/12/08 | Machine | $43,213 | $20.78 | 6 | 12 | 35 | No | 3 | 1 | 1 | IL | Midwest |
| 1593 | 08/15/08 | Shipping | $47,891 | $23.02 | 6 | 12 | 38 | No | 1 | 2 | 1 | NE | C-Plains |
| 1596 | 06/12/09 | CFO | $131,276 | $63.11 | 6 | 19 | 42 | No | 3 | 1 | 2 | PA | Northeast |
| 1597 | 11/20/11 | Flr Supr | $70,293 | $33.79 | 3 | 16 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1598 | 02/15/13 | Machine | $29,661 | $14.26 | 2 | 12 | 19 | No | 3 | 1 | 2 | PA | Northeast |
| 1608 | 03/15/99 | Flr Supr | $75,375 | $36.24 | 16 | 16 | 44 | Yes | 3 | 2 | 1 | IL | Midwest |
| 1608 | 04/15/09 | Sales | $73,258 | $35.22 | 6 | 19 | 53 | No | 3 | 1 | 1 | PA | Northeast |
| 1609 | 07/20/11 | Machine | $33,266 | $15.99 | 3 | 12 | 26 | No | 3 | 1 | 2 | NE | C-Plains |
| 1611 | 09/23/07 | Machine | $46,378 | $22.30 | 7 | 12 | 38 | No | 3 | 1 | 1 | PA | Northeast |
| 1612 | 03/06/11 | Shipping | $37,800 | $18.17 | 4 | 12 | 25 | No | 2 | 1 | 1 | NE | C-Plains |
| 1613 | 05/04/12 | Machine | $32,496 | $15.62 | 3 | 12 | 24 | No | 1 | 1 | 1 | PA | Northeast |
| 1616 | 09/15/09 | Advertg | $65,027 | $31.26 | 5 | 16 | 34 | No | 3 | 2 | 2 | PA | Northeast |
| 1616 | 08/09/06 | Engineering | $86,818 | $41.74 | 8 | 19 | 48 | No | 3 | 1 | 1 | NE | C-Plains |
| 1619 | 11/3/07 | Machine | $45,641 | $21.94 | 7 | 12 | 36 | No | 3 | 1 | 1 | NE | C-Plains |
| 1620 | 06/07/13 | Gen Shop | $15,248 | $7.33 | 2 | 12 | 18 | No | 1 | 2 | 2 | NE | C-Plains |
| 1622 | 02/06/12 | Shipping | $33,047 | $15.89 | 3 | 12 | 21 | No | 3 | 2 | 2 | PA | Northeast |
| 1623 | 03/04/12 | Engineering | $64,153 | $30.84 | 3 | 16 | 28 | No | 2 | 1 | 1 | IL | Midwest |
| 1625 | 09/12/09 | Purch | $60,346 | $29.01 | 5 | 16 | 31 | No | 3 | 1 | 1 | IL | Midwest |
| 1626 | 07/08/12 | Gen Shop | $19,141 | $9.20 | 2 | 14 | 21 | No | 3 | 2 | 2 | NE | C-Plains |
| 1629 | 09/04/11 | Shipping | $35,550 | $17.09 | 3 | 12 | 24 | No | 1 | 1 | 1 | IL | Midwest |
| 1630 | 09/12/08 | Shipping | $47,650 | $22.91 | 6 | 12 | 36 | No | 3 | 1 | 1 | IL | Midwest |
| 1636 | 04/17/09 | Gen Shop | $25,671 | $12.34 | 6 | 12 | 24 | No | 4 | 1 | 1 | NE | C-Plains |
| 1637 | 06/07/11 | Sales | $64,494 | $31.01 | 4 | 16 | 37 | No | 4 | 1 | 1 | PA | Northeast |
| 1638 | 09/01/07 | Machine | $46,787 | $22.49 | 7 | 12 | 38 | No | 3 | 1 | 2 | IL | Midwest |
| 1639 | 07/30/12 | Machine | $31,567 | $15.18 | 2 | 12 | 23 | No | 1 | 1 | 2 | PA | Northeast |
| 1640 | 08/13/07 | Design | $77,045 | $37.04 | 7 | 16 | 42 | No | 3 | 1 | 1 | PA | Northeast |
| 1644 | 09/05/11 | Gen Shop | $17,598 | $8.46 | 3 | 12 | 19 | No | 3 | 1 | 2 | PA | Northeast |
| 1654 | 06/07/11 | Engineering | $79,709 | $38.32 | 4 | 16 | 35 | No | 3 | 2 | 1 | NE | C-Plains |
| 1658 | 03/22/10 | Admin | $32,300 | $15.53 | 5 | 16 | 33 | No | 1 | 2 | 2 | PA | Northeast |
| 1659 | 11/02/06 | Machine | $49,925 | $24.00 | 8 | 12 | 40 | No | 1 | 1 | 2 | NE | C-Plains |
| 1660 | 01/14/10 | Machine | $34,420 | $16.55 | 5 | 12 | 28 | No | 1 | 2 | 1 | PA | Northeast |
| 1661 | 03/18/13 | Sales | $52,300 | $25.14 | 2 | 16 | 28 | No | 3 | 2 | 1 | IL | Midwest |
| 1661 | 11/18/11 | Shipping | $34,456 | $16.57 | 3 | 12 | 23 | No | 1 | 2 | 2 | NE | C-Plains |
| 1667 | 01/15/08 | Engineering | $86,096 | $41.39 | 7 | 16 | 40 | No | 3 | 1 | 1 | PA | Northeast |
| 1667 | 03/14/05 | Machine | $51,554 | $24.79 | 10 | 12 | 44 | No | 3 | 1 | 1 | PA | Northeast |
| 1668 | 05/01/00 | Advertg | $65,089 | $31.29 | 15 | 16 | 35 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1668 | 07/10/09 | Machine | $35,688 | $17.16 | 5 | 12 | 32 | No | 4 | 1 | 2 | PA | Northeast |
| 1669 | 09/05/11 | Design | $61,882 | $29.75 | 3 | 16 | 32 | No | 3 | 2 | 1 | PA | Northeast |
| 1671 | 06/13/12 | Machine | $31,809 | $15.29 | 3 | 12 | 23 | No | 3 | 1 | 1 | IL | Midwest |
| 1672 | 05/04/08 | Sr Flr Mgr | $96,546 | $46.42 | 7 | 12 | 38 | No | 3 | 1 | 1 | IL | Midwest |
| 1673 | 03/07/13 | Mrktg | $67,415 | $32.41 | 2 | 16 | 35 | No | 3 | 2 | 1 | IL | Midwest |
| 1679 | 05/18/09 | Acctg/Fin | $66,109 | $31.78 | 6 | 16 | 39 | No | 3 | 1 | 1 | PA | Northeast |
| 1680 | 01/06/13 | Design | $51,226 | $24.63 | 2 | 16 | 24 | No | 1 | 1 | 2 | IL | Midwest |
| 1687 | 12/15/05 | Gen Shop | $27,541 | $13.24 | 9 | 14 | 30 | No | 1 | 1 | 1 | NE | C-Plains |
| 1687 | 06/02/04 | Machine | $53,784 | $25.86 | 11 | 12 | 46 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1693 | 03/15/99 | Engineering | $93,678 | $45.04 | 16 | 19 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1709 | 09/20/05 | Machine | $50,522 | $24.29 | 9 | 12 | 43 | No | 1 | 1 | 1 | IL | Midwest |
| 1723 | 06/02/12 | Gen Shop | $19,397 | $9.33 | 3 | 14 | 21 | No | 3 | 1 | 2 | PA | Northeast |
| 1723 | 11/10/07 | Machine | $45,495 | $21.87 | 7 | 12 | 36 | No | 1 | 1 | 1 | PA | Northeast |
| 1726 | 03/15/99 | Design | $81,159 | $39.02 | 16 | 19 | 56 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1733 | 09/18/13 | Flr Supr | $65,780 | $31.63 | 1 | 16 | 32 | No | 1 | 2 | 1 | PA | Northeast |
| 1736 | 09/18/07 | Gen Shop | $27,221 | $13.09 | 7 | 12 | 28 | No | 3 | 2 | 2 | PA | Northeast |
| 1736 | 04/01/09 | Machine | $39,130 | $18.81 | 6 | 12 | 33 | No | 3 | 1 | 2 | IL | Midwest |
| 1737 | 03/15/99 | Invent | $76,188 | $36.63 | 16 | 16 | 52 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1741 | 03/30/09 | Machine | $39,191 | $18.84 | 6 | 12 | 34 | No | 3 | 1 | 1 | IL | Midwest |
| 1744 | 06/15/11 | Eng Mgr | $110,233 | $53.00 | 4 | 19 | 45 | No | 3 | 1 | 1 | PA | Northeast |
| 1744 | 08/16/06 | Gen Shop | $28,486 | $13.70 | 8 | 12 | 32 | No | 1 | 1 | 1 | NE | C-Plains |
| 1744 | 11/12/07 | Machine | $45,317 | $21.79 | 7 | 12 | 36 | No | 3 | 1 | 1 | NE | C-Plains |
| 1745 | 06/10/10 | Machine | $34,196 | $16.44 | 5 | 12 | 28 | No | 4 | 1 | 1 | PA | Northeast |
| 1748 | 08/25/10 | Mrktg | $68,352 | $32.86 | 4 | 16 | 35 | No | 3 | 2 | 1 | PA | Northeast |
| 1749 | 08/14/00 | Sr Mach | $82,777 | $39.80 | 14 | 12 | 56 | Yes | 1 | 1 | 2 | NE | C-Plains |
| 1750 | 06/22/10 | Gen Shop | $21,828 | $10.49 | 5 | 14 | 22 | No | 3 | 1 | 2 | NE | C-Plains |
| 1750 | 08/13/09 | Machine | $35,536 | $17.08 | 5 | 12 | 31 | No | 1 | 1 | 1 | IL | Midwest |
| 1754 | 05/06/03 | Sr Mach | $70,507 | $33.90 | 12 | 12 | 48 | Yes | 1 | 1 | 1 | PA | Northeast |
| 1756 | 05/13/01 | Machine | $56,888 | $27.35 | 14 | 12 | 50 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1756 | 07/01/09 | Sr Flr Mgr | $93,478 | $44.94 | 6 | 16 | 42 | No | 3 | 1 | 1 | PA | Northeast |
| 1757 | 2/16/02 | Machine | $55,840 | $26.85 | 13 | 12 | 49 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1760 | 02/04/11 | Design | $60,348 | $29.01 | 4 | 16 | 28 | No | 2 | 1 | 2 | PA | Northeast |
| 1760 | 09/15/12 | Machine | $31,049 | $14.93 | 2 | 12 | 22 | No | 3 | 1 | 2 | IL | Midwest |
| 1764 | 6/17/01 | Machine | $57,530 | $27.66 | 14 | 12 | 50 | Yes | 3 | 1 | 2 | IL | Midwest |
| 1767 | 05/20/05 | Machine | $51,360 | $24.69 | 10 | 12 | 44 | No | 3 | 1 | 1 | IL | Midwest |
| 1770 | 03/06/04 | Engineering | $86,972 | $41.81 | 11 | 16 | 48 | Yes | 3 | 1 | 1 | NE | C-Plains |
| 1771 | 03/14/05 | Machine | $51,899 | $24.95 | 10 | 12 | 44 | No | 3 | 1 | 1 | PA | Northeast |
| 1773 | 06/07/05 | Purch | $60,999 | $29.33 | 10 | 16 | 42 | No | 3 | 1 | 2 | PA | Northeast |
| 1774 | 10/25/13 | Flr Supr | $68,455 | $32.91 | 1 | 16 | 33 | No | 3 | 2 | 1 | NE | C-Plains |
| 1776 | 11/13/09 | Design | $61,441 | $29.54 | 5 | 16 | 30 | No | 3 | 2 | 2 | IL | Midwest |
| 1776 | 03/15/99 | Machine | $60,198 | $28.94 | 16 | 12 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1779 | 09/07/10 | Machine | $33,631 | $16.17 | 4 | 12 | 28 | No | 3 | 1 | 1 | NE | C-Plains |
| 1779 | 06/01/05 | Machine | $51,084 | $24.56 | 10 | 12 | 43 | No | 3 | 1 | 1 | IL | Midwest |
| 1782 | 03/04/04 | Machine | $53,903 | $25.91 | 11 | 12 | 46 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1785 | 07/06/06 | Engineering | $86,972 | $41.81 | 8 | 16 | 50 | No | 3 | 1 | 1 | IL | Midwest |
| 1785 | 09/21/09 | Gen Shop | $26,096 | $12.55 | 5 | 14 | 25 | No | 4 | 1 | 2 | IL | Midwest |
| 1785 | 02/08/10 | Shipping | $42,456 | $20.41 | 5 | 12 | 32 | No | 3 | 2 | 1 | PA | Northeast |
| 1787 | 07/21/07 | Acctg/Fin | $66,261 | $31.86 | 7 | 16 | 45 | No | 3 | 1 | 1 | IL | Midwest |
| 1789 | 09/23/08 | Machine | $42,802 | $20.58 | 6 | 12 | 35 | No | 3 | 1 | 1 | PA | Northeast |
| 1793 | 03/15/99 | Design | $81,077 | $38.98 | 16 | 19 | 54 | Yes | 1 | 1 | 1 | IL | Midwest |
| 1793 | 09/07/07 | Shipping | $50,788 | $24.42 | 7 | 14 | 40 | No | 3 | 2 | 1 | IL | Midwest |
| 1793 | 09/08/08 | Sr Sales Mgr | $90,822 | $43.66 | 6 | 19 | 50 | No | 3 | 1 | 2 | IL | Midwest |
| 1794 | 01/14/14 | Engineering | $60,323 | $29.00 | 1 | 16 | 24 | No | 3 | 1 | 2 | PA | Northeast |
| 1796 | 03/14/10 | Sales Mgr | $101,275 | $48.69 | 5 | 19 | 43 | No | 3 | 1 | 1 | PA | Northeast |
| 1797 | 02/08/03 | Sr Mach | $70,084 | $33.69 | 12 | 12 | 44 | Yes | 2 | 1 | 1 | NE | C-Plains |
| 1800 | 05/14/09 | Machine | $36,918 | $17.75 | 6 | 12 | 32 | No | 1 | 1 | 1 | PA | Northeast |
| 1800 | 03/15/99 | Machine | $59,647 | $28.68 | 16 | 14 | 54 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1802 | 5/31/08 | Machine | $43,498 | $20.91 | 7 | 12 | 35 | No | 4 | 1 | 1 | NE | C-Plains |
| 1803 | 09/30/00 | Mrktg | $81,282 | $39.08 | 14 | 16 | 45 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1804 | 08/19/09 | Quality | $64,510 | $31.01 | 5 | 16 | 46 | No | 1 | 2 | 1 | PA | Northeast |
| 1809 | 10/16/01 | Machine | $56,946 | $27.38 | 13 | 12 | 50 | Yes | 1 | 1 | 1 | NE | C-Plains |
| 1812 | 04/06/05 | Gen Shop | $27,781 | $13.36 | 10 | 12 | 30 | No | 1 | 1 | 1 | PA | Northeast |
| 1813 | 01/15/03 | Machine | $53,922 | $25.92 | 12 | 12 | 47 | Yes | 1 | 1 | 2 | IL | Midwest |
| 1814 | 08/19/11 | Sr Sales Mgr | $87,102 | $41.88 | 3 | 16 | 53 | No | 1 | 1 | 1 | PA | Northeast |
| 1815 | 08/17/11 | Machine | $33,244 | $15.98 | 3 | 12 | 26 | No | 3 | 1 | 1 | NE | C-Plains |
| 1816 | 04/16/09 | Machine | $37,144 | $17.86 | 6 | 12 | 33 | No | 3 | 1 | 1 | NE | C-Plains |
| 1819 | 10/06/09 | Machine | $34,804 | $16.73 | 5 | 12 | 30 | No | 2 | 1 | 1 | IL | Midwest |
| 1820 | 08/06/09 | Shipping | $44,236 | $21.27 | 5 | 12 | 32 | No | 3 | 1 | 1 | NE | C-Plains |
| 1821 | 09/13/06 | Machine | $50,130 | $24.10 | 8 | 12 | 40 | No | 3 | 1 | 1 | PA | Northeast |
| 1822 | 05/02/07 | Engineering | $81,691 | $39.27 | 8 | 16 | 36 | No | 3 | 1 | 1 | NE | C-Plains |
| 1824 | 04/13/13 | Machine | $30,089 | $14.47 | 2 | 12 | 20 | No | 1 | 2 | 2 | NE | C-Plains |
| 1829 | 03/01/07 | Machine | $48,826 | $23.47 | 8 | 12 | 39 | No | 1 | 1 | 1 | PA | Northeast |
| 1830 | 1/15/00 | Machine | $58,928 | $28.33 | 15 | 14 | 52 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1831 | 08/16/12 | Sr Mach | $65,938 | $31.70 | 2 | 12 | 29 | No | 1 | 2 | 1 | PA | Northeast |
| 1835 | 06/07/13 | Sr Mach | $65,556 | $31.52 | 2 | 12 | 29 | No | 4 | 1 | 1 | NE | C-Plains |
| 1836 | 08/12/06 | Machine | $50,199 | $24.13 | 8 | 12 | 41 | No | 1 | 1 | 1 | NE | C-Plains |
| 1840 | 2/16/00 | Machine | $58,792 | $28.27 | 15 | 12 | 52 | Yes | 3 | 1 | 1 | IL | Midwest |
| 1841 | 06/07/07 | Design | $79,865 | $38.40 | 8 | 16 | 45 | No | 2 | 1 | 2 | PA | Northeast |
| 1841 | 08/05/13 | Sr Mach | $65,117 | $31.31 | 1 | 12 | 28 | No | 3 | 1 | 1 | PA | Northeast |
| 1846 | 04/23/09 | Design | $80,113 | $38.52 | 6 | 19 | 46 | No | 3 | 2 | 2 | PA | Northeast |
| 1846 | 03/05/13 | Engineering | $60,324 | $29.00 | 2 | 16 | 24 | No | 3 | 1 | 1 | IL | Midwest |
| 1846 | 08/30/04 | Machine | $53,369 | $25.66 | 10 | 12 | 46 | Yes | 2 | 1 | 1 | PA | Northeast |
| 1848 | 12/15/09 | Design | $80,722 | $38.81 | 5 | 19 | 52 | No | 3 | 1 | 1 | PA | Northeast |
| 1848 | 06/05/04 | Gen Shop | $28,344 | $13.63 | 11 | 12 | 32 | Yes | 3 | 1 | 1 | PA | Northeast |
| 1850 | 11/20/10 | Gen Shop | $24,060 | $11.57 | 4 | 12 | 24 | No | 3 | 1 | 2 | PA | Northeast |
| 1850 | 08/05/07 | Invent | $58,068 | $27.92 | 7 | 12 | 30 | No | 3 | 2 | 1 | IL | Midwest |
| Region Key | |||||||||||||
| State | Region | # | % | ||||||||||
| PA | Northeast | 148 | 39.78% | ||||||||||
| IL | Midwest | 123 | 33.06% | ||||||||||
| NE | C-Plains | 101 | 27.15% | ||||||||||
| 372 | 100.00% | ||||||||||||
Sorted Data Instruction-Cooksey
Cooksey Comment: Hi Nana, It looks like that you did not sort the data and compute the subtotal of the salary by region. Here are the steps how I arrived at my solution. First you need to sort the data by region using the filter funnel. See the first screenshot below. Then, use the subtotal feature to subtotal the salary for each of the three regions. Set up your subtotal fields as displayed in the second screenshot below. Finally, review the resource provided in Step 8 about sorting data and using the subtotal feature. The link is: https://www.gcflearnfree.org/excel2010/outlining-data/2/ You should be able to generate the correct output now as presented in the third screenshot below.
