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

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.

Extracts from this document...

Introduction

NILESH HUDIA        MATHS COURSEWORK 2        NOVEMBER 2001

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

Rover

82,000

1.6

16

£1,000

£6,200

10

Peugeot

119,000

1.1

17

£750

£5,100

11

Peugeot

96,000

1.0

18

£1,350

£9,140

8

Ford

108,000

1.6

19

£2,950

£17,750

8

Ford

96,000

2.9

20

£3,250

£9,990

7

...read more.

Middle

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 difference is I could plot that in a scatter diagram to find the correlation between the depreciation percentage and the age. I found the depreciation with the equation

D=100-((o-p)*100)

Where D= Depreciation, o= the original price and p= price when used

No.

Depreciation (%)

Age

No.

Depreciation (%)

Age

1

39.91

3

10

88.73

10

2

52.82

7

11

49.14

4

3

71.05

6

12

49.44

3

4

67.48

6

13

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

...read more.

Conclusion

Of these 15 values,

¨      80% were outside the majority age,

¨      73% cars were outside the majority mileage,

¨      and 33% cars were outside the majority engine size.

One of the cars, car 25, was reliant on the engine size to make it an unusually priced car, having values for mileage and age close to the mean values for both. The size of the engine gave it an unusually high depreciation.

All the above data prove that the age and the mileage are the two most prominent 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.

...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. used car coursework

    age increases by 1 year the used car price will decrease by �824.32. The intercept of the line is 9092.1 and this tells us that if the age is 0 then the used car price will be �9190.40. This scatter diagram shows the affect on used car price as the mileage increases.

  2. I will research the cars by putting the data I have been given into ...

    I then found that when looking at similar cars colour played a large impact on certain cars. This was because it was part of a trend which was no longer fashionable. The technology table shows that technology does not have a big impact on its own but lack of technology is coupled with an older car.

  1. This piece of coursework is designed to test the use and interpretation of statistics ...

    by using the information shown above for all 36 car records. I have noticed from this scatter diagram that, although the trend line suggests that my hypothesis is right, the information in the graph seems to put forward a different outcome of results to the trend line.

  2. Maths Data Handling-Secondhand Car

    the refined samples I will expect to see a strong positive correlation because as you refine the samples using similar models you tend to get values much closer to the trend line because the cars have similar properties and so depreciate at the same rate.

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

    92 Mitsubishi Carisma 1385 71000 12 100 Nissan 100 NX 1005 43000 12 107 Mercedes SL-Class 89-02 19260 12000 9 114 Fiat Bravo 1125 90000 12 116 BMW 5-Series 1996 6145 19900 10 120 Nissan Almera 9075 90000 3 140 Fiat Stilo 4900 60000 5 146 Toyota Previa 10700 12000

  2. Handling data Used car prices

    With this I can work out how good the relationship is between the two sets of data (mileage and age) using the product moment correlation coefficient. 3. Relating to the second aim, I think that the depreciation values for saloons will have the least depreciation value.

  1. T-Total Maths

    Below are the T-Number and T-Total and the numbers. GRIDS - 5 T NUMBER T-TOTAL 12 25 13 30 14 35 Numbers inside T shape 12 1 2 3 7 12 13 2 3 4 8 13 14 3 4 5 9 14 5 X 12 = 60 - 25 = 35 FORMULA = 5N - 35 T NUMBER

  2. Maths Data Handaling

    �10,423.00 �1,295.00 81000 88 10 36 �11,598.00 �1,195.00 65000 90 11 37 �6,795.00 �1,995.00 47000 71 12 40 �8,272.00 �1,500.00 32000 82 13 41 �13,650.00 �6,995.00 21000 49 14 43 �8,748.00 �1,995.00 60000 77 15 48 �6,828.00 �2,800.00 49000 59 16 50 �9,525.00 �4,395.00 32400 54 17 51 �11,800.00 �3,595.00

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