• 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

    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. 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. Gary's Car Sales.

    the scatter diagram of the depreciation versus the age, you can definitely see a strong positive correlation where graph#1 did not. This is because the price difference is subject to the original price. If the original price is high, the price difference may be large in comparison to the others,

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

  1. Car sales

    Explain line of best fit = you can use the line of best fit to estimate one measurement, given another. The more closely the points are clustered around the line of best fit, the better the estimate Pie charts I have made pie charts for both age and make.

  2. Legal and Ethical Analysis of Ford Pinto

    Ford blamed the government for conflicting regulations which placed unreasonable burdens on domestic automakers. Ford blamed the imports for pricing pressure and lowered profit margin. Ford blamed the industry watchdogs for unfairly targeting its cars and the media for stirring up public controversy.

  1. Used second hand cars

    This shows that there would be a decrease in frequency with an increase in age. Standard deviation: The standard deviation, s, of a set of data is given by the formula: The higher the standard deviation, the more spread out the data is.

  2. Maths Data Handaling

    58000 72 18 53 �13,975.00 �4,700.00 34000 66 19 62 �13,230.00 �5,795.00 53000 59 20 65 �17,490.00 �7,500.00 34000 38 21 67 �27,855.00 �13,995.00 17500 57 22 71 �17,915.00 �11,750.00 40500 50 23 77 �14,486.00 �11,750.00 17000 34 24 81 �7,740.00 �7,995.00 30000 55 25 83 �14,486.00 �3,685.00 64000 75

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