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

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.

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

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

# Related GCSE Gary's (and other) Car Sales essays

1. ## Car sales

� 49 = �6886.836734693877551020408163265 The median for used car price is: � 4,280 Unlike age, the mean and median for used car price is very different. Upper and lower quartiles Once you have figured out the median, you can then start figuring out the upper and lower quartile.

2. ## Legal and Ethical Analysis of Ford Pinto

In February 1978, NHTSA conducted experimental crash test of 11 Pintos manufactured from 1971 to 1976. The Pintos were staged at speeds between 30 and 35 mph and they all resulted in significant fuel leakage after the crash with 2 cars caught fire (29).

1. ## Used second hand cars

x 30 =1.5 2 Porche 1/100 =0.01 (1/100) x 30 =0.3 0 Renault 5/100 =0.05 (5/100) x 30 =1.5 2 Rolls Royce 1/100 =0.01 (1/100) x 30 =0.3 0 Rover 12/100 =0.12 (12/100) x 30 =3.6 4 Seat 1/100 =0.01 (1/100) x 30 =0.3 0 Suzuki 1/100 =0.01 (1/100)

2. ## Maths Coursework - Used Cars

1995 1.1 52000 7 63.69426752 Rover 416i 14486 3685 1.6 64000 6 74.56164573 Vauxhall Vectra 18580 7999 2.5 20000 2 56.94833154 Vauxhall Tigra 13510 7499 1.4 27000 4 44.49296817 Vauxhall Vectra 18140 6499 2.5 49000 4 64.17309813 Vauxhall Corsa 8900 4995 1.6 24000 2 43.87640449 Vauxhall Nova 5599 1000 1.4

1. ## Factors affecting price of Used Car

These are Ford, Vauxhall, Rover and Fiat respectively. I believe these 4 car makes add up to 51 cars; 16+13+12+10=51 which is more than half the total number of cars. I will then carry out stratified sampling. I will select stratified random sample of size 40.

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

1. ## used car coursework

Used car price New car price 7999 16000 1595 8785 1995 8748 2300 9105 4295 12125 4700 11800 3200 8680 3495 13183 1664 6590 3995 15405 2995 9995 This table compares the used car price to the new car price of Ford cars.

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

BMW 3-Series 91-99 12825 68000 6 31 Skoda Fabia 3585 20000 7 34 Mazda 121 1620 55000 10 43 Mazda Demio 1920 71000 9 70 Daihatsu Sirion 4915 17500 5 71 Mercedes Cab E-Class 10920 9500 10 75 Ford Mondeo 96-00 3335 22000 8 79 Subaru Forester 4550 50000 10

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