• 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 car coursework

    The intercept of the line is 5823.6 and this tells us that if the used car price is �0 then the new car price will be �5823.60. Overall from looking at these scatter diagrams I have realised that the used car price is affected by different factors such as mileage, age, engine size.

  2. I have been given instructions to collect data for my GCSE statistics coursework and ...

    Below I have randomly selected 4 cars, with their price when new and second hand, this is simply to show how the much the price of the second hand car is different to when new. If you look at the graph, you can see that the price when new is

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

    Ford and Mercedes' mean and median Mercedes-mileage Mercedes-mileage Median=39000 Mercedes-price (GBP) Mercedes-price (GBP) Median=12665 Ford-mileage Ford-mileage Median=10000 Ford-Price (GBP) Ford-Price (GBP) =4823.5 Median=4425 I worked out the mean of my data because it is usually the most representative because it uses all the data.

  2. 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.

  1. Handling data Used car prices

    As you can see from the table, there are clearly more hatchbacks than any other, but this should not cause any bias or unreliable results. The pages after this show the data for the three groups split into 5 groups for the value of depreciation - 0-20%, 21-40%, 41-60%, 61-80% and 81-100%.

  2. T-Total Maths

    16 = 80 - 39 = 49 FORMUAL =5N - 49 GIRD-8 Numbers inside T shape T NUMBER T TOTAL 18 34 19 39 20 44 21 49 22 54 23 59 18 1 2 3 10 19 2 3 4 11 20 3 4 5 12 21 4 5

  1. Used second hand cars

    Then I rounded up my answer to the nearest whole number. Process: SHIFT, RAN#, =, *100 The bigger the sample, the more useful the data will be. A sample of size 25 is an adequate minimum. 30 is a sensible size for a sample because it is bigger than 25 and because it divides 360 exactly.

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

    SELECTED DATA] In the table above I have a column with the second hand price, but I do not feel this is the best way to compare how much the car has gone down in value compared to other cars.

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