• 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

    ANALYSIS The graph shows a positive correlation which conflicts with my hypothesis. I stated that engine size would be the least influential factor to determine the price of a car. But it seems I have been proved wrong. The r-squared value suggests otherwise yet my graph shows a positive correlation.

  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

    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

    ASSUMPTIONS From a utilitarian perspective, designing a safer fuel system would have resulted in the most happiness and the greatest utility. However, it is clear that Ford's intention was to maximize profit; otherwise, they would have been concerned about the devastating effects that would occur as a result of not modifying the gas tank design and placement.

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

    �3,750.00 8 7 �3,000.00 �10,400.00 �7,400.00 15 7 �2,600.00 �12,000.00 �9,400.00 20 7 �3,250.00 �9,990.00 �6,740.00 36 7 �2,000.00 �8,300.00 �6,300.00 18 8 �1,350.00 �9,140.00 �7,790.00 19 8 �2,950.00 �17,750.00 �14,800.00 6 9 �1,500.00 �8,700.00 �7,200.00 7 9 �995.00 �8,500.00 �7,505.00 10 10 �850.00 �7,540.00 �6,690.00 16 10 �1,000.00 �6,200.00

  1. Maths Coursework: Car Sales

    11000 pounds to 4800 pounds, where as the price of cars which are both ten years old can vary from 850 pounds to 1000 pounds. So from this graph, we can make a conclusion as the following: * As the age of a car increases, the price also decreases.

  2. Used second hand cars

    x 30 =0.3 0 Mazda 1/100 =0.01 (1/100) x 30 =0.3 0 Mercedes 3/100 =0.03 (3/100) x 30 =0.9 1 Mitsubishi 2/100 =0.02 (2/100) x 30 =0.6 1 Nissan 6/100 =0.06 (6/100) x 30 =1.8 2 Peugot 5/100 =0.05 (5/100) x 30 =1.5 2 Porche 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