Coding Cont.
NEXT I wanted to determine the distance from home the crimes occurred. The distance is measured in KM.
MIN .03 KM
AVG distance is 66.26 KM
Max distance 10632.72 KM
I also wanted to write a code to determine the distance for the fraudulent transactions made in person from the last location. I did not include online transactions in this query because I wanted a clear picture of how hard criminals were willing to work, or how arrogant they were staying close. I determined online transactions were not a good indication of this.
AVG 21.89 KM
MAX 1607.89 KM