Hello All…
Here I am coming with new challenge. Use below dataset and solve
this challenge.
Region |
Number of Customers |
Number of Orders |
East |
2 |
0 |
East |
3 |
1 |
West |
9 |
0 |
West |
3 |
1 |
West |
1 |
2 |
South |
24 |
0 |
South |
6 |
1 |
South |
10 |
2 |
South |
3 |
3 |
South |
5 |
More Than 3 |
North |
6 |
1 |
North |
4 |
2 |
Note: Avg column is based on below calculation
Avg: sum (Number of
customers * Number of orders) / Total Number of orders
Note:
if number of orders is more than 3 then I am multiplying with 4. You can see Avg
for South.
Avg for East: ((0
*2) + (1* 3)) / 5 = 0.60
Avg for North: ((1*6)
+ (2*4)) / 10 = 1.40
Avg for South: ((0*24)
+ (1*6) + (2*20) + (3*3) + (5*4))/48 = 1.15
Avg for West: ((0*9)
+ (1*3) + (2*1))/13 = 0.38
For more challenges: Click Here
Experiment… Observe… Learn…