• 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
  • Level: GCSE
  • Subject: Maths
  • Word count: 5858

Objective; to investigate the relationship between used car price and age of car.

Extracts from this document...


30/6/03 Mathematics Coursework C+H/WK Objective; to investigate the relationship between used car price and age of car. Equipment; to do this task I will need the following equipment; Ruler, Pencil, Pen, Multimedia computer (to write up investigation in neat), And plenty of A4 paper. My Hypothesis; Since all the cars from the given data base are MODERN cars, I predict that they ONLY decrease in value once they are bought. It would be different for really old CLASSICS as they can be so old that they actually increase in their value as they age. This is because; 1. The demand of these cars rises as few are left available, from being scraped. 2. Since theses cars lack modern technology of galvanised metal, they suffer from rust, thus people selling them in mint condition spent thousands of pounds restoring the car to it's original condition, hence they want that money back when they come to sell it. 3. The cars are different from modern cars, and give the owner a high status through being so immensely unique. Because all these cars in the database are all modern, the cars should, in my prediction decrease in value as they age and those that are guaranteed to become classics may depreciate slower in value than those that aren't. Also those of luxury and prestigious names like Mercedes, Bentley and Rolls-Royce, and those that have a high demand will loose their value more slowly then those that aren't, but just as a generalisation, no matter what car i choose, the older it is, the lesser it's value is against those that are younger. This means that in the graphs I produce there is a TREND in the cars correlation which must be NEGATIVE in order for my hypothesis to be true. Sampling; (Planning) My plan involves selecting 40 cars from the total of 100 cars by car in the list. ...read more.


As you can see from the line i drew on the graphs the 2 other cars I mentioned that were vastly higher in price than the others for the same age join coincidentally almost perfectly up together with the fiesta at the bottom. I know it is false as the Ford Fiesta is a very simple car that owners wouldn't sell for a complex price- probably �1,700 not an absurd �1,664!. However as the rest of the data presents the older the car is the lesser it's price is against those that are younger. This means that my Hypothesis is correct but just to be sure before I do my predictions I will produce another scatter diagram which gives the mean price data for each car age group. This means adding all the cars prices together for each age group and dividing it by how many cars there are in that age group; Mean price for 1 year in pounds(�) = (6,795+7,995+13,500+10,999)/4 = 32,289/4 = 9,822.25 Mean price for 2 years in pounds(�) = (4,995+4,995+7,999+5,999)/4 = 23,988/4 = 5,997 Mean price for 3 years in pounds(�) = (5,999+4,500+3,999)/3 = 14,498/3 = 4,832.67 Mean price for 4 years in pounds(�) = (6,999+3,995+4,300+3,769+6,895)/5 = 25,958/5 =5,191.60 Mean price for 5 years in pounds(�) = (3,400+4,693+3,495)/3 = 11,588/3 = 3,862.67 Mean price for 6 years in pounds(�) = (3,685+6,995+2,995+3,795+6,995+2,800+2,975)/7 => mean price = 30,240/7 = 4,320 Mean price for 7 years in pounds(�) = (3,695+1,500+2,595+3,495+1,595+795)/6 = 13,675/6 => mean price = 2,279.17 Mean price for 8 years in pounds(�) = (1,495+1,995+2,450+1,795)/4 = 7,735/4 = 1,933.75 Mean price for 9 years in pounds(�) = (1,595+1,195)/2 = 2,790/2 = 1,395 Mean price for 10 years in pounds(�) = (1,664+1,000)/2 = 2,664/2 = 1,332 Then I used exactly the same procedures as with the last graph, listing the car data on excel to process it onto a scatter diagram over the next page. ...read more.


A cars value is around 30% it's value at 10 years old compared to when it is 4 years old 2. That super cars cost almost 20 times more than popular cars when they are 7.5 years old! 3. Than popular modern cars cost around �500-�750 more when they are 4 years old compared to when they are 5 years old. 4. That super cars have a difference in price between 6 years and 7.5 years 6 times more than then difference for the same aged modern, cheap and popular cars. 5. That the depreciation of modern cars by 7.5 years is twice as fast as that for same aged super cars. Comparing these statements to my hypothesis I know that my hypothesis is correct as modern cars do depreciate in value, hence the reason why there is negative correlation in all the graphs, that more prestigious cars like the Ferrari do depreciate slower than those that are less desirable, and even the cheapest new cars like the new Volkswagen Beetle hold their value well because of their high demand. Also the part that says there's a trend in the cars values compared to their ages is true as from the first scatter diagrams only 3 out of about 40 cars were out of that trend. Evaluating; I would say that this investigation has been a success. I managed to find a link between the car price and car age and managed to make points on how this differs throughout certain ages and for certain types of cars. If I were to redo this investigation, I would make sure that I had a bigger range of cars to choose from with a bigger age range of perhaps 1 to 50 years not 1 to 10. I'd also use cars in the graph that have ages between whole years like 4.5 years and 6.7 years etc... I'd also used a larger sample of perhaps 200 cars instead of just 40 as which would give a better mean price for the value of cars in one particular age group. ...read more.

The above preview is unformatted text

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

    11819 5,499 8365 5,499 7756 5,399 All the ranges for the price are quite consistent so there shouldn't be any outliers there. Similarly, the ranges for the mileage are also quite consistent so there shouldn't be any outliers here either.

  2. used car coursework

    The equation of the line is: y = -0.0815x + 8218.6 The gradient is -0.0815 and this tells us that every time the mileage increases by 1 year the used car price will decrease by �0.0815. The intercept of the line is 8218.6 and this tells us that if the

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

    Investigating how mileage affects depreciation Investigating depreciation per 1000 miles Depreciation per 1000 miles (%) Frequency Mid-interval value Frequency x Mid-interval value Cumulative frequency 0<x<1 8 0.5 4 8 1<x<2 68 1.5 102 76 2<x<3 11 2.5 27.5 87 3<x<4 5 3.5 17.5 92 4<x<6 3 5 15 95 6<x<13

  2. Maths Coursework:Used Cars

    went very well because I was able to prove my hypothesis right most of the time with a few exceptions which may be because of errors in the spreadsheet which I use to make all the graphs and tables in this coursework.

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

    Therefore, I will use the following formula. For example, a car worth 26040 when new but the second hand price is 11395 and I would like to see how much it has depreciated so and the price has depreciated 56.24% over 5 years therefore .

  2. Maths Data Handling-Secondhand Car

    I shall look at percentage depreciation. I have used this formula to work out the percentage depreciation: There is only one real outlier in this graph and that belongs to the 15 year old Volkswagon Golf. The computer sets the depreciation for this car as 0 because there is no recorded value for the original price of the car in the spreadsheet.

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

    Eventually, the random numbers produced are spread evenly over the whole interval from zero to one. The following calculator command will be used to generate the random numbers I need for my sample: * Enter 204Ran# to generate a random number between 0 and 204 After the Ran# command is

  2. Maths - statistical driving test

    I am now going to investigate further by dividing instructor B's students into two separate scatter graphs, one to explore males and the other females performance levels, again looking at the number of lessons and mistakes. As before I will be looking for negative correlation.

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