Analytics Module 1 Comprehensive Assignment
aujam253
2-7-2019DistanceTraveled2.xlsx
Sheet1
| ID | Distance Traveled | Distance Traveled_R |
| 1 | 95.20 | 84.06 |
| 2 | 96.80 | 85.37 |
| 3 | 103.90 | 129.80 |
| 4 | 110.00 | 96.75 |
| 5 | 104.40 | 65.09 |
| 6 | 94.00 | 186.02 |
| 7 | 105.00 | 146.98 |
| 8 | 94.90 | 104.74 |
| 9 | 101.70 | 90.52 |
| 10 | 108.50 | 102.62 |
| 11 | 100.50 | 81.26 |
| 12 | 106.40 | 99.88 |
| 13 | 106.50 | 112.42 |
| 14 | 95.50 | 102.87 |
| 15 | 92.70 | 110.54 |
| 16 | 97.20 | 106.33 |
| 17 | 107.40 | 106.07 |
| 18 | 103.80 | 101.51 |
| 19 | 109.40 | 118.20 |
| 20 | 94.70 | 149.81 |
| 21 | 93.70 | 124.59 |
| 22 | 97.80 | 99.76 |
| 23 | 101.60 | 78.87 |
| 24 | 95.70 | 99.31 |
| 25 | 99.90 | 114.16 |
| 26 | 103.60 | 73.90 |
| 27 | 109.70 | 102.92 |
| 28 | 98.30 | 70.39 |
| 29 | 105.00 | 92.84 |
| 30 | 105.50 | 92.97 |
| 31 | 104.40 | 89.50 |
| 32 | 105.60 | 131.66 |
| 33 | 101.80 | 64.78 |
| 34 | 90.90 | 105.54 |
| 35 | 97.90 | 102.43 |
| 36 | 90.10 | 96.73 |
| 37 | 99.60 | 105.43 |
| 38 | 93.60 | 118.51 |
| 39 | 90.10 | 133.56 |
| 40 | 90.90 | 72.55 |
| 41 | 107.80 | 104.96 |
| 42 | 104.90 | 108.60 |
| 43 | 96.00 | 77.99 |
| 44 | 103.70 | 108.38 |
| 45 | 104.90 | 96.37 |
| 46 | 100.60 | 124.09 |
| 47 | 98.90 | 37.41 |
| 48 | 92.70 | 87.46 |
| 49 | 92.40 | 88.73 |
| 50 | 93.80 | 72.83 |
| 51 | 99.90 | 109.77 |
| 52 | 91.20 | 99.30 |
| 53 | 91.80 | 91.50 |
| 54 | 99.90 | 87.33 |
| 55 | 96.30 | 101.05 |
| 56 | 100.20 | 137.06 |
| 57 | 94.50 | 134.79 |
| 58 | 98.10 | 118.73 |
| 59 | 92.00 | 77.92 |
| 60 | 105.20 | 92.60 |
| 61 | 109.00 | 96.40 |
| 62 | 91.50 | 137.75 |
| 63 | 99.50 | 147.36 |
| 64 | 107.30 | 77.34 |
| 65 | 90.90 | 119.66 |
| 66 | 91.30 | 102.01 |
| 67 | 96.10 | 120.21 |
| 68 | 107.50 | 108.46 |
| 69 | 106.10 | 106.29 |
| 70 | 104.30 | 95.89 |
| 71 | 92.90 | 102.99 |
| 72 | 97.90 | 114.84 |
| 73 | 103.70 | 135.48 |
| 74 | 107.30 | 110.89 |
| 75 | 102.40 | 136.87 |
| 76 | 93.50 | 94.06 |
| 77 | 93.60 | 144.55 |
| 78 | 101.60 | 96.94 |
| 79 | 108.80 | 78.63 |
| 80 | 92.30 | 106.25 |
| 81 | 103.20 | 135.52 |
| 82 | 109.60 | 113.82 |
| 83 | 108.80 | 96.98 |
| 84 | 91.70 | 157.31 |
| 85 | 98.80 | 108.10 |
| 86 | 97.40 | 125.05 |
| 87 | 109.40 | 132.82 |
| 88 | 103.40 | 107.64 |
| 89 | 101.50 | 78.27 |
| 90 | 105.90 | 106.35 |
| 91 | 94.10 | 66.67 |
| 92 | 103.30 | 100.71 |
| 93 | 91.40 | 107.36 |
| 94 | 93.80 | 113.20 |
| 95 | 97.70 | 141.27 |
| 96 | 102.90 | 143.89 |
| 97 | 99.10 | 104.91 |
| 98 | 94.90 | 110.32 |
| 99 | 107.30 | 89.13 |
| 100 | 101.30 | 114.86 |
| 101 | 102.70 | 87.24 |
| 102 | 97.70 | 118.48 |
| 103 | 106.60 | 98.54 |
| 104 | 108.20 | 98.34 |
| 105 | 90.20 | 95.85 |
| 106 | 99.90 | 89.89 |
| 107 | 98.20 | 120.66 |
| 108 | 109.10 | 93.43 |
| 109 | 107.20 | 126.83 |
| 110 | 91.30 | 88.50 |
| 111 | 97.10 | 163.01 |
| 112 | 102.50 | 110.22 |
| 113 | 96.60 | 90.35 |
| 114 | 103.70 | 83.59 |
| 115 | 105.70 | 87.03 |
| 116 | 106.90 | 105.99 |
| 117 | 93.70 | 106.60 |
| 118 | 107.60 | 118.56 |
| 119 | 91.20 | 74.11 |
| 120 | 102.60 | 120.05 |
| 121 | 93.30 | 84.61 |
| 122 | 93.20 | 77.71 |
| 123 | 94.20 | 110.81 |
| 124 | 101.80 | 114.30 |
| 125 | 92.60 | 105.89 |
| 126 | 104.60 | 118.93 |
| 127 | 98.40 | 110.44 |
| 128 | 106.20 | 98.87 |
| 129 | 95.00 | 109.46 |
| 130 | 95.30 | 100.57 |
| 131 | 92.20 | 120.50 |
| 132 | 106.90 | 107.28 |
| 133 | 101.70 | 90.61 |
| 134 | 94.70 | 75.62 |
| 135 | 103.20 | 81.45 |
| 136 | 106.70 | 60.95 |
| 137 | 103.90 | 117.13 |
| 138 | 106.50 | 77.01 |
| 139 | 95.60 | 77.56 |
| 140 | 91.50 | 93.27 |
| 141 | 98.40 | 133.37 |
| 142 | 97.50 | 134.24 |
| 143 | 107.70 | 100.04 |
| 144 | 91.50 | 89.74 |
| 145 | 109.70 | 71.65 |
| 146 | 108.40 | 110.76 |
| 147 | 98.90 | 109.63 |
| 148 | 90.60 | 138.52 |
| 149 | 101.20 | 112.74 |
| 150 | 103.60 | 137.38 |
| 151 | 107.30 | 100.28 |
| 152 | 100.70 | 112.47 |
| 153 | 92.70 | 35.30 |
| 154 | 100.50 | 66.40 |
| 155 | 99.10 | 99.61 |
| 156 | 102.50 | 95.62 |
| 157 | 95.30 | 103.10 |
| 158 | 106.90 | 131.09 |
| 159 | 100.10 | 77.77 |
| 160 | 100.70 | 74.19 |
| 161 | 99.30 | 90.17 |
| 162 | 105.40 | 95.24 |
| 163 | 95.40 | 95.32 |
| 164 | 98.50 | 85.50 |
| 165 | 105.70 | 129.45 |
| 166 | 100.80 | 80.72 |
| 167 | 91.70 | 59.80 |
| 168 | 101.90 | 63.13 |
| 169 | 104.90 | 133.66 |
| 170 | 102.40 | 114.63 |
| 171 | 107.70 | 123.00 |
| 172 | 107.80 | 88.89 |
| 173 | 91.70 | 110.79 |
| 174 | 100.40 | 88.36 |
| 175 | 109.00 | 150.60 |
| 176 | 107.80 | 165.26 |
| 177 | 102.70 | 80.58 |
| 178 | 100.70 | 121.38 |
| 179 | 96.80 | 82.95 |
| 180 | 95.00 | 93.97 |
| 181 | 93.30 | 126.74 |
| 182 | 96.30 | 121.70 |
| 183 | 106.40 | 62.76 |
| 184 | 98.20 | 147.97 |
| 185 | 99.90 | 104.89 |
| 186 | 102.50 | 120.94 |
| 187 | 101.30 | 98.21 |
| 188 | 108.90 | 158.60 |
| 189 | 109.70 | 77.45 |
| 190 | 93.50 | 82.27 |
| 191 | 101.20 | 104.82 |
| 192 | 98.00 | 96.22 |
| 193 | 95.80 | 130.27 |
| 194 | 93.40 | 112.31 |
| 195 | 106.80 | 97.09 |
| 196 | 106.50 | 125.74 |
| 197 | 108.30 | 118.32 |
| 198 | 105.70 | 137.65 |
| 199 | 100.40 | 68.18 |
| 200 | 107.00 | 105.33 |
| 201 | 90.20 | 131.31 |
| 202 | 100.60 | 93.31 |
| 203 | 105.10 | 124.84 |
| 204 | 98.10 | 86.12 |
| 205 | 94.10 | 140.46 |
| 206 | 108.70 | 107.27 |
| 207 | 101.00 | 67.06 |
| 208 | 98.10 | 143.98 |
| 209 | 109.20 | 93.42 |
| 210 | 98.80 | 100.08 |
| 211 | 96.60 | 154.45 |
| 212 | 105.00 | 139.63 |
| 213 | 95.90 | 111.38 |
| 214 | 93.40 | 61.48 |
| 215 | 109.60 | 131.34 |
| 216 | 108.00 | 85.36 |
| 217 | 102.70 | 113.50 |
| 218 | 103.60 | 110.65 |
| 219 | 99.20 | 118.69 |
| 220 | 107.80 | 90.79 |
| 221 | 103.20 | 117.86 |
| 222 | 109.60 | 74.63 |
| 223 | 105.50 | 104.43 |
| 224 | 101.00 | 80.68 |
| 225 | 102.80 | 119.74 |
| 226 | 100.60 | 104.66 |
| 227 | 92.70 | 103.57 |
| 228 | 105.30 | 118.69 |
| 229 | 92.00 | 77.11 |
| 230 | 105.80 | 134.93 |
| 231 | 97.60 | 71.77 |
| 232 | 103.00 | 85.47 |
| 233 | 109.70 | 112.20 |
| 234 | 100.10 | 95.94 |
| 235 | 101.70 | 106.15 |
| 236 | 101.60 | 101.62 |
| 237 | 106.50 | 100.68 |
| 238 | 103.00 | 105.67 |
| 239 | 94.30 | 123.23 |
| 240 | 93.60 | 138.38 |
| 241 | 106.40 | 100.78 |
| 242 | 107.20 | 86.89 |
| 243 | 101.50 | 93.34 |
| 244 | 97.80 | 84.85 |
| 245 | 108.80 | 32.36 |
| 246 | 105.00 | 132.71 |
| 247 | 108.70 | 114.67 |
| 248 | 99.60 | 98.82 |
| 249 | 97.70 | 101.36 |
| 250 | 99.00 | 126.80 |
| 251 | 97.70 | 134.98 |
| 252 | 103.60 | 177.39 |
| 253 | 93.50 | 64.47 |
| 254 | 105.70 | 109.05 |
| 255 | 106.70 | 113.27 |
| 256 | 96.10 | 74.87 |
| 257 | 106.10 | 90.58 |
| 258 | 94.40 | 67.91 |
| 259 | 98.10 | 110.07 |
| 260 | 90.90 | 99.66 |
| 261 | 98.40 | 126.80 |
| 262 | 108.00 | 147.74 |
| 263 | 96.90 | 116.79 |
| 264 | 105.30 | 106.34 |
| 265 | 100.30 | 81.55 |
| 266 | 94.90 | 168.07 |
| 267 | 103.50 | 107.41 |
| 268 | 107.80 | 96.11 |
| 269 | 101.30 | 76.60 |
| 270 | 103.50 | 90.00 |
| 271 | 109.20 | 77.79 |
| 272 | 95.60 | 96.89 |
| 273 | 91.70 | 99.16 |
| 274 | 108.80 | 118.78 |
| 275 | 100.90 | 116.82 |
| 276 | 101.70 | 113.87 |
| 277 | 107.00 | 108.38 |
| 278 | 90.90 | 137.05 |
| 279 | 106.50 | 134.90 |
| 280 | 105.30 | 93.07 |
| 281 | 93.30 | 135.16 |
| 282 | 93.50 | 111.68 |
| 283 | 100.60 | 115.75 |
| 284 | 99.90 | 82.23 |
| 285 | 90.10 | 99.79 |
| 286 | 92.80 | 134.48 |
| 287 | 108.90 | 90.98 |
| 288 | 103.20 | 103.89 |
| 289 | 96.20 | 129.20 |
| 290 | 90.10 | 94.16 |
| 291 | 90.50 | 135.00 |
| 292 | 104.10 | 105.65 |
| 293 | 98.30 | 84.58 |
| 294 | 105.40 | 99.33 |
| 295 | 100.40 | 93.82 |
| 296 | 101.30 | 107.92 |
| 297 | 93.80 | 105.65 |
| 298 | 90.00 | 97.58 |
| 299 | 90.80 | 121.93 |
| 300 | 102.60 | 104.24 |
| 301 | 94.10 | 108.87 |
| 302 | 106.90 | 92.14 |
| 303 | 96.70 | 121.32 |
| 304 | 90.30 | 97.32 |
| 305 | 99.50 | 81.36 |
| 306 | 96.20 | 100.01 |
| 307 | 101.50 | 171.04 |
| 308 | 100.00 | 63.01 |
| 309 | 98.20 | 97.32 |
| 310 | 97.50 | 77.37 |
| 311 | 99.40 | 131.93 |
| 312 | 92.10 | 94.06 |
| 313 | 108.60 | 76.56 |
| 314 | 98.70 | 59.88 |
| 315 | 90.40 | 74.28 |
| 316 | 107.70 | 133.13 |
| 317 | 100.90 | 115.17 |
| 318 | 102.70 | 124.26 |
| 319 | 107.30 | 104.25 |
| 320 | 96.50 | 88.59 |
| 321 | 99.20 | 142.15 |
| 322 | 99.40 | 86.60 |
| 323 | 97.20 | 135.70 |
| 324 | 101.60 | 127.18 |
| 325 | 107.90 | 65.29 |
| 326 | 93.40 | 134.20 |
| 327 | 97.20 | 75.76 |
| 328 | 92.50 | 44.63 |
| 329 | 99.90 | 122.02 |
| 330 | 104.30 | 105.01 |
| 331 | 107.60 | 98.04 |
| 332 | 96.80 | 108.84 |
| 333 | 103.30 | 136.00 |
| 334 | 92.70 | 106.29 |
| 335 | 94.60 | 86.38 |
| 336 | 97.30 | 117.85 |
| 337 | 98.40 | 113.38 |
| 338 | 96.20 | 114.27 |
| 339 | 91.00 | 95.21 |
| 340 | 94.40 | 87.16 |
| 341 | 90.20 | 67.54 |
| 342 | 100.30 | 130.96 |
| 343 | 109.80 | 114.27 |
| 344 | 109.10 | 104.57 |
| 345 | 91.30 | 79.88 |
| 346 | 99.50 | 64.03 |
| 347 | 99.80 | 102.47 |
| 348 | 105.70 | 103.55 |
| 349 | 97.00 | 85.38 |
| 350 | 109.10 | 98.42 |
| 351 | 102.80 | 83.41 |
| 352 | 110.00 | 144.81 |
| 353 | 91.00 | 57.16 |
| 354 | 107.80 | 108.56 |
| 355 | 106.10 | 97.20 |
| 356 | 90.80 | 94.71 |
| 357 | 108.20 | 122.53 |
| 358 | 90.60 | 107.99 |
| 359 | 105.00 | 56.48 |
| 360 | 107.40 | 90.62 |
| 361 | 98.40 | 64.12 |
| 362 | 94.80 | 93.39 |
| 363 | 97.20 | 127.65 |
| 364 | 105.40 | 102.54 |
| 365 | 100.00 | 123.01 |