• 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

Investigate what influences the price of a second hand car

Extracts from this document...


Marcus Wright



Use the information to investigate what influences the price of a second hand car.


I’m going to find out what it is that affects the price of a second hand car.


I think that the main factors in the drop of car prices are the age and mileage; this is because they give us a good indication as to what the cars price and other information could be.


I am going to prove this by making scatter graphs which compare the age and mileage with the second hand price. I have decided to only use 3 car makes, this is because there is 100 different cars with lots of irrelevant information. Therefore I will use Ford, Vauxhall and Rover because these are the most popular makes in the database.

...read more.




As I was creating these graphs I realised that I would have more accurate results if I found the % depreciation and used this to compare with the age and mileage instead of the second hand price.

I found the % Depreciation by finding the new price and dividing it with the second hand price, then dividing this by the new price, and finally multiplying this by 100.

Price when new – Second hand price = Price difference

Price difference            = % Price depreciation

Price when new

I used Microsoft Excel, so this formula looked like this: -

=SUM(cell number/cell number)*100

The cell number is the cell on the spreadsheet where the prices when new and the second hand prices are for the cars used.


...read more.



Was I correct?

My prediction was a success; the Fiat Uno’s current price is £1495. This is only a £145 difference from my prediction.


I think there is a strong significant relationship between age and % depreciation, and mileage and % depreciation. Engine size is also a good factor as this helped me with my prediction. I believe all of the other factors are insignificant and show no relationship, so I didn’t need to compare or use them.

Maths Coursework


...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. Used Cards - find which factors will influence the price of a second hand ...

    sampling may give an equal chance of a car being selected, I decided to choose it. Furthermore as this is my pilot study I will only be working with a small population of my data, so it will be easy to avoid any incorrect conclusions.

  2. T-Total Maths

    6 7 8 17 28 7 8 9 18 29 8 9 10 19 5 X 22 = 110 - 40 =70 FORMULA =5N - 70 FORMULAS GRID 5 = 5N - 35 GRID 6 = 5N - 42 GRID 7 =5N - 49 GRID 8 = 5N - 56

  1. Maths Coursework: Car Sales

    5 8700 6500 2200 6 8700 1500 7200 7 8500 995 7505 8 10400 3000 7400 9 9770 7495 2275 10 7540 850 6690 11 11000 5595 5405 12 9880 4995 4885 13 14000 5595 8405 14 11500 4995 6505 15 12000 2600 9400 16 6200 1000 5200 17 5100

  2. Statistic coursework-what has the most influence on the price of a second hand car?

    Instead, I will use the actual numbers instead to produce an accurate result. I put this grouped data in pie chart. Therefore, it can be much easier to see the difference in price and mileage. In addition, I can easily identify 46% of Mercedes ran 20000 or less in mileage

  1. What factors influence the price of a second hand car

    Once I have my data I will work out the percentage depreciation for each car as this is a much better measure of how much the car has gone down in value. For example... To work out the percentage depreciation I will use this formula in an Excel spread sheet:

  2. Used car prices.

    With the help of cumulative frequency graphs I will find the estimate of the median, upper quartile, lower quartile and the Inter quartile Range (IQR). I will only make a cumulative frequency graph and estimate the above, one particular factor or maybe more than one.

  1. Handling data Used car prices

    To avoid any bias I will be make sure that each group has varied value of depreciation. Representation & Interpretation of Data Hypothesis 1 - I predict that as the age of the car increases, the percentage of depreciation in the value of the car increases.

  2. used car coursework

    It shows a positive correlation between used car price and engine size. From the graph I can say that as the engine size increases the used car price increases. The equation of the line is: y = 3967.9x - 2476.1 The gradient is 3967.9 and this tells us that every

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