Case Study - Compensation for Sales Professionals

profileMathematicsExpert
data.xlsx

Sheet1

Observation Salary (AED) Position Experience
1 173154 Inside Low
2 145863 Inside Low
3 166896 Inside Low
4 155844 Inside Low
5 160392 Inside Low
6 158499 Inside Low
7 167877 Inside Low
8 191397 Inside Low
9 162366 Inside Low
10 176442 Inside Low
11 177828 Inside Low
12 170970 Inside Low
13 169383 Inside Low
14 148266 Inside Low
15 173010 Inside Low
16 156216 Inside Low
17 153357 Inside Low
18 169056 Inside Low
19 164673 Inside Low
20 160392 Inside Low
21 211545 Outside Low
22 186849 Outside Low
23 191568 Outside Low
24 206574 Outside Low
25 190434 Outside Low
26 192864 Outside Low
27 214035 Outside Low
28 196638 Outside Low
29 198072 Outside Low
30 183384 Outside Low
31 182979 Outside Low
32 183897 Outside Low
33 205680 Outside Low
34 201711 Outside Low
35 186675 Outside Low
36 188643 Outside Low
37 185040 Outside Low
38 207426 Outside Low
39 181683 Inside Low
40 180777 Inside Low
41 193384 Inside Low
42 192979 Inside Low
43 193897 Inside Low
44 215680 Outside Low
45 211711 Outside Low
46 196675 Outside Low
47 198643 Outside Low
48 195040 Outside Low
49 217426 Outside Low
50 191683 Outside Low
51 190777 Outside Low
52 148266 Inside Low
53 173010 Inside Low
54 156216 Inside Low
55 153357 Inside Low
56 169056 Inside Low
57 164673 Inside Low
58 160392 Inside Low
59 211545 Outside Low
60 186849 Outside Low
61 191568 Outside Low
62 206574 Outside Low
63 190434 Outside Low
64 192864 Outside Low
65 214035 Outside Low
66 196638 Outside Low
67 211711 Outside Low
68 207864 Inside Medium
69 221574 Inside Medium
70 175392 Inside Medium
71 211638 Inside Medium
72 206397 Inside Medium
73 181896 Inside Medium
74 177366 Inside Medium
75 238545 Inside Medium
76 213072 Inside Medium
77 170844 Inside Medium
78 196683 Outside Medium
79 222426 Outside Medium
80 168357 Outside Medium
81 195777 Outside Medium
82 198897 Outside Medium
83 220680 Outside Medium
84 192828 Outside Medium
85 197979 Outside Medium
86 171216 Outside Medium
87 163266 Outside Medium
88 179673 Outside Medium
89 185970 Outside Medium
90 203643 Outside Medium
91 188010 Outside Medium
92 201675 Outside Medium
93 200040 Outside Medium
94 216711 Outside Medium
95 175392 Outside Medium
96 184383 Outside Medium
97 184056 Outside Medium
98 173266 Outside Medium
99 189673 Outside Medium
100 195970 Outside Medium
101 213643 Outside Medium
102 198010 Outside Medium
103 211675 Outside Medium
104 210040 Inside Medium
105 226711 Inside Medium
106 185392 Inside Medium
107 194383 Inside Medium
108 194056 Inside Medium
109 175392 Outside Medium
110 184383 Outside Medium
111 184056 Outside Medium
112 173266 Outside Medium
113 189673 Outside Medium
114 195970 Outside Medium
115 213643 Outside Medium
116 198010 Outside Medium
117 211675 Outside Medium
118 210040 Inside Medium
119 226711 Inside Medium
120 185392 Inside Medium
121 194383 Inside Medium
122 194056 Inside Medium
123 210040 Inside Medium
124 226711 Inside Medium
125 206598 Inside High
126 206247 Inside High
127 183081 Inside High
128 209304 Inside High
129 199704 Inside High
130 203159 Inside High
131 202098 Inside High
132 196447 Inside High
133 204241 Inside High
134 203365 Inside High
135 218505 Outside High
136 218742 Outside High
137 234222 Outside High
138 236130 Outside High
139 232209 Outside High
140 236808 Outside High
141 223167 Outside High
142 232068 Outside High
143 233460 Outside High
144 233403 Outside High
145 198960 Outside High
146 231933 Outside High
147 230589 Outside High
148 227373 Outside High
149 225978 Outside High
150 205707 Outside High
151 223122 Outside High
152 232866 Outside High
153 202809 Outside High
154 267243 Outside High
155 243403 Outside High
156 208960 Outside High
157 241933 Outside High
158 240589 Outside High
159 237373 Outside High
160 235978 Outside High
161 215707 Inside High
162 233122 Inside High
163 242866 Inside High
164 212809 Inside High
165 277243 Inside High
166 183081 Inside High
167 209304 Inside High
168 199704 Inside High
169 203157 Inside High
170 202098 Inside High
171 196446 Inside High
172 204240 Inside High
173 203364 Inside High
174 218505 Outside High
175 218742 Outside High
176 234222 Outside High
177 236130 Outside High
178 232209 Outside High
179 236808 Outside High
180 223167 Outside High
181 232068 Outside High
182 233460 Outside High
183 233403 Outside High
184 198960 Outside High

Sheet2

Sheet3