Analytics

ellacoco
AssignmentData.xlsx
Home>Business & Finance homework help>Management homework help>Analytics

Sheet1

Mixed Split
Emp.ID Name Job Grade Annual Leave Basic Salary Current Gross
1 John 10 30 25,500 39,250
2 Peter 10 30 20,752 35,418
3 Mary 9 30 79,879 110,546
4 Angi 9 30 54,476 74,726
5 Thierry 13 42 13,283 20,283
6 Kayla 15 42 8,154 20,385
7 Ella 8 30 16,509 25,842
8 Mabel 12 42 18,200 27,533
9 Eric 14 42 40,584 58,084
10 Nelly 8 30 46,536 66,786
11 Fana 8 30 33,253 50,753
12 Shan 10 30 22,419 37,825
13 Omer 15 42 30,000 44,666
14 Lily 7 30 15,590 24,923
15 Marline 7 30 7,300 11,967
16 Xira 9 30 20,824 34,574
17 Emilia 8 30 50,000 64,840
18 Emile 16 42 24,500 38,250
19 Roland 10 30 24,500 38,250
20 Glen 8 30 7,767 13,350
21 Ricard 9 30 25,011 41,801
22 Geny 12 42 27,561 44,351
23 Macknel 8 30 24,000 37,750
24 Neris 9 30 25,002 41,792
25 Dillard 17 42 7,439 12,106
26 Blend 12 42 19,768 34,991
27 Jude 14 42 8,500 13,167
28 Ryan 12 42 13,622 22,955
29 Juliette 15 42 16,072 29,822
30 Lucy 8 30 23,176 40,020
31 Passy 14 42 7,186 11,853
32 Aaron 9 30 15,853 26,080
33 Joan 9 30 27,512 44,415
34 McMillan 10 30 49,750 70,000
35 Felix 17 42 17,963 25,259
36 Fongang 15 42 14,896 21,896

Sheet8

Gaining Losing Out Gaining Losing Out
66 178 183 61
27% 73% 75% 25%

60:40 Split

Gaining Losing Out 183 61

Gaining Losing Out 0.75 0.25

60:40 Split

Gaining Losing Out 183 61

Gaining Losing Out 0.75 0.25

XDO_METADATA

BI Publisher Version XDO 6.0
Version 1
Template Code DPE_ERN_DED_RPT_v1.xsl
Last Modified Date :
last modified by : tdexter
Data Constraints:
XDO_?S_GROSS_SALARY? <?sum(.//GROSS_SALARY)?>
XDO_?S_NET_SALARY? <?sum(.//NET_SALARY)?>