• 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

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

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.

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. ## Statistically analyse the data given to me regarding Gary's used car sales.

Age Loss per Year (%) Age 12.95 4 9.64 7 12.28 4 7.55 7 15.85 5 10.65 8 11.38 5 10.42 8 11.84 6 9.81 9 11.25 6 9.20 9 11.19 7 8.87 10 10.84 7 8.39 10 10.16 7 7.75 11 As you can see from the table, the values of the annual depreciation are not near the mean.

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

2 4 1 1 3 7 6,970/3 = 2,323.33 3,350/7 = 478.57 3,995/6 = 665.83 5,300/6 = 883.33 6,500/3 = 2166.66 1,500/9 = 166.66 995/9 = 110.55 3,000/7 = 428.57 7,495/1 = 7495 850/10 = 85 5,595/4 = 1398.75 4,995/3 = 1665 5,595/4 = 1398.75 4,995/4 = 1248.75 2,600/7 =

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

Here is the original random sample of numbers and their data that I had (In ascending order): Random Numbers Random Data Car Make Model Price Mileage no. Used 2 Mercedes E-Class 2000 11395 12000 2 Mercedes E-Class 2000 11395 12000 4 Rover 25 2970 50000 11 Nissan Micra 860 28000

2. ## CAR SALES MATHS COURSEWORK

The result I got was so now using my original values the formula looks like this p=op(1-(0.28=0.922))y. The reason for this is you can work out the equation of a linear graph and substitute it and it will then represent the depreciation per year.

1. ## Ford Motor Company

to introduce a series of new models mainly aimed at the family market. These include the family sedan and a series of midsize cars, the Five Hundred, Mercury Montego sedans and the Ford Freestyle tall wagon (Business Week, 3865, 30), in the hope of restoring their competitive dominance of a decade ago.

2. ## Maths - statistical driving test

I am now going to investigate further by dividing instructor B's students into two separate scatter graphs, one to explore males and the other females performance levels, again looking at the number of lessons and mistakes. As before I will be looking for negative correlation.

1. ## Legal and Ethical Analysis of Ford Pinto

The Pintos were staged at speeds between 30 and 35 mph and they all resulted in significant fuel leakage after the crash with 2 cars caught fire (29). Similar test on GM's Chevrolet Vega resulted in minimal gasoline leakage (30).

2. ## Maths Data Handling-Secondhand Car

which, instead of being listed normally, the engine size has been listed in cylinder size. After using secondary sources such as the internet I have discovered that this 1989 Graduate had an engine size of 1.1 and if I change that result this is the graph I am left with:

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