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

  2. What Influence Did Henry Ford Have On 1920s America?

    The success of Ford, and entrepreneurs like him, made only him rich. While Ford increased workers' wages, they were still horribly disproportionate to the huge profits the big companies were raking in.

  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. Used second hand cars

    x 30 =1.5 2 Porche 1/100 =0.01 (1/100) x 30 =0.3 0 Renault 5/100 =0.05 (5/100) x 30 =1.5 2 Rolls Royce 1/100 =0.01 (1/100) x 30 =0.3 0 Rover 12/100 =0.12 (12/100) x 30 =3.6 4 Seat 1/100 =0.01 (1/100) x 30 =0.3 0 Suzuki 1/100 =0.01 (1/100)

  1. This piece of coursework is designed to test the use and interpretation of statistics ...

    8601 3995 no no no yes The extra features that I have chosen to use for this hypothesis consist of Central Locking, Air Conditioning, Airbags and Service History. I have decided to create a scatter diagram for this hypothesis. To do so, I will need to devise a table of

  2. The aim of this investigation is to find out what influences the price of ...

    higher the taken percentage of original value the newer the car is. It is negative correlation. I was right in my assumption that car prices drop by percentage per year. The graph is nearer perfect correlation than my age and price graph, but it's still not perfect, this can be affected by other hypotheses such as milage.

  1. Statistic coursework-what has the most influence on the price of a second hand car?

    In addition, Interquartile range is also calculated since outliers could affect the range easily as it only calculates the difference between the highest and lowest value. However, the interquartile range notifies me the range of the middle 50% of the data where is most of the information is.

  2. Maths Data Handling-Secondhand Car

    This graph of age against percentage price depreciation for Vauxhalls has a slightly weaker correlation than the one for Fords and from it we can see that generally Vauxhalls lose value at about 7% per year, but I shall now be calculating the actual depreciation per year by working out the formulas for the trend lines.

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