• 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. Statistically analyse the data given to me regarding Gary's used car sales.

    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

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

    In addition I feel that once again I cannot fully trust engine size a defining factor. The main reason being is that I got better correlations for age/mileage etc. CREATING A MODEL To further my original line of enquiry I am now ready to create a model using the data and my knowledge.

  2. Car sales

    This is exactly what my graphs will look like but with different results. I chose this graph because the data can be easily analysed and interpreted. And once a line of best fit is added, you can estimate results that aren't actually on the graph.

  1. Legal and Ethical Analysis of Ford Pinto

    Knowing that there was a problem and knowing that it could partially "fix" the problem with some relatively inexpensive modifications, Ford continued to maintain in public that its vehicles were safe, or at least as safe as other comparable products on the market.

  2. Maths Data Handling-Secondhand Car

    which, instead of being listed normally, the engine size has been listed in cylinder size. After using secondary sources such as the internet I have discovered that this 1989 Graduate had an engine size of 1.1 and if I change that result this is the graph I am left with:

  1. Gary's Car Sales.

    �7,300.00 11 4 �5,595.00 �11,000.00 �5,405.00 13 4 �5,595.00 �14,000.00 �8,405.00 14 4 �4,995.00 �11,500.00 �6,505.00 28 4 �8,000.00 �21,000.00 �13,000.00 30 4 �4,050.00 �8,400.00 �4,350.00 32 4 �4,100.00 �8,900.00 �4,800.00 25 5 �2,700.00 �13,000.00 �10,300.00 27 5 �2,800.00 �6,500.00 �3,700.00 4 6 �5,300.00 �16,300.00 �11,000.00 2 7 �3,350.00 �7,100.00

  2. Maths Coursework: Car Sales

    And also showing a negative correlation as the price drops faster when the car is younger than the older and the price will never reach a negative price. It might slow down less and less but will not reach a negative value.

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