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

Gary's Car Sales Mathematics Coursework

Extracts from this document...

Introduction

Gary’s Car Sales Mathematics Coursework  

For this experiment I was given a table of second hand cars for sale showing how the factors eg. age and mileage, effect the cost of a second hand car, compared with the same cars price when new. The table consists of 36 cars separated into 5 different manufacturers. For my investigation I will only use 3 of these manufacturers, Ford, Vauxhall, and Rover. I chose these 3 because they were the makes with the largest amount of information. Using the table I have been given I will try to find out which car is the best value for money. To do this I will have to draw two different types of graph, age against second hand price, and mileage against second hand price, draw a line of best fit, and work out formulas for these graphs.

  Car no. Price   Age Make Cost when Mileage Engine Size     (£) (Years)     new   (£)       (Litres)               1 6,970 3 Ford 11,600 24,000 1.6 2 3,350 7 Peugeot 7,100 85,000 1.1 3 3,995 6 Ford 13,800 52,000 2.0 4 5,300 6 Vauxhall 16,300 70,000 2.0 5 6,500 3 Fiat 8,700 24,000 1.2 6 1,500 9 Vauxhall 8,700 82,000 1.6 7 995 9 Ford 8,500 102,000 1.8 8 3,000 7 Vauxhall 10,400 63,000 1.7 9 7,495 1 Vauxhall 9,770 8,000 1.4 10 850 10 Ford 7,540 124,000 1.6 11 5,595 4 Ford 11,000 41,000 1.6 12 4,995 3 Ford 9,880 34,000 1.4 13 5,595 4 Ford 14,000 55,000 1.6 14 4,995 4 Rover 11,500 40,000 1.4 15 2,600 7 Rover 12,000 82,000 1.6 16 1,000 10 Peugeot 6,200 119,000 1.1 17 750 11 Peugeot 5,100 96,000 1.0 18 1,350 8 Ford 9,140 108,000 1.6 19 2,950 8 Ford 17,750 96,000 2.9 20 3,250 7 Vauxhall 9,990 86,000 1.6 21 5,650 3 Vauxhall 11,150 34,000 1.6 22 4,600 2 Rover 7,300 17,000 1.1 23 5,400 1 Rover 7,300 11,000 1.1 24 4,800 1 Rover 7,300 26,000 1.1 25 2,700 5 Fiat 13,000 51,000 2.0 26 11,000 1 Peugeot 13,800 9,000 1.8 27 2,800 5 Fiat 6,500 43,000 1.0 28 8,000 4 Rover 21,000 142,000 2.3 29 6,495 2 Ford 8,800 23,000 1.3 30 4,050 4 Ford 8,400 48,000 1.3 31 6,300 2 Ford 10,300 26,000 1.3 32 4,100 4 Vauxhall 8,900 37,000 1.3 33 6,600 1 Vauxhall 8,500 9,000 1.3 34 7,800 1 Peugeot 10,500 13,000 1.4 35 8,700 3 Vauxhall 16,000 42,000 2.0 36 2,000 7 Peugeot 8,300 65,000 1.4

                                                                                                                                           Page 2

Using the table I have drawn 4 graphs for age against second hand price.

...read more.

Middle

Vauxhall

Say you wanted to find out how much the Vauxhall will be worth after 8 years.

Because the Vauxhall starts at £8,200 and the gradient is 750 the formula would be shown as:

                                                                                                                                           Page 3

Y = 8200 - (750 x 8)

Y = 8200 - 6000

Y = 2200                                                                                                                          

Therefore the value of the car after 8 years would be £2,200.

Rover

Say you wanted to find out how much the Rover will be worth after 8 years.

Because the Rover starts at £5, from 800 and the gradient is 450 the formula would be shown as:

Y = 5800 - (450 x 8)

Y = 5800 - 3600

Y = 2200

Therefore the value of the car after 8 years would be £2,200

  Car Manufacturer

Value after:

Ford

Vauxhall

Rover

Cost when new

£7,900

£8,200

£5,800

2 Years

£6,450

£6,700

£4,900

4 Years

£5,000

£5,200

£4,000

6 Years

£3,550

£3,700

£3,100

8 Years

£2,100

£2,200

£2,200

10 Years

£650

£700

£1,300

This table shows that after 10 years the Rover is valued the highest, despite being the cheapest to start with. So far this investigation  is in Rovers favour showing that it is the best value car.

For mileage against price I have drawn another 4 graphs. 1 for each manufacturer as before.

The gradients for these graphs are:

Ford

The graph for Ford is a strong, negative correlation. The Ford becomes worthless when it reaches 126,000 miles.

...read more.

Conclusion

Because the Rover starts at £5,800 and the gradient is 400 the formula would be shown as:

Y = 5800 - (400 x 8)

Y = 5800 - 4000

Y = 2600

                                                                                                                                           Page 5

Therefore the value of the car after 80,000 miles would be £2,600.

The table below shows the value of each make of car after various mileages using the formula.

  Car Manufacturer

Value after:

Ford

Vauxhall

Rover

0 Miles (Cost when new)

£7,900

£8,200

£5,800

20,000 Miles

£6,600

£6,600

£5,000

40,000 Miles

£5,300

£5,000

£4,200

60,000 Miles

£4,000

£3,400

£3,400

80,000 Miles

£2,700

£1,800

£2,600

100,000 Miles

£1,400

£200

£1,800

Looking at this table Rover is the best value car as it loses the least amount of money after every 10,000 miles. After starting off the costliest the Vauxhall is only worth £200 after 100,000 miles, which makes it the car that loses the highest value by far. Whereas the Rover starts off the cheapest and finishes the highest priced of the three manufacturers after 100,000 miles.

In this experiment I discovered that Rover is the best value car out of the three that I chose to investigate. Vauxhall was the worst value car because it lost the most money on age and mileage. Ford was almost as bad value for money as the Vauxhall. My investigation could be improved by including more manufacturers and their cars. Also because the graphs are not 100% accurate. In real life as soon as you drive a new car off the forecourt it drops in value instantly. This means the graphs should have looked more like

...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. CAR SALES MATHS COURSEWORK

    In contrast I feel that the make will decide the price of a car to a certain extent. PLAN OF ACTION Firstly, I am going to plot graphs variables I have chosen to investigate. I will also use standard deviation and rank correlation coefficient to give me an idea if the correlation between certain aspects of my data.

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

    I have expanded the working out of the correlation by using Spearman's rank. Using this method, I am going to rank the price used and the age in an ascending order to its specific ranking. From here I will take the rankings away from each other and square them.

  1. Gary's Car Sales.

    60.04 4 5 25.29 3 14 56.57 4 6 82.76 9 15 78.33 7 7 88.29 9 16 83.87 10 8 71.15 7 17 85.29 11 9 23.29 1 18 85.23 8 No. Depreciation (%) Age No. Depreciation (%) Age 19 83.38 8 28 61.90 4 20 67.47 7 29

  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

  1. Car sales

    The median of a list of data is when the data is put in ascending or descending order, and the median is the middle number. The reason I only have 49 rather than 50 in my sample, Is because when I had an anomaly in my results I totally removed it.

  2. Legal and Ethical Analysis of Ford Pinto

    On May 9, 1978, NHTSA announced that it had made an initial determination that a safety defect existed in the fuel systems of Ford Pintos built between 1971 through 1976. NHTSA claimed that it was aware of 38 cases in which real-end collisions of Pintos had resulted in fuel tank damage, leakage, and/or ensuing fires.

  1. Used second hand cars

    Here it is proved that my hypotheses were correct the age of the car does affect the price of the car and its price decreases with more aged car. To find the value of the correlation I have conducted spearman's rank.

  2. The aim of this coursework is to find out what affects the price of ...

    6595 4 black 1.6 11 Fiat Bravo 10351 3495 5 red 1.4 16 Rover 820 SLi 21586 3795 6 red 2 17 Mitsubishi Carisma 15800 5999 2 blue 1.8 19 Rover 416i 13586 3795 6 silver 1.6 25 Rover Metro 6645 895 7 Nightfire 1.1 29 Volkswagen Golf 400 15

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