• 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
  10. 10
    10
  11. 11
    11
  12. 12
    12
  • Level: GCSE
  • Subject: Maths
  • Word count: 2603

The task for this investigation is to statistically analyse the data given to compare Grays used car sales with the other pieces of information given in the table.

Extracts from this document...

Introduction

Car No

Price £

Age

Years

Make

Cost when new

Mileage

Engine Size

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

6,970

3,350

3,995

5,300

6,500

1,500

995

3,000

7,495

850

5,595

4,995

5,595

4,995

2,600

1,000

750

1,350

2,950

3,250

5,650

4,600

5,400

4,800

2,700

11,000

2,800

8,000

6,495

4,050

6,300

4,100

6,600

7,800

8,700

2,000

3

7

6

6

3

9

9

7

1

10

4

3

4

4

7

10

11

8

8

7

3

2

1

1

5

1

5

4

2

4

2

4

1

1

3

7

Ford

Peugeot

Ford

Vauxhall

Fiat

Vauxhall

Ford

Vauxhall

Vauxhall

Ford

Ford

Ford

Ford

Rover

Rover

Peugeot

Peugeot

Ford

Ford

Vauxhall

Vauxhall

Rover

Rover

Rover

Fiat

Peugeot

Fiat

Rover

Ford

Ford

Ford

Vauxhall

Vauxhall

Peugeot

Vauxhall

Peugeot

11,600

7,100

13,800

16,300

8,700

8,700

8,500

10,400

9,770

7,540

11,000

9,880

14,000

11,500

12,000

6,200

5,100

9,140

17,750

9,990

11,150

7,300

7,300

7,300

13,000

13,800

6,500

21,000

8,800

8,400

10,300

8,900

8,500

10,500

16,000

8,300

24,000

85,000

52,000

70,000

24,000

82,000

102,000

63,000

8,000

124,000

41,000

34,000

55,000

40,000

82,000

119,000

96,000

108,000

96,000

86,000

34,000

17,000

11,000

26,000

51,000

9,000

43,000

142,000

23,000

48,000

26,000

37,000

9,000

13,000

42,000

65,000

1.6

1.1

2.0

2.0

1.2

1.6

1.8

1.7

1.4

1.6

1.6

1.4

1.6

1.4

1.6

1.1

1.0

1.6

2.9

1.6

1.6

1.1

1.1

1.1

2.0

1.8

1.0

2.3

1.3

1.3

1.3

1.3

1.3

1.4

2.0

1.4

Grays Car Sales  

The task for this investigation is to statistically analyse the data given to compare Grays used car sales with the other pieces of information given in the table. I will begin to look at the data to decide how I will proceed with the investigation. The following data was given to me.

The pieces of information that I am going to compare are the price with the mileage and the age of the car to see if the cars do affect the price. I think that the age will affect the age because the older the age the less the car will cost, which I also think that the make will affect it as well.

I think that the engine size will affect the price and probably the make of the car mileage as well.

I am now going to start by putting the information in order in order to compare with the price.

...read more.

Middle

3,350/7 = 478.57

3,995/6 = 665.83

5,300/6 = 883.33

6,500/3 = 2166.66

1,500/9 = 166.66

995/9 = 110.55

3,000/7 = 428.57

7,495/1 = 7495

850/10 = 85

5,595/4 = 1398.75

4,995/3 = 1665

5,595/4 = 1398.75

4,995/4 = 1248.75

2,600/7 = 371.42

1,000/10 = 100

750/11 = 68.18

1,350/8 = 168.75

2,950/8 = 368.75

3,250/7 = 464.28

5,650/3 = 1883.33

4,600/2 = 2300

5,400/1 = 5400

4,800/1 = 4800

2,700/5 = 540

11,000/1 = 11000

2,800/5 = 560

8,000/4 = 2000

6,495/2 = 3247.50

4,050/4 = 1012.50

6,300/2 = 3150

4,100/4 = 1025

6,600/1 = 6600

7,800/1 = 7800

8,700/3 = 2900

2,000/7 = 285.71

Table 1

Car No

Price

Make

Percentage drop for the price in %

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

750

850

995

1,000

1,350

1,500

2,000

2,600

2,700

2,800

2,950

3,000

3,250

3,350

3,995

4,050

4,100

4,600

4,800

4,995

4,995

5,300

5,400

5,595

5,595

5,650

6,300

6,495

6,500

6,600

6,970

7,495

7,800

8,000

8,700

11,000

Ford

Peugeot

Ford

Vauxhall

Fiat

Vauxhall

Ford

Vauxhall

Vauxhall

Ford

Ford

Ford

Ford

Rover

Rover

Peugeot

Peugeot

Ford

Ford

Vauxhall

Vauxhall

Rover

Rover

Rover

Fiat

Peugeot

Fiat

Rover

Ford

Ford

Ford

Vauxhall

Vauxhall

Peugeot

Vauxhall

Peugeot

2,323.33/5100 × 100 = 45.5%

478.57/6200 × 100 = 7.71%

665.83/6500 × 100 = 10.2%

883.33/7100 × 100 = 12.4%

2,166.66/7300 × 100 = 29.6%

166.66/7300 × 100 = 2.28%

110.55/7300 × 100 = 1.51%

428.57/7540 × 100 = 5.68%

7,495/8300 × 100 = 90.3%

428.57/8400 × 100 = 5.10%

1,398.75/8500 × 100 = 16.4%

1,665/8500 × 100 = 19.5%

1,398.75/8700 × 100 = 16.0%

1,248.75/8700 × 100 = 14.3%

371.42/8800 × 100 = 4.22%

100/8900 × 100 = 1.12%

68.18/9140 × 100 = 0.74%

168.75/9770 × 100 = 1.75%

368.75/9880 × 100 = 3.73%

464.28/9990 × 100 = 4.66%

1,883.33/10300 × 100 = 18.2%

2,300/10400 × 100 = 22.1%

5,400/10500 × 100 = 51.4%

4,600/11000 × 100 = 41.8%

540/11150 × 100 = 4.84%

1,1000/11500 × 100 = 95.6%

560/11600 × 100 = 4.82%

2,000/12000 × 100 = 16.6%

3,247.50/13000 × 100 = 24.9%

1,012.50/13800 × 100 = 7.33%

3,150/13800 × 100 = 22.8%

1,025/14000 × 100 =7.32%

6,600/16000 × 100 = 41.2%

7,800/16300 × 100 = 47.8%

2,900/17750 × 100 = 16.3%

285.71/21000 × 100 = 1.36%

Table 2

Fords

Car No

Drop per Year

1

3

7

10

11

12

13

18

19

29

30

31

45.5 /3

10.2/6

1.51/9

5.10/10

16.4/4

19.5/3

16.0/4

1.72/8

3.73/8

24.9/2

7.33/4

22.8/2

15.5%

1.7%

0.16%

0.51%

4.1%

6.5%

4%

0.21%

0.46%

12.4%

1.83%

11.4%

   Average drop per year

4.86%

Vauxhalls
Car No
Drop Per Year

4

6

8

9

20

21

32

33

35

12.4/6

2.28/9

5.68/7

90.3/1

4.66/7

18.2/3

7.32/4

41.2/1

16.3

2.06%

0.25%

0.81%

90.3%

0.66%

6.06%

1.83%

41.2%

5.43%

Average drop per year

16.5%

Tables 3

Peugeots

Car No

Drop Per Year

2

16

17

26

34

36

7.71/7

1.12/10

0.74/11

95.6/1

47.8/1

1.36/7

1.10%

0.11%

0.06%

95.6%

47.8%

0.19%

...read more.

Conclusion

Next I am going to look at the prices themselves. I split the prices into ranges of 1000 and the graph shows the median and the inter-quartile range.

Price

Frequency

Cumulative Frequency

0<x<1000

1000<x<2000

2000<x<3000

3000<x<4000

4000<x<5000

5000<x<6000

6000<x<7000

7000<x<8000

8000<x<9000

9000<x<10000

10000<x<11000

4

3

5

3

6

5

5

3

1

0

1

4

7

12

15

21

26

31

34

35

35

36

From the data above it proves that the age and the mileage are the two most leading deciding factors of the price and the depreciation of a car. The size of engine however does not affect this by comparing it with the tables and using the depreciation to do this and that there are 12 cars with unusual mileage and age.

I have also found out that the age and price both have a negative correlation using a scatter graph to do this.

Next I could find the main contributing factors to the price is using the standard and 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. CAR SALES MATHS COURSEWORK

    I still however feel that other variables can affect the price. Earlier I plotted the graph for engine size ans price when new, now I will plot a graph for engine size and price decrease/age. This should hopefully give an insight in to the factors which most effect the price of a car.

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

    8 90000 162 Mercedes CLK 40590 15990 8 90000 159 Mercedes V-Class 28220 8980 9 90000 194 Mercedes C-Class 31575 4995 11 90000 81 Mercedes E-Class 29240 12150 7 103000 Analysing and Calculating Below is a XY scatter graph that allows me to view the correlation between price and mileages

  1. Car sales

    I did this by checking that there weren't any 'silly' results e.g. a car that is 1million years old. I used scatter graphs because you can easily subtract information from it and its quick and easy to use. On the graph I entered a trend line to show whether there is a positive or negative correlation.

  2. Used second hand cars

    But because we can see that the car which is ten years old has a lower price than the cars aged 1, 2, and 4 and so on. To make sure that I get an accurate figure of how the price depreciates per year, I have found out the percentage depreciation.

  1. Maths Data Handling-Secondhand Car

    Using just Fords, I have made a scatter graph to show how much more the sample has been refined and how much stronger the correlation gets when you refine the sample, without any proper outliers, this graph has a positive correlation.

  2. Handling data Used car prices

    value as a percentage value which has been calculated by using the formula: difference in price/original X 100. To do the stratified sample I will need to pick a proportional amount of cars from each group. Out of the 100 cars in the database, I want a sample of 30

  1. T-Total Maths

    25 7 16 24 25 26 8 17 25 26 27 5 X 2 = 10 - 73 = - 63 FORMUAL = 5N + 63 GRID-10 T NUMBER T TOTAL 2 80 3 85 4 90 5 95 6 100 7 105 8 110 9 115 Numbers inside T

  2. Maths Data Handaling

    26 85 �7,740.00 �3,495.00 55000 53 27 86 �7,659.00 �1,664.00 37000 75 28 91 �7,510.00 �3,769.00 38000 30 29 92 �8,710.00 �4,693.00 50000 46 30 94 �5,445.00 �1,195.00 52000 64 I am now going to explain how I had worked out % price drop in price The formula is %Price

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