• 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
• Level: GCSE
• Subject: Maths
• Word count: 2935

# Use the information to investigate what influences the price of cars.

Extracts from this document...

Introduction

Andrew Frampton

Wilson’s School

Guaranteed 18/24 on Higher Tier

GCSE Coursework 2002/2003

Mathematics

Use the information to investigate what influences the price of cars.

## Objectives

1. Specify clearly what you plan to do and why you are approaching the data in this way.
1. Collate the data needed and represent it in a way, which helps to develop the investigation.
1. Interpret the results and draw conclusions from them.

Each of these strands is worth a possible 8 marks.

The source of all my data is a printed database of cars which was issued to everybody doing the investigation. It includes various fields, some of which will be used in my investigation. They are:

• Car make
• Car model
• Price when new
• Price now
• Age
• Colour
• Engine size
• Fuel
• Miles per gallon
• Mileage
• Service
• Owners
• Length of MOT
• Tax
• Insurance
• Doors
• Style
• Central Locking
• Seats
• Gearbox
• Air conditioning
• Airbags

Objective 1

Specify clearly what you plan to do and why you are approaching the data in this way.

Aim

My aim is to find out exactly what factor affects the price of second hand cars most.

## What I plan to do

I plan to use a series of hypotheses and test them against the data to see if they affect the price of second hand cars. I will do this by predicting three hypotheses of my choice, which are relevant to the data.

I will use an example from every make of car for each hypothesis. To avoid bias I will variate in where I select the car from on the sheet e.g. at the very beginning or at the end.

Middle

3

9

6

6250

11

5

25

7

3999

18

11

121

8

2975

21

13

169

9

4999

16

7

49

10

5795

15

5

25

11

5999

13

2

4

12

6999

10

-2

4

13

5995

14

1

1

14

7995

9

-5

25

15

5999

13

-2

4

16

13995

4

-12

144

17

7495

9

-8

64

18

19495

2

-16

256

19

795

25

6

36

20

2995

20

0

0

21

1195

24

3

9

22

3995

19

-3

9

23

1495

23

0

0

24

2495

22

-2

4

25

14735

3

-22

484

Total

1665

I drew up a table like this so we could easily work out the Spearman’s Rank Correlation Coefficient for the data. The table has the fields rank, price, rank, difference and difference² as all of these components are needed to complete the formula for it. It will tell us whether there is a positive or negative correlation between the data.

Table 2

 Price (£) Cumulative Frequency 0 up to but not including 4000 8 0 up to but not including 8000 20 0 up to but not including 12000 21 0 up to but not including 16000 23 0 up to but not including 20000 24 0 up to but not including 24000 24 0 up to but not including 28000 24 0 up to but not including 32000 24 0 up to but not including 36000 24 0 up to but not including 40000 25

I drew up another table like this (above) so that calculating the cumulative frequency for the data would be easy. It allows us to draw up a graph to show the data.

Graph 3

I chose to put a cumulative frequency graph in so that we could see how the data works in proportion with one another. I set the graph out like this as it is the clearest and simplest way to produce data in this form. We expect to see a continuous rise in the graph.

Statement 2: The price of second hand cars will increase with engine size.

Conclusion

I conclude that again, in this hypothesis also, that the engine size of the car does affect its second hand price.

Statement 3:The price of second hand cars will decrease with the mileage it has done.

Graph 1

In this graph I saw that that in general there was no relationship between the price now and the mileage it had. Most of the time, when the prices now increased so did the mileage, completely contradicting my hypothesis. This may be because people do not mind how much mileage a car has so the car dealerships can exploit this by raising the prices of older cars with a lot of mileage. Another reason may be because the cars with the most mileage may have only had one previous owner, was not very old or had a small engine. All of these factors may have influenced the prices of cars further.

I conclude that in this hypothesis the mileage did not have a significant effect on the price of the cars.

In general I saw that only two of my hypotheses were correct out of a possible three. Out of the two which were correct and did affect the price of second hand cars as I had expected, I believe that the one which had the most influence on the price of second hand cars was age. This is because we saw the most significant relationships between price and age in this graph than in the engine size graph.

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. ## Statistics: Factors Affecting the Price of Used Cars

For the price, the ranges are quite consistent so there shouldn't be any extreme values. Mileage standard deviation x x2 71,074 5,051,513,476 68,446 4,684,854,916 54,848 3,008,303,104 25,925 672,105,625 51,580 2,660,496,400 89,442 7,999,871,364 79,159 6,266,147,281 77,980 6,080,880,400 52,329 2,738,324,241 68,838 4,738,670,244 Totals ?x = 639,621 ?

2. ## I will research the cars by putting the data I have been given into ...

but the range was very large.I looked then at only Ford cars using a stem and leaf diagram. This shows that most Ford cars depreciate between 1 and 2 percent per 1000 miles and at an average of 1.42 % per 1000 miles.

1. ## Maths Coursework:Used Cars

Now I will do the mileage and second hand price of separate cars. I will start with Fiat. this scatter graph I can see a negative correlation and a steep line. Also I can see that the ford car doesn't lose much mileage per year, it is only �0.0899.

2. ## Examine how the age of a second hand car affects its price. Also to ...

1 0.25 0 90000-100000 4 1 1 Exclude this one to get sample of 25 100000-110000 1 0.25 0 Calculation: From here I randomly pick the amount of cars in the mileage group. Car No Make Model New Old Mileage Percentage of new 61 Fiat Bravo 10954 6795 3000 62%

1. ## My maths coursework is based on a spreadsheet with information about cars.

So I plotted all the data into a scatter diagram with line of best fit. The three anomalous results where removed from the data before the diagram was drawn. If I was to repeat this question I would use all the data the first time or use a larger random sample.

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

Mercedes Ford In order to compare the depreciation rate per year of Mercedes and Ford, I will use the arithmetic mean. Here is the formula I used to find this out. =average (E2:E39). The average depreciation rate per year for ford is 11.39% and for Mercedes is 10.46%.

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

Here is the data with the random sample numbers on the side. Selected data: As you can see I have selected a random sample from my database, I chose the first 30 numbers that my random sample formula provided me and notified and replaced and errors which it had chosen.

2. ## Maths - statistical driving test

In order to draw upon accuracy I will use a stratified sample. To calculate the stratified sample I will divide the previous total population by four, which equals 60, this is now one quarter of the total population. I will now will proceed to divide each instructors male and female populations by the initial 240, multiplying by 60.

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