• 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. Maths Data Handling-Secondhand Car

    size and than used the depreciation to relate it to the 2nd hand price. Again by using just Fords, I have made a graph which clearly shows a positive correlation but there are too many outliers to make a formula.

  2. Handling data Used car prices

    5-6 Years The 21st, 11th, 1st, 18th, 15th, 23rd, 19th and 5th cars. 7-8 Years The 20th, 14th, 17th, 23rd, 22nd, 15th and 16th cars. 9-10 Years The 8th and 4th cars. 11+ Years The 1st car. The following cars have been included into the sample and will be used to find the relationship between age and value of depreciation.

  1. T-Total Maths

    GRID 6 N + N+6 + N+12 + N+11 + N+13 (FORMULA= 5N+42) GRID 7 N + N+7 + N+14 + N +13 + N+15 (FORMULA=5N+49) GRID 8 N + N+8 + N+16 + N+15 + N+17 (FORMULA=5N+56) GRID 9 N + N+9 + N+18 + N+19 + N+17 (FORMULA=5N+63)

  2. Maths Data Handaling

    Then I am going to collect my data and plot it in a table 4)

  1. Car sales

    I will then subtract the necessary information from the database and put then into charts to help show my results. Once I took my random sample of all brands I removed some of the outliers as they would throw the results.

  2. Used second hand cars

    0 81 0 10 1 10 100 100 = 138 = 799 Mean= fx = 138 x , 30 = 4.6 The formula s= becomes Standard deviation= 2.339515619 = 2.34 (3 s.f) The mean of the age of the second hand cars is 4.6 and the standard deviation is 2.34.

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