• 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
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  • Level: GCSE
  • Subject: Maths
  • Word count: 6939

Factors affecting price of Used Car

Extracts from this document...

Introduction

Introduction

I have been given a coursework with secondary data that contains different types of car makes, each with different models. The data has all the mandatory information of a car. These are; colour, age, mileage, engine size, both price when new and price when used. My objective is to find out which of the factor/s mentioned above has/have the most effect on the price of a used car.

Hypothesis

A car is considered to be used when it has been travelled with. Travelling consumes time and consequently increases the mileage of a car. I therefore predict that the older a car gets, the more distance it covers and hence undoubtedly the less it will cost in the market.


Method of Enquiry

I am going to carry out an investigation applying all my mathematical and general knowledge to analyze and find out the factor/s affecting the price of a second hand car. Since the data I have is of two types i.e. Qualitative data (involves names and words e.g. black, blue, yes and no) and Quantitative data (involves numbers and figures), this makes it very complex to work on. I will refine my data so that I will work on only the major factors, which affect most and then later on I will break them further into small bits so that I will remain with a maximum of two factors. The reason for doing this is because some of the information contained in the data is hardly of any use to help me complete my objective e.g. air condition and gearbox. With factors like these, the range difference between two different makes is very small such that it has barely any effect on the price of a use car.


Procedure

...read more.

Middle

Equations For the curve:image04.png

Ford: y = 82.8x2 - 1703.5x + 10127      Fiat: y = 68.0x2 - 1379.8x + 7930

Rover:        y = 253.5x2 - 4240.9x + 19088    Vauxhall: y = -65.1x2 + 34.3x + 7002.1image17.pngimage18.png

I made four scatter diagrams for to see the relation between age and second hand price. As you will notice, I made two trend lines one is curvy while the other one is straight. I used to curvy trend, which is also known as polynomial type to show how the second hand price reduces as age increases, which agrees with my prediction. However if you look carefully at the trend, you might notice that when the car is young i.e. has been used for 1 year or two, its price declines drastically but as it gets older, its second hand price reduces steadily. The second hand price keeps on declining as the car gets older but the second hand price will never reach a negative value. It might go to a price next to nothing but it will not go negative. This is quite obvious because if the second hand price goes negative then it means that the seller will have to add some money on top of the car he is selling, which hypothetically does not happen.

However there is one anomaly in Vauxhall circled blue. This car seems to be old but yet its second hand price is still high. There I reckon there’s a factor, which is causing this result. This car is exactly the same one as the one on the previous graphs showing the relation between mileage and second hand price. This car is an exceptional because not only is it old but also it has a high mileage. The thing that’s still making it maintain it high value is the engine size of 2.0.

...read more.

Conclusion

Rover

Price (x)

3685

1700

2975

2975

1995

6999

14999

895

2495

Age  (y)

6

8

5

6

7

4

1

7

6

Price  (x)

3685

1700

2975

2975

1995

6999

14999

895

2495

Engine Size (y)

1.6

1.4

2.3

2.3

1.1

2.3

1.8

1.1

1.4

Price  (x)

3685

1700

2975

2975

1995

6999

14999

895

2495

Mileage (y)

64000

55000

96000

96000

52000

30000

2000

43000

33000

Coefficient of correlation between second hand price and Age is: r = - 0.948

Coefficient of correlation between second hand price and Engine size is:  r = 0.338

Coefficient of correlation between second hand price and Mileage is:  r = -0.620

The same thing is happening again, correlation between age and second hand price seems to be stronger than the other two. I can predict that it would be the same with fiat. I am going to carry out the calculations to prove this.

Fiat

Price (x)

3495

1995

1500

4995

1495

6795

1295

4500

Age  (y)

5

6

7

2

8

1

6

3

Price  (x)

3495

1995

1500

4995

1495

6795

1295

4500

Engine Size (y)

1.4

0.9

1.4

1.4

1

1.2

1.6

1.2

Price  (x)

3495

1995

1500

4995

1495

6795

1295

4500

Mileage (y)

51000

20000

32000

18500

51000

3000

81000

13000

Coefficient of correlation between second hand price and Age is: r = -0.957

Coefficient of correlation between second hand price and Engine size is:  r = -0.003

Coefficient of correlation between second hand price and Mileage is:  r = -0.712

I was right, age has the most effect on the second hand price and it’s followed by mileage.

Note that r engine size is negative, this implies that as the engine size increases, the price decreases which is not quite true. I came across the same thing previously and I explained that it was an exceptional.

I experienced a bit of difficulties doing this coursework, this is mainly because of the following:

  • The data provided was secondary, this means that I did not personally collect the data and therefore errors might have been encountered whilst it was collected hence affecting my results.
  • The data was insufficient in that there were only 100 cars provided. This restricts me from doing further analysis.
  • Even in the same make, cars have different specs and therefore I could not be able to compare like with like.

This brings me to my conclusion, as I mentioned in my hypothesis that age would be the dominant factor that affects the second hand price the most followed by the mileage. I used all my mathematical and statistical knowledge to come to this conclusion.

                   -  -

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

    the working out is considerably long, I shall just give the answer, which is n?x2 -(?x)2 = �2440.20 n2 I used the standard deviation in conjunction with the mean price, which was �4556.39, to find an estimate for the inter-quartile range.

  2. The task for this investigation is to statistically analyse the data given to compare ...

    Drop in mileage for each year 1 3 7 10 11 12 13 18 19 29 30 31 3.44/3 = 1.14 13.0/6 = 2.16 102.5/9 = 11.3 145.8/10 = 14.5 7.32/4 = 1.83 6.80/3 = 2.26 9.83/4 = 2.45 80/8 = 10 32.5/8 = 4.06 3.54/2 = 1.77 11.8/4 =

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

    Then convenience or judgment sampling is used to select the required number of subjects from each stratum. This differs from stratified sampling, where the stratums are filled by random sampling. As you can see above I have analysed each sampling method to its extreme, and have noticed that since random

  2. Statistics: Factors Affecting the Price of Used Cars

    The reason why I want to use a sample of 40 cars is because it is a manageable amount. Furthermore, I will only record the information that I need to use in my investigation when I am collecting my data so there isn't any confusion and it will be easier to find certain information.

  1. Maths Coursework - Used Cars

    It this very low when compared to the rest of the cars for Rover. Other factors may also imply for the Rover Club, such as mileage. The Rover Club has a mileage of 2000 and when compared to the rest of the cars, it is considered very low.

  2. Maths - statistical driving test

    If taking more lessons means that you make less mistakes this should be shown on the graph as negative correlation. On my graph there is no correlation, providing me with no information. Conclusion for graph 4 Graph 4 is the scatter graph for the stratified sample group of students and

  1. Legal and Ethical Analysis of Ford Pinto

    In August 1973, NHTSA announced a proposal for a 30 mph moving barrier, rear-end fuel system integrity standard, effective September 1976 for all 1977 models. The fuel system integrity standard was also applicable to rollover accidents. In 1977, Standard 301 was fully enacted (25).

  2. Maths Data Handling-Secondhand Car

    Using the same method I worked out the formula for the Rovers using the points (2, 12000) and (6, 3700) which came to: Price of 2nd hand Rover = -2075 � Age + 16150 Following my comparison of the graphs this shows that it was in fact wrong as the

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