Solve Q1 and Q2 using excel

It is going to be the River Festivel in New York next Friday, in the aim of encourage more driver get online and drive with Uber, the operation manager shared with following plans 1. As long as Driver get online for more than 6 hours, the average rating is more than 4.7, they will get a reward of 60$. 2. For drivers who completed more than 5 trips, and the average rating is more than 4.7, each trip they will get a reward of 5$. Q1 What would be the cost of the above 2 plans, and the porpotion of drivers who get reward for each of the plans? Which plan is better and why? Q2 Out of those drivers, which driver is the most efficient driver? And which driver is the lowest efficient driver? What do you think these indicate? E F G H I J order_click success_click completed_order 69 16 15 trip_distance 133.4 income 777.8 40 8 3 31 14 19 7 3 8 58.1 15 66 349.2 90 345.4 164.2 8 4 4 31.1 105 679 32 96 37 17 10 21 11 17 10 12 20 45 50 51 71 15 104 60 42 29 134 16 8 18 10 15 10 10 20 3 18 6 6 12 6 6 18 128.3 67 131.7 132.8 131.1 97.6 76.6 107.7 34.6 211.8 33.6 112 39.8 136.6 3 19 7 7 12 6 6 18 9 14 51 210 11 13 7 1 13 2 6 4 6 6 15 69 17 8 17 12 AL B C D 1 Date Driver_id Average Rating Online_time 2 Friday 1 5 9 3 Friday 2 5 10.42 4 Friday 3 5 15.67 5 Friday 4 5 9 6 Friday 5 5 5.92 7 Friday 6 5 13.5 8 Friday 7 4.9 11.17 9 Friday 8 8 5 15.25 10 Friday 9 9 5 15.17 11 Friday 10 4.9 6.25 12 Friday 11 5 13.67 13 Friday 12 5 10.33 14 Friday 13 5 7.42 15 Friday 14 4.9 11.58 16 Friday 15 5 12.83 17 Friday 16 5 4.67 18 Friday 17 4.9 5.58 19 Friday 18 5 16 20 Friday 19 5 13.75 21 Friday 20 5 3.75 22 Friday 21 5 13.5 23 Friday 22 5 14.42 24 Friday 23 5 11.58 25 Friday 24 4.9 10 26 Friday 25 4.9 11 27 Friday 26 4.9 15.92 28 Friday 27 5 17.33 29 Friday 28 5 8.33 30 Friday 29 5 4.17 31 Friday 30 4.9 8.17 32 Friday 31 5 14 33 Friday 32 5 5 13.5 34 Friday 33 5 6.42 35 Friday 34 5 12.42 36 Friday 35 4.9 12.5 37 Friday 36 5 5.75 38 Friday 37 5 15.5 39 Friday 38 5 13.58 40 Friday 39 5 5 16.83 41 Friday 40 5 5 14.58 42 Friday 41 5 5 9.25 43 Friday 42 4.9 6.42 44 Friday 43 5 11.67 45 Friday 44 4.9 7.25 46 Friday 45 4.7 8.25 47 Friday 46 5 14.58 48 Friday 47 5 15.58 49 Friday 48 5 5 16.67 50 Friday 49 5 5 18.33 51 Friday 50 4.9 8 51 5 14.08 53 Friday 52 5 6.75 54 Friday 53 5 11 55 Friday 54 4.9 8.33 56 Friday 55 5 12.42 57 Friday 56 4.9 5.17 58 Friday 57 5 4.25 59 Friday 58 5 12.33 60 Friday 59 5 16.17 61 Friday 60 5 6 62 Friday 61 5 5 12.75 63 Friday 62 4.9 13.08 64 Friday 63 4.9 13.58 65 Friday 64 5 15.67 66 Friday 65 4.9 11.42 67 Friday 66 4.9 14.33 68 Friday 67 5 4.83 69 Friday 68 5 5 15.25 70 Friday 69 5 5 8 71 Friday 70 5 5 8.58 72 Friday 71 5 4.25 73 Friday 72 4.9 3.42 74 Friday 73 5 4.08 75 Friday 74 4.9 14 78 42 89 51 61 63 149 41 30 165 69 137 66 2 7 4 5 18 9 9 18 12 9 13 27 6 6 6 10 10 21 10 9 11 27 6 5 10 8 19 9 8 18 13 24 2. 2 15 5 12 5 357 823.1 681.6 726.4 516.4 446.4 695.7 182.7 1052.4 230.5 586 240.7 771.6 532.2 435.8 101.8 261.1 132.7 233.8 1116.6 603.7 677.3 1170.6 1174 1219.6 1023.7 269 95.2 407.5 304.9 735.8 402.6 169.8 720.7 551.7 1007.8 91.6 710.8 298.9 626.3 131.2 580.9 377.5 320.4 704.5 633.2 444.3 597.8 745 449.2 456.3 225.1 117 91 73 62 6 109 48 105 103 74.3 22.8 49.2 17.1 40.1 209.6 118.9 121 264.3 248.3 265.5 178.2 38 7 68.8 51.7 117.5 70.8 16.1 116.4 99.9 190.3 18.5 120.3 51 116.7 15.5 102.1 59.9 53.7 119.3 113.9 62.3 101.3 138 69.5 89.9 39.3 190 113.5 125 180.5 71.7 85 113 82.3 138 35.7 31.6 228.6 57.3 108.9 112.9 111.4 9 20 15 24 2 17 5 13 5 13 13 13 18 16 16 14 11 16 8 52 69 41 35 134 54 37 132 53 34 52 Friday 5 22 24 12 18 4 56 15 69 67 82 20 32 49 28 67 57 76 11 14 54 25 74 11 12 10 15 14 14 13 11 12 7 4 21 24 12 17 6 9 18 20 19 4 4 4 18 11 21 21 21 5 5 19 8 14 10 15 940.8 810.3 593.1 905.7 347 429.2 675.9 635.5 835.5 188.6 192.8 1109.4 313.5 610 601.6 630.9 8 13 9 30 54 13