• 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’s used car sales

Extracts from this document...

Introduction

image02.pngimage00.png

image03.png

image01.png

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

...read more.

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

...read more.

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

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

    -0.08 Upon closer inspection it is also clear that the deviation for the mileage has deviated to the left suggesting that. Descriptive Statistics: Mileage Variable N N* Mean StDev Minimum Q1 Median Q3 Maximum Mileage 36 0 48847 26548 8000 27250 47500 63750 124000 To further look at the correlation

  2. Gary's Car Sales Mathematics Coursework

    To work out the formula for the price of a used car with a certain mileage I have used the same formula as last time. Y = Answer C = Cost when new M = Gradient X = Age in years The formula for a negative gradient is Y = C - MX.

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

  1. Used second hand cars

    Age of the car Average percentage depreciation 1 20.77932623 2 42.30898654 3 53.65260137 4 52.12021079 5 60.0931322 6 67.0946609 7 79.53066255 8 77.21169121 10 74.74962064 You can clearly see in the previous table that the average depreciation increases as the age increases too.

  2. Handling data Used car prices

    This is repeated 5 more times because I need a sample of 6 from this group. 1-2 Years The 6th, 10th, 4th, 9th, 8th and 16th cars need to be picked from this group. 3-4 Years The 17th, 11th, 19th, 1st, 6th and 8th cars.

  1. T-Total Maths

    63 FORMULA =5N + 63 FORMULAS GRID 5 = 5N +35 GRID 6 = 5N + 63 GRID 7 =5N + 49 GRID 8 = 5N + 56 GRID 9 = 5N + 63 GRID 10 =5N + 70 I have turned the T-shape upside down.

  2. used car coursework

    It shows a negative correlation between used car price and age. From the graph I can say that as the age increases the used car price decreases. The equation of the line is: y = -824.32x + 9092.1 The gradient is -824.32 and this tells us that every time the

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