• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Maths Data Handling-Secondhand Car

Extracts from this document...

Introduction

        Maths: Data Handling Coursework

Second Hand Car Sales

Introduction:

        When selling a car, there are many factors that will affect the price of the car including:

Age, Mileage, Condition, Model, Engine size, Colour, Interior, Original Cost, Previous owners, Fuel/Petrol type, installed systems (e.g. Safety systems, sound systems, central locking), Air conditioning, Insurance, Tax and MOT, Number of seats, Type of Transmission, Miles per Gallon and Service History.

        I shall use only cars which are 2nd hand in my coursework because as soon as the car has been used the value instantly loses the VAT and becomes 2nd hand.

Plan:

I shall look at Scatter Graphs for Price against Age, Price against Colour, Price against engine Size and Percentage depreciation against age. I shall also try to refine my graphs and where possible use secondary sources, I shall also look at the Percentage depreciation per year of certain models. I shall work out formulas for my trend lines, describe correlations and compare graphs where it is relevant. If I were to do these by hand I would select maybe 10 from my sample but because I have access to the spreadsheet, I can easily use all 100.

Hypothesis:

...read more.

Middle

image05.png

Through this graph, we can see a weak but positive correlation which proves my prediction to be correct. I shall now try to use only a certain model which should eliminate those outliers from cars which had an expensive original price or those which have lost value much faster than the others.

image06.png

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

Although this graph has a strongish correlation I do not believe that this is relevant because it uses the 2nd hand price which will be largely subject to the age rather than the engine size, I believe it would be more relevant if I took the original prices against engine size and than used the depreciation to relate it to the 2nd hand price.

image07.png

Again by using just Fords, I have made a graph which clearly shows a positive correlation but there are too many outliers to make a formula. So I would need to choose a specific model to try to make a formula.

Age against Price:

image08.png

...read more.

Conclusion

nd hand car.

Fords: Using the same method as I used before I have acquired the formula, Percentage Depreciation = 5 × Age + 35so the depreciation per year is about 5%. Also Fords lose 35% of their value after they have been used.

Vauxhalls: Again I shall use the same method to acquire the formula, Percentage Depreciation = 7.5 ×Age + 22.5 so the depreciation per year is about 7.5% and Vauxhalls lose 22.5% of their value after they have been used.

Conclusion:

From this investigation, I have found that the price is mainly affected by the age and original price of the car although the make, model and peripherals also affect the price although they affect the original price which in turn affects the 2nd hand price. I am now also able to find out which cars lose value faster and I am also able to apply this in a business if I were to choose such a profession.

Although I was unable to use secondary sources because of information which was not included in the information (mainly original price), I was still able to use information in the sample I had to refine my graphs so I could have definite results. I have learnt many things from this investigation, mainly what affects the price of 2nd hand cars most and this may in future influence my choice of car which I plan on buying.

...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. Used Cards - find which factors will influence the price of a second hand ...

    -15530 393605760.3 241180900 -308107435 4715 10000 -1255.5 -24530 1576280.25 601720900 30797415 12320 80000 6349.5 45470 40316150.25 2067520900 288711765 1225 10000 -4745.5 -24530 22519770.25 601720900 116407115 Total Total Total Total Total Total Total 5970.5 34530 0 0 1022834768 21813883000 -498037950 I used the following formula to work out the correlation coefficient;

  2. T-Total Maths

    shape 22 1 2 3 12 23 2 3 4 13 24 3 4 5 14 25 4 5 6 15 26 5 6 7 16 27 6 7 8 17 28 7 8 9 18 29 8 9 10 19 5 X 22 = 110 - 40 =70 FORMULA

  1. CAR SALES MATHS COURSEWORK

    Car no. Make Price when new Second hand price Age Mileage Engine size Price decrease 1 Peugeot 8300 2000 7 65000 1.4 6300 2 Vauxhall 8700 1500 9 82000 1.6 7200 3 Vauxhall 9770 7495 1 8000 1.4 2275 4 Ford 7540 850 10 124000 1.6 6690 5 Ford 11000

  2. maths=Data Handling Coursework

    I will also use a line of best fit. The reasons to why I have chosen this particular things Is because they will make it easy for me to present my data and also compare it. The calculations that I am going to follow is that I am going to find the mean of each of the cars, and

  1. Gary's Car Sales.

    26.03% 26.03% 24 1 Rover 34.25% 34.25% 25 5 Fiat 79.23% 15.85% 26 1 Peugeot 20.29% 20.29% 27 5 Fiat 56.92% 11.38% 28 4 Rover 61.90% 15.48% 29 2 Ford 26.19% 13.10% 30 4 Ford 51.79% 12.95% 31 2 Ford 38.83% 19.42% 32 4 Vauxhall 53.93% 13.48% 33 1 Vauxhall

  2. Maths Coursework: Car Sales

    Again, there is a problem on this graph, because a point (circled in red) seems to be out of place again. This car is exactly the same one as the one on the previous graph. This car has been used more frequently than the others and its mileage is much higher than the other cars.

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

    In order to prove or disprove my first hypothesis, I will have to use spearman's co-efficient rank of correlation and scatter graph to see the correlation between mileage and price of Fords and Mercedes cars in my data. Mercedes-spearman's co-efficient rank of correlation Ford- spearman's co-efficient rank of correlation Ford-second

  2. Used car prices.

    I will be finding the mean, median, mode and range for some certain makes of cars, from the data I have been given, I then will represent my collected data by the help of pie charts, bar charts, scatter graphs, etc.

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