EXCEL ASSINGMENTS
TolgaD5
P10_05.xlsxSource
This is fictitious data.
Data
| Employee | Salary Christopher J. Zappe: Current annual salary (in dollars). | Years Previous Experience Christopher J. Zappe: Number of years of relevant work experience prior to coming to DataCom. | Years Employed Christopher J. Zappe: Number of years employed at DataCom. | Years Education Christopher J. Zappe: Number years of education beyond high school. | Gender Christopher J. Zappe: 0=Female, 1=Male | Department Christopher J. Zappe: 1=Sales, 2=Purchasing, 3=Advertising, 4=Engineering. | Number Supervised Christopher J. Zappe: Number of employees supervised by this employee. |
| 1 | $65,487 | 0 | 27 | 12 | 1 | 4 | 44 |
| 2 | $46,184 | 3 | 20 | 4 | 0 | 4 | 1 |
| 3 | $32,782 | 1 | 0 | 7 | 0 | 1 | 0 |
| 4 | $54,899 | 5 | 12 | 8 | 1 | 4 | 0 |
| 5 | $34,869 | 5 | 7 | 4 | 1 | 4 | 1 |
| 6 | $35,487 | 2 | 8 | 2 | 1 | 4 | 2 |
| 7 | $26,548 | 1 | 5 | 0 | 0 | 4 | 2 |
| 8 | $32,920 | 3 | 15 | 9 | 1 | 1 | 4 |
| 9 | $29,548 | 6 | 5 | 1 | 0 | 1 | 0 |
| 10 | $34,231 | 2 | 6 | 6 | 0 | 4 | 3 |
| 11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 |
| 12 | $39,331 | 3 | 9 | 6 | 1 | 4 | 1 |
| 13 | $36,512 | 6 | 6 | 4 | 1 | 4 | 2 |
| 14 | $35,467 | 6 | 3 | 6 | 1 | 2 | 3 |
| 15 | $68,425 | 2 | 25 | 12 | 0 | 4 | 1 |
| 16 | $35,468 | 5 | 9 | 4 | 1 | 2 | 5 |
| 17 | $36,578 | 4 | 4 | 8 | 0 | 3 | 8 |
| 18 | $39,828 | 6 | 18 | 5 | 1 | 1 | 5 |
| 19 | $36,487 | 5 | 6 | 2 | 0 | 4 | 3 |
| 20 | $37,548 | 9 | 19 | 4 | 0 | 3 | 6 |
| 21 | $31,528 | 11 | 3 | 3 | 0 | 1 | 6 |
| 22 | $34,632 | 4 | 5 | 4 | 0 | 4 | 0 |
| 23 | $46,211 | 5 | 14 | 6 | 1 | 4 | 5 |
| 24 | $29,876 | 0 | 2 | 3 | 1 | 2 | 5 |
| 25 | $43,674 | 9 | 6 | 4 | 0 | 2 | 2 |
| 26 | $38,985 | 7 | 18 | 9 | 0 | 1 | 5 |
| 27 | $53,234 | 0 | 25 | 6 | 0 | 3 | 3 |
| 28 | $51,698 | 6 | 18 | 6 | 0 | 4 | 1 |
| 29 | $41,889 | 16 | 22 | 7 | 0 | 1 | 7 |
| 30 | $38,791 | 4 | 21 | 5 | 0 | 1 | 9 |
| 31 | $69,246 | 3 | 22 | 10 | 0 | 4 | 45 |
| 32 | $48,695 | 19 | 6 | 8 | 0 | 4 | 40 |
| 33 | $34,987 | 6 | 9 | 2 | 1 | 4 | 3 |
| 34 | $28,985 | 1 | 0 | 4 | 1 | 1 | 4 |
| 35 | $35,631 | 4 | 6 | 4 | 0 | 4 | 2 |
| 36 | $54,679 | 3 | 20 | 6 | 1 | 3 | 4 |
| 37 | $39,743 | 6 | 9 | 5 | 1 | 4 | 1 |
| 38 | $41,255 | 4 | 9 | 6 | 0 | 4 | 4 |
| 39 | $36,431 | 4 | 9 | 4 | 1 | 2 | 2 |
| 40 | $26,578 | 6 | 0 | 2 | 1 | 2 | 2 |
| 41 | $47,536 | 5 | 15 | 6 | 0 | 3 | 4 |
| 42 | $36,571 | 1 | 6 | 4 | 0 | 2 | 2 |
| 43 | $56,326 | 3 | 12 | 8 | 0 | 2 | 6 |
| 44 | $31,425 | 6 | 7 | 5 | 1 | 3 | 6 |
| 45 | $24,749 | 2 | 6 | 0 | 1 | 1 | 1 |
| 46 | $26,452 | 3 | 1 | 2 | 1 | 4 | 0 |
