• 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

    The mean age of a car is: 374 � 49 = 7.6326530612244897959183673469388 The median age of a car is: 7 For the age of the car the mean and median are quite close. When you have a long list of numbers where most of them are different, you start creating ranges.

  2. Legal and Ethical Analysis of Ford Pinto

    and made an offer to install modifications which would have improved the car's safety. Ford could have done this while simultaneously pointing out that the car as designed met existing safety standards. While issuing the recall and the admission of safety problems, Ford could have publicly apologized for any deaths or injuries which had resulted from use of its product.

  1. Used second hand cars

    The box and whisker diagram has a positive skew. The median is not in the middle of the diagram.

  2. Maths Coursework - Used Cars

    8595 2495 1.4 33000 6 70.97149506 Rover Metro 6645 895 1.1 43000 7 86.53122649 Rover 214i 9565 1700 1.4 55000 8 82.22686879 Rover 623GSi 24086 2975 2.3 96000 5 87.64842647 Rover Club 19530 14999 1.8 2000 1 23.20020481 Rover 623 GSi 24086 2975 2.3 96000 6 87.64842647 Rover Metro 5495

  1. CAR SALES MATHS COURSEWORK

    between age and mileage I use spearman's rank to see if there was a correlation. Rank correlation of Mileage and Age = 0.857 . 0.857 is very close to 1 suggesting there is a strong positive correlation between age and mileage.

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

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

    Ford Puma 12295 7560 5 10000 Ford Galaxy 21245 12370 5 10000 Ford Cougar 21980 7985 6 10000 Ford Galaxy 2000 25597 8990 7 10000 Ford Focus 12000 4615 7 10000 Ford Galaxy 18995 9715 7 10000 Ford Fiesta 8250 2670 7 10000 Ford Fiesta 99-02 7695 2100 8 10000

  2. Handling data Used car prices

    miles and it would contain many modern features, so therefore the price of the car is only one of many factors that affects the car's price when second hand.

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