ID Name Age Department Salary Performance Rating
1 Employee_1 48 Finance 90490 5
2 Employee_2 59 Finance 185324 4
3 Employee_3 57 Finance 95359 4
4 Employee_4 40 Marketing 21836 5
5 Employee_5 48 IT 26199 5
6 Employee_6 34 Marketing 143271 1
7 Employee_7 58 Finance 128846 5
8 Employee_8 29 HR 75033 4
9 Employee_9 23 Sales 107577 5
10 Employee_10 23 Finance 189360 1
11 Employee_11 49 HR 154194 1
12 Employee_12 26 IT 167226 1
13 Employee_13 55 Finance 38297 1
14 Employee_14 60 HR 121148 3
15 Employee_15 37 Finance 73620 5
16 Employee_16 32 Marketing 120851 2
17 Employee_17 31 HR 122434 5
18 Employee_18 35 Marketing 81756 3
19 Employee_19 33 Marketing 127173 1
20 Employee_20 26 HR 37013 3
AVERAGE 105350.35
MEDIAN 114214
MODE 5
STANDARD DEV 49055.903693
VLOOKUP Employee_1
HLOOKUP Sales
Location Department Sum of Salary
Austin 531833
Tota
Finance 404660
Marketing 127173 12
Boston 238343
Finance 95359
10
HR 121148
Marketing 21836
Chicago 717214
8
Finance 189360
HR 276628
IT 26199 6
Marketing 225027
New York 438420
Finance 38297 4
HR 112046
IT 167226
Marketing 120851 2
0
Austin Boston Chicago Ne
4
2
San Francisco 181197
Finance 73620
Sales 107577 0
Austin Boston Chicago Ne
Total Result 2107007
Location Years at Company Bonus Salary based on years of service
Austin 6 9049 99539
Austin 3 18532.4 185324
Boston 6 9535.9 104894.9
Boston 10 2183.6 24019.6
Chicago 6 2619.9 28818.9
Chicago 5 7163.55 143271
Austin 2 12884.6 128846
New York 10 7503.3 82536.3
San Francisco 10 10757.7 118334.7
Chicago 2 9468 189360
Chicago 7 7709.7 169613.4
New York 2 8361.3 167226
New York 6 1914.85 42126.7
Boston 5 8480.36 121148
San Francisco 4 7362 73620
New York 7 6042.55 132936.1
Chicago 8 12243.4 134677.4
Chicago 4 5722.92 81756
Austin 1 6358.65 127173
New York 1 2590.91 37013
Total
Department
Chicago New York San Francisco Total Result
Chicago New York San Francisco Total Result
