ONLY DO IN EXCEL WITH STEPS OF EACH SO THAT I CAN DO IN EXCEL I need steps not answers because I have to solve it on my own for my understanding do with steps,

note: question is data set 2 and it's data is given in pic

question is below

data is given below

Data Set 2 1. On average, on which day of the week was maximum requests accepted? 2. What is the average difference between the Predicted ETA and the actual ETA for each of the days (i.e. Sunday, Monday..... to Saturday)? Therefore, which day is the prediction performing the worst? 3. On average, which day has the highest supply hours? data B D 1 Date Hour 1/9/2013 2 3 4 S 2/9/2013 6 7 59.18 3/9/2013 9 10 11 4/9/2013 12 13 7.06 14 5/9/2013 15 16 17 6/9/2013 18 19 20 7/9/2013 21 22 23 8/9/2013 24 408 44.55 25 354 26 9/9/2013 27 28 29 10/9/2013 30 31 Day 11 S 12 s 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F 11 Sa 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F 11 Sa 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F Accepted Rec Completes Supply Hours Time On Trip Predicted ETA Actual ETA 79 55 42.63 20.43 5.51 7.19 73 41 36.43 15.53 5.48 8.48 54 50 23.02 17.76 5.07 8.94 193 170 64.2 31.47 5.31 6.55 258 210 80.28 38.68 4.94 6.08 153 107 23.37 5.14 6.42 124 34 30.67 19.65 6.7 8.19 78 34 27.02 14.38 6.36 8.01 36 15 20.82 12.62 7.82 9.05 98 43 29.17 16.55 6.99 8.32 67 39 24.42 13.87 6.48 7.56 34 20 22.58 17.67 6.51 184 167 58.32 25.03 4.84 5.65 334 256 71.47 45.73 5.85 6.5 264 109 43.83 29.68 7.27 8.25 171 151 52.35 24.08 4.99 5.73 275 222 73.83 44.43 6.12 7.24 208 101 50.25 30.5 6.81 8.44 342 298 74.43 47.6 5.83 6.59 558 396 94.82 73.62 7.02 8.04 532 340 59.02 39.57 7.83 8.9 203 164 64.68 25.23 4.34 4.9 257 65.58 5.7 6.89 100 27.5 19.63 7.36 9.04 213 155 52 29.55 6.5 7.8 318 187 54.33 42.57 6.88 8.61 372 120 29.12 23.03 7.06 8.15 49 44 31.48 13.95 6.34 7.66 48 38 25.45 13.92 6.82 8.23 49 12 23.55 9.14 6.46 7.86 306 76 26.2 21.83 7.68 12.06 209 34 19.18 15.85 7.43 8.05 170 50 11.25 10.18 7.47 7.88 185 155 57.8 21.95 4.5 327 232 63.12 41.72 6.22 6.95 304 107 48.92 26.77 6.28 144 128 58.33 21.87 5.38 6.14 379 166 56.37 34.75 6.78 7.9 483 60 29.68 12.22 6.06 7.23 317 250 70.88 35.78 5.39 6.09 385 284 73.13 50.45 6.18 6.86 185 123 52.52 31.32 5.98 6.7 222 186 52.62 28.28 5.43 6.03 409 267 59.82 52.52 6.89 8.42 273 121 36.32 8.05 10.57 136 54.55 20.72 4.7 312 210 55.08 36.97 6.49 7.29 222 91 32.98 26.48 7.39 8.55 44 37 42.13 12.61 4.92 6.02 41 35 26.32 12.52 6.21 7.3 26 12 18.53 10.75 5.48 7.69 85 56 43.95 15.82 5.39 6.47 45 28 34.48 17.28 6.08 32 27 49.9 16.95 6.37 6.67 364 222 49.45 37.05 6.05 8.1 389 268 65.17 58.22 5 8.43 290 161 51.85 39.18 5.69 7.7 292 218 73.4 28.22 4.79 482 260 61.62 41.58 5.01 7.11 453 71 33.08 23.02 2.43 8.1 32 11/9/2013 33 35 12/9/2013 4.61 36 37 7.07 38 9/13/2013 39 40 41 9/14/2013 42 43 44 9/15/2013 45 46 37.43 47 9/16/2013 158 4.91 48 50 9/17/2013 51 52 53 9/18/2013 54 7.88 55 56 9/19/2013 57 58 59 9/20/2013 5.98 60 61 62 9/21/2013 63 64 65 9/22/2013 66 67 77.1 104.1 71.85 95.33 118.93 85.62 67 71.85 48.73 30.83 27.92 68 40.48 66.92 35.37 34.56 57.05 40.65 29.75 47.82 37.62 12.72 12.22 9/23/2013 328 528 323 306 469 285 236 382 242 53 89 56 41 26 15 115 266 420 156 269 376 215 183 260 130 33 34 35 37 69 70 11 Sa 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F 11 Sa 6.22 6.78 6.95 5.26 5.65 6.33 6.2 8.24 9.6 7.57 7.28 8.71 6.54 6.44 6.13 6.59 71 9/24/2013 72 5.13 5.35 3.94 4.4 4.97 5.4 5.06 5.97 6.92 6.38 4.09 3.7 6.15 5.28 5.39 4.35 4.42 5.55 2.52 5.4 5.22 6.01 73 23.13 9.05 74 9/25/2013 75 18 76 77 9/26/2013 6 60 68 78 102 5.86 36.7 32.23 27.93 40.32 47.72 39.4 63.13 74.97 59.62 67.18 11.07 11.03 15.76 15.42 14.47 14.7 22.22 48.68 31.67 42.72 79 52 80 9/27/2013 81 62 366 426 233 308 300 296 130 266 6.28 5.49 6.91 7.33 6.89 82 83 9/28/2013 84 85 86 9/29/2013 87 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 428 233 302 378 321 180 307 215 361 140 240 306 149 151 247 275 95.07 59.58 84.85 99.07 76.9 68.33 78.25 56.83 50.15 30.17 37.03 52.02 30.55 24.87 45.78 29.13 4.88 4.69 5.13 5.75 5.86 5.21 5.75 5.35 5.3 6.37 6.51 6.6 6.42 6.07 6.71 7.59 88 89 9/30/2013 90 91 92 Data Set 2 1. On average, on which day of the week was maximum requests accepted? 2. What is the average difference between the Predicted ETA and the actual ETA for each of the days (i.e. Sunday, Monday..... to Saturday)? Therefore, which day is the prediction performing the worst? 3. On average, which day has the highest supply hours? data B D 1 Date Hour 1/9/2013 2 3 4 S 2/9/2013 6 7 59.18 3/9/2013 9 10 11 4/9/2013 12 13 7.06 14 5/9/2013 15 16 17 6/9/2013 18 19 20 7/9/2013 21 22 23 8/9/2013 24 408 44.55 25 354 26 9/9/2013 27 28 29 10/9/2013 30 31 Day 11 S 12 s 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F 11 Sa 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F 11 Sa 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F Accepted Rec Completes Supply Hours Time On Trip Predicted ETA Actual ETA 79 55 42.63 20.43 5.51 7.19 73 41 36.43 15.53 5.48 8.48 54 50 23.02 17.76 5.07 8.94 193 170 64.2 31.47 5.31 6.55 258 210 80.28 38.68 4.94 6.08 153 107 23.37 5.14 6.42 124 34 30.67 19.65 6.7 8.19 78 34 27.02 14.38 6.36 8.01 36 15 20.82 12.62 7.82 9.05 98 43 29.17 16.55 6.99 8.32 67 39 24.42 13.87 6.48 7.56 34 20 22.58 17.67 6.51 184 167 58.32 25.03 4.84 5.65 334 256 71.47 45.73 5.85 6.5 264 109 43.83 29.68 7.27 8.25 171 151 52.35 24.08 4.99 5.73 275 222 73.83 44.43 6.12 7.24 208 101 50.25 30.5 6.81 8.44 342 298 74.43 47.6 5.83 6.59 558 396 94.82 73.62 7.02 8.04 532 340 59.02 39.57 7.83 8.9 203 164 64.68 25.23 4.34 4.9 257 65.58 5.7 6.89 100 27.5 19.63 7.36 9.04 213 155 52 29.55 6.5 7.8 318 187 54.33 42.57 6.88 8.61 372 120 29.12 23.03 7.06 8.15 49 44 31.48 13.95 6.34 7.66 48 38 25.45 13.92 6.82 8.23 49 12 23.55 9.14 6.46 7.86 306 76 26.2 21.83 7.68 12.06 209 34 19.18 15.85 7.43 8.05 170 50 11.25 10.18 7.47 7.88 185 155 57.8 21.95 4.5 327 232 63.12 41.72 6.22 6.95 304 107 48.92 26.77 6.28 144 128 58.33 21.87 5.38 6.14 379 166 56.37 34.75 6.78 7.9 483 60 29.68 12.22 6.06 7.23 317 250 70.88 35.78 5.39 6.09 385 284 73.13 50.45 6.18 6.86 185 123 52.52 31.32 5.98 6.7 222 186 52.62 28.28 5.43 6.03 409 267 59.82 52.52 6.89 8.42 273 121 36.32 8.05 10.57 136 54.55 20.72 4.7 312 210 55.08 36.97 6.49 7.29 222 91 32.98 26.48 7.39 8.55 44 37 42.13 12.61 4.92 6.02 41 35 26.32 12.52 6.21 7.3 26 12 18.53 10.75 5.48 7.69 85 56 43.95 15.82 5.39 6.47 45 28 34.48 17.28 6.08 32 27 49.9 16.95 6.37 6.67 364 222 49.45 37.05 6.05 8.1 389 268 65.17 58.22 5 8.43 290 161 51.85 39.18 5.69 7.7 292 218 73.4 28.22 4.79 482 260 61.62 41.58 5.01 7.11 453 71 33.08 23.02 2.43 8.1 32 11/9/2013 33 35 12/9/2013 4.61 36 37 7.07 38 9/13/2013 39 40 41 9/14/2013 42 43 44 9/15/2013 45 46 37.43 47 9/16/2013 158 4.91 48 50 9/17/2013 51 52 53 9/18/2013 54 7.88 55 56 9/19/2013 57 58 59 9/20/2013 5.98 60 61 62 9/21/2013 63 64 65 9/22/2013 66 67 77.1 104.1 71.85 95.33 118.93 85.62 67 71.85 48.73 30.83 27.92 68 40.48 66.92 35.37 34.56 57.05 40.65 29.75 47.82 37.62 12.72 12.22 9/23/2013 328 528 323 306 469 285 236 382 242 53 89 56 41 26 15 115 266 420 156 269 376 215 183 260 130 33 34 35 37 69 70 11 Sa 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 11 T 12 T 13 T 11 W 12 W 13 W 11 Th 12 Th 13 Th 11 F 12 F 13 F 11 Sa 6.22 6.78 6.95 5.26 5.65 6.33 6.2 8.24 9.6 7.57 7.28 8.71 6.54 6.44 6.13 6.59 71 9/24/2013 72 5.13 5.35 3.94 4.4 4.97 5.4 5.06 5.97 6.92 6.38 4.09 3.7 6.15 5.28 5.39 4.35 4.42 5.55 2.52 5.4 5.22 6.01 73 23.13 9.05 74 9/25/2013 75 18 76 77 9/26/2013 6 60 68 78 102 5.86 36.7 32.23 27.93 40.32 47.72 39.4 63.13 74.97 59.62 67.18 11.07 11.03 15.76 15.42 14.47 14.7 22.22 48.68 31.67 42.72 79 52 80 9/27/2013 81 62 366 426 233 308 300 296 130 266 6.28 5.49 6.91 7.33 6.89 82 83 9/28/2013 84 85 86 9/29/2013 87 12 Sa 13 Sa 11 S 12 S 13 S 11 M 12 M 13 M 428 233 302 378 321 180 307 215 361 140 240 306 149 151 247 275 95.07 59.58 84.85 99.07 76.9 68.33 78.25 56.83 50.15 30.17 37.03 52.02 30.55 24.87 45.78 29.13 4.88 4.69 5.13 5.75 5.86 5.21 5.75 5.35 5.3 6.37 6.51 6.6 6.42 6.07 6.71 7.59 88 89 9/30/2013 90 91 92