Wednesday, May 7, 2014

Plotting used car prices

Our next assignment is to make a graph of used car prices. In order to complete the assignment, you'll do the following:

Choose three cars you would like to research. It needs to be a fairly common car that could be found used and for sale around town (sorry, not a Ferrari or anything too exotic). Next, visit www.carmax.com and do a search for that vehicle. Limit your search (or sort your search) looking for vehicles made in 2009-2010. Then make some data points like below in a spreadsheet. You must use google drive for this project. You'll need at least 5 data points for each car. Find the miles and the price and record it like this:



Once you have your data points, make make a bubble chart for each vehicle that will look like this: (highlight your data points for each model and select insert chart then select bubble chart).


Label your chart (so it doesn't say 'chart title') and then insert three of those bubble charts in the spreadsheet.

Extra credit: get your chart to look like this with all the data points showing.




This project is due next week, May 14, 2014.