Data Mining - Research on Used Cars

Copy information from [login to view URL] and [login to view URL] for specified cars and input data in a spreadsheet. See details for more info. ## Deliverables For each of the following cars, you need to enter the data for the 5 cheapest options that are within 75 miles of ZIP Code 08817, and the 3 cheapest options in the whole USA (So 8 entries per car). There are 22 cars, so there should be a total of 176 rows in the Excel Table. 1. Audi TT 2008-2012 Certified, Navigation 2. Audi TT 2008-2012 Used, Navigation 3. Audi A5 2008-2012 Certified, Navigation 4. Audi A5 2008-2012 Used, Navigation 5. Audi S5 2008-2012 Certified, Navigation 6. Audi S5 2008-2012 Used, Navigation 7. Audi Q5 2008-2012 Certified, Navigation 8. Audi Q5 2008-2012 Used, Navigation 9. BMW 3 Series, 2008-2012, Certified, Navigation 10. BMW 3 Series, 2008-2012, Used, Navigation 11. BMW 5 Series, 2008-2012, Certified, Navigation 12. BMW 5 Series, 2008-2012, Used, Navigation 13. Ford Mustang 2009-2012, Used, Navigation 14. Infinity G Models 2008-2012, Used, Navigation 15. Nissan 350Z 2008-2012, Certified 16. Nissan 350Z 2008-2012, Used 17. Nissan 370Z 2008-2012, Certified 18. Nissan 370Z 2008-2012, Used 19. Porsche Cayenne 2008-2012, Certified 20. Porsche Cayenne 2008-2012, Used 21. Porsche Caymen 2008-2012, Certified 22. Porsche Caymen 2008-2012, Used For each of these cars, the following details are required (see attached table - These will be the columns of the table) * Make * Model * Certified (Y/N) * Year * Mileage * Price * Miles from ZIP 08817 * Exterior Color * Interior Color * Body Style * Seller Name * Bluetooth (Y/N) * Navigation (Y/N) * Keyless Entry (Y/N) * Leather Seats (Y/N) * URL to Page Notes: 1. Note that when I say cheapest, start with cars that are priced at more than $5000 (so don't put a row in the excel table if the car's price is less than $5000) . 2. See attached file (How To [login to view URL]) for example of screenshots on the searched 1. You can go to "expanded search options" to select Navigation as an option 2. In section "Which cars are you interested in?", you can choose "Certified Cars" or "Used Cars" 3. In section "Where will you look", you will first need to search within 75 miles of Zip Code 08817, and then go back and search for Any Distance of 08817 4. In section "What makes and models would you like to see?", you will need to select the car model and make. You will need to do the searches for 1 Model at a time so that you can easily get the results for only the model selected. 5. In section "How much do you plan to spend", you need to enter $5000 as the Minimum Price 6. In section "Choose your Specifications", you need to choose: 1. Transmission = Automatic 7. In "What features are you looking for" section, you need to check "Navigation" if needed for that specific Model. 8. In "Sort By", choose "Price - Low to High" 3. Attached is also the Excel document with the column names needed. Please fill in this document Thanks! Karim T