• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

I have been asked to investigate factors that affect the depreciation of cars.

Extracts from this document...


I have been asked to investigate factors that affect the depreciation of cars.  To do this I would ideally like to collect my own data about used cars.  This would be called primary data.  I would have collected data on the make, model, mileage, engine size, age, price and price when new of several hundred used cars.  Unfortunately this would have taken a lot of time, but the advantage would have been that it would have been reliable data which I could trust, and I could have found out exactly the information that I wanted.

        It would have been impossible for me to do such a large survey, however, so I had to use secondary data that I got from the CCEA website.  The advantage of this was that it was quick, cheap and easy, but I can’t be sure of the accuracy of these results and I don’t know if any bias was involved when it was being collected.  I have also found that many of the results are incomplete.

        From the very start, I am sure that two of these results are wrong – a Renault Laguna which costs £50,000, and a Renault Clio that increases in value.  I have deleted these results straight away.

Hypothesis 1

My first hypothesis is that cars depreciate more as they get older.  I used the spreadsheet on the computer to test this hypothesis, but first I had to get the age and percentage depreciation for each car, neither of which are recorded in the table.

        Firstly, to get the age of the cars, I subtracted the year in which they were made from 2002, the year when the data was collected.  I first created a new column on the spreadsheet and called it age.

...read more.


Cars taken =  (Cars in group / Total no of cars) x 40

When worked out to the nearest whole number, group 1 will have 14 cars selected from it, group 2 will have 17 cars selected from it, and group 3 will have 9cars selected from it.  I will use the random number generator on my calculator to select the cars at random as follows.  

Place in group of car selected = Random number x No.  of cars in group

I will use this formula and select the nearest whole number to my answer until I have selected the required number of cars from each group.  When I have selected the 40 random cars, I will plot their mileage against their percentage depreciation in a scattergraph. (See scattergraph)

The graph shows a definite positive correlation, meaning that as the mileage of the car increases, so does the percentage depreciation.  This time the best-fit line is not curved, suggesting that the two values are directly proportional – as mileage doubles, so does percentage depreciation.  There is again a large variation in the percentage depreciation, as the values form a wide band across the axis.  This is due to the effect of age on the percentage depreciation.

        These results agree with my hypothesis and show that the mileage must have an effect on the percentage depreciation.

        This graph can also be used to make predictions about used cars.  For example, I have found an advertisement for a 1.2 litre ford fiesta made in 1999.  All of the 1.2 litre fiestas made in 1999 on the spreadsheets were priced at £9,020, so I will assume that this was the original price for the car in question.

        The advertisement says that the car has a mileage of 34,000 miles, and states a price of £2,100.

...read more.



I found that make had a small effect on the percentage depreciation.  I found that Vauxhalls depreciate the most and that Peugeots depreciate the least.  However, the difference was less than 20%, so make has a smaller effect on the depreciation than age or mileage.  


I found that the fuel on which a car runs has a small effect on the depreciation on the car.  I found that diesel cars depreciate more than petrol cars do.  However, the difference was very small - less than 7% - and I was unable to determine whether this difference was caused by the fuel used or by bias involving age in the original sample.

All of the data that I have collected can be used to make decisions when buying a new or used car.

        If I was buying a new car, I would buy a Peugeot that runs on petrol, because the data suggests that this sort of car would be likely to depreciate the least, and therefore be worth more when the time came to sell it.  I would definitely not buy a Vauxhall as they depreciated more than the other makes in the survey.

        If I was buying a used car, I would buy a Vauxhall, because they have depreciated more than any other type of car in the survey and should therefore be the cheapest.  I would try to buy one that was less than 5 years old, however, because of the way that the graph of depreciation against age curves.  After 5 years old, the slope of the graph becomes very gentle.  This means that the cars are getting older, and therefore in worse condition, but the price is falling very slowly, so you will get less value for money as the cars get older.

...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. Statistics: Factors Affecting the Price of Used Cars

    However, the mileage has quite a large difference which is around 10 000 miles. I also calculated the mileage because it will also affect the results and I can't control the mileage. The ranges for the years are all close together so there aren't any outliers for that.

  2. I will research the cars by putting the data I have been given into ...

    The mileage line graph showed a moderate positive correlation. It was a straight line and therefore was able to get the equation: Y=1.6><-59 This can be used to find the average depreciation given the mileage of a car. I then calculated that the mean depreciation per 1000 miles was 1.89%

  1. Maths Coursework:Used Cars

    First of all I will do the mileage for all the four car makes and then do mileage for the four cars separately. I am investigating whether the mileage has an effect on the second hand price. Mileage This graph has a steep, negative correlation and it shows that it loses �0.0724 per year.

  2. My maths coursework is based on a spreadsheet with information about cars.

    1.2 1995 1.2 1495 1.2 4500 1.2 6795 1.2 3495 1.2 1595 1.3 2800 1.3 2495 1.3 2995 1.3 10999 1.4 7499 1.4 3495 1.4 2495 1.4 1000 1.4 400 1.4 3695 1.4 1700 1.4 1500 1.4 2300 1.4 2595 1.4 4395 1.4 4295 1.4 8250 1.4 7995 1.4 4995

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

    This is shown in this section of the graph. (I have drawn an arrow to show the slope and where it occurs). This proves that my theory/assumption was slightly correct; since there are anomalous results in my graph. (Here are examples which I have circled)

  2. Maths - statistical driving test

    important that I look at each instructor individually as one or more of the instructors results might be distorting the graph due to there being no correlation between the number of lesions and mistakes a person occurs within my previous hypothesis.

  1. Handling data Used car prices

    The nearer the value is to 0, the less perfect the correlation is. However, here we can see that the data are high positive. Hypothesis 3 - I predict that the depreciation value for saloons will have the least depreciation value.

  2. T-Total Maths

    63 FORMULA =5N + 63 FORMULAS GRID 5 = 5N +35 GRID 6 = 5N + 63 GRID 7 =5N + 49 GRID 8 = 5N + 56 GRID 9 = 5N + 63 GRID 10 =5N + 70 I have turned the T-shape upside down.

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