Analytics Module 1 Comprehensive Assignment

profileaujam253
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