I could write SQL to solve this problem.. but the data was in Excel.
I pulled pricing and mileage data from several car for-sale sites and dropped it in an Excel sheet. Columns include year, price, kilometers (mileage), etc. Here is a snippet of the data:
Now I had some data in Excel that would mimic how it would be stored in a relational database but I wanted to analyze it.
I wanted to get the average price and mileage…