• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Gary's Car Sales.

Extracts from this document...

Introduction

Gary's Car Sales

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

Vauxhall

86,000

1.6

21

£5,650

£11,150

3

...read more.

Middle

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

    Each one of these factors produced similar scatter diagrams with similar trend lines for each car make. Comparing 2nd hand prices of Renault and Vauxhall cars Make 2nd hand price Renault 1495 Renault 1995 Renault 2748 Renault 4999 Renault 6999 Vauxhall 850 Vauxhall 1000 Vauxhall 2900 Vauxhall 3191 Vauxhall 3495

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

    I assume that the higher the age of the car, the lower the price. I have adjusted my data and have added the ages of all the chosen cars. Here is the data that I am going to use: Car Make Model Price Used Mileage Age no.

  1. Maths - statistical driving test

    To start the investigation I need to draw up a tally table for the males and one for the females in order to the data into separate groups, from this I will find it easer to work with the existing data that I previously stratified sampled within hypothesis one.

  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. T-Total Maths

    Know l have got a + (positive) number for my second T-Shape. T SHAPE TURNED LEFT GRID 5 Numbers inside T shape T NUMBER T-TOTAL 10 43 9 38 8 33 10 9 8 3 13 9 8 7 2 12 8 7 6 1 11 5 x 10 = 50 - 43 = 7 FORMULA =

  2. Car sales

    'I predict that the older the car, and the higher the mileage of the car, the lower the used price will be.' I am going to collect the require information and make some graphs by using the used car database provided; I will then take a random sample from this.

  1. Legal and Ethical Analysis of Ford Pinto

    Ford believed that most of its problems were the result of external forces, not a consequence of its own operational failings or management shortcomings. Even the company's chairman, Henry Ford, II, lamented that "it's the mess in which we live."

  2. Used second hand cars

    Make Makes given in decimal point Number of makes in the sample of 30 The cars rounded to their nearest whole number Audi 1/100 =0.01 (1/100) x 30 =0.3 0 Bentley 1/100 =0.01 (1/100)

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