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

# My task for this coursework was to analyse the data given to me to see what effects the price of a second hand car; I tested such ideas like, age, service history and M.P.G.

Extracts from this document...

Introduction

## Coursework

My task for this coursework was to analyse the data given to me to see what effects the price of a second hand car; I tested such ideas like, age, service history and M.P.G.

The first thing I had to do was work out what the percentage price loss between the new price and the second hand price, I put my results in the table below.

Car make and Model

Price when new

Price when used

Price loss

% loss

### Ford Orion

16000

7999

8001

50

Ford Escort

8785

1595

7190

82

Ford Fiesta

7875

1050

6825

86

Ford Fiesta

7310

1495

5815

81

Ford Fiesta lx

8748

1995

6753

77

Ford Escort duet

9105

2300

6805

75

Ford Escort

12125

4295

7830

65

Ford Escort

11800

4700

7100

60

Ford Fiesta

8680

3200

5480

63

Ford Focus

14505

8800

5705

39

Ford Puma

13230

8250

4980

38

Ford Escort

13183

3495

9688

73

Ford Mondeo

17780

7995

9785

55

Ford Fiesta

6590

1664

4926

75

Ford Escort

15405

3995

11410

74

Ford Escort

9995

2995

7000

70

From this I found out that Ford cars lose so much  % when comparing the new car prices with the used car prices. The first things that I thought to test were the age against the %lost and see if there is any correlation between these two,

 Car Model age Ford Orion 1 Ford Escort 7 Ford Fiesta 8 Ford Fiesta 11 Ford Fiesta lx 7 Ford Escort duet 7 Ford Escort 5 Ford Escort 5 Ford Fiesta 4 Ford Focus 2 Ford Puma 3 Ford Escort 7 Ford Mondeo 4 Ford Fiesta 10 Ford Escort 5 Ford Escort 6
...read more.

Middle

77

Ford Escort duet

7

64000

1.4

75

Ford Escort

5

29000

1.4

65

Ford Escort

5

34000

1.8

60

Ford Fiesta

4

27000

1.8

63

Ford Focus

2

7200

1.6

39

Ford Puma

3

34000

1.4

38

Ford Escort

7

43000

1.8

73

Ford Mondeo

4

30000

2

55

Ford Fiesta

10

37000

1

75

Ford Escort

5

57000

1.9

74

Ford Escort

6

64000

1.3

70

To test to see if these have any effect on the overall percentage loss I had to compare them with the %loss column. I plotted them on a scatter graph to see if there was any correlation and I found out that there is a slight negative correlation between the %loss and the engine size, the bigger the engine the less money lost from the original price. I also plotted the mileage against the %loss and I found that there is a positive between the amount of miles done and the value that the car decreases.

From my research so far I have found out that the age and the mileage effects how much the car losses in value. The bigger the age or mileage the more the value is decreased in a second hand car.

After doing these scatter graphs I decided to test to see if the M.P.G (miles per gallon) would effect the price loss, to do this I had to work out the average M.P.G from a range of results.

 Car Model % loss M.P.G average M.P.G Ford Orion 50 25-47 36 Ford Escort 82 39-54 46.5 Ford Fiesta 86 45-62 53.5 Ford Fiesta 81 32-50 41 Ford Fiesta lx 77 45-62 53.5 Ford Escort duet 75 28-47 37.5 Ford Escort 65 28-47 37.5 Ford Escort 60 29-46 37.5 Ford Fiesta 63 47-68 57.5 Ford Focus 39 31-51 41 Ford Puma 38 29-46 37.5 Ford Escort 73 29-46 37.5 Ford Mondeo 55 24-44 34 Ford Fiesta 75 45-60 52.5 Ford Escort 74 29-46 37.5 Ford Escort 70 39-54 46.5
...read more.

Conclusion

2

41-50

1

0-50

3

51-60

2

0-60

5

61-70

3

0-70

8

71-80

5

0-80

13

81-90

3

0-90

16

91-100

0

0-100

16

When plotting the cumulative frequency graph we can find out the medium % loss for the Ford company and not just one car, this an be compared with another company to find out which make holds its value the best and this will help use to find out if the make of a car affects its second hand price

This graph shows that the average % loss for a typical Ford car is 70%n and that the inter quartile range is 22; this is done by taking the lower quarter of the graph from the high quarter of the graph. This becomes useful when comparing as it allows us to see if a certain model of car keeps the value better then another. Another figure that is useful when comparing two makes of cars together is annual % loss as this can show which company losses the most % in value in each year.

 % loss age Annual price loss 50 1 50 86 7 12.28571429 81 8 10.125 63 11 5.727272727 75 7 10.71428571 77 7 11 74 5 14.8 70 5 14 73 4 18.25 65 2 32.5 60 3 20 82 7 11.71428571 75 4 18.75 39 10 3.9 38 5 7.6 55 6 9.166666667

From this table we can work out that an average Ford loses 15.07% each year and when compared to another car manufacturer we can see if Ford is a reason why cars lose value when it becomes second hand.

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

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

1. ## used car coursework

The intercept of the line is 6221 and this tells us that if the used car price is �0 then the new car price will be �6221. Mileage Age Used car price Engine size 1 20000 2 7999 2.5 2 75000 10 1000 1.4 3 73000 10 850 1.6 4

2. ## I have been given instructions to collect data for my GCSE statistics coursework and ...

women, 10 teenage girls and 10 teenage boys so that they could interview them about their television viewing. It suffers from a number of practical flaws, the most basic of which is that the sample is not a random sample and therefore the sampling distributions of any statistics are unknown

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

is divided by �21586 (new price). This gives the answer of 0.18 to 2 d.p. This is the same as 18 %. 18% of the original price. Ultimately the lower the percentage the less it is worth as compared to the new price.

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

Ford- secondhand price Second hand price (GBP) Number of cars 0 to 2000 9 2001 to 4000 7 4001 to 6000 11 6001 to 8000 4 8001 to 10000 4 10001 to 12000 2 12001 to 14000 1 Total 38 From my bar chart, the range of Ford secondhand price is much smaller compared to Mercedes.

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

1. ## Maths - statistical driving test

I would like to investigate to identify if the instructors have an affect on the students ability to make less mistakes.

2. ## Handling data Used car prices

From the sample I have worked out the average value of depreciation for the cars in the sample. This will then allow me to plot the information onto a scatter diagram. The graph shown above shows a very good upwards trend.

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