• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  • Level: GCSE
  • Subject: Maths
  • Word count: 3172

Used Car Prices

Extracts from this document...


Vina Ragupathy 11L

Maths Coursework
Used Car Prices

There are many factors that will strongly affect the price of a used car, such as the:

  • make
  • age
  • engine size
  • condition of the car
  • mileage
  • type of fuel used
  • number of previous owners


I plan to investigate how mileage, engine size and age of the car will affect the second-hand selling price of a used car, as I believe that these are the most important factors that will have the greatest effect on the price.

  • Firstly, I will analyse the data we have been given in the appendix.
  • I will input this data on to a spreadsheet to aid my analysis.
  • Using the ‘Auto Filter’ function I will group cars under their make, enabling for a fair comparison to be made between the price and the factors that will affect price.
  • I will produce scatter graphs which will display the results in such a way that a trend can be spotted easily.
  • From these trends I will make a few simple hypotheses, stating what I would expect to find from examining a different set of data
  • To test these hypotheses I will use external resources such as car magazines, which contain a listing of used cars and their mileage, engine size and age, thus enabling me to obtain a wider range of the data I require. A sample size of approximately 50 cars would be sufficient for investigation.
  • I will use random sampling to obtain my data set to remove bias from my collection; this would also be a better test of my predictions. To do this, I will either select 1 in every 5 cars or use the random number generator on my calculator.
  • Once I have gathered my data set I will set about processing it and representing it in the forms of charts and graphs. I could use scatter diagrams again, which would make it an easier comparison to my initial set of results. Alternatively I could use a cumulative frequency graph which will also help me find the median and inter-quartile range.
  • After I have collated the data I will try and find a general formula for the depreciation of car prices.
  • I will then set about refining my investigation to find a more accurate formula. I can do this by concentrating on a specific type or model of car or maybe even combining some of the features.
  • The final stage of my investigation will be to write up a conclusion describing my findings.
...read more.



There is quite a strong negative correlation here, apart from a couple of points where two different cars have a difference of 20000 for the mileage but are priced the same. The gradient of the graph = -£4000 ÷ 60000miles = £666.67 average depreciation per 10,000miles travelled.


For the above graph there is almost perfect negative correlation. This is the strongest indication yet that age is a very important determinant of price. The gradient of the graph is approximately -£3000 ÷ 5 years = £600 average depreciation per year, which is relatively low and would attract buyers as it may be seen as an investment to buy the car.


There is absolutely no correlation once again between engine size and price.

Volkswagen is another of the populous makes of car. Here I will analyse the graphs I have produced from the data I gathered from the appendix.


There is a visible negative correlation between mileage and selling price in the graph above, even though there are only 6 cars whose data has been used. Besides one, the points do not vary much from the line so we can say that the graph is strongly correlating. The results displayed add further emphasis to the idea that mileage influences price.


I cannot say that there is much correlation in the above scatter diagram, probably because there are not enough cars to establish any pattern in this case. However a line of best fit can still be drawn if we disregard the outlying point.

The gradient of this line is approximately -£4000 = average depreciation of £500 / year.                                                       8 years

This is a very cheap average depreciation but under similar circumstances to a previous analysis of another make of car, I have disregarded an outlying point.

...read more.


y     1


y =  k


when x is 15000, y is 6000 => 6000 =     k   s


                                => k = 6000 x 15000s= 90,000,000

therefore, the final equation is y = 90,000,000


However, the values used in this calculation were estimations taken from the computer drawn graph which you see displayed above, and so the actual formula may differ slightly from what I have been able to work out.


There is some negative correlation in the graph above, although there is no strong, definite pattern. This still proves my hypothesis that “The more expensive cars…will be younger in age.” We can still use the graph to obtain a general formula for the average depreciation per year of these cars:

y = mx + c → m = gradient, c = y-intercept

gradient = £4000 - £6000        = -2000        = - 800

               6yrs – 3.5yrs              2.5                       1

y-intercept ≈ £9000

if we take the point (6,4000), x = 6, y = 4000

substitute into y = mx + c → 4000 = -800x6 + 9000

                                   4000 = -4800 + 9000

                                 -5000 ≈ -4800

Once again the formula was created using estimated figures, and so it is acceptable that when checking the values for the formula the answers were only approximately the same.

Therefore, we can establish the formula for average annual depreciation as:

y = -800‘x’ + 9000 (‘x’ denotes x as a letter rather than a multiplication symbol)


It is clear that there is no correlation between the engine size and the price of a car, suggesting that although it may appear to be quite an important factor, it does not influence the price as much as other factors such as mileage and age. In this sense, this proved my prediction that “cars with larger engine sizes will be more expensive than cars with small ones” to be incorrect, as we can clearly see that some cars have smaller engines yet are more expensive than cars with larger engines.

        -  -

...read more.

This student written piece of work is one of many that can be found in our GCSE Gary's (and other) Car Sales section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Gary's (and other) Car Sales essays

  1. Statistically analyse the data given to me regarding Gary's used car sales.

    For clarity as to which factor influenced the price most, we should look at the same factors, but in conjunction with the outside majority range values. The standard deviation of the depreciation is 21.77 and the mean is 55.97, making the majority range 34.2 to 77.74.

  2. Used Cards - find which factors will influence the price of a second hand ...

    10700 12000 148 Chrysler GrandVoyager 6690 15000 156 Land Rover Range Rover 7735 12000 166 Mercedes M-Class 25810 19000 169 Ford Explorer 4715 10000 177 Mercedes A-Class 12320 80000 190 Ford Escort 1225 10000 Analysing and Calculating To analyse my data I will use a "XY scatter graph" as I

  1. T-Total Maths

    15 16 17 3 10 16 17 18 4 11 17 18 19 5 12 18 19 20 6 13 17 20 21 5 X 2 = 10 - 39 = - 49 FORMUAL =5N + 49 GIRD-8 Numbers inside T shape T NUMBER T TOTAL 2 66 3 71

  2. Statistics: Factors Affecting the Price of Used Cars

    This makes my result more reliable. The Spearman's co-efficient rank of correlation for both Audi and Peugeot are very close together because all the data is of cars between 2002 2005 which means they have a low range. Conclusion My conclusion to my hypotheses is that they are in fact true.

  1. Maths Coursework - Used Cars

    has been used for 1 or two years, its price declines drastically but as it gets older, its second hand price reduces steadily.

  2. Maths - statistical driving test

    As before I will be looking for negative correlation. Graph 13 & 14 Conclusion After separating instructor B's male and the female students results into four scatter graphs I can now see a very clear result which has greatly influenced instructor B's results. In comparing the four scatter graphs I have distinguished that instructor B's male students display a

  1. Legal and Ethical Analysis of Ford Pinto

    Ford knew that people were being killed and injured as a result of the fuel system design of the Pinto. Ford had studied its design problem and determined that there were a number of alternatives which could be deployed to reduce the safety risk.

  2. Maths Data Handling-Secondhand Car

    The gradient in these formulas or the m in y=mx+c will be the number which is multiplied by the age and will be the percentage depreciation per year for the trend line. Also c is the depreciation of the car which occurs immediately after it has become a 2nd hand car.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work