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

Gary&amp;#146;s used car sales

Extracts from this document...

Introduction

My task for this coursework is to statistically analyse the data given to me regarding Gary’s used car sales. I shall begin with looking at the data. The following data was given to me.

 No. Price Price when New Age Make Mileage Engine Size 1 £6,970 £11,600 3 Ford 24,000 1.6 2 £3,350 £7,100 7 Peugeot 85,000 1.1 3 £3,995 £13,800 6 Ford 52,000 2.0 4 £5,300 £16,300 6 Vauxhall 70,000 2.0 5 £6,500 £8,700 3 Fiat 24,000 1.2 6 £1,500 £8,700 9 Vauxhall 82,000 1.6 7 £995 £8,500 9 Ford 102,000 1.8 8 £3,000 £10,400 7 Vauxhall 63,000 1.7 9 £7,495 £9,770 1 Vauxhall 8,000 1.4 10 £850 £7,540 10 Ford 124,000 1.6 11 £5,595 £11,000 4 Ford 41,000 1.6 12 £4,995 £9,880 3 Ford 34,000 1.4 13 £5,595 £14,000 4 Ford 55,000 1.6 14 £4,995 £11,500 4 Rover 40,000 1.4 15 £2,600 £12,000 7

Middle

Rover

142,000

2.3

29

£6,495

£8,800

2

Ford

23,000

1.3

30

£4,050

£8,400

4

Ford

48,000

1.3

31

£6,300

£10,300

2

Ford

26,000

1.3

32

£4,100

£8,900

4

Vauxhall

37,000

1.3

33

£6,600

£8,500

1

Vauxhall

9,000

1.3

34

£7,800

£10,500

1

Peugeot

13,000

1.4

35

£8,700

£16,000

3

Vauxhall

42,000

2.0

36

£2,000

£8,300

7

Peugeot

65,000

1.4

The first question, which occurred to me, was, is there any correlation between the difference between the price when new and the age. I expected there to be a positive correlation if there was one, showing that as the age went up, the drop in price from when the car is new and when it is re-sold increases. Below is a table of the Price differences and the age.

 No. Price Difference Age No. Price Difference Age 1 £4,630 3 19 £14,800 8 2 £3,750 7 20 £6,740 7 3 £9,805 6 21 £5,500 3 4 £11,000 6 22 £2,700 2 5 £2,200 3 23 £1,900 1 6 £7,200 9 24 £2,500 1 7 £7,505 9 25 £10,300 5 8 £7,400 7 26 £2,800 1 9 £2,275 1 27 £3,700 5 10 £6,690 10 28 £13,000 4 11 £5,405 4 29 £2,305 2 12 £4,885 3 30 £4,350 4 13 £8,405 4 31 £4,000 2 14 £6,505 4 32 £4,800 4 15 £9,400 7 33 £1,900 1 16 £5,200 10 34 £2,700 1 17 £4,350 11 35 £7,300 3 18 £7,790 8 36 £6,300 7

If you look at graph 1, you will see that I was wrong. There was no correlation between the price difference and the age. After seeing this, I thought that if I found what percentage of the original price the price

Conclusion

All the above data prove that the age and the mileage are the two most important deciding factors of the price and depreciation of a car, with the size of the engine entering into the equation if there is nothing out of the ordinary about the age and mileage.

In conclusion, I have discovered the following facts about the data provided:

·        I found that there is no correlation between the price difference and the age, using a scatter diagram.

·        I found that there is a strong positive correlation between the depreciation and the age, using another scatter diagram.

·        I found a way to predict a percentage loss using a line of best fit and the lines equation.

·        I found that a car decreases in value more in its first three years than at any other time using a scatter diagram.

·         I found the main contributing factors and one backup factor to the price using the standard deviation, mean, inter-quartile range and majority range for the prices.

By Jamie Barnes

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

7 64000 Ford Probe 20570 1055 12 71000 Data - Mercedes Car Make Model Price New Price Old Age Mileage 77 Mercedes C-Class 24090 12530 7 6500 10 Mercedes SLK 35025 19955 7 9000 71 Mercedes Cab E-Class 40475 10920 10 9500 176 Mercedes E-Class 42340 30000 4 11000 2

2. Handling data Used car prices

21000-30999 Miles The 4th, 8th and 2nd cars. 31000-40999 Miles The 2nd, 1st, 7th and 10th cars. 41000-50999 Miles The 2nd, 10th, 9th, 6th, 16th and 19th cars. 51000-60999 Miles The 12th, 3rd, 7th, 11th and 1st cars. 61000-70999 Miles The 5th, 1st and 8th cars.

1. used car coursework

This suggests that the cars are not made for the same market as there is a big difference in second hand price. The most expensive car for Vauxhall is �7999 where as the most expensive Renault was �6999. The least expensive Vauxhall was �850 but the least expensive for Renault was higher at �1495.

2. Car sales

The 12.25th (rounded down to 12th) number in my sample was the lower quartile. This was �1330 for used car price and 5 years for age. The 36.75th (rounded up to 37th) number in my sample was the upper quartile.

1. Used second hand cars

Display: Line graph The graph shows how some cars aged really old have an average price higher than few cars aged less influenced by their price value when new. The points plotted random as each cars value are different when they were new.

2. Maths Coursework - Used Cars

All the graphs have close to identical linear lines in the scatter diagrams. The car make with the steepest gradient is the Fiat, which means that the mileage has a greater value for Fiat cars. The car make with the gentlest gradient is the Rover, which tells us that it is least influenced by mileage.

1. Factors affecting price of Used Car

Of Cars for all Car Make . Ford: 16/51 X 40 = 13 . . Vauxhall: 13/51 X 40 = 10 Rover: 12/51 X 40 = 9 Fiat: 10/51 X 40 = 8 Now that I know how many cars of each car make I need; I will make a random selection.

2. Maths coursework - car prices

as the age of the car increases, the price of the car decreases. I will test this hypothesis by drawing a scatter diagram of 'price now' against the 'age of the car', I will then obtain the line of best fit through points of prices against age and estimate from

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