• 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

Middle

Equations For the curve:

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

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.

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.

-  -

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

# Related GCSE Gary's (and other) Car Sales essays

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

hand price and mileage Mercedes-second hand price and mileage Spearman's co-efficient rank of correlation of Mercedes and ford let to validate the coefficient correlation between second hand price and mileage because they reflect the same answer, which is as the mileage increases the lower the second hand price of the car.

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

without incurring the cost or time required to select a random sample. Quota sampling is the non-probability equivalent of stratified sampling. Like stratified sampling, the researcher first identifies the stratums and their proportions as they are represented in the population.

2. ## Maths - statistical driving test

important that I look at each instructor individually as one or more of the instructors results might be distorting the graph due to there being no correlation between the number of lesions and mistakes a person occurs within my previous hypothesis.

1. ## Handling data Used car prices

group; I will need to divide the total number of cars in the group by the total population which is 100 and multiply it by 30. 1000-10999 Miles 7/100 X 30 = 2.1 = 2 Therefore from this group I will take a random sample of 2 cars.

2. ## used car coursework

1.8 7 64000 6 3685 1.6 8 52000 7 1995 1.1 This table shows the 8 out of 12 Rover cars chosen using stratified sampling. The table shows the mileage, age, used car price and the engine size. This scatter diagram shows the affect on used car price as the age increases.

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

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